Exemplo n.º 1
0
        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));
        }
Exemplo n.º 2
0
        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));
        }