| | |
| | | DataSet ds = new DataSet(); |
| | | ds = oCN.RunProcReturn("select * from Gy_MouldFileMain where HInterID=" + HInterID, "Gy_MouldFileMain"); |
| | | DataRow dr = ds.Tables[0].Rows[0]; |
| | | string Num = dr["HBillNo"].ToString(); |
| | | string Num = dr["HBarCode"].ToString(); |
| | | string Num1 = Num.Substring(0,(Num.Length)-5); |
| | | oCN.BeginTran(); |
| | | for (int i = StarNum1; i <= EndNum1; i++) |
| | |
| | | if (ds1.Tables[0].Rows.Count == 0 || ds1 == null) |
| | | { |
| | | long HItemID = DBUtility.ClsPub.CreateBillID("3899", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //string HBillNo = DBUtility.ClsPub.CreateBillCode("3899", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | string sql = string.Format(@"Insert Into Gy_MouldFileMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HBarCode" + |