public int SelectContractStockBill(ContractStockBillInfo ci)
{
if (publicDbOpClass.DataTableQuary("select * from EPM_Con_ContractStockBill where ID=" + ci.ID.ToString() + " ").Rows.Count > 0)
{
return(1);
}
return(0);
}
public int AddContractStockBill(ContractStockBillInfo ci)
{
string str = "";
object obj2 = str + "INSERT INTO EPM_Con_ContractStockBill ( ProjectCode, ContractType, ContractCode , ResourceCode,ResourceName,Specification,Unit,Price)";
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] {
obj2, "values('", ci.ProjectCode, "','", ci.ContractType, "', '", ci.ContractCode, "', '", ci.ResourceCode, "','", ci.ResourceName, "', ", (ci.Specification.ToString() == " ") ? "null" : ("'" + ci.Specification.ToString() + "'"), ", '", ci.Unit, "',",
ci.Price, " ) "
})));
}
public int UpdateContractStockBill(ContractStockBillInfo ci)
{
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { "UPDATE [EPM_Con_ContractStockBill] SET Specification='", ci.Specification, "', logo='", ci.logo, "', producer='", ci.producer, "', LimitTime='", ci.LimitTime, "', Remark='", ci.Remark, "', Num=", ci.Num, ", Price=", ci.Price, " where ID=", ci.ID.ToString() })));
}
