Exemplo n.º 1
0
        public int StuffFirstInsert(StuffFirstMain sm)
        {
            string str  = "";
            string str2 = str + "insert into EPM_Stuff_PartyABill(ProjectCode,FirstClass,Maker,FirstSummary,Remark,FirstAddDate,WarrantCode) values ('";
            string str3 = str2 + sm.ProjectCode + " ','" + sm.FirstClass + "','";

            return(publicDbOpClass.ExecSqlString(str3 + sm.Maker + "','" + sm.FirstSummary + "','" + sm.Remark + "','" + sm.FirstAddDate + "','" + sm.WarrantCode + "')"));
        }
Exemplo n.º 2
0
        public int StuffFirstUp(StuffFirstMain sm)
        {
            string str = "";

            return(publicDbOpClass.ExecSqlString((((((((str + "update EPM_Stuff_PartyABill set ProjectCode = '" + sm.ProjectCode + "',") + " FirstAddDate = '" + sm.FirstAddDate + "' ,") + " Maker = '" + sm.Maker + "',") + " Remark = '" + sm.Remark + "',") + " FirstClass = '" + sm.FirstClass + "',") + " FirstSummary = '" + sm.FirstSummary + "',") + " WarrantCode = '" + sm.WarrantCode + "'") + " where FirstID = " + sm.FirstID));
        }