| | |
| | | ",HCarNumber='" + omodel.HCarNumber + "'" + |
| | | ",HPhone='" + omodel.HPhone + "'" + |
| | | ",HOutReason='" + omodel.HOutReason + "'" + |
| | | ",HOutAddress='" + omodel.HOutAddress + "'" + |
| | | ",HMaterName='" + omodel.HMaterName + "'" + |
| | | " where HInterID=" + lngBillKey.ToString(); |
| | | |
| | |
| | | //鎻掑叆涓昏〃 |
| | | string mainSql = "Insert Into Xs_OutDoorBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate,HBillStatus,HMaker,HMakeDate,HRemark,HStockOrgID" + |
| | | ",HCusID,HEmpID,HShipper,HCarNumber,HPhone,HOutReason,HMaterName) " + |
| | | ",HCusID,HEmpID,HShipper,HCarNumber,HPhone,HOutReason,HOutAddress,HMaterName) " + |
| | | "values(" + |
| | | "" + omodel.HDate.Year + "" + |
| | | "," + omodel.HDate.Month + "" + |
| | |
| | | ",'" + omodel.HCarNumber + "'" + |
| | | ",'" + omodel.HPhone + "'" + |
| | | ",'" + omodel.HOutReason + "'" + |
| | | ",'" + omodel.HOutAddress + "'" + |
| | | ",'" + omodel.HMaterName + "'" + |
| | | ")"; |
| | | |
| | |
| | | omodel.HCarNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCarNumber"]); |
| | | omodel.HPhone = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPhone"]); |
| | | omodel.HOutReason = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutReason"]); |
| | | omodel.HOutAddress = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutAddress"]); |
| | | omodel.HMaterName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterName"]); |
| | | omodel.HOutCheckMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckMan"]); |
| | | omodel.HOutCheckDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckDate"]); |