public int Update(BuildDiary_mxModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update opm_Epcm_BuildDiary_mx set ");
builder.Append("TaskCode='" + model.TaskCode + "',");
builder.Append("TaskName='" + model.TaskName + "',");
builder.Append("WorkGroup='" + model.WorkGroup + "',");
builder.Append("WorkersCount='" + model.WorkersCount + "',");
builder.Append("BuildPosition='" + model.BuildPosition + "',");
builder.Append("jdqk='" + model.Jdqk + "',");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where uid='" + model.UID + "'");
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), null));
}
public int Add(BuildDiary_mxModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into opm_Epcm_BuildDiary_mx(UID,BDID,TaskCode,TaskName,WorkGroup,WorkersCount,BuildPosition,Jdqk,Remark) ");
builder.Append("values(");
builder.Append("'" + model.UID + "',");
builder.Append("'" + model.BDID + "',");
builder.Append("'" + model.TaskCode + "',");
builder.Append("'" + model.TaskName + "',");
builder.Append("'" + model.WorkGroup + "',");
builder.Append("'" + model.WorkersCount + "',");
builder.Append("'" + model.BuildPosition + "',");
builder.Append("'" + model.Jdqk + "',");
builder.Append("'" + model.Remark + "')");
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), null));
}