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