protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (CheckInput())
{
Model_SysUser usermodel = new Model_SysUser();
bool result = false;
usermodel = GetSysUserModel();
result = new SysUserBLL().MyInfoUpdate(usermodel);
if (result)
{
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("【修改个人信息】【ID】： {0}【是否可用】：{1}【手机】：{2}", usermodel.SysUser_ID, usermodel.SysUser_Enable, usermodel.SysUser_Tel);
new BLL_clsAuth().AddLogFromBS(Module_Id, strLog.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>PublicHandel('1','操作成功！','');</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>PublicHandel('2','操作失败！','');</script>");
}
}
}
catch (Exception ex)
{
new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类：{0}，方法：{1},错误信息：{2}， 详细：{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
throw ex;
}
}
public int AddSysUser(Model_SysUser Model_SysUser, SysRoleModel SysRoleModel, string sType)
{
List <string> sQLStringList = new List <string>();
string item = string.Empty;
if (sType == "1")
{
string str2 = string.Empty;
str2 = string.Format("insert into SysUser(SysUser_ID,SysUser_Name,SysUser_LoginName,SysUser_PassWord,SysUser_Tel,SysDepartment_ID,SysUser_Enable,SysUser_Remark,CreateTime,CreateUser) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}') ;", new object[] { Model_SysUser.SysUser_ID, Model_SysUser.SysUser_Name, Model_SysUser.SysUser_LoginName, Model_SysUser.SysUser_PassWord, Model_SysUser.SysUser_Tel, Model_SysUser.SysDepartment_ID, Model_SysUser.SysUser_Enable, Model_SysUser.SysUser_Remark, Model_SysUser.CreateTime, Model_SysUser.CreateUser });
sQLStringList.Add(str2);
}
else
{
string str3 = string.Empty;
string str4 = string.Empty;
string str5 = string.Empty;
str3 = string.Format("update SysUser set SysUser_Name='{0}',SysUser_LoginName='{1}',SysUser_PassWord='******',SysUser_Tel='{3}',SysUser_Enable='{4}',[UpdateTime]='{5}',[UpdateUser]='{6}' where sysUser_ID='{7}'", new object[] { Model_SysUser.SysUser_Name, Model_SysUser.SysUser_LoginName, Model_SysUser.SysUser_PassWord, Model_SysUser.SysUser_Tel, Model_SysUser.SysUser_Enable, Model_SysUser.UpdateTime, Model_SysUser.UpdateUser, Model_SysUser.SysUser_ID });
str5 = string.Format(" delete from SysUserRoleRelation where SysUser_ID='{0}'", Model_SysUser.SysUser_ID);
sQLStringList.Add(str3);
sQLStringList.Add(str4);
sQLStringList.Add(str5);
}
foreach (SysUserRoleRelationModel model in SysRoleModel.SysUserRoleList)
{
item = string.Format("insert into SysUserRoleRelation(SysUser_ID,SysRole_ID,CreateTime,CreateUser) values('{0}','{1}','{2}','{3}');", new object[] { model.SysUser_ID, model.SysRole_ID, model.CreateTime, model.CreateUser });
sQLStringList.Add(item);
}
return(DbHelperSQL.ExecuteSqlTran(sQLStringList));
}
public bool Update(Model_SysUser model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SysUser set ");
builder.Append("SysUser_ID=@SysUser_ID,");
builder.Append("SysUser_Name=@SysUser_Name,");
builder.Append("SysUser_LoginName=@SysUser_LoginName,");
builder.Append("SysUser_PassWord=@SysUser_PassWord,");
builder.Append("SysUser_Tel=@SysUser_Tel,");
builder.Append("SysDepartment_ID=@SysDepartment_ID,");
builder.Append("SysUser_Enable=@SysUser_Enable,");
builder.Append("SysUser_Remark=@SysUser_Remark,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("CreateUser=@CreateUser,");
builder.Append("UpdateTime=@UpdateTime,");
builder.Append("UpdateUser=@UpdateUser");
builder.Append(" where ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysUser_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysUser_Name", SqlDbType.NVarChar, 0x80), new SqlParameter("@SysUser_LoginName", SqlDbType.NVarChar, 20), new SqlParameter("@SysUser_PassWord", SqlDbType.NVarChar, 200), new SqlParameter("@SysUser_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@SysDepartment_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysUser_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysUser_Remark", SqlDbType.NVarChar, 0x800), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysUser_ID;
cmdParms[1].Value = model.SysUser_Name;
cmdParms[2].Value = model.SysUser_LoginName;
cmdParms[3].Value = model.SysUser_PassWord;
cmdParms[4].Value = model.SysUser_Tel;
cmdParms[5].Value = model.SysDepartment_ID;
cmdParms[6].Value = model.SysUser_Enable;
cmdParms[7].Value = model.SysUser_Remark;
cmdParms[8].Value = model.CreateTime;
cmdParms[9].Value = model.CreateUser;
cmdParms[10].Value = model.UpdateTime;
cmdParms[11].Value = model.UpdateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
//从页面上获取模板数据
private Model_SysUser GetSysUserFromPage()
{
Model_SysUser Model_SysUser = null;
switch (actionType)
{
case SysUser.Add:
Model_SysUser = new Model_SysUser();
Model_SysUser.SysUser_ID = sysUser_IDs;
Model_SysUser.SysUser_Name = txtName.Text.Trim();
Model_SysUser.SysUser_LoginName = txtNamelogin.Text.Trim();
if (!string.IsNullOrEmpty(txtpwdlogin.Text.Trim()))
{
Model_SysUser.SysUser_PassWord = DESEncryptLogin.EncryptString(txtpwdlogin.Text.Trim());
}
else
{
Model_SysUser.SysUser_PassWord = GetSysUser_PassWord();
}
Model_SysUser.SysUser_Tel = txtPhone.Text.Trim();
if (ckbIsEnable.Checked)
{
Model_SysUser.SysUser_Enable = true;
}
else
{
Model_SysUser.SysUser_Enable = false;
}
Model_SysUser.CreateTime = DateTime.Now;
Model_SysUser.CreateUser = loginUser.SysUser_ID;
break;
case SysUser.Edit:
Model_SysUser = GetSysUserInfo();
Model_SysUser.SysUser_ID = sysUser_ID;
Model_SysUser.SysUser_Name = txtName.Text.Trim();
Model_SysUser.SysUser_LoginName = txtNamelogin.Text.Trim();
if (!string.IsNullOrEmpty(txtpwdlogin.Text.Trim()))
{
Model_SysUser.SysUser_PassWord = DESEncryptLogin.EncryptString(txtpwdlogin.Text.Trim());
}
Model_SysUser.SysUser_Tel = txtPhone.Text.Trim();
if (ckbIsEnable.Checked)
{
Model_SysUser.SysUser_Enable = true;
}
else
{
Model_SysUser.SysUser_Enable = false;
}
Model_SysUser.UpdateTime = DateTime.Now;
Model_SysUser.UpdateUser = loginUser.SysUser_ID;
break;
}
return(Model_SysUser);
}
public bool MyInfoUpdate(Model_SysUser model)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat("UPDATE SysUser SET [SysUser_Name]='{0}',[SysUser_LoginName]='{1}',[SysUser_Tel]='{2}',[SysUser_Remark]='{3}',[UpdateTime]='{4}',[UpdateUser]='{5}' where [SysUser_ID]='{6}';", new object[] { model.SysUser_Name, model.SysUser_LoginName, model.SysUser_Tel, model.SysUser_Remark, model.UpdateTime, model.UpdateUser, model.SysUser_ID });
if (DbHelperSQL.ExecuteSql(builder.ToString()) <= 0)
{
return(false);
}
return(true);
}
internal int Update(DbTransaction tran, Model_SysUser model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" UPDATE ");
builder.Append(" SysUser ");
builder.Append(" SET ");
builder.Append(" SysUser_ID=@SysUser_ID,SysUser_Name=@SysUser_Name,SysUser_LoginName=@SysUser_LoginName,SysUser_PassWord=@SysUser_PassWord,SysUser_Tel=@SysUser_Tel,SysRole_ID=@SysRole_ID,SysDepartment_ID=@SysDepartment_ID,SysUser_Enable=@SysUser_Enable,SysUser_Remark=@SysUser_Remark,CreateTime=@CreateTime,CreateUser=@CreateUser,UpdateTime=@UpdateTime,UpdateUser=@UpdateUser ");
builder.Append(" WHERE ");
builder.Append(" SysUser_ID=@SysUser_ID ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SysUser_ID, model.SysUser_Name, model.SysUser_LoginName, model.SysUser_PassWord, model.SysUser_Tel, model.SysRole_ID, model.SysDepartment_ID, model.SysUser_Enable, model.SysUser_Remark, model.CreateTime, model.CreateUser, model.UpdateTime, model.UpdateUser }));
}
internal int Add(DbTransaction tran, Model_SysUser model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO ");
builder.Append(" SysUser( ");
builder.Append(" SysUser_ID,SysUser_Name,SysUser_LoginName,SysUser_PassWord,SysUser_Tel,SysRole_ID,SysDepartment_ID,SysUser_Enable,SysUser_Remark,CreateTime,CreateUser,UpdateTime,UpdateUser ");
builder.Append(" ) ");
builder.Append(" values( ");
builder.Append(" @SysUser_ID,@SysUser_Name,@SysUser_LoginName,@SysUser_PassWord,@SysUser_Tel,@SysRole_ID,@SysDepartment_ID,@SysUser_Enable,@SysUser_Remark,@CreateTime,@CreateUser,@UpdateTime,@UpdateUser ");
builder.Append(" ) ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SysUser_ID, model.SysUser_Name, model.SysUser_LoginName, model.SysUser_PassWord, model.SysUser_Tel, model.SysRole_ID, model.SysDepartment_ID, model.SysUser_Enable, model.SysUser_Remark, model.CreateTime, model.CreateUser, model.UpdateTime, model.UpdateUser }));
}
public bool Exists(Model_SysUser model, int i)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from SysUser");
if (i == 0)
{
builder.AppendFormat(" where 1=1 and sysUser_ID<>'{0}' AND SysUser_LoginName='{1}'", model.SysUser_ID, model.SysUser_LoginName);
}
else
{
builder.AppendFormat(" where 1=1 and SysUser_LoginName='{0}'", model.SysUser_LoginName);
}
return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0);
}
public List <Model_SysUser> DataTableToList(DataTable dt)
{
List <Model_SysUser> list = new List <Model_SysUser>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_SysUser item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
//获取界面参数
private Model_SysUser GetSysUserModel()
{
try
{
Model_SysUser usermodel = new Model_SysUser();
usermodel.SysUser_ID = sysUser_ID;
usermodel.SysUser_Name = txtSysUserName.Text.Trim();
usermodel.SysUser_LoginName = lblNamelogin.Text.Trim();
//if (string.IsNullOrEmpty(txtpwdlogin.Text.Trim()))
//{
// usermodel.SysUser_PassWord = sysUser_PassWord;
//}
//else
//{
// usermodel.SysUser_PassWord = DESEncryptLogin.EncryptString(txtpwdlogin.Text.Trim());
//}
usermodel.SysUser_Tel = txtTel.Text.Trim();
//if (ckbIsEnable.Checked)
//{
// usermodel.SysUser_Enable = true;
//}
//else
//{
// usermodel.SysUser_Enable = false;
//}
usermodel.SysUser_Remark = txtContent.Text.Trim();
usermodel.UpdateTime = DateTime.Now;
usermodel.UpdateUser = loginUser.SysUser_ID;
return(usermodel);
}
catch (Exception ex)
{
new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类：{0}，方法：{1},错误信息：{2}， 详细：{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
throw ex;
}
}
public bool Add(Model_SysUser model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SysUser(");
builder.Append("SysUser_ID,SysUser_Name,SysUser_LoginName,SysUser_PassWord,SysUser_Tel,SysDepartment_ID,SysUser_Enable,SysUser_Remark,CreateTime,CreateUser,UpdateTime,UpdateUser)");
builder.Append(" values (");
builder.Append("@SysUser_ID,@SysUser_Name,@SysUser_LoginName,@SysUser_PassWord,@SysUser_Tel,@SysDepartment_ID,@SysUser_Enable,@SysUser_Remark,@CreateTime,@CreateUser,@UpdateTime,@UpdateUser)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysUser_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysUser_Name", SqlDbType.NVarChar, 0x80), new SqlParameter("@SysUser_LoginName", SqlDbType.NVarChar, 20), new SqlParameter("@SysUser_PassWord", SqlDbType.NVarChar, 200), new SqlParameter("@SysUser_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@SysDepartment_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysUser_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysUser_Remark", SqlDbType.NVarChar, 0x800), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysUser_ID;
cmdParms[1].Value = model.SysUser_Name;
cmdParms[2].Value = model.SysUser_LoginName;
cmdParms[3].Value = model.SysUser_PassWord;
cmdParms[4].Value = model.SysUser_Tel;
cmdParms[5].Value = model.SysDepartment_ID;
cmdParms[6].Value = model.SysUser_Enable;
cmdParms[7].Value = model.SysUser_Remark;
cmdParms[8].Value = model.CreateTime;
cmdParms[9].Value = model.CreateUser;
cmdParms[10].Value = model.UpdateTime;
cmdParms[11].Value = model.UpdateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(Model_SysUser model)
{
return(this.dal.Update(model));
}
public bool Exists(Model_SysUser model, int i)
{
return(this.DAL.Exists(model, i));
}
public int Update(Model_SysUser model)
{
return(this.Update(null, model));
}
internal List <Model_SysUser> GetModel_SysUserListByPage(DbTransaction tran, int pageSize, int pageIndex, string orderColumn, string orderType, string strCondition, params object[] param)
{
if ((pageSize <= 0) || (pageIndex <= 0))
{
throw new Exception("分页参数错误，必须大于零");
}
if (string.IsNullOrEmpty(orderColumn))
{
throw new Exception("排序字段必须填写");
}
int num = ((pageIndex - 1) * pageSize) + 1;
int num2 = pageIndex * pageSize;
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT * FROM (");
builder.Append(string.Format(" SELECT (ROW_NUMBER() OVER(ORDER BY {0} {1})) as rownum,* FROM SysUser", orderColumn, orderType));
if (!string.IsNullOrWhiteSpace(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
builder.Append(" ) t ");
builder.Append(" WHERE rownum between ");
builder.Append(string.Format(" {0} ", num));
builder.Append(" AND ");
builder.Append(string.Format(" {0} ", num2));
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Model_SysUser> list = new List <Model_SysUser>();
Model_SysUser item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SysUser();
if (row["SysUser_ID"] != null)
{
item.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysUser_Name"] != null)
{
item.SysUser_Name = row["SysUser_Name"].ToString();
}
if (row["SysUser_LoginName"] != null)
{
item.SysUser_LoginName = row["SysUser_LoginName"].ToString();
}
if (row["SysUser_PassWord"] != null)
{
item.SysUser_PassWord = row["SysUser_PassWord"].ToString();
}
if (row["SysUser_Tel"] != null)
{
item.SysUser_Tel = row["SysUser_Tel"].ToString();
}
if (row["SysRole_ID"] != null)
{
item.SysRole_ID = row["SysRole_ID"].ToString();
}
if (row["SysDepartment_ID"] != null)
{
item.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysUser_Enable"] != null)
{
item.SysUser_Enable = new bool?(Convert.ToBoolean(row["SysUser_Enable"].ToString()));
}
if (row["SysUser_Remark"] != null)
{
item.SysUser_Remark = row["SysUser_Remark"].ToString();
}
if (row["CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["CreateTime"].ToString()))
{
item.CreateTime = null;
}
else
{
item.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
if (row["CreateUser"] != null)
{
item.CreateUser = row["CreateUser"].ToString();
}
if (row["UpdateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateTime"].ToString()))
{
item.UpdateTime = null;
}
else
{
item.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
if (row["UpdateUser"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateUser"].ToString()))
{
item.UpdateUser = null;
}
else
{
item.UpdateUser = row["UpdateUser"].ToString();
}
}
list.Add(item);
}
return(list);
}
internal List <Model_SysUser> GetModel_SysUserList(DbTransaction tran, int recordNum, string orderColumn, string orderType, string strCondition, params object[] param)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
if (recordNum > 0)
{
builder.Append(" TOP " + recordNum);
}
builder.Append(" * ");
builder.Append(" FROM ");
builder.Append(" SysUser ");
if (!string.IsNullOrEmpty(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
if (!string.IsNullOrEmpty(orderColumn))
{
builder.Append(" ORDER BY ");
builder.Append(orderColumn);
if (!string.IsNullOrEmpty(orderType))
{
builder.Append(" " + orderType);
}
}
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Model_SysUser> list = new List <Model_SysUser>();
Model_SysUser item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SysUser();
if (row["SysUser_ID"] != null)
{
item.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysUser_Name"] != null)
{
item.SysUser_Name = row["SysUser_Name"].ToString();
}
if (row["SysUser_LoginName"] != null)
{
item.SysUser_LoginName = row["SysUser_LoginName"].ToString();
}
if (row["SysUser_PassWord"] != null)
{
item.SysUser_PassWord = row["SysUser_PassWord"].ToString();
}
if (row["SysUser_Tel"] != null)
{
item.SysUser_Tel = row["SysUser_Tel"].ToString();
}
if (row["SysRole_ID"] != null)
{
item.SysRole_ID = row["SysRole_ID"].ToString();
}
if (row["SysDepartment_ID"] != null)
{
item.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysUser_Enable"] != null)
{
item.SysUser_Enable = new bool?(Convert.ToBoolean(row["SysUser_Enable"].ToString()));
}
if (row["SysUser_Remark"] != null)
{
item.SysUser_Remark = row["SysUser_Remark"].ToString();
}
if (row["CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["CreateTime"].ToString()))
{
item.CreateTime = null;
}
else
{
item.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
if (row["CreateUser"] != null)
{
item.CreateUser = row["CreateUser"].ToString();
}
if (row["UpdateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateTime"].ToString()))
{
item.UpdateTime = null;
}
else
{
item.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
if (row["UpdateUser"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateUser"].ToString()))
{
item.UpdateUser = null;
}
else
{
item.UpdateUser = row["UpdateUser"].ToString();
}
}
list.Add(item);
}
return(list);
}
public int Update(Model_SysUser model)
{
return(this.DAL.Update(model));
}
internal Model_SysUser GetModel_SysUserByPK(DbTransaction tran, string sysuser_id)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
builder.Append(" TOP 1 * ");
builder.Append(" FROM ");
builder.Append(" SysUser ");
builder.Append(" WHERE ");
builder.Append(" SysUser_ID=@SysUser_ID ");
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, new object[] { sysuser_id });
Model_SysUser user = null;
if (set.Tables[0].Rows.Count > 0)
{
DataRow row = set.Tables[0].Rows[0];
user = new Model_SysUser();
if (row["SysUser_ID"] != null)
{
user.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysUser_Name"] != null)
{
user.SysUser_Name = row["SysUser_Name"].ToString();
}
if (row["SysUser_LoginName"] != null)
{
user.SysUser_LoginName = row["SysUser_LoginName"].ToString();
}
if (row["SysUser_PassWord"] != null)
{
user.SysUser_PassWord = row["SysUser_PassWord"].ToString();
}
if (row["SysUser_Tel"] != null)
{
user.SysUser_Tel = row["SysUser_Tel"].ToString();
}
if (row["SysDepartment_ID"] != null)
{
user.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if (row["SysUser_Enable"] != null)
{
user.SysUser_Enable = new bool?(Convert.ToBoolean(row["SysUser_Enable"].ToString()));
}
if (row["SysUser_Remark"] != null)
{
user.SysUser_Remark = row["SysUser_Remark"].ToString();
}
if (row["CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["CreateTime"].ToString()))
{
user.CreateTime = null;
}
else
{
user.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
if (row["CreateUser"] != null)
{
user.CreateUser = row["CreateUser"].ToString();
}
if (row["UpdateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["UpdateTime"].ToString()))
{
user.UpdateTime = null;
}
else
{
user.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
}
if (row["UpdateUser"] == null)
{
return(user);
}
if (string.IsNullOrWhiteSpace(row["UpdateUser"].ToString()))
{
user.UpdateUser = null;
return(user);
}
user.UpdateUser = row["UpdateUser"].ToString();
}
return(user);
}
public int Add(Model_SysUser model)
{
return(this.Add(null, model));
}
//验证是否存在
private bool IsExists(Model_SysUser model, int i)
{
return(BLL.Exists(model, i));
}
public int Add(Model_SysUser model)
{
return(this.DAL.Add(model));
}
public int AddSysUser(Model_SysUser Model_SysUser, SysRoleModel SysRoleModel, string sType)
{
return(this.DAL.AddSysUser(Model_SysUser, SysRoleModel, sType));
}
public bool Add(Model_SysUser model)
{
return(this.dal.Add(model));
}
public Model_SysUser DataRowToModel(DataRow row)
{
Model_SysUser user = new Model_SysUser();
if (row != null)
{
if (row["SysUser_ID"] != null)
{
user.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["SysUser_Name"] != null)
{
user.SysUser_Name = row["SysUser_Name"].ToString();
}
if (row["SysUser_LoginName"] != null)
{
user.SysUser_LoginName = row["SysUser_LoginName"].ToString();
}
if (row["SysUser_PassWord"] != null)
{
user.SysUser_PassWord = row["SysUser_PassWord"].ToString();
}
if (row["SysUser_Tel"] != null)
{
user.SysUser_Tel = row["SysUser_Tel"].ToString();
}
if (row["SysDepartment_ID"] != null)
{
user.SysDepartment_ID = row["SysDepartment_ID"].ToString();
}
if ((row["SysUser_Enable"] != null) && (row["SysUser_Enable"].ToString() != ""))
{
if ((row["SysUser_Enable"].ToString() == "1") || (row["SysUser_Enable"].ToString().ToLower() == "true"))
{
user.SysUser_Enable = true;
}
else
{
user.SysUser_Enable = false;
}
}
if (row["SysUser_Remark"] != null)
{
user.SysUser_Remark = row["SysUser_Remark"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
user.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["CreateUser"] != null)
{
user.CreateUser = row["CreateUser"].ToString();
}
if ((row["UpdateTime"] != null) && (row["UpdateTime"].ToString() != ""))
{
user.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString()));
}
if (row["UpdateUser"] != null)
{
user.UpdateUser = row["UpdateUser"].ToString();
}
}
return(user);
}
public bool MyInfoUpdate(Model_SysUser model)
{
return(this.DAL.MyInfoUpdate(model));
}
