public bool Update(Model_S_MeasureTarget model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update S_MeasureTarget set ");
builder.Append("GradeTerm=@GradeTerm,");
builder.Append("Subject=@Subject,");
builder.Append("Resource_Version=@Resource_Version,");
builder.Append("Parent_Id=@Parent_Id,");
builder.Append("MTName=@MTName,");
builder.Append("MTCode=@MTCode,");
builder.Append("MTLevel=@MTLevel,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("UpdateUser=@UpdateUser,");
builder.Append("UpdateTime=@UpdateTime");
builder.Append(" where S_MeasureTarget_Id=@S_MeasureTarget_Id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@Parent_Id", SqlDbType.Char, 0x24), new SqlParameter("@MTName", SqlDbType.VarChar, 200), new SqlParameter("@MTCode", SqlDbType.VarChar, 50), new SqlParameter("@MTLevel", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@S_MeasureTarget_Id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.GradeTerm;
cmdParms[1].Value = model.Subject;
cmdParms[2].Value = model.Resource_Version;
cmdParms[3].Value = model.Parent_Id;
cmdParms[4].Value = model.MTName;
cmdParms[5].Value = model.MTCode;
cmdParms[6].Value = model.MTLevel;
cmdParms[7].Value = model.CreateUser;
cmdParms[8].Value = model.CreateTime;
cmdParms[9].Value = model.UpdateUser;
cmdParms[10].Value = model.UpdateTime;
cmdParms[11].Value = model.S_MeasureTarget_Id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_S_MeasureTarget DataRowToModel(DataRow row)
{
Model_S_MeasureTarget target = new Model_S_MeasureTarget();
if (row != null)
{
if (row["S_MeasureTarget_Id"] != null)
{
target.S_MeasureTarget_Id = row["S_MeasureTarget_Id"].ToString();
}
if (row["GradeTerm"] != null)
{
target.GradeTerm = row["GradeTerm"].ToString();
}
if (row["Subject"] != null)
{
target.Subject = row["Subject"].ToString();
}
if (row["Resource_Version"] != null)
{
target.Resource_Version = row["Resource_Version"].ToString();
}
if (row["Parent_Id"] != null)
{
target.Parent_Id = row["Parent_Id"].ToString();
}
if (row["MTName"] != null)
{
target.MTName = row["MTName"].ToString();
}
if (row["MTCode"] != null)
{
target.MTCode = row["MTCode"].ToString();
}
if (row["MTLevel"] != null)
{
target.MTLevel = row["MTLevel"].ToString();
}
if (row["CreateUser"] != null)
{
target.CreateUser = row["CreateUser"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
target.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["UpdateUser"] != null)
{
target.UpdateUser = row["UpdateUser"].ToString();
}
if ((row["UpdateTime"] != null) && (row["UpdateTime"].ToString() != ""))
{
target.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
return(target);
}
/// <summary>
/// 修改时的默认值
/// </summary>
protected void loadData()
{
if (string.IsNullOrEmpty(mtId))
{
model = bll.GetModel(mtId_Copy);
}
else
{
model = bll.GetModel(mtId);
}
if (model != null)
{
ddlMTLevel.SelectedValue = model.MTLevel;
txtMTName.Text = model.MTName;
txtMTCode.Text = model.MTCode;
}
}
public List <Model_S_MeasureTarget> DataTableToList(DataTable dt)
{
List <Model_S_MeasureTarget> list = new List <Model_S_MeasureTarget>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_S_MeasureTarget item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_S_MeasureTarget model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into S_MeasureTarget(");
builder.Append("S_MeasureTarget_Id,GradeTerm,Subject,Resource_Version,Parent_Id,MTName,MTCode,MTLevel,CreateUser,CreateTime,UpdateUser,UpdateTime)");
builder.Append(" values (");
builder.Append("@S_MeasureTarget_Id,@GradeTerm,@Subject,@Resource_Version,@Parent_Id,@MTName,@MTCode,@MTLevel,@CreateUser,@CreateTime,@UpdateUser,@UpdateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@S_MeasureTarget_Id", SqlDbType.Char, 0x24), new SqlParameter("@GradeTerm", SqlDbType.Char, 0x24), new SqlParameter("@Subject", SqlDbType.Char, 0x24), new SqlParameter("@Resource_Version", SqlDbType.Char, 0x24), new SqlParameter("@Parent_Id", SqlDbType.Char, 0x24), new SqlParameter("@MTName", SqlDbType.VarChar, 200), new SqlParameter("@MTCode", SqlDbType.VarChar, 50), new SqlParameter("@MTLevel", SqlDbType.Char, 0x24), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.S_MeasureTarget_Id;
cmdParms[1].Value = model.GradeTerm;
cmdParms[2].Value = model.Subject;
cmdParms[3].Value = model.Resource_Version;
cmdParms[4].Value = model.Parent_Id;
cmdParms[5].Value = model.MTName;
cmdParms[6].Value = model.MTCode;
cmdParms[7].Value = model.MTLevel;
cmdParms[8].Value = model.CreateUser;
cmdParms[9].Value = model.CreateTime;
cmdParms[10].Value = model.UpdateUser;
cmdParms[11].Value = model.UpdateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(mtId))
{
#region 添加
//验证MTCode是否已存在
string strWhereCount = " MTCode='" + txtMTCode.Text.Trim()
+ "' and GradeTerm='" + GradeTerm
+ "' and Subject='" + Subject
+ "' and Resource_Version='" + Resource_Version + "'";
if (bll.GetRecordCount(strWhereCount) > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('编码已存在。', { time: 2000, icon: 4})</script>");
return;
}
model.S_MeasureTarget_Id = Guid.NewGuid().ToString();
model.GradeTerm = GradeTerm;
model.Subject = Subject;
model.Resource_Version = Resource_Version;
model.Parent_Id = parentId;
model.MTName = txtMTName.Text.Trim();
model.MTCode = txtMTCode.Text.Trim();
model.MTLevel = ddlMTLevel.SelectedValue;
model.CreateTime = DateTime.Now;
model.CreateUser = loginUser.SysUser_ID;
if (bll.Add(model))
{
if (parentId == "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadSubData2('0');parent.layer.close(index)});</script>");
return;
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增失败!',{ time: 2000,icon:2});</script>");
return;
}
Rc.Common.SystemLog.SystemLog.AddLogFromBS(loginUser.SysUser_ID, "", "新增测量目标");
#endregion
}
else
{
#region 修改
model = bll.GetModel(mtId);
model.MTName = txtMTName.Text.Trim();
model.MTCode = txtMTCode.Text.Trim();
model.MTLevel = ddlMTLevel.SelectedValue;
model.UpdateTime = DateTime.Now;
model.UpdateUser = loginUser.SysUser_ID;
if (bll.Update(model))
{
if (parentId == "0")
{
ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadSubData2('0');parent.layer.close(index);});</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败!',{ time: 2000,icon:2});</script>");
return;
}
Rc.Common.SystemLog.SystemLog.AddLogFromBS(loginUser.SysUser_ID, "", "修改测量目标");
#endregion
}
}
catch (Exception)
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('操作失败!',{ time: 2000,icon:2});});</script>");
}
}
public bool Add(Model_S_MeasureTarget model)
{
return(this.dal.Add(model));
}
public bool Update(Model_S_MeasureTarget model)
{
return(this.dal.Update(model));
}
