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 + "')")); }
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)); }