您现在的位置：>>
>>正文内容
如何实现批量审核订单？
1006-T6-渠道配货管理插件11.0
如何实现批量审核订单？一张一张审核订单非常麻烦而且很费时间。
同解决方案
在“订单管理”下拉菜单中点击“订单列表”，将需要审核的订单前面的复选框打勾，然后点击“审核”即可实现批审的功能。【图文】给力订单高效处理_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
评价文档：
给力订单高效处理
上传于||文档简介
&&给​力​订​单​高​效​处​理
大小：4.31MB
登录百度文库，专享文档复制特权，财富值每天免费拿！
你可能喜欢采购订单是存货在采购业务中流动的起点，是详细记录企业物流的循环流动轨迹、累积企业管理决策所需要的经营运作信息的关键。通过它可以直接向供应商订货并可查询采购订单的收货情况和订单执行状况，通过采购订单的关联跟踪，采购业务的处理过程可以一目了然。
本系统的采购订单不仅能够通过手工新增、复制、引入的方式来增加，对于以销订购业务，系统还支持通过采购看板将销售订单上拉生成采购订单，对于组合件业务的采购，系统支持按子件进行采购，这可以极大地方便用户的日常操作。
对于生成的采购订单，系统支持对其进行审核控制，控制采购订单在审核通过后才能下推生成采购单，如果用户不需要进行审核控制，也可以取消，取消审核控制后，生成的采购订单无需审核就可直接下推生成采购单。通过采购订单跟踪表，用户可以直接查询采购订单的收货情况和订单的执行状况，在采购订单执行完毕后，系统还提供了采购订单关闭功能，如果用户由于误操作不小心关闭了订单，还可以反关闭采购订单。
点击“打开主菜单-采购订单”，进入采购订单新增页面。
录入订单信息。
点击“保存”按钮。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，选择点击待修改订单记录对应的修改图标，进入采购订单编辑页面。
修改订单信息。
点击“保存”按钮。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，选择点击待修改订单记录对应的修改图标，进入采购订单编辑页面。
点击“复制”按钮。
修改订单信息。
点击“保存”按钮。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
在订单列表工具栏中，点击“引入”按钮，进入采购订单引入对话框。
点击“模板文件”链接 ，弹出“文件下载”对话框。
点击“保存”按钮，将模板文件保存在本地。
在本地打开模板文件，并录入引入数据文件。
录入完数据文件后，保存关闭文件后，回到采购订单引入对话框。
点击“浏览”按钮，选择本地数据文件后，点击“引入”按钮。
系统在引入成功后，会给予引入成功给提示
引入失败后，点击“点击此处下载引入失败的数据”链接，可以下载引入失败的数据，并修改数据。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，点击待删除订单记录对应的删除图标，并确认删除。
如需批量删除订单，点击待删除的多条订单记录前的复选框，点击“批量删除”，并确认删除。
点击“打开主菜单-采购订单”，进入采购订单新增页面。
在单据头录入订单基本信息。
点击“按子件采购”按钮，弹出存货转换单模板列表对话框。
在转换单模板列表中，输入所需采购的组合件的数量。
点击“确定”按钮，系统自动按照组合件与子件用量的配比关系计算出子件数量，并将子件清单填充单据分录。
点击“保存”按钮。
注意：按子件采购时，系统必须存在存货转换单模板。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，点击待审核或反审核的一条或多条订单记录前的复选框，点击“审核”或“反审核”。
注意：仅在系统设置页面的“采购订单审核控制”勾选时，采购订单才需要进行审核与反审核操作；如果不勾选，则采购订单无需进行审核，“审核”与“反审核”按钮隐藏。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，选择点击待订单记录对应的修改图标，进入采购订单编辑页面。
点击“关闭订单”或“反关闭订单”按钮。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，选择待关闭或关关闭记录前的复选框。
点击列表栏中的“关闭订单”或“反关闭订单”按钮。
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在订单列表中，选择点击待订单记录对应的修改图标，进入采购订单编辑页面。
点击“生成采购单”按钮。
注意：如果系统设置页面中的“采购订单审核控制勾”选时，订单需要审核后，才能生成采购单
点击“打开主菜单-采购订单列表”，进入采购订单列表页面。
设置查询条件，点击查询按钮。
在采购单列表中，选择点击待打印记录对应的修改图标，进入采购单编辑页面
，点击打印按钮，并在弹出选择打印模板对话框中选择打印模板，点击确定按钮。
如需打印多张采购单，点击待打印的多条采购单记录前的复选框，点击“打印”按钮，并在弹出选择打印模板对话框中选择打印模板，点击确定按钮。
在采购订单编辑界面，选择供应商。
在单据头中，点击“查询联系方式”链接，弹出详细联系方式对话框。
在此对话框中，查看供应商联系方式。
在采购订单编辑界面，点击“维护常用备注”链接，弹出“常用备注”对话框。
录入备注信息保存。
做单据时，只需在“备注”对应的下拉框中选择即可。
在采购订单编辑界面，在订单分录中选择存货。
点击“可用量分析”链接，则系统以单据日期为终止日期，以分录中的存货作为过滤条件查出可用量分析报表，并弹出存货可用量分析报表页面。
在采购订单编辑界面，在订单分录中选择存货。
点击“即时库存”链接，弹出即时库存查询对话框。
查看该存货在各个存货地点的及时库存。
在采购订单编辑界面，选择供应商和存货后。
点击“最近交易记录”链接，弹出最近交易对话框。
查看该存货对该供应商的的历史交易价格。
用户只能录入日期在系统设置页面设置的“录入日期控制”之后的采购订单。
如果系统设置页面中的“是否计税”没有勾选，则采购订单页面，单据头中的“单据类型”隐藏、单据分录中的“税率”和“税额”字段隐藏；如果系统设置页面中的“是否计税”勾选，则采购订单页面，单据头中的“单据类型”显示，单据分录中的“税率”和“税额”字段在单据类型为“税票”模式下显示。
在计税模式下，本系统采购订单的单据类型分为收据和税票
，其中税票模式下需要录入税额，税票模式不需要录入税额。一般来说，中国会计制度下采购的货品都是需要计税的，而有些地区在采购业务上是不用计税，例如香港。
如需对项目进行跟踪，需在“项目”下拉框中选择项目。
对于常用的备注信息，可点击“维护常用备注”链接，在“常用备注”对话框中录入备注信息保存，后续做单据时只需在“备注”对应的下拉框中选择即可。
选择供应商后，将自动带出该供应商默认采购人员、税率、折扣率、账期、联系方式，并允许修改，但修改结果仅仅记录在本单上，不会更新该供应商的默认信息。
用户在选择供应商后，可点击“查询联系方式”链接查看该供应商的联系方式。
用户在选择存货后，将自动带出该存货默认地点、单价、折扣率和税率。
用户在订单分录中选择存货后，可点击“即时库存”链接，查看该存货在各个存货地点的及时库存。
用户在选择供应商和存货后，点击“最近交易记录”链接，可查看该存货对该供应商的的历史交易价格，为后续业务的签订提供有力的决策依据。
单价下拉列表数据来源：“标准价”来源于存货档案中设置的标准买价；“最高采购限价”来源于存货档案中设置的最高采购限价；“协议价格”来源于存货档案中采购信息维护中设置的采购协议价格。
价格、折扣率及税率跟踪：单据录入过程中，如果所录入的存货在其档案中同时维护了存货的标准买价、采购协议价格、协议折扣率和增值税税率，那么自动取存货的协议价格作为存货的默认价格、自动取存货的协议折扣率作为折扣率的默认值，自动取存货的增值税税率作为税率的默认值；如果存货档案中同时只维护了存货的标准买价，那么自动取存货的标准买价作为存货的默认价格，自动取供应商的折扣率作为折扣率的默认值，自动取供应商的默认税率作为税率的默认值。
商业折扣和整单折扣处理方法：商业折扣可通过单据分录的折扣率和折扣额实现，整单折扣可通过单据的优惠实现。
用户在录入“交货日期”后，系统根据账期和交货日期自动计算出到期日。
对于一些需要通过多个子件组装成一个组合件的存货，采购组合件时可以按子件采购，具体操作参见。
贴心服务，创造价值！大型商贸系统（进货管理）技术解析（五）自营无订单进仓冲红单
功能介绍：
&&&& 自营无订单仓冲红单通过选择已审核无订单进仓单抵消某张已审核过的进仓冲红单使其进货无效。进仓冲红包括自营进仓冲红；无订单进仓冲红。其中自营无订单进仓冲红，在选择了相应的需要冲红的已审核无订单进仓单后，使其录入的件数和细数为原进仓单的相反数，然后保存，修改，经过审核后即可实现冲红操作功能。
功能实现：
1.&&&&自营无订单进仓冲红单所用到的表与表之间的关系图
表1：冲红单表（Offset）
用于存放自营无订单进仓冲红单信息
Repertory_enter_id
Review_deny
Record_number
nchar（20）
Registrant_id
Auditor_id
Review_time
Review_time
表2：进仓单表（Repertory_enter）
用于存放商品进仓单信息
& 主键/外键
Repertory_enter_id
& 进仓单id
Repertory_place_id
仓库地点id
Hava_indent_deny
&有无订单否
Receiver_id
Record_number
&nchar（20）
Registrant_id
Register_time
Auditor_id
Review_time
& datetime
Affix_count
nchar（10）
Type_of_operation_pubid
经营方式pubid
Original_number
nchar（20）
Agreement_id
Review_deny
YouXiaoFou
表3：进仓明细表（Repertory_enter_detail）
用于记录进仓明细单信息
Repertory_enter_detail_id
进仓明细id
Repertory_enter_detail_Farid
进仓明细farid
Repertory_enter_id
Repertory_enter_packages
decimal(18,0)
Repertory_enter_quantity
decimal(18,0)
Giveaway_quantity
decimal(18,0)
Review_deny
Auditor_id
Review_time
ChongHong_deny
表4：员工表（Eemployee）
用于记录员工信息
Employee_id
Employee_number
nchar（12）
Employee_name
nchar（10）
Department_id
2.&&&&实现自营无订单进仓冲红单界面效果图
& & & & & & & & & & & & & & & & & & & & & & & & 图2.1
2.1&&&实现该功能的界面代码
&!DOCTYPE html&
&meta content=&text/charset=utf-8& /&
&title&自营无订单冲红处理&/title&
&link href=&../../Content/jquery-easyui-1.3.3/themes/icon.css& rel=&stylesheet& /&
&link href=&../../Content/jquery-easyui-1.3.3/demo/demo.css& rel=&stylesheet& /&
&link href=&../../Content/jquery-easyui-1.3.3/themes/default/easyui.css& rel=&stylesheet& /&
&link href=&../../Content/MyCSS/PublicCSS.css& rel=&stylesheet& /&
&script src=&../../Content/jquery-easyui-1.3.3/jquery.min.js&&&/script&
&script src=&../../Content/jquery-easyui-1.3.3/jquery.easyui.min.js&&&/script&
&script src=&../../Content/jquery-easyui-1.3.3/easyloader.js&&&/script&
&link href=&../../Content/yxsss/js_css/yu.css& rel=&stylesheet& /&
&script src=&../../Content/yxsss/js_css/yu.js&&&/script&
&style type=&text/css&&
body { text-align: font-size: 20 }
input { margin-top: 1 margin-left: 5 margin-right: 5 font-size: 15 }
button { height: 28 font-size: 20 margin: 1px 3px 1px 3 }
div & button { margin: 15px 4px auto 15 }
#weibu tr td { height: 30 }
.myimg:hover { margin-top: 3 margin-left: 3 }
&body style=&text-align: center&&
&div style=&display: none&&
&div class=&easyui-window& title=&& id=&wWDingDanJinHuoChuLi& style=&display: text-align: border-spacing: 0; padding: 0; border: 0 height: 600&
data-options=&fit:true,collapsible:false,minimizable:false,maximizable:false,closable:false,draggable:false,resizable:false,shadow:false,modal:true,center:true&&
&div style=&padding: 5 background: #e0 color: #4169e1; font-size: 20 margin: 0 0& border=&1&&
无订单冲红处理
&table id=&tbWDingDanJinHuoChuLi& style=&width: 780 height: 20 padding: 0; border:&&
&td style=&vertical-align: middle&&
&input type=&button& value=&记录编号& onclick=&OpenZiYingJinCangDanChaZhao()& style=&width: 100& /&&input type=&text& @*onclick=&SelectWuDingDanJinCangRecord_number()&*@ id=&txtWuDingDanCHJiLuBianMa& style=&width: 120 color: margin-left: 5& /&&/td&
&td style=&vertical-align: middle&&
&input type=&button& value=&进货部门& style=&width: 100& /&&input type=&text& id=&bumendaima& style=&width: 40 text-align: margin-left: 5px& /&&/td&
&td style=&vertical-align: middle&&
&div style=&border-bottom: #000 1 width: 180&&
&input id=&txtBuMenMC& readonly=&readonly& style=&width: 240 margin-left: 5 border: color: #0000FF; font-size: 15& /&
&table style=&width: 780 height: 150 padding: 0; border:&&
&td style=&width: 180 text-align: font-size: 15&&合同号：&/td&
&div style=&border-bottom: #000 1 width: 100&&
&input id=&AgreementCode& readonly=&readonly& style=&width: 100 border: color: #0000FF; font-size: 17& /&
&td style=&text-align: font-size: 15&&库存地点：&/td&
&input class=&easyui-combobox& id=&RepertoryPlaceIdentifier& data-options=&panelHeight:100& style=&width: 145 text-align: center& /&&/td&
&div style=&border-bottom: #000 1 width: 180&&
&input readonly=&readonly& id=&kucunMC& style=&width: 180 border: color: #0000FF; font-size: 17& /&
&td style=&width: 110 text-align: font-size: 15&&结算方式：&/td&
&div style=&border-bottom: #000 1 width: 100&&
&input readonly=&readonly& id=&jiesuanfangshi& style=&width: 100 border: color: #0000FF; font-size: 17& /&
&td style=&text-align: font-size: 15&&附件:&input type=&text& id=&txtFuJianZhangShu& style=&width: 40px& /&张数&/td&
&td colspan=&2& align=&right& style=&font-size: 15&&原始进货单号:&input type=&text& id=&txtTongJinCang& style=&width: 180& /&&/td&
&td style=&width: 110 text-align: font-size: 15&&买手：&/td&
&div style=&border-bottom: #000 1 width: 80&&
&input readonly=&readonly& id=&maijia& style=&width: 80 border: color: #0000FF; font-size: 17& /&
&td style=&text-align: font-size: 15&&收货人：&/td&
&input class=&easyui-combobox& id=&shouhuorenbianhao& data-options=&panelHeight:100& style=&width: 145 text-align: center& /&&/td&
&div style=&border-bottom: #000 1 width: 180&&
&input readonly=&readonly& id=&ReceiverName& style=&width: 180 border: color: #0000FF; font-size: 17& /&
&td style=&width: 120 text-align: font-size: 15&&往来单位：&/td&
&td style=&width: 160& colspan=&2&&
&div style=&border-bottom: #000 1 width: 300&&
&input readonly=&readonly& id=&SupplyUnits& style=&width: 300 border: color: #0000FF; font-size: 17& /&
&td style=&vertical-align: middle&&
&input type=&button& id=&piliangxuanshangpin& value=&批量选商品& onclick=&OpenPiLiangXuanShangPin()& style=&width: 100 text-align: font-size: 17& /&
&button onclick=&SelectWDJinCangChongHongDan()&&
&img src=&../../Content/image/2.png& /&查询&/button&
&div class=&easyui-panel& style=&width: 785 height: 243&&
&table id=&tb进窗信息& class=&easyui-datagrid& style=&width: 3780& data-options=&rownumbers:true,idField:'Goods_id',singleSelect:true,onClickRow:onClickRowMingXi,@*onAfterEdit:onAfterEdit,*@
fit:true,pagination:true,frozenColumns:[[
{field:'ShanChu',width:40,title:'删除',align:'center',formatter:deleteSelect}
&th data-options=&field:'Goods_id',hidden:true,width:80,align:'center'&&商品ID&/th&
&th data-options=&field:'Repertory_enter_detail_id',hidden:true,width:80,align:'center'&&进仓明细ID&/th&
&th data-options=&field:'Goods_code',width:80,align:'center'&&商品代码&/th&
&th data-options=&field:'Goods_bar_code',width:80,align:'center'&&商品条码&/th&
&th data-options=&field:'Goods_name',width:80,align:'center'&&商品名称&/th&
&th data-options=&field:'Quality_content',width:80,align:'center'&&包装含量&/th&
&th data-options=&field:'NumberOfUnits',editor:'numberbox',width:80,align:'center',styler:cellStyler&&入库件数&/th&
&th data-options=&field:'Shipments_quantity',width:80,editor:'numberbox',align:'center',styler:cellStyler&&入库细数&/th&
&th data-options=&field:'WuGouShuLiang',editor:'numberbox',width:80,align:'center',styler:cellStyler&&物扣数量&/th&
&th data-options=&field:'Tax_inclusive_price',width:80,align:'center'&&含税进价&/th&
&th data-options=&field:'Input_ratio',width:80,align:'center'&&进项税率&/th&
&th data-options=&field:'Purchase_bid',width:80,align:'center'&&采购进价&/th&
&th data-options=&field:'Art_No',width:80,align:'center'&&货号&/th&
&th data-options=&field:'Format_model',width:80,align:'center'&&规格型号&/th&
&th data-options=&field:'JiLiangDanWei',width:80,align:'center'&&计量单位&/th&
&th data-options=&field:'Retail_unit_price',width:80,align:'center'&&零售单价&/th&
&th data-options=&field:'MaiJia',width:80,hidden:true,align:'center'&&买手&/th&
&th data-options=&field:'Vender_bar_code_deny',width:80,align:'center'&&厂家条码否&/th&
&th data-options=&field:'Goods_abbreviation',width:80,align:'center'&&商品简称&/th&
&th data-options=&field:'Plncode_PLN',width:80,align:'center'&&PLN码&/th&
&th data-options=&field:'Goods_name',width:80,align:'center'&&商品标记&/th&
&th data-options=&field:'Copy_record_deny',width:80,align:'center'&&复制记录否&/th&
&th data-options=&field:'Contract_number',width:80,align:'center'&&合同号&/th&
&th data-options=&field:'Manufacturer_name',width:80,align:'center'&&生产厂家&/th&
&th data-options=&field:'Producing_area_name',width:80,align:'center'&&产地&/th&
&th data-options=&field:'ShiYongDuiXiang',width:80,align:'center'&&使用对象&/th&
&th data-options=&field:'Goods_colours',width:80,align:'center'&&商品花色&/th&
&th data-options=&field:'Goods_rademark_name',width:80,align:'center'&&商品商标&/th&
&th data-options=&field:'ShangPinFenLei',width:80,align:'center'&&商品分类&/th&
&th data-options=&field:'BaoZhiQi',width:80,align:'center'&&保质期&/th&
&th data-options=&field:'Output_ratio',width:80,align:'center'&&销项税率&/th&
&th data-options=&field:'Count_scale',width:80,align:'center'&&统计比例&/th&
&th data-options=&field:'ZhiLiangDengJi',width:80,align:'center'&&质量等级&/th&
&th data-options=&field:'JiYingJiJie',width:80,align:'center'&&经营季节&/th&
&th data-options=&field:'Permit_decimal_deny',width:80,align:'center'&&允许小数否&/th&
&th data-options=&field:'ChanPinZhuangTai',width:80,align:'center'&&产品状态&/th&
&th data-options=&field:'DengJiRen',width:80,align:'center'&&登记人&/th&
&th data-options=&field:'Register_time',width:80,align:'center'&&登记时间&/th&
&th data-options=&field:'ShenHeRen',width:80,align:'center'&&审核人&/th&
&th data-options=&field:'Review_time',width:80,align:'center'&&审核时间&/th&
&th data-options=&field:'GengXinRen',width:80,align:'center'&&更新人&/th&
&th data-options=&field:'Update_Time',width:80,align:'center'&&更新时间&/th&
&th data-options=&field:'Self_fix_goods_deny',width:80,align:'center'&&自订货否&/th&
&th data-options=&field:'Mini_fix_goods_deny',width:80,align:'center'&&最小订货数&/th&
&table id=&weibu& style=&width: 715 height: 35px&&
&td style=&font-size: 15 width: 60px&&登记人&/td&
&td style=&width: 50px&&
&div style=&border-bottom: #000 1 width: 180&&
&input class=&easyui-combobox& id=&dengjiren& data-options=&url:'/ShangPinJinChuangDan/SelectEmployee',valueField:'ID',textField:'MC'& style=&width: 180 border: color: #0000FF; font-size: 17& /&
&td style=&font-size: 15px&&登记时间&/td&
&td style=&width: 250px&&
&div style=&border-bottom: #000 1 width: 180&&
&input class=&easyui-datetimebox& data-options=&formatter:myformatter& id=&datdengjishijian& style=&width: 180 border: color: #0000FF; font-size: 17& /&
&td style=&font-size: 15 width: 60px&&审核人&/td&
&td style=&width: 50px&&
&div style=&border-bottom: #000 1 width: 180&&
&input class=&easyui-combobox& id=&Auditor& data-options=&url:'/ShangPinJinChuangDan/SelectEmployee',valueField:'ID',textField:'MC'& style=&width: 180 border: color: #0000FF; font-size: 17& /&
&td style=&font-size: 15px&&审核时间&/td&
&div style=&border-bottom: #000 1 width: 180&&
&input class=&easyui-datetimebox& data-options=&formatter:myformatter& id=&datshenheshijian& style=&width: 180 border: color: #0000FF; font-size: 17& /&
&button onclick=&OpenwYiShenHeWDDJC(); & id=&TianJia&&
&img src=&../../Content/image/add.png& /&添加&/button&
&button onclick=&UpdateWDJinCangCH();&&
&img src=&../../Content/image/table_edit.png& /&修改&/button&
&button onclick=&DeleteWDJinCangCHDan();& id=&ShanChu&&
&img src=&../../Content/image/delete.png& /&删除&/button&
&button id=&BaoCun& onclick=&BaoCunWDJCChongHong();&&
&img src=&../../Content/image/disk.png& /&保存&/button&
&button onclick=&qingKong();& id=&FanQi&&
&img src=&../../Content/image/01.png& /&放弃&/button&
&button onclick=&ShenHeWDJinCangChongHong();& id=&ShenHe&&
&img src=&../../Content/image/ok.gif& /&审核&/button&
&button id=&DaYin&&
&img src=&../../Content/image/2.png& /&打印&/button&
&button id=&TuiChu& onclick=& parent.jinCang();&&
&img src=&../../Content/image/1.png& /&退出&/button&
3. 对无订单进仓冲红的记录编号的操作
3.1 实现该功能的界面代码
3.2&在JavaScript中的代码实现
3.3&实现该功能的控制器代码
#region 生成配货单据
public ActionResult SelectWuDingDanJinCangCangHongRecord_number()
//实例化DataTable接收对象_myWuDingDanJinCangChongHong的方法GetOddNumbers中数据返回的数据
DataTable dt = _myWuDingDanJinCangChongHong.GetOddNumbers(8);
DataTable dt2 = _myWuDingDanJinCangChongHong.GetDayMaxQuantity(17);//查询获取当前日最大单据数
string patchNumber = dt.Rows[0][&Prefixs&].ToString().Trim();//声明变量接收获取表dt中[&Prefixs&]列单元格的值
string patchCount = dt2.Rows[0][0].ToString();//声明变量patchCount，dt2表中的总长度
//for循环并判断总的长度与dt.Rows[0][&Suffix_number&]作比较
for (int i = patchCount.L i & Convert.ToInt32(dt.Rows[0][&Suffix_number&].ToString().Trim()); i++)
patchCount = &0& + patchC//符合条件的要在patchCount前加“0”
string recordNumber = patchNumber + patchC//对自营无订单进仓冲红单记录编号的并接
return Json(recordNumber, JsonRequestBehavior.AllowGet);
#endregion
3.4&实现该功能逻辑层代码
#region 获取当前日最大单据
public DataTable GetDayMaxQuantity(int dayMaxQuantityId)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Day_max_quantity_id&,SqlDbType.Int),
sql[0].Value = &GetDayMaxQuantity&;
sql[1].Value = dayMaxQuantityId;
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&Update_Day_Max_Count&, sql);
#endregion
#region 获取记录编号前缀
public DataTable GetOddNumbers(int intOddNumbersId)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Odd_numbers_id&,SqlDbType.Int),
sql[0].Value = &GetOddNumbers&;
sql[1].Value = intOddNumbersId;
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&Update_Day_Max_Count&, sql);
#endregion
3.5&实现该功能存储过程
if(@NB='GetDayMaxCount')
--获取日最大单数
Day_max_count
Day_max_quantity
where Day_max_quantity_id=@Day_max_quantity_id
if(@NB='GetOddNumbers')
--获取记录编号/批次号前缀
Odd_numbers_id,Suffix_number,(rtrim(Prefix)+CONVERT(varchar(12),GETDATE(),112))as Prefixs
Odd_numbers
(Odd_numbers_id = @Odd_numbers_id)
4. 对“添加”按钮的操作
4.1 点击“添加”按钮将会弹出“选择已审核无订单进仓单”的窗口
界面效果图
& & & & & & & & & & & & & & & & & & & & &&
& & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & 图4.1
4.2&实现该功能的界面代码
4.3&在JavaScript中的代码实现
1.1 在JavaScript中的代码实现
//打开已审核无订单进仓单（选择已审核无订单进仓）
function OpenwYiShenHeWDDJC() {
//对记录编号的操作
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/SelectWuDingDanJinCangCangHongRecord_number&, function (value) {
$(&#txtWuDingDanCHJiLuBianMa&).val(value);
//打开“选择已审核无订单进仓单”的窗口
$('#wXuanZeYiShenHeWDDJCDanXiAll').window('open');
//对“选择已审核无订单进仓单”窗口中DGV的数据查询
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/SelectYiShenHeWdjcChongHong&, function (data) {
$('#tbXuanZeYiShenHeWDDJCDan').datagrid('loadData', data);
//模糊查询已审核无订单进仓单
function MohuSelectYiShenHeWdjcChongHong() {
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/MohuSelectYiShenHeWdjcChongHong?strBlur=& + $('#strBlur').val(), function (data) {
$('#tbXuanZeYiShenHeWDDJCDan').datagrid('loadData', data);
4.4 实现该功能的控制器操作
#region 查询已审核无订单进仓单信息（冲红单）
public ActionResult SelectYiShenHeWdjcChongHong()
DataTable dt = _myWuDingDanJinCangChongHong.SelectYiShenHeWdjcChongHong();=
List&Dictionary&string, object&& listReturn = ConvertHelper.DtToList(dt);
return Json(listReturn, JsonRequestBehavior.AllowGet);
#endregion
#region 模糊查询已审核无定进仓信息（冲红单）
public ActionResult MohuSelectYiShenHeWdjcChongHong(string strBlur)
DataTable dt = _myWuDingDanJinCangChongHong.MohuSelectYiShenHeWdjcChongHong(strBlur);
List&Dictionary&string, object&& listReturn = ConvertHelper.DtToList(dt);
return Json(listReturn, JsonRequestBehavior.AllowGet);
#endregion
4.5 实现该功能逻辑层的操作
#region 查询已审核无订单进仓单信息（冲红单）
public DataTable SelectYiShenHeWdjcChongHong()
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
sql[0].Value = &SelectYiShenHeWdjcChongHong&;
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
#region 模糊查询已审核无定进仓信息（冲红单）
public DataTable MohuSelectYiShenHeWdjcChongHong(string trBlur)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@strBlur&, SqlDbType.Char),
sql[0].Value = &MohuSelectYiShenHeWdjcChongHong&;
sql[1].Value = trB
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
4.6 实现该功能的存储过程
--查询已审核无订单进仓单信息（冲红单）
if(@NB='SelectYiShenHeWdjcChongHong')
Repertory_enter.Repertory_enter_id, Repertory_enter.Hava_indent_deny, Repertory_enter.Record_number, Repertory_enter.Agreement_id, Repertory_enter.Repertory_place_id,
Agreement.Contract_number, Department.Department_name, Repertory_enter.Review_deny, Department.Department_code, Department.Department_id, Repertory_place.Repertory_place_name,
Attribute_gather_detail.Attribute_gather_detail_name AS settlement, Repertory_enter.Affix_count, Repertory_enter.Original_number, Eemployee.Employee_name AS maijia,
Repertory_enter.Receiver_id, Eemployee_1.Employee_number AS Receivecoad, Eemployee_1.Employee_name AS ReceiverName, Enterprise_name.Chinese,
Repertory_place.Repertory_place_identifier, Repertory_enter.Registrant_id, CONVERT(varchar(20), Repertory_enter.Register_time, 120) AS Register_time,
Eemployee_2.Employee_number AS dengjirencoad, Eemployee_2.Employee_name AS dengjiren, Repertory_enter.Auditor_id, CONVERT(varchar(20), Repertory_enter.Review_time, 120)
AS Review_time, Eemployee_3.Employee_name AS Auditor, Attribute_gather_detail_1.Attribute_gather_detail_name AS jiesuanfangshi
Repertory_enter INNER JOIN
Agreement ON Repertory_enter.Agreement_id = Agreement.Agreement_id INNER JOIN
Department ON Agreement.Purchase_unit_id = Department.Department_id INNER JOIN
Repertory_place ON Repertory_enter.Repertory_place_id = Repertory_place.Repertory_place_id INNER JOIN
Attribute_gather_detail ON Agreement.Settlement_pubid = Attribute_gather_detail.Attribute_gather_detail_id INNER JOIN
Eemployee ON Agreement.Purchasing_agent_id = Eemployee.Employee_id INNER JOIN
Eemployee AS Eemployee_1 ON Repertory_enter.Receiver_id = Eemployee_1.Employee_id INNER JOIN
Supply_units ON Agreement.Supply_units_id = Supply_units.Supply_units_id INNER JOIN
Enterprise_name ON Supply_units.Enterprise_name_id = Enterprise_name.Enterprise_name_id INNER JOIN
Eemployee AS Eemployee_2 ON Repertory_enter.Registrant_id = Eemployee_2.Employee_id INNER JOIN
Eemployee AS Eemployee_3 ON Repertory_enter.Auditor_id = Eemployee_3.Employee_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_1 ON Agreement.Settlement_pubid = Attribute_gather_detail_1.Attribute_gather_detail_id
where Repertory_enter.Review_deny='True'and Repertory_enter.Hava_indent_deny='false'
and Repertory_enter.chongHongFou='false'
--模糊查询已审核无定进仓信息（冲红单）
if(@NB='MohuSelectYiShenHeWdjcChongHong')
Repertory_enter.Repertory_enter_id, Repertory_enter.Hava_indent_deny, Repertory_enter.Record_number, Repertory_enter.Agreement_id, Repertory_enter.Repertory_place_id,
Agreement.Contract_number, Department.Department_name, Repertory_enter.Review_deny, Department.Department_code, Department.Department_id, Repertory_place.Repertory_place_name,
Attribute_gather_detail.Attribute_gather_detail_name AS settlement, Repertory_enter.Affix_count, Repertory_enter.Original_number, Eemployee.Employee_name AS maijia,
Repertory_enter.Receiver_id, Eemployee_1.Employee_number AS Receivecoad, Eemployee_1.Employee_name AS ReceiverName, Enterprise_name.Chinese,
Repertory_place.Repertory_place_identifier, Repertory_enter.Registrant_id, CONVERT(varchar(20), Repertory_enter.Register_time, 120) AS Register_time,
Eemployee_2.Employee_number AS dengjirencoad, Eemployee_2.Employee_name AS dengjiren, Repertory_enter.Auditor_id, CONVERT(varchar(20), Repertory_enter.Review_time, 120)
AS Review_time, Eemployee_3.Employee_name AS Auditor, Attribute_gather_detail_1.Attribute_gather_detail_name AS jiesuanfangshi
Repertory_enter INNER JOIN
Agreement ON Repertory_enter.Agreement_id = Agreement.Agreement_id INNER JOIN
Department ON Agreement.Purchase_unit_id = Department.Department_id INNER JOIN
Repertory_place ON Repertory_enter.Repertory_place_id = Repertory_place.Repertory_place_id INNER JOIN
Attribute_gather_detail ON Agreement.Settlement_pubid = Attribute_gather_detail.Attribute_gather_detail_id INNER JOIN
Eemployee ON Agreement.Purchasing_agent_id = Eemployee.Employee_id INNER JOIN
Eemployee AS Eemployee_1 ON Repertory_enter.Receiver_id = Eemployee_1.Employee_id INNER JOIN
Supply_units ON Agreement.Supply_units_id = Supply_units.Supply_units_id INNER JOIN
Enterprise_name ON Supply_units.Enterprise_name_id = Enterprise_name.Enterprise_name_id INNER JOIN
Eemployee AS Eemployee_2 ON Repertory_enter.Registrant_id = Eemployee_2.Employee_id INNER JOIN
Eemployee AS Eemployee_3 ON Repertory_enter.Auditor_id = Eemployee_3.Employee_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_1 ON Agreement.Settlement_pubid = Attribute_gather_detail_1.Attribute_gather_detail_id
where Repertory_enter.Review_deny='True'and Repertory_enter.Hava_indent_deny='false'
and Repertory_enter.Record_number like '%'+RTRIM(@strBlur)+'%'
5 对自营无订单进仓冲红单录入的功能所以操作代码
JavaScript中代码
//单击无定单进仓冲红（绑定冲红单）
var repertoryEnterid = 0;
function onClickWDJCCH(rowIndex, rowData) {
$('#wXuanZeYiShenHeWDDJCDanXiAll').window('close');
$('#bumendaima').val(rowData.Department_code);
$('#txtBuMenMC').val(rowData.Department_name);
$('#AgreementCode').val(rowData.Contract_number);
$('#RepertoryPlaceIdentifier').combobox('setValue', rowData.Repertory_place_identifier);
$('#kucunMC').val(rowData.Repertory_place_name);
$('#jiesuanfangshi').val(rowData.jiesuanfangshi);
$('#txtFuJianZhangShu').val(rowData.Affix_count);
$('#txtTongJinCang').val(rowData.Record_number);
$('#maijia').val(rowData.maijia);
$('#shouhuorenbianhao').combobox('setValue', rowData.Receivecoad);
$('#ReceiverName').val(rowData.ReceiverName);
$('#SupplyUnits').val(rowData.Chinese);
repertoryEnterid = rowData.Repertory_enter_
BingDingWDJCCHMingXi(rowData.Repertory_enter_id);
控制器代码：
//绑定冲红单根据(无定单进仓id)
var repertoryEnterDetailid = 0;
function BingDingWDJCCHMingXi(repertoryEnterid) {
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/BingDingWdjcchMingXi?repertoryEnterid=& + repertoryEnterid, function (data) {
$('#tb进窗信息').datagrid('loadData', data);
repertoryEnterDetailid = data[0].Repertory_enter_detail_
#region 绑定无订单进仓冲红明细
public ActionResult BingDingWdjcchMingXi(int repertoryEnterid)
DataTable dt = _myWuDingDanJinCangChongHong.BingDingWdjcchMingXi(repertoryEnterid);
dt.Columns.Add(&YiRuKuShu&, typeof(int));
dt.Columns.Add(&HaiYaoRuKuShu&, typeof(int));
//for循环遍历，对DGV中数据的处理，并使其数据为原来无订单进仓单的数据的相反数
for (int i = 0; i & dt.Rows.C i++)
int giveawayQuantity = Convert.ToInt32(dt.Rows[i][&WuGouShuLiang&]);
int repertoryEnterPackages = Convert.ToInt32(dt.Rows[i][&NumberOfUnits&]);
int repertoryEnterQuantity = Convert.ToInt32(dt.Rows[i][&Shipments_quantity&]);
int rpdetailid = Convert.ToInt32(dt.Rows[i][&Repertory_enter_detail_id&]);
var zongyaoRuKuShu = -(Convert.ToInt32(dt.Rows[i][&ZongYaoRuKuShu&]));
DataTable k = _myWuDingDanJinCangChongHong.SelectYiRuKuShu(rpdetailid);
int yirukushu = Convert.ToInt32(k.Rows[0][&yirukushu&]);
dt.Rows[i][&YiRuKuShu&] =
dt.Rows[i][&HaiYaoRuKuShu&] = zongyaoRuKuShu -
dt.Rows[i][&NumberOfUnits&] = -repertoryEnterP
dt.Rows[i][&Shipments_quantity&] = -repertoryEnterQ
dt.Rows[i][&WuGouShuLiang&] = -giveawayQ
List&Dictionary&string, object&& listReturn = ConvertHelper.DtToList(dt);
return Json(listReturn, JsonRequestBehavior.AllowGet);
#region 绑定无订单进仓冲红明细
public DataTable BingDingWdjcchMingXi(int repertoryEnterId)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Repertory_enter_id&, SqlDbType.Int),
sql[0].Value = &BingDingWdjcchMingXi&;
sql[1].Value = repertoryEnterId;
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
存储过程：
--绑定无订单进仓冲红明细
if(@NB='BingDingWdjcchMingXi')
Goods.Goods_code, Goods.Goods_bar_code, Goods.Goods_name, Goods.Art_No, Goods.Format_model, Attribute_gather_detail.Attribute_gather_detail_name AS JiLiangDanWei,
Goods.Goods_abbreviation, Goods.Plncode_PLN, Goods.Agreement_id, Attribute_gather_detail_1.Attribute_gather_detail_name AS ShiYongDuiXiang, Goods.Goods_colours, Goods.Input_ratio,
Goods.Output_ratio, Goods.Count_scale, Goods.Quality_content, Attribute_gather_detail_2.Attribute_gather_detail_name AS ZhiLiangDengJi, Manage_season.Manage_season_name AS JiYingJiJie,
Goods.Permit_decimal_deny, Goods.Copy_record_deny, Goods.Vender_bar_code_deny, Attribute_gather_detail_3.Attribute_gather_detail_name AS ShangPinBiaoJi,
Manufacturer.Manufacturer_name, Goods_producing_area.Producing_area_name, Attribute_gather_detail_4.Attribute_gather_detail_name AS ChanPinZhuangTai, CONVERT(varchar(20),
Goods.Register_time, 120) AS Register_time, CONVERT(varchar(20), Goods.Review_time, 120) AS Review_time, CONVERT(varchar(20), Goods.Update_Time, 120) AS Update_Time,
Goods.Retail_unit_price, Goods.Purchase_bid, Goods.Self_fix_goods_deny, Goods.Mini_fix_goods_deny, Attribute_gather_detail_5.Attribute_gather_detail_name AS ShangPinFenLei,
Agreement.Contract_number, Goods_rademark.Goods_rademark_name, Attribute_gather_detail_6.Attribute_gather_detail_name AS BaoZhiQi, Repertory_enter_detail.Repertory_enter_id,
Repertory_enter_detail.Goods_id, Repertory_enter_detail.Repertory_enter_packages AS NumberOfUnits, Repertory_enter_detail.Repertory_enter_quantity AS Shipments_quantity,
Repertory_enter_detail.Giveaway_quantity AS WuGouShuLiang, Goods.Purchase_bid * (CAST(Goods.Input_ratio AS decimal(18, 5)) / 100 + 1) AS Tax_inclusive_price, Goods.Purchase_bid AS Expr1,
Eemployee_1.Employee_name AS DengJiRen, Eemployee_2.Employee_name AS GengXinRen, Eemployee.Employee_name AS ShenHeRen, Repertory_enter_detail.Repertory_enter_detail_id,
(Repertory_enter_detail.Repertory_enter_packages *(cast(Goods.Quality_content AS decimal(18, 5)))+Repertory_enter_detail.Giveaway_quantity) AS ZongYaoRuKuShu
Goods INNER JOIN
Attribute_gather_detail ON Goods.Unit_of_measurement_pubid = Attribute_gather_detail.Attribute_gather_detail_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_1 ON Goods.Use_target_pubid = Attribute_gather_detail_1.Attribute_gather_detail_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_2 ON Goods.Quality_grade_pubid = Attribute_gather_detail_2.Attribute_gather_detail_id INNER JOIN
Manage_season ON Goods.Manage_season_id = Manage_season.Manage_season_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_3 ON Goods.Goods_tab_pubid = Attribute_gather_detail_3.Attribute_gather_detail_id INNER JOIN
Manufacturer ON Goods.Manufacturer_id = Manufacturer.Manufacturer_id INNER JOIN
Goods_producing_area ON Goods.Producing_area_id = Goods_producing_area.Producing_area_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_4 ON Goods.Product_status_pubid = Attribute_gather_detail_4.Attribute_gather_detail_id INNER JOIN
Eemployee AS Eemployee_1 ON Goods.Registrant_id = Eemployee_1.Employee_id INNER JOIN
Eemployee ON Goods.Auditor_id = Eemployee.Employee_id INNER JOIN
Eemployee AS Eemployee_2 ON Goods.Update_person_id = Eemployee_2.Employee_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_5 ON Goods.Goods_classify_pubid = Attribute_gather_detail_5.Attribute_gather_detail_id INNER JOIN
Agreement ON Goods.Agreement_id = Agreement.Agreement_id INNER JOIN
Goods_rademark ON Goods.Goods_rademark_id = Goods_rademark.Goods_rademark_id INNER JOIN
Attribute_gather_detail AS Attribute_gather_detail_6 ON Goods.Quality_guarantee_period_pubid = Attribute_gather_detail_6.Attribute_gather_detail_id INNER JOIN
Repertory_enter_detail ON Goods.Goods_id = Repertory_enter_detail.Goods_id
where Repertory_enter_detail.Repertory_enter_id=@Repertory_enter_id
AND (Repertory_enter_detail.Repertory_enter_detail_Farid = 0)
6.对“保存”按钮的功能的操作代码
在JavaScript中的代码：
//新增无订单进仓冲红
function BaoCunWDJCChongHong() {
ui.confirm('是否新增？？？', function (k) {
if ($('#shouhuorenbianhao').combobox('getValue') == && || $('#dengjiren').combobox('getValue') == && ||
$('#RepertoryPlaceIdentifier').combobox('getValue') == && || $('#txtJiLuBianMa').val() == && ||
$('#datdengjishijian').datetimebox('getValue') == &&) {
ui.error(&数据不完整，新增失败！&, 1000, false);
//新增冲红单
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/Insert_Offsert?& +
&repertoryEnterId=& + repertoryEnterid + &&& +
&recordNumber=& + $('#txtWuDingDanCHJiLuBianMa').val() + &&& +
®istrantId=& + $('#dengjiren').combobox('getValue') + &&& +
®isterTime=& + $('#datdengjishijian').datetimebox('getValue'),
function (data) {
if (data & 0) {
$(&#tb进窗信息&).datagrid(&endEdit&, $('#tb进窗信息').datagrid('getRowIndex', $('#tb进窗信息').datagrid('getSelected')));
var dataMingXi = $('#tb进窗信息').datagrid('getRows');
for (var i = 0; i & dataMingXi. i++) {
//新增新进仓明细
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/Insert_NewRepertoryEnterDetail?& +
&repertoryEnterId=& + repertoryEnterid + '&' +
&goodsId=& + dataMingXi[i].Goods_id + '&' +
&repertoryEnterQuantity=& + dataMingXi[i].Shipments_quantity + '&' +
&repertoryEnterPackages=& + dataMingXi[i].NumberOfUnits + &&& +
&giveawayQuantity=& + dataMingXi[i].WuGouShuLiang);
ui.alert('新增进仓冲红单保存成功!!!', 1000, false);
QingChu();
$('#Auditor').combobox({ disabled: false });
$('#datshenheshijian').datetimebox({ disabled: false });
ui.alert('新增进仓冲红单保存失败!!!', 1000, false);
控制代码：
#region 保存新增
//新增新进仓单明细（进仓冲红明细）
public void Insert_NewRepertoryEnterDetail(string repertoryEnterId, string goodsId,
string repertoryEnterQuantity, string repertoryEnterPackages,
string giveawayQuantity)
_myWuDingDanJinCangChongHong.Insert_NewRepertoryEnterDetail(Convert.ToInt32(repertoryEnterId),
Convert.ToInt32(goodsId),
Convert.ToDecimal(repertoryEnterQuantity),
Convert.ToDecimal(repertoryEnterPackages),
Convert.ToDecimal(giveawayQuantity));
//新增冲红单
public int Insert_Offsert(string repertoryEnterId, string recordNumber,
string registrantId, string registerTime)
DataTable dt = _myWuDingDanJinCangChongHong.Insert_Offsert(
Convert.ToInt32(repertoryEnterId),
recordNumber,
Convert.ToInt32(registrantId),
Convert.ToDateTime(registerTime));
return Convert.ToInt32(dt.Rows[0][0].ToString());
#endregion
逻辑层代码：
#region 保存新增
//新增新进仓单明细（进仓冲红明细）
public int Insert_NewRepertoryEnterDetail(int repertoryEnterId, int goodsId,
decimal repertoryEnterQuantity, decimal repertoryEnterPackages,
decimal giveawayQuantity)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Repertory_enter_id&, SqlDbType.Int),
new SqlParameter(&@Goods_id&, SqlDbType.Int),
new SqlParameter(&@Repertory_enter_quantity&, SqlDbType.Decimal),
new SqlParameter(&@Repertory_enter_packages&, SqlDbType.Decimal),
new SqlParameter(&@Giveaway_quantity&, SqlDbType.Decimal),
sql[0].Value = &Insert_NewRepertoryEnterDetail&;
sql[1].Value = repertoryEnterId;
sql[2].Value = goodsId;
sql[3].Value = repertoryEnterQ
sql[4].Value = repertoryEnterP
sql[5].Value = giveawayQ
int dt = _myDalMethod.DAL_OPTableDB_Par(&NOOrderFormOffsetEntry&, sql);
//新增冲红单
public DataTable Insert_Offsert(int repertoryEnterId,
string recordNumber, int registrantId, DateTime registerTime)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Repertory_enter_id&, SqlDbType.Int),
new SqlParameter(&@Record_number&, SqlDbType.Char),
new SqlParameter(&@Registrant_id&, SqlDbType.Int),
new SqlParameter(&@Register_time&, SqlDbType.DateTime),
sql[0].Value = &Insert_Offsert&;
sql[1].Value = repertoryEnterId;
sql[2].Value = recordN
sql[3].Value = registrantId;
sql[4].Value = registerT
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
#region 保存新增
//新增新进仓单明细（进仓冲红明细）
public int Insert_NewRepertoryEnterDetail(int repertoryEnterId, int goodsId,
decimal repertoryEnterQuantity, decimal repertoryEnterPackages,
decimal giveawayQuantity)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Repertory_enter_id&, SqlDbType.Int),
new SqlParameter(&@Goods_id&, SqlDbType.Int),
new SqlParameter(&@Repertory_enter_quantity&, SqlDbType.Decimal),
new SqlParameter(&@Repertory_enter_packages&, SqlDbType.Decimal),
new SqlParameter(&@Giveaway_quantity&, SqlDbType.Decimal),
sql[0].Value = &Insert_NewRepertoryEnterDetail&;
sql[1].Value = repertoryEnterId;
sql[2].Value = goodsId;
sql[3].Value = repertoryEnterQ
sql[4].Value = repertoryEnterP
sql[5].Value = giveawayQ
int dt = _myDalMethod.DAL_OPTableDB_Par(&NOOrderFormOffsetEntry&, sql);
//新增冲红单
public DataTable Insert_Offsert(int repertoryEnterId,
string recordNumber, int registrantId, DateTime registerTime)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Repertory_enter_id&, SqlDbType.Int),
new SqlParameter(&@Record_number&, SqlDbType.Char),
new SqlParameter(&@Registrant_id&, SqlDbType.Int),
new SqlParameter(&@Register_time&, SqlDbType.DateTime),
sql[0].Value = &Insert_Offsert&;
sql[1].Value = repertoryEnterId;
sql[2].Value = recordN
sql[3].Value = registrantId;
sql[4].Value = registerT
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
存储过程：
--新增冲红单
if(@NB='Insert_Offsert')
begin tran
INSERT INTO Offset
(Repertory_enter_id,Record_number,Registrant_id, Register_time,Review_deny)
(@Repertory_enter_id,@Record_number,@Registrant_id,@Register_time,'false')
select @@IDENTITY
Day_max_quantity
Day_max_count = Day_max_count + 1
(Day_max_quantity_id = 20)
commit tran
--新增新进仓单明细（进仓冲红明细）
if(@NB='Insert_NewRepertoryEnterDetail')
INSERT INTO Repertory_enter_detail
(Repertory_enter_detail_Farid,Repertory_enter_id, Goods_id, Repertory_enter_packages,
Repertory_enter_quantity, Giveaway_quantity,ChongHong_deny)
(0,@Repertory_enter_id,@Goods_id,@Repertory_enter_packages,@Repertory_enter_quantity,@Giveaway_quantity,'true')
7.对“修改”按钮的操作，所以功能的代码实现
JavaScript中代码：
//修改无订单进仓冲红
function UpdateWDJinCangCH() {
if (offsetId & 0) {
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/UpdateWdJinCangChongHong?offsetId=& + offsetId + &&& +
&repertoryEnterId=& + repertoryEnterId + &&& +
®istrantId=& + $('#dengjiren').combobox('getValue') + &&& +
&datdengjishijian=& + $('#datdengjishijian').datetimebox('getValue'),
function (data) {
if (data & 0) {
ui.alert('修改无定进仓冲红单成功!!!', 1000, false);
QingChu();
控制器代码：
#region 修改进仓冲红单
public int UpdateWdJinCangChongHong(string offsetId, string repertoryEnterId,
string registrantId, string datdengjishijian)
int dt = _myWuDingDanJinCangChongHong.UpdateWdJinCangChongHong(
Convert.ToInt32(offsetId),
Convert.ToInt32(repertoryEnterId),
Convert.ToInt32(registrantId),
Convert.ToDateTime(datdengjishijian));
#endregion
逻辑层代码：
#region 修改进仓冲红单
public int UpdateWdJinCangChongHong(int offsetId, int repertoryEnterId, int registrantId, DateTime registerTime)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Offset_id&, SqlDbType.Int),
new SqlParameter(&@Repertory_enter_id&, SqlDbType.Int),
new SqlParameter(&@Registrant_id&, SqlDbType.Int),
new SqlParameter(&@Register_time&, SqlDbType.DateTime),
sql[0].Value = &UpdateWdJinCangChongHong&;
sql[1].Value = offsetId;
sql[2].Value = repertoryEnterId;
sql[3].Value = registrantId;
sql[4].Value = registerT
return _myDalMethod.DAL_OPTableDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
存储过程：
--修改无订单进仓冲红
if(@NB='UpdateWdJinCangChongHong')
Repertory_enter_id =@Repertory_enter_id, Registrant_id =@Registrant_id, Register_time =@Register_time
where Offset.Offset_id=@Offset_id
8.对“放弃”按钮的功能操作
function qingKong() {
$('#txtWuDingDanJiLuBianMa').val('');
$('#bumendaima').val('');
$('#txtBuMenMC').val('');
$('#AgreementCode').val('');
$('#RepertoryPlaceIdentifier').combobox('clear');
$('#kucunMC').val('');
$('#jiesuanfangshi').val('');
$('#txtFuJianZhangShu').val('');
$('#txtTongJinCang').val('');
$('#maijia').val('');
$('#shouhuorenbianhao').combobox('clear');
$('#ReceiverName').val('');
$('#SupplyUnits').val('');
$('#tb进窗信息').datagrid('loadData', { total: 0, rows: [] });
$('#dengjiren').combobox('clear');
$('#datdengjishijian').datetimebox('clear');
$('#Auditor').combobox('clear');
$('#datshenheshijian').datetimebox('clear');
parent.document.getElementById(&labTips&).innerHTML = &&;
8.对“审核”按钮的功能操作代码
在JavaScript中：
//审核无定单进仓冲红单
function ShenHeWDJinCangChongHong() {
var auditor = $('#Auditor').combobox('getValue');
var shenheshijian = $('#datshenheshijian').datetimebox('getValue');
var jCchMingXi = $('#tb进窗信息').datagrid('getRows');
var goodsid = 0;
for (var i = 0; i & jCchMingXi. i++) {
goodsid += jCchMingXi[i].Goods_id + &,&;
$.getJSON(&/ZiYingWuDingDanJinCangChongHong/ShenHeWdJinCangChongHong?repertoryPlaceId=& + repertoryPlaceId + &&& +
&goodsid=& + goodsid + &&& +
&offsetId=& + offsetId + &&& +
&auditor=& + auditor + &&& +
&shenheshijian=& + shenheshijian, function (data) {
var tip = &&;
if (data == &审核成功！！！&) {
ui.alert('审核成功！', 1000, false);
ui.error('审核失败！详情请看右栏...', 1000, false);
var strs1 = data.split('+');
for (var j = 0; j & strs1. j++) {
tip += &&li style='font-size:15margin-left:1'&& + strs1[j] + &&/li&&;
if (tip != &&) {
parent.document.getElementById(&labTips&).innerHTML = &&ol && + tip + &&/ol&&;
控制器代码：
#region 审核进仓冲红单
public ActionResult ShenHeWdJinCangChongHong(int repertoryPlaceId, string goodsid, int offsetId, int auditor, DateTime shenheshijian)
string[] goodIds = goodsid.Split(',');
string msg = &&;
var stocksid = new List&int&();
var chongHongShuList = new List&int&();
for (int i = 0; i & goodIds.Length - 1; i++)
DataTable dt = _myWuDingDanJinCangChongHong.SelectStockQuantity(repertoryPlaceId, Convert.ToInt32(goodIds[i]));
int stockQuantity = Convert.ToInt32(dt.Rows[0][&Stock_quantity&]);
int stockId = Convert.ToInt32(dt.Rows[0][&Stock_id&]);
DataTable dt1 = _myWuDingDanJinCangChongHong.SelectJcchMingXi(offsetId);
int repertoryEnterQuantity = Convert.ToInt32(dt1.Rows[0][&Repertory_enter_quantity&]);
int giveawayQuantity = Convert.ToInt32(dt1.Rows[0][&Giveaway_quantity&]);
var zongChongHongShu = repertoryEnterQuantity + giveawayQ
if (stockQuantity & -zongChongHongShu)
stocksid.Add(stockId);
chongHongShuList.Add(zongChongHongShu);
msg += &库存不足！&;
if (msg == &&)
for (int i = 0; i & stocksid.C i++)
_myWuDingDanJinCangChongHong.UpateStockQuary(stocksid[i], chongHongShuList[i]);
_myWuDingDanJinCangChongHong.Insert_JCCHAuditorAndReview_time(auditor, shenheshijian);
_myWuDingDanJinCangChongHong.UpateJcchdShenHeFou(offsetId);
msg = &审核成功！！！&;
return Json(msg, JsonRequestBehavior.AllowGet);
#endregion
逻辑层代码：
#region 审核进仓冲红单
//（1）查询库存数根据仓库id，商品id
public DataTable SelectStockQuantity(int repertoryPlaceId, int goodsid)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Repertory_place_id&, SqlDbType.Int),
new SqlParameter(&@Goods_id&, SqlDbType.Int),
sql[0].Value = &SelectStockQuantity&;
sql[1].Value = repertoryPlaceId;
sql[2].Value =
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
//(2)查询进仓明细（每条单的总冲红数）
public DataTable SelectJcchMingXi(int offsetId)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Offset_id&, SqlDbType.Int),
sql[0].Value = &SelectJcchMingXi&;
sql[1].Value = offsetId;
DataTable dt = _myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
//(3)修改库存数量
public void UpateStockQuary(int stockId, Decimal stockQuantity)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Stock_id&, SqlDbType.Int),
new SqlParameter(&@Stock_quantity&, SqlDbType.Decimal),
sql[0].Value = &UpateStockQuary&;
sql[1].Value = stockId;
sql[2].Value = stockQ
_myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
//(4)修改进仓冲红单的审核否
public void UpateJcchdShenHeFou(int offsetId)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Offset_id&,SqlDbType.Int),
sql[0].Value = &UpateJCCHDShenHeFou&;
sql[1].Value = offsetId;
_myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
//(5)新增进仓冲红的审核人和审核时间
public void Insert_JCCHAuditorAndReview_time(int auditor, DateTime shenheshijian)
SqlParameter[] sql =
new SqlParameter(&@NB&, SqlDbType.Char),
new SqlParameter(&@Auditor_id&, SqlDbType.Int),
new SqlParameter(&@Review_time&, SqlDbType.DateTime),
sql[0].Value = &Insert_JCCHAuditorAndReview_time&;
sql[1].Value =
sql[2].Value =
_myDalMethod.DAL_SelectDB_Par(&NOOrderFormOffsetEntry&, sql);
#endregion
存储过程：
--审核无定单进仓冲红
--（）查询库存数根据仓库id和商品id
if(@NB='SelectStockQuantity')
isnull(Stock_quantity,0) as Stock_quantity,Stock_id
where Repertory_place_id=@Repertory_place_id and Goods_id=@Goods_id
--(2)查询无定进仓明细（每条单的总冲红数根据冲红id
if(@NB='SelectJcchMingXi')
Repertory_enter_detail.Repertory_enter_quantity, Repertory_enter_detail.Giveaway_quantity, Repertory_enter_detail.Repertory_enter_packages, Offset.Offset_id, Offset.Repertory_enter_id
Repertory_enter_detail INNER JOIN
Offset ON Repertory_enter_detail.Repertory_enter_id = Offset.Repertory_enter_id
Offset.Offset_id=@Offset_id
--(3)修改库存数量
if(@NB='UpateStockQuary')
Stock_quantity =Stock_quantity-@Stock_quantity
where Stock_id=@Stock_id
--(4)修改进仓冲红单的审核否
if(@NB='UpateJcchdShenHeFou')
begin tran
Review_deny = 'true'
where Offset_id=@Offset_id
Repertory_enter
YouXiaoFou ='false'
where Repertory_enter_id=(SELECT
Repertory_enter_id
Offset where Offset_id=@Offset_id)
Repertory_enter
ChongHongFou ='true'
where Repertory_enter_id=(SELECT
Repertory_enter_id
(Offset_id = @Offset_id))
commit tran
--(5)新增进仓冲红的审核人和审核时间
if(@NB='Insert_JCCHAuditorAndReview_time')
INSERT INTO Offset
(Auditor_id, Review_time)
(@Auditor_id,@Review_time)
end& & & & & &&
&&仅供初学者使用，禁止商业用途。
&& 每件事情都必须有一个期限，否则，大多数人都会有多少时间就花掉多少时间。
经验不是发生在一个人身上的事件，而是一个人如何看待发生在他身上的事。
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：3096次
排名：千里之外
原创：11篇
