public int AddContract(ContractMainInfo ci) { string str = ""; object obj2 = str + " begin " + " insert into EPM_Con_ContractMain(ProjectCode, ContractType, ContractCode, ContractName, SignAddr, SignDate, PayMode, SumMoney, Begindate, EndDate, WorkDay, MainWork,QualitySafety, Remark, ContractOwner, ContractOwnerAddr, ContractOwnerMan, ContractOwnerSpokesman,ContractOwnerTel, ContractOwnerFax, ContractOwnerZipcode, ContractOwnerBack, ContractOwnerAccount,ContractOther, ContractOtherAddr, ContractOtherMan, ContractOtherSpokesman, ContractOtherTel, ContractOtherFax, ContractOtherZipcode, ContractOtherBack, ContractOtherAccount,FromType) "; return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, " values('", ci.ProjectCode.ToString(), "','", ci.ContractType.ToString(), "','", ci.ContractCode, "','", ci.ContractName, "', '", ci.SignAddr.ToString(), "',", (ci.SignDate == DateTime.MinValue) ? "null" : ("'" + ci.SignDate.ToShortDateString() + "'"), ", '", ci.PayMode, "',", Convert.ToInt32(ci.SumMoney.ToString()).ToString(), ",", (ci.BeginDate == DateTime.MinValue) ? "null" : ("'" + ci.BeginDate.ToShortDateString() + "'"), ",", (ci.EndDate == DateTime.MinValue) ? "null" : ("'" + ci.EndDate.ToShortDateString() + "'"), ", ", ci.WorkDay, ",'", ci.MainWork, "','", ci.QualitySafety, "','", ci.Remark, "','", ci.ContractOwner, "','", ci.ContractOwnerAddr, "','", ci.ContractOwnerMan, "', '", ci.ContractOwnerSpokesman, "','", ci.ContractOwnerTel, "','", ci.ContractOwnerFax, "', '", ci.ContractOwnerZipcode, "','", ci.ContractOwnerBack, "','", ci.ContractOwnerAccount, "', '", ci.ContractOther, "','", ci.ContractOtherAddr, "','", ci.ContractOtherMan, "', '", ci.ContractOtherSpokesman, "','", ci.ContractOtherTel, "','", ci.ContractOtherFax, "', '", ci.ContractOtherZipcode, "','", ci.ContractOtherBack, "','", ci.ContractOtherAccount, "',", ci.FromType, ") " }) + " end")); }
public int UpdateContract(ContractMainInfo ci) { string str = ""; return(publicDbOpClass.ExecSqlString((((((((((((((((((((((((((((((((((str + " begin " + " update EPM_Con_ContractMain set ") + " ContractName='" + ci.ContractName + "',") + " SignAddr='" + ci.SignAddr + "',") + " SignDate=" + ((ci.SignDate == DateTime.MinValue) ? "null" : ("'" + ci.SignDate.ToShortDateString() + "'")) + ",") + " PayMode='" + ci.PayMode + "',") + " SumMoney=" + ci.SumMoney.ToString() + ",") + " BeginDate=" + ((ci.BeginDate == DateTime.MinValue) ? "null" : ("'" + ci.BeginDate.ToShortDateString() + "'")) + ",") + " EndDate=" + ((ci.EndDate == DateTime.MinValue) ? "null" : ("'" + ci.EndDate.ToShortDateString() + "'")) + ",") + " WorkDay=" + ci.WorkDay.ToString() + ",") + " MainWork='" + ci.MainWork + "',") + " QualitySafety='" + ci.QualitySafety + "',") + " Remark='" + ci.Remark + "',") + " FromType='" + ci.FromType + "',") + " ContractOwner='" + ci.ContractOwner + "',") + " ContractOwnerAddr='" + ci.ContractOwnerAddr + "',") + " ContractOwnerMan='" + ci.ContractOwnerMan + "',") + " ContractOwnerSpokesman='" + ci.ContractOwnerSpokesman + "',") + " ContractOwnerTel='" + ci.ContractOwnerTel + "',") + " ContractOwnerFax='" + ci.ContractOwnerFax + "',") + " ContractOwnerZipcode='" + ci.ContractOwnerZipcode + "',") + " ContractOwnerBack='" + ci.ContractOwnerBack + "',") + " ContractOwnerAccount='" + ci.ContractOwnerAccount + "',") + " ContractOther='" + ci.ContractOther + "',") + " ContractOtherAddr='" + ci.ContractOtherAddr + "',") + " ContractOtherMan='" + ci.ContractOtherMan + "',") + " ContractOtherSpokesman='" + ci.ContractOtherSpokesman + "',") + " ContractOtherTel='" + ci.ContractOtherTel + "',") + " ContractOtherFax='" + ci.ContractOtherFax + "',") + " ContractOtherZipcode='" + ci.ContractOtherZipcode + "',") + " ContractOtherBack='" + ci.ContractOtherBack + "',") + " ContractOtherAccount='" + ci.ContractOtherAccount + "'") + " where ContractCode = '" + ci.ContractCode.ToString() + "' and ") + " ContractType='" + ci.ContractType.ToString() + "'") + " end")); }
public int UpdateBidBalance(ContractMainInfo ci) { string str = ""; return(publicDbOpClass.ExecSqlString((((str + " update EPM_Con_ContractMain set ") + " BalanceRemark='" + ci.BalanceRemark + "',") + " SumBalance=" + ci.SumBalance.ToString() + " ") + " where ContractCode = '" + ci.ContractCode.ToString() + "' ")); }