直接调拨免扫物料条码上传方法修改,条码状态更新导入模块优化
| | |
| | | <Reference Include="System.Drawing" /> |
| | | <Reference Include="System.Windows.Forms" /> |
| | | <Reference Include="System.Xml" /> |
| | | <Reference Include="WebAPI, Version=1.0.0.0, Culture=neutral, processorArchitecture=x86"> |
| | | <SpecificVersion>False</SpecificVersion> |
| | | <HintPath>bin\x86\Debug\WebAPI.dll</HintPath> |
| | | </Reference> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <Compile Include="ClsShowMod.cs" /> |
| | |
| | | HBarCodeStatus = DBUtility.ClsPub.isStrNull(grdmain.Rows[i].Cells[sHBarCodeStatusCol].Value); |
| | | |
| | | //å¿
填项夿 |
| | | if (HBarCode == "") |
| | | { |
| | | sHRemark = sHRemark + "第" + DBUtility.ClsPub.isStrNull(i + 1) + "è¡ï¼æ¡ç ç¼å·ä¸è½ä¸ºç©ºï¼"; |
| | | } |
| | | else |
| | | //if (HBarCode == "") |
| | | //{ |
| | | // sHRemark = sHRemark + "第" + DBUtility.ClsPub.isStrNull(i + 1) + "è¡ï¼æ¡ç ç¼å·ä¸è½ä¸ºç©ºï¼"; |
| | | //} |
| | | //else |
| | | //{ |
| | | // b = true; |
| | | //} |
| | | if (HBarCode != "") |
| | | { |
| | | b = true; |
| | | } |
| | |
| | | } |
| | | OpenExcelFile.Title = "Open Excel File "; |
| | | OpenExcelFile.FileName = ""; |
| | | OpenExcelFile.Filter = "Microsoft Office Excel Files(*.xls)|*.xls"; |
| | | OpenExcelFile.Filter = "Microsoft Office Excel Files(*.xls;*.xlsx)|*.xls;*.xlsx"; |
| | | OpenExcelFile.ShowDialog(); |
| | | if (OpenExcelFile.FileName != "") |
| | | { |
| | |
| | | //æ°é䏿ºåæ°éä¸ä¸è´æ¶ï¼æ´æ°æ¡ç åºå
¥åºä¸´æ¶è¡¨ HQty åæ®µå¼ |
| | | if (item.HQty != item.HQtyMust) |
| | | { |
| | | oCn.RunProc("Update KF_PonderationBillMain_Temp set HQty=" + item.HQty.ToString() + " where HInterID= " + websLsmain.HInterID.ToString() + " and HBillType='" + websLsmain.HBillType + "' and HSourceInterID= " + item.HSourceInterID.ToString() + " and HSourceEntryID= " + item.HSourceEntryID.ToString()); |
| | | oCn.RunProc("Update KF_PonderationBillMain_Temp set HQty2=" + item.HQty.ToString() + " where HInterID= " + websLsmain.HInterID.ToString() + " and HBillType='" + websLsmain.HBillType + "' and HSourceInterID= " + item.HSourceInterID.ToString() + " and HSourceEntryID= " + item.HSourceEntryID.ToString()); |
| | | } |
| | | } |
| | | |