public virtual bool Edit(DbConn PubConn, tb_user_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//员工工号
new ProcedureParameter("@userstaffno", model.userstaffno),
//
new ProcedureParameter("@username", model.username),
//员工角色，查看代码枚举：开发人员，管理员
new ProcedureParameter("@userrole", model.userrole),
//
new ProcedureParameter("@usercreatetime", model.usercreatetime),
//员工手机号码
new ProcedureParameter("@usertel", model.usertel),
//
new ProcedureParameter("@useremail", model.useremail),
//登录密码
new ProcedureParameter("@userpsw", model.userpsw)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_user set userstaffno=@userstaffno,username=@username,userrole=@userrole,usercreatetime=@usercreatetime,usertel=@usertel,useremail=@useremail,userpsw=@userpsw where id=@id", Par);
return rev == 1;
}
public virtual bool Add(DbConn PubConn, tb_user_model model)
{
List<ProcedureParameter> Par = new List<ProcedureParameter>()
{
//员工工号
new ProcedureParameter("@userstaffno", model.userstaffno),
//
new ProcedureParameter("@username", model.username),
//员工角色，查看代码枚举：开发人员，管理员
new ProcedureParameter("@userrole", model.userrole),
//
new ProcedureParameter("@usercreatetime", model.usercreatetime),
//员工手机号码
new ProcedureParameter("@usertel", model.usertel),
//
new ProcedureParameter("@useremail", model.useremail),
//登录密码
new ProcedureParameter("@userpsw", model.userpsw)
};
int rev = PubConn.ExecuteSql(@"insert into tb_user(userstaffno,username,userrole,usercreatetime,usertel,useremail,userpsw)
values(@userstaffno,@username,@userrole,@usercreatetime,@usertel,@useremail,@userpsw)", Par);
return rev == 1;
}
public ActionResult Add(tb_user_model model)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_user_dal dal = new tb_user_dal();
model.usercreatetime = DateTime.Now;
model.usertel = model.usertel.NullToEmpty();
model.useremail = model.useremail.NullToEmpty();
if (model.id == 0)
dal.Add(PubConn, model);
else
dal.Edit(PubConn, model);
}
return RedirectToAction("index");
});
}
public virtual tb_user_model CreateModel(DataRow dr)
{
var o = new tb_user_model();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//员工工号
if (dr.Table.Columns.Contains("userstaffno"))
{
o.userstaffno = dr["userstaffno"].Tostring();
}
//
if (dr.Table.Columns.Contains("username"))
{
o.username = dr["username"].Tostring();
}
//员工角色，查看代码枚举：开发人员，管理员
if (dr.Table.Columns.Contains("userrole"))
{
o.userrole = dr["userrole"].ToByte();
}
//
if (dr.Table.Columns.Contains("usercreatetime"))
{
o.usercreatetime = dr["usercreatetime"].ToDateTime();
}
//员工手机号码
if (dr.Table.Columns.Contains("usertel"))
{
o.usertel = dr["usertel"].Tostring();
}
//
if (dr.Table.Columns.Contains("useremail"))
{
o.useremail = dr["useremail"].Tostring();
}
//
if (dr.Table.Columns.Contains("userpsw"))
{
o.userpsw = dr["userpsw"].Tostring();
}
return o;
}