Пример #1
0
        public static bool AddAttemperBill(GoodsOutBill gob)
        {
            string str2 = "";
            string str3 = str2 + " insert into EPM_Stuff_Attemper(OutCode,OutBillCode,OutDate,LLDept,LLMan,ProjectCode,Sender,Remark) values('" + gob.OutCode.ToString() + "','" + gob.OutBillCode + "','" + gob.OutDate.ToShortDateString() + "','" + gob.LLDept + "','" + gob.LLMan + "',";

            return(publicDbOpClass.NonQuerySqlString(str3 + "'" + gob.ProjectCode.ToString() + "','" + gob.Sender + "','" + gob.Remark + "') "));
        }
Пример #2
0
        public static bool UpdOutBill(GoodsOutBill gob)
        {
            string str2 = "";
            string str3 = str2 + " update EPM_Stuff_MaterialOut set OutDate='" + gob.OutDate.ToShortDateString() + "',LLDept='" + gob.LLDept + "',";

            return(publicDbOpClass.NonQuerySqlString((str3 + "LLMan='" + gob.LLMan + "',ProjectCode='" + gob.ProjectCode.ToString() + "',Sender='" + gob.Sender + "',Remark='" + gob.Remark + "'") + " where OutCode='" + gob.OutCode.ToString() + "'"));
        }