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