public int SelectContractTask(ContractTaskInfo ci) { if (publicDbOpClass.DataTableQuary("select * from EPM_Con_ContractTask where ContractType='" + ci.ContractType.ToString() + "' and ContractCode ='" + ci.ContractCode.ToString() + "' and TaskCode='" + ci.TaskCode.ToString() + "'").Rows.Count > 0) { return(1); } return(0); }
public int AddContractTask(ContractTaskInfo ci) { string str = ""; string str2 = str + "INSERT INTO EPM_Con_ContractTask ( ProjectCode, ContractType, ContractCode, TaskCode, TaskName, QuantityUnit,Quantity, ContractPrice, subtotal )"; string str3 = str2 + "values('" + ci.ProjectCode.ToString() + "','" + ci.ContractType.ToString() + "', '" + ci.ContractCode.ToString() + "',"; object obj2 = str3 + " '" + ci.TaskCode.ToString() + "','" + ci.TaskName.ToString() + "', '" + ci.QuantityUnit.ToString() + "',"; object obj3 = string.Concat(new object[] { obj2, " ", ci.Quantity, ", " }); object obj4 = string.Concat(new object[] { obj3, " ", ci.ContractPrice, ", " }); return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj4, " ", ci.subtotal, ") " }))); }
public int UpdateContractTask(ContractTaskInfo ci) { return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { "UPDATE [EPM_Con_ContractTask] SET Quantity=", ci.Quantity, ", ContractPrice=", ci.ContractPrice, ", subtotal=", ci.subtotal, " where ContractType='", ci.ContractType.ToString(), "'and ContractCode ='", ci.ContractCode.ToString(), "' and TaskCode='", ci.TaskCode.ToString(), "'" }))); }