public static bool AddInBill(GoodsInBill gib) { string str2 = ""; object obj2 = str2 + " insert into EPM_Stuff_MaterialIn(StockInCode,StockInBillCode,InDate,ProjectCode,SupplyMan,Sender,Checker,Reciver,Remark,BuyDept,ContractCode,PlanID,InAddr) values('" + gib.StockInCode.ToString() + "','" + gib.StockInBillCode + "','" + gib.InDate.ToShortDateString() + "','" + gib.ProjectCode.ToString() + "'," + gib.SupplyMan.ToString() + ",'" + gib.Sender + "'"; return(publicDbOpClass.NonQuerySqlString(string.Concat(new object[] { obj2, ",'", gib.Checker, "','", gib.Reciver, "','", gib.Remark, "',", gib.BuyDept, ",'", gib.ContractCode.ToString(), "',", gib.PlanID.ToString(), ",'", gib.InAddr.ToString(), "') " }))); }
public static bool UpdInBill(GoodsInBill gib) { string str = ""; object obj2 = str; return(publicDbOpClass.NonQuerySqlString(string.Concat(new object[] { obj2, "update EPM_Stuff_MaterialIn set InDate='", gib.InDate.ToShortDateString(), "',ProjectCode='", gib.ProjectCode.ToString(), "',InAddr='", gib.InAddr.ToString(), "',Sender='", gib.Sender, "',Checker='", gib.Checker, "',Reciver='", gib.Reciver, "',Remark='", gib.Remark, "',BuyDept=", gib.BuyDept }) + " where StockInCode='" + gib.StockInCode.ToString() + "'")); }