SCM/Properties/Settings.Designer.cs
@@ -12,7 +12,7 @@ [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "12.0.0.0")] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "16.8.1.0")] internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase { private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings()))); @@ -26,7 +26,7 @@ [global::System.Configuration.ApplicationScopedSettingAttribute()] [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.WebServiceUrl)] [global::System.Configuration.DefaultSettingValueAttribute("http://localhost/WEBS-WMS/WebService1.asmx")] [global::System.Configuration.DefaultSettingValueAttribute("http://124.70.129.242/WEBS-WMS/WebService1.asmx")] public string SCM_WMSWeb_WebService1 { get { return ((string)(this["SCM_WMSWeb_WebService1"])); SCM/Properties/Settings.settings
@@ -3,7 +3,7 @@ <Profiles /> <Settings> <Setting Name="SCM_WMSWeb_WebService1" Type="(Web Service URL)" Scope="Application"> <Value Profile="(Default)">http://localhost/WEBS-WMS/WebService1.asmx</Value> <Value Profile="(Default)">http://124.70.129.242/WEBS-WMS/WebService1.asmx</Value> </Setting> </Settings> </SettingsFile> SCM/SCM.csproj
@@ -798,10 +798,10 @@ </None> </ItemGroup> <ItemGroup> <WebReferenceUrl Include="http://localhost/WEBS-WMS/WebService1.asmx"> <WebReferenceUrl Include="http://124.70.129.242/WEBS-WMS/WebService1.asmx"> <UrlBehavior>Dynamic</UrlBehavior> <RelPath>Web References\WMSWeb\</RelPath> <UpdateFromURL>http://localhost/WEBS-WMS/WebService1.asmx</UpdateFromURL> <UpdateFromURL>http://124.70.129.242/WEBS-WMS/WebService1.asmx</UpdateFromURL> <ServiceLocationURL> </ServiceLocationURL> <CachedDynamicPropName> SCM/Web References/WMSWeb/ClsCLD_Customer_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsCLD_Customer_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsCLD_Customer_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsCLD_Customer_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsCLD_Department_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsCLD_Department_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsCLD_Department_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsCLD_Department_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsCLD_Employee_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsCLD_Employee_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsCLD_Employee_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsCLD_Employee_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsCLD_StockPlace_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsCLD_StockPlace_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsCLD_StockPlace_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsCLD_StockPlace_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsCLD_Supplier_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsCLD_Supplier_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsCLD_Supplier_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsCLD_Supplier_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsCLD_Warehouse_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsCLD_Warehouse_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsCLD_Warehouse_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsCLD_Warehouse_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_BadReason_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_BadReason_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_BadReason_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_BadReason_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_BarCodeBill_WMS_Model_View.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_BarCodeBill_WMS_Model_View" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_BarCodeBill_WMS_Model_View, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_BarCodeBill_WMS_Model_View, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Customer_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Customer_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Customer_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Customer_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Department_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Department_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Department_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Department_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Employee_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Employee_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Employee_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Employee_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Group_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Group_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Group_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Group_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Item30JiTai_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Item30JiTai_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Item30JiTai_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Item30JiTai_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Source_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Source_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Source_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Source_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_StockPlace_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_StockPlace_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_StockPlace_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_StockPlace_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Supplier_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Supplier_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Supplier_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Supplier_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsGy_Warehouse_Model.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsGy_Warehouse_Model" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsGy_Warehouse_Model, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsGy_Warehouse_Model, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/ClsKf_ICStockBill_WMS.datasource
@@ -6,5 +6,5 @@ cause the file to be unrecognizable by the program. --> <GenericObjectDataSource DisplayName="ClsKf_ICStockBill_WMS" Version="1.0" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <TypeInfo>SCM.WMSWeb.ClsKf_ICStockBill_WMS, Web References.WMSWeb.Reference.cs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> <TypeInfo>SCM.WMSWeb.ClsKf_ICStockBill_WMS, Web References.WMSWeb.Reference.cs.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null</TypeInfo> </GenericObjectDataSource> SCM/Web References/WMSWeb/Reference.cs
Diff too large SCM/Web References/WMSWeb/Reference.map
@@ -1,7 +1,7 @@ <?xml version="1.0" encoding="utf-8"?> <DiscoveryClientResultsFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Results> <DiscoveryClientResult referenceType="System.Web.Services.Discovery.DiscoveryDocumentReference" url="http://localhost/WEBS-WMS/WebService1.asmx?disco" filename="WebService1.disco" /> <DiscoveryClientResult referenceType="System.Web.Services.Discovery.ContractReference" url="http://localhost/WEBS-WMS/WebService1.asmx?wsdl" filename="WebService1.wsdl" /> <DiscoveryClientResult referenceType="System.Web.Services.Discovery.DiscoveryDocumentReference" url="http://124.70.129.242/WEBS-WMS/WebService1.asmx?disco" filename="WebService1.disco" /> <DiscoveryClientResult referenceType="System.Web.Services.Discovery.ContractReference" url="http://124.70.129.242/WEBS-WMS/WebService1.asmx?wsdl" filename="WebService1.wsdl" /> </Results> </DiscoveryClientResultsFile> SCM/Web References/WMSWeb/WebService1.disco
@@ -1,6 +1,6 @@ <?xml version="1.0" encoding="utf-8"?> <discovery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.xmlsoap.org/disco/"> <contractRef ref="http://localhost/WEBS-WMS/WebService1.asmx?wsdl" docRef="http://localhost/WEBS-WMS/WebService1.asmx" xmlns="http://schemas.xmlsoap.org/disco/scl/" /> <soap address="http://localhost/WEBS-WMS/WebService1.asmx" xmlns:q1="http://tempuri.org/" binding="q1:WebService1Soap" xmlns="http://schemas.xmlsoap.org/disco/soap/" /> <soap address="http://localhost/WEBS-WMS/WebService1.asmx" xmlns:q2="http://tempuri.org/" binding="q2:WebService1Soap12" xmlns="http://schemas.xmlsoap.org/disco/soap/" /> <contractRef ref="http://124.70.129.242/WEBS-WMS/WebService1.asmx?wsdl" docRef="http://124.70.129.242/WEBS-WMS/WebService1.asmx" xmlns="http://schemas.xmlsoap.org/disco/scl/" /> <soap address="http://124.70.129.242/WEBS-WMS/WebService1.asmx" xmlns:q1="http://tempuri.org/" binding="q1:WebService1Soap" xmlns="http://schemas.xmlsoap.org/disco/soap/" /> <soap address="http://124.70.129.242/WEBS-WMS/WebService1.asmx" xmlns:q2="http://tempuri.org/" binding="q2:WebService1Soap12" xmlns="http://schemas.xmlsoap.org/disco/soap/" /> </discovery> SCM/Web References/WMSWeb/WebService1.wsdl
Diff too large SCM/app.config
@@ -8,7 +8,7 @@ <applicationSettings> <SCM.Properties.Settings> <setting name="SCM_WMSWeb_WebService1" serializeAs="String"> <value>http://localhost/WEBS-WMS/WebService1.asmx</value> <value>http://124.70.129.242/WEBS-WMS/WebService1.asmx</value> </setting> </SCM.Properties.Settings> </applicationSettings> SCM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -185,9 +185,10 @@ public Int64 HOrgID = -1; public string HOrgNumber = ""; public string CampanyName = ""; //客æ·å®å¶ååç§° //------------------------------------------------------------------------- public Int64 HInterID = 0; //å ç //------------------------------------------------------------------------- #region åºå®ä»£ç //æ¸ ç©ºçé¢ public void Sub_ClearBill() { @@ -643,6 +644,13 @@ //ä¿ååæ® private bool Sub_SaveBill() { //è·åå ç if (!oWeb.get_MaxBillID(ModName, ref HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) { MessageBox.Show("è·åå ç 失败ï¼è¯·éæ°ç¹å»çææé®çææ¡ç ï¼"); return false; } // HOrgID = oWeb.get_ORGANIZATIONSIDByName(cmbHOrgID.Text); HOrgNumber = oWeb.get_ORGANIZATIONSNOByName(cmbHOrgID.Text); if (HOrgID == -1) @@ -1472,7 +1480,7 @@ POOrderBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[POOrderBillNo2Col].Value); HSellMaterName = ClsPub.isStrNull(grdSub.Rows[i].Cells[HSellMaterName2Col].Value); HSellBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[HSellBillNo2Col].Value); sSQLMul[mm] = "insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + sSQLMul[mm] = "insert into Gy_BarCodeBill (HinterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + @@ -1483,7 +1491,7 @@ ",POOrderBillNo " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HSellMaterName,HSellBillNo " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() + HInterID.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString() + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'" + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'" @@ -1948,8 +1956,50 @@ DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name); DBUtility.Xt_BaseBillFun.GetGrid(grdSub, this.Name + "grdSub"); grdSub.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //éè¡æ¨¡å¼ //// ClsPub1.initGridList(grdList, this.Name + "grdList"); } private void Display() { //ClsCN SubCn = new ClsCN(); DataSet DSet; string sSql = ""; string sWhere = ""; //è¿æ»¤æ¡ä»¶ if (HInterID <= 0) { return; } // DSet = oWeb.getDataSetBySQL("select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString(), "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo); //DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); //çæé¦è¡æ é¢ if (DSet == null) { MessageBox.Show("没æè¿åä»»ä½ç»æ,æ¡ç ä¸åå¨ï¼" + DBUtility.ClsPub.sExeReturnInfo); return; } // grdList.DataSource = DSet.Tables[0].DefaultView; //å»ç» int FrCol = 0; string s = "æ¯"; ClsPub1.DisplayGrid(grdList, this.Name + "grdList", s, FrCol); //ç»çº¿ //GraphLine(); // } //å ¬å¼éç® private void RowCount(int sRow, int sTag) { @@ -2944,6 +2994,55 @@ } } //å¡«å ¥åæ®è¡¨å¤´ä¿¡æ¯ private void ReportBeforePostRecord_WB()// { try { //Report.FieldByName("ç©æä»£ç ").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HMaterNumber2Col].Value); //Report.FieldByName("ç©æåç§°").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HMaterName2Col].Value); //Report.FieldByName("è§æ ¼åå·").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HMaterModel2Col].Value); ////Report.FieldByName("èªå®ä¹è§æ ¼").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HModel2Col].Value); //Report.FieldByName("æ¡ç ç¼å·").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HTMCol].Value); //Report.FieldByName("æ°é").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HQty2Col].Value); //Report.FieldByName("æºååå·").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HSourceBillNoCol].Value); //Report.FieldByName("éå®è®¢åå·").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HSeOrderBillNo2Col].Value); //Report.FieldByName("ç产车é´").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HDeptName2Col].Value); //Report.FieldByName("夿³¨").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HRemark2Col].Value); } catch (Exception e) { MessageBox.Show("æå°å¤±è´¥!表头ï¼" + e.Message); } } private void ReportFetchRecordByDataTable_WB() { try { DataTable ds = new DataTable(); SCM.Utility.FillRecordToReport(Report, grdList, ds, 0); } catch (Exception e) { MessageBox.Show("æå°å¤±è´¥!表ä½ï¼" + e.Message); } } private void Sub_SetReport_WB(string sOpenTmp) { //å¤æè¡æ° // Report = new GridppReport(); Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here . Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord_WB); Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable_WB); //Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd_WB); } private void dy_Click(object sender, EventArgs e) { //夿æ¯å¦å·²ç»çææ¡ç @@ -3179,7 +3278,34 @@ } private void wbdy_Click(object sender, EventArgs e) { //夿æ¯å¦å·²ç»çææ¡ç if (DBUtility.ClsPub.isStrNull(grdList.Rows[0].Cells[1].Value) == "") { MessageBox.Show("æ¡ç æªçæï¼è¯·å çææ¡ç ååæå°ï¼"); return; } ////æå°å夿æ¡ç æ¯å¦å·²æå°è¿ //if (ReportPrintBegin()) //{ // return; //} //æ ¹æ®å®¢æ·ç±»åæ¾å°å¯¹åºæå°æ¨¡æ¿è¿è¡å¾ªç¯æå° for (int i = 0; i < grdList.Rows.Count; i++) { //è·åå½åè¡ç客æ·ç±»å å¹¶æ¾å° å¯¹åº æ¨¡æ¿ // Sub_SetReport_WB(""); Report.Print(true); Thread.Sleep(1000); } } } } SCM/ÌõÂë´òÓ¡/Gy_BarCodeBill.designer.cs
@@ -103,6 +103,10 @@ this.tabPage1 = new System.Windows.Forms.TabPage(); this.tabPage2 = new System.Windows.Forms.TabPage(); this.grdSub = new System.Windows.Forms.DataGridView(); this.tabPage3 = new System.Windows.Forms.TabPage(); this.grdList = new System.Windows.Forms.DataGridView(); this.wbdy = new System.Windows.Forms.ToolStripButton(); this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator(); this.Tool.SuspendLayout(); this.P1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.pic1)).BeginInit(); @@ -115,6 +119,8 @@ this.tabPage1.SuspendLayout(); this.tabPage2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.grdSub)).BeginInit(); this.tabPage3.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.grdList)).BeginInit(); this.SuspendLayout(); // // Tool @@ -138,6 +144,8 @@ this.kc, this.toolStripSeparator3, this.tb, this.toolStripSeparator7, this.wbdy, this.toolStripSeparator5, this.tc, this.toolStripSeparator12, @@ -392,7 +400,7 @@ this.P1.Controls.Add(this.pb1); this.P1.Dock = System.Windows.Forms.DockStyle.Top; this.P1.Location = new System.Drawing.Point(55, 62); this.P1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.P1.Margin = new System.Windows.Forms.Padding(4); this.P1.Name = "P1"; this.P1.Size = new System.Drawing.Size(1308, 154); this.P1.TabIndex = 31; @@ -400,7 +408,7 @@ // pic1 // this.pic1.Location = new System.Drawing.Point(417, 4); this.pic1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.pic1.Margin = new System.Windows.Forms.Padding(4); this.pic1.Name = "pic1"; this.pic1.Size = new System.Drawing.Size(104, 51); this.pic1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage; @@ -427,9 +435,9 @@ this.gbUp.Controls.Add(this.cmbSourceBillType); this.gbUp.Controls.Add(this.label10); this.gbUp.Location = new System.Drawing.Point(19, 52); this.gbUp.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.gbUp.Margin = new System.Windows.Forms.Padding(4); this.gbUp.Name = "gbUp"; this.gbUp.Padding = new System.Windows.Forms.Padding(4, 4, 4, 4); this.gbUp.Padding = new System.Windows.Forms.Padding(4); this.gbUp.Size = new System.Drawing.Size(1333, 94); this.gbUp.TabIndex = 33; this.gbUp.TabStop = false; @@ -450,7 +458,7 @@ this.cmbHWorksNumber.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cmbHWorksNumber.FormattingEnabled = true; this.cmbHWorksNumber.Location = new System.Drawing.Point(525, 21); this.cmbHWorksNumber.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.cmbHWorksNumber.Margin = new System.Windows.Forms.Padding(4); this.cmbHWorksNumber.Name = "cmbHWorksNumber"; this.cmbHWorksNumber.Size = new System.Drawing.Size(249, 23); this.cmbHWorksNumber.TabIndex = 100; @@ -489,7 +497,7 @@ this.cmbHOrgID.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cmbHOrgID.FormattingEnabled = true; this.cmbHOrgID.Location = new System.Drawing.Point(135, 21); this.cmbHOrgID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.cmbHOrgID.Margin = new System.Windows.Forms.Padding(4); this.cmbHOrgID.Name = "cmbHOrgID"; this.cmbHOrgID.Size = new System.Drawing.Size(249, 23); this.cmbHOrgID.TabIndex = 85; @@ -510,7 +518,7 @@ this.cmbHBarCodeType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.cmbHBarCodeType.FormattingEnabled = true; this.cmbHBarCodeType.Location = new System.Drawing.Point(901, 58); this.cmbHBarCodeType.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.cmbHBarCodeType.Margin = new System.Windows.Forms.Padding(4); this.cmbHBarCodeType.Name = "cmbHBarCodeType"; this.cmbHBarCodeType.Size = new System.Drawing.Size(249, 23); this.cmbHBarCodeType.TabIndex = 81; @@ -532,7 +540,7 @@ this.cmdHEmpID.Image = ((System.Drawing.Image)(resources.GetObject("cmdHEmpID.Image"))); this.cmdHEmpID.ImageAlign = System.Drawing.ContentAlignment.TopRight; this.cmdHEmpID.Location = new System.Drawing.Point(1189, -9); this.cmdHEmpID.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.cmdHEmpID.Margin = new System.Windows.Forms.Padding(4); this.cmdHEmpID.Name = "cmdHEmpID"; this.cmdHEmpID.Size = new System.Drawing.Size(29, 28); this.cmdHEmpID.TabIndex = 79; @@ -544,7 +552,7 @@ this.cmdSourceBillNo.Image = ((System.Drawing.Image)(resources.GetObject("cmdSourceBillNo.Image"))); this.cmdSourceBillNo.ImageAlign = System.Drawing.ContentAlignment.TopRight; this.cmdSourceBillNo.Location = new System.Drawing.Point(747, 56); this.cmdSourceBillNo.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.cmdSourceBillNo.Margin = new System.Windows.Forms.Padding(4); this.cmdSourceBillNo.Name = "cmdSourceBillNo"; this.cmdSourceBillNo.Size = new System.Drawing.Size(29, 28); this.cmdSourceBillNo.TabIndex = 42; @@ -555,7 +563,7 @@ // this.txtHSourceBillNo.ImeMode = System.Windows.Forms.ImeMode.NoControl; this.txtHSourceBillNo.Location = new System.Drawing.Point(525, 58); this.txtHSourceBillNo.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.txtHSourceBillNo.Margin = new System.Windows.Forms.Padding(4); this.txtHSourceBillNo.Name = "txtHSourceBillNo"; this.txtHSourceBillNo.Size = new System.Drawing.Size(220, 25); this.txtHSourceBillNo.TabIndex = 41; @@ -579,7 +587,7 @@ this.cmbSourceBillType.FormattingEnabled = true; this.cmbSourceBillType.ImeMode = System.Windows.Forms.ImeMode.NoControl; this.cmbSourceBillType.Location = new System.Drawing.Point(135, 58); this.cmbSourceBillType.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.cmbSourceBillType.Margin = new System.Windows.Forms.Padding(4); this.cmbSourceBillType.Name = "cmbSourceBillType"; this.cmbSourceBillType.Size = new System.Drawing.Size(249, 23); this.cmbSourceBillType.TabIndex = 36; @@ -598,7 +606,7 @@ // pb1 // this.pb1.Location = new System.Drawing.Point(829, 15); this.pb1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.pb1.Margin = new System.Windows.Forms.Padding(4); this.pb1.Name = "pb1"; this.pb1.Size = new System.Drawing.Size(341, 29); this.pb1.TabIndex = 92; @@ -628,7 +636,7 @@ this.panel2.Controls.Add(this.label8); this.panel2.Dock = System.Windows.Forms.DockStyle.Bottom; this.panel2.Location = new System.Drawing.Point(55, 633); this.panel2.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.panel2.Margin = new System.Windows.Forms.Padding(4); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(1308, 116); this.panel2.TabIndex = 32; @@ -862,7 +870,7 @@ // this.panel1.Dock = System.Windows.Forms.DockStyle.Left; this.panel1.Location = new System.Drawing.Point(0, 62); this.panel1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.panel1.Margin = new System.Windows.Forms.Padding(4); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(55, 687); this.panel1.TabIndex = 33; @@ -871,7 +879,7 @@ // this.panel3.Dock = System.Windows.Forms.DockStyle.Right; this.panel3.Location = new System.Drawing.Point(1363, 62); this.panel3.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.panel3.Margin = new System.Windows.Forms.Padding(4); this.panel3.Name = "panel3"; this.panel3.Size = new System.Drawing.Size(52, 687); this.panel3.TabIndex = 34; @@ -886,7 +894,7 @@ this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill; this.grdMain.ImeMode = System.Windows.Forms.ImeMode.NoControl; this.grdMain.Location = new System.Drawing.Point(4, 4); this.grdMain.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.grdMain.Margin = new System.Windows.Forms.Padding(4); this.grdMain.Name = "grdMain"; this.grdMain.ReadOnly = true; this.grdMain.RowHeadersWidth = 30; @@ -909,7 +917,7 @@ this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom; this.grdSum.Location = new System.Drawing.Point(55, 609); this.grdSum.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.grdSum.Margin = new System.Windows.Forms.Padding(4); this.grdSum.Name = "grdSum"; this.grdSum.ReadOnly = true; this.grdSum.RowHeadersWidth = 51; @@ -922,7 +930,7 @@ // this.grdPrint.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdPrint.Location = new System.Drawing.Point(1079, 679); this.grdPrint.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.grdPrint.Margin = new System.Windows.Forms.Padding(4); this.grdPrint.Name = "grdPrint"; this.grdPrint.RowHeadersWidth = 51; this.grdPrint.RowTemplate.Height = 23; @@ -934,9 +942,10 @@ // this.tabControl1.Controls.Add(this.tabPage1); this.tabControl1.Controls.Add(this.tabPage2); this.tabControl1.Controls.Add(this.tabPage3); this.tabControl1.Dock = System.Windows.Forms.DockStyle.Fill; this.tabControl1.Location = new System.Drawing.Point(55, 216); this.tabControl1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.tabControl1.Margin = new System.Windows.Forms.Padding(4); this.tabControl1.Name = "tabControl1"; this.tabControl1.SelectedIndex = 0; this.tabControl1.Size = new System.Drawing.Size(1308, 393); @@ -946,9 +955,9 @@ // this.tabPage1.Controls.Add(this.grdMain); this.tabPage1.Location = new System.Drawing.Point(4, 25); this.tabPage1.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.tabPage1.Margin = new System.Windows.Forms.Padding(4); this.tabPage1.Name = "tabPage1"; this.tabPage1.Padding = new System.Windows.Forms.Padding(4, 4, 4, 4); this.tabPage1.Padding = new System.Windows.Forms.Padding(4); this.tabPage1.Size = new System.Drawing.Size(1300, 364); this.tabPage1.TabIndex = 0; this.tabPage1.Text = "ç©æä¿¡æ¯"; @@ -958,10 +967,10 @@ // this.tabPage2.Controls.Add(this.grdSub); this.tabPage2.Location = new System.Drawing.Point(4, 25); this.tabPage2.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.tabPage2.Margin = new System.Windows.Forms.Padding(4); this.tabPage2.Name = "tabPage2"; this.tabPage2.Padding = new System.Windows.Forms.Padding(4, 4, 4, 4); this.tabPage2.Size = new System.Drawing.Size(1256, 363); this.tabPage2.Padding = new System.Windows.Forms.Padding(4); this.tabPage2.Size = new System.Drawing.Size(1300, 364); this.tabPage2.TabIndex = 1; this.tabPage2.Text = "æ¡ç ä¿¡æ¯"; this.tabPage2.UseVisualStyleBackColor = true; @@ -976,15 +985,62 @@ this.grdSub.Dock = System.Windows.Forms.DockStyle.Fill; this.grdSub.ImeMode = System.Windows.Forms.ImeMode.NoControl; this.grdSub.Location = new System.Drawing.Point(4, 4); this.grdSub.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.grdSub.Margin = new System.Windows.Forms.Padding(4); this.grdSub.Name = "grdSub"; this.grdSub.ReadOnly = true; this.grdSub.RowHeadersWidth = 30; this.grdSub.RowTemplate.Height = 23; this.grdSub.Size = new System.Drawing.Size(1248, 355); this.grdSub.Size = new System.Drawing.Size(1292, 356); this.grdSub.TabIndex = 45; this.grdSub.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.grdSub_CellBeginEdit); this.grdSub.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.grdSub_CellEndEdit); // // tabPage3 // this.tabPage3.Controls.Add(this.grdList); this.tabPage3.Location = new System.Drawing.Point(4, 25); this.tabPage3.Name = "tabPage3"; this.tabPage3.Size = new System.Drawing.Size(1300, 364); this.tabPage3.TabIndex = 2; this.tabPage3.Text = "æ¡£æ¡å表"; this.tabPage3.UseVisualStyleBackColor = true; // // grdList // this.grdList.AllowUserToAddRows = false; this.grdList.AllowUserToDeleteRows = false; this.grdList.BackgroundColor = System.Drawing.Color.WhiteSmoke; this.grdList.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.grdList.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.grdList.Dock = System.Windows.Forms.DockStyle.Fill; this.grdList.ImeMode = System.Windows.Forms.ImeMode.NoControl; this.grdList.Location = new System.Drawing.Point(0, 0); this.grdList.Margin = new System.Windows.Forms.Padding(4); this.grdList.Name = "grdList"; this.grdList.ReadOnly = true; this.grdList.RowHeadersWidth = 30; this.grdList.RowTemplate.Height = 23; this.grdList.Size = new System.Drawing.Size(1300, 364); this.grdList.TabIndex = 47; // // wbdy // this.wbdy.AutoSize = false; this.wbdy.Image = ((System.Drawing.Image)(resources.GetObject("wbdy.Image"))); this.wbdy.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; this.wbdy.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.wbdy.ImageTransparentColor = System.Drawing.Color.White; this.wbdy.Name = "wbdy"; this.wbdy.Size = new System.Drawing.Size(70, 47); this.wbdy.Text = "å¤å æå°"; this.wbdy.TextAlign = System.Drawing.ContentAlignment.BottomCenter; this.wbdy.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; this.wbdy.Click += new System.EventHandler(this.wbdy_Click); // // toolStripSeparator7 // this.toolStripSeparator7.Name = "toolStripSeparator7"; this.toolStripSeparator7.Size = new System.Drawing.Size(6, 62); // // Gy_BarCodeBill // @@ -1002,7 +1058,7 @@ this.Controls.Add(this.grdPrint); this.ForeColor = System.Drawing.Color.Black; this.KeyPreview = true; this.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); this.Margin = new System.Windows.Forms.Padding(4); this.Name = "Gy_BarCodeBill"; this.Text = "åæ®ç¼è¾"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; @@ -1026,6 +1082,8 @@ this.tabPage1.ResumeLayout(false); this.tabPage2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.grdSub)).EndInit(); this.tabPage3.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.grdList)).EndInit(); this.ResumeLayout(false); } @@ -1105,5 +1163,9 @@ private System.Windows.Forms.ToolStripButton spRow; private System.Windows.Forms.ToolStripSeparator toolStripSeparator6; private System.Windows.Forms.CheckBox chkAddModel; private System.Windows.Forms.TabPage tabPage3; private System.Windows.Forms.DataGridView grdList; private System.Windows.Forms.ToolStripSeparator toolStripSeparator7; private System.Windows.Forms.ToolStripButton wbdy; } } SCM/ÌõÂë´òÓ¡/Gy_BarCodeBill.resx
@@ -462,6 +462,16 @@ YII= </value> </data> <data name="wbdy.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAADmSURBVDhPlY6xDYMwFES9U3bKCmzACEh0FJmACRiAnoqK jo6OzvH7yVk/OFHg0MnC/vfuhzOq6zrK76vzIrRtm3nf92sgBpdlieu6ZgCe5xmAXEot0zTZMABBXLiU grRUVRWHYTATYpOfYR9kiGbMnQelUTu5wzmsoDWk796GOI6jGRDDzH0BxAyQ1Z5e4xhuGUSQWbkAaE2B FMRN05h9uAD4JoHato1d9yjCOjOAH9Y+QggDOW5gwZdfEgR7iAf4YG53yq0eBADzjlWk/+QP2WXf9xmk u3/Bo2wICEG/Oo9XdCIYwhNr8dl8ZRwfdQAAAABJRU5ErkJggg== </value> </data> <data name="tc.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> <value> iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8