protected void btnSubmit_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(SchoolSMS_Person_Id)) { #region 添加 model = new Model_SchoolSMS_Person(); model.SchoolSMS_Person_Id = Guid.NewGuid().ToString(); model.Name = txtName.Text.TrimEnd(); model.Job = txtJob.Text.TrimEnd(); model.PhoneNum = txtPhoneNum.Text.TrimEnd(); model.Company = txtCompany.Text.TrimEnd(); model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; model.School_Id = School_Id; if (bll.Add(model)) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('新增成功!',{ time: 2000,icon:1},function(){window.parent.loadData();window.parent.layer.closeAll()})});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增失败!',{ time: 2000,icon:2});</script>"); return; } #endregion } else { #region 修改 model = bll.GetModel(SchoolSMS_Person_Id); model.Name = txtName.Text.TrimEnd(); model.Job = txtJob.Text.TrimEnd(); model.PhoneNum = txtPhoneNum.Text.TrimEnd(); model.Company = txtCompany.Text.TrimEnd(); if (bll.Update(model)) { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.ready(function(){layer.msg('修改成功!',{ time: 2000,icon:1},function(){window.parent.loadData();window.parent.layer.closeAll()})});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败!',{ time: 2000,icon:2});</script>"); return; } #endregion } } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('操作失败!',{ time: 2000,icon:2}</script>"); } }
/// <summary> /// 修改时的默认值 /// </summary> protected void loadData() { model = bll.GetModel(SchoolSMS_Person_Id); if (model == null) { return; } else { txtName.Text = model.Name; txtJob.Text = model.Job; txtCompany.Text = model.Company; txtPhoneNum.Text = model.PhoneNum; } }
public List <Model_SchoolSMS_Person> DataTableToList(DataTable dt) { List <Model_SchoolSMS_Person> list = new List <Model_SchoolSMS_Person>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SchoolSMS_Person item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_SchoolSMS_Person model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SchoolSMS_Person("); builder.Append("SchoolSMS_Person_Id,School_Id,Name,PhoneNum,Job,Company,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@SchoolSMS_Person_Id,@School_Id,@Name,@PhoneNum,@Job,@Company,@CreateUser,@CreateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SchoolSMS_Person_Id", SqlDbType.Char, 0x24), new SqlParameter("@School_Id", SqlDbType.VarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@PhoneNum", SqlDbType.NVarChar, 11), new SqlParameter("@Job", SqlDbType.NVarChar, 50), new SqlParameter("@Company", SqlDbType.NVarChar, 100), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.SchoolSMS_Person_Id; cmdParms[1].Value = model.School_Id; cmdParms[2].Value = model.Name; cmdParms[3].Value = model.PhoneNum; cmdParms[4].Value = model.Job; cmdParms[5].Value = model.Company; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.CreateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_SchoolSMS_Person DataRowToModel(DataRow row) { Model_SchoolSMS_Person person = new Model_SchoolSMS_Person(); if (row != null) { if (row["SchoolSMS_Person_Id"] != null) { person.SchoolSMS_Person_Id = row["SchoolSMS_Person_Id"].ToString(); } if (row["School_Id"] != null) { person.School_Id = row["School_Id"].ToString(); } if (row["Name"] != null) { person.Name = row["Name"].ToString(); } if (row["PhoneNum"] != null) { person.PhoneNum = row["PhoneNum"].ToString(); } if (row["Job"] != null) { person.Job = row["Job"].ToString(); } if (row["Company"] != null) { person.Company = row["Company"].ToString(); } if (row["CreateUser"] != null) { person.CreateUser = row["CreateUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { person.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } } return(person); }
public bool Update(Model_SchoolSMS_Person model) { StringBuilder builder = new StringBuilder(); builder.Append("update SchoolSMS_Person set "); builder.Append("School_Id=@School_Id,"); builder.Append("Name=@Name,"); builder.Append("PhoneNum=@PhoneNum,"); builder.Append("Job=@Job,"); builder.Append("Company=@Company,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime"); builder.Append(" where SchoolSMS_Person_Id=@SchoolSMS_Person_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@School_Id", SqlDbType.VarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@PhoneNum", SqlDbType.NVarChar, 11), new SqlParameter("@Job", SqlDbType.NVarChar, 50), new SqlParameter("@Company", SqlDbType.NVarChar, 100), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@SchoolSMS_Person_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.School_Id; cmdParms[1].Value = model.Name; cmdParms[2].Value = model.PhoneNum; cmdParms[3].Value = model.Job; cmdParms[4].Value = model.Company; cmdParms[5].Value = model.CreateUser; cmdParms[6].Value = model.CreateTime; cmdParms[7].Value = model.SchoolSMS_Person_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add(Model_SchoolSMS_Person model) { return(this.dal.Add(model)); }
public bool Update(Model_SchoolSMS_Person model) { return(this.dal.Update(model)); }