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)); }