Esempio n. 1
0
        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(), "') " })));
        }
Esempio n. 2
0
        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() + "'"));
        }