Esempio n. 1
0
        public static bool AddBackBill(MaterialBackInfo mbi)
        {
            string str2 = "";
            string str3 = str2 + " insert into EPM_Stuff_BackBill(BackCode,BackBillCode,BackDate,BackDept,Sender,ProjectCode,Checker,Remark,isBackToEnt) values('" + mbi.OutCode.ToString() + "','" + mbi.OutBillCode + "','" + mbi.OutDate.ToShortDateString() + "','" + mbi.LLDept + "','" + mbi.LLMan + "',";

            return(publicDbOpClass.NonQuerySqlString(str3 + "'" + mbi.ProjectCode.ToString() + "','" + mbi.Sender + "','" + mbi.Remark + "','0') "));
        }
Esempio n. 2
0
        public static bool UpdBackBill(MaterialBackInfo mbi)
        {
            string str2 = "";
            string str3 = str2 + " update EPM_Stuff_BackBill set BackDate='" + mbi.OutDate.ToShortDateString() + "',BackDept='" + mbi.LLDept + "',";

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