/// <summary>
/// 获得用户基本信息参数
/// </summary>
/// <returns></returns>
CJia.PEIS.Views.AdminHandleEventArgs GetUserArgs()
{
CJia.PEIS.Views.AdminHandleEventArgs args = new Views.AdminHandleEventArgs();
if (cjiaGridView.GetFocusedDataRow() != null && !isAddNewUser)//修改用户
{
args.UserID = int.Parse(cjiaGridView.GetFocusedDataRow()["user_id"].ToString());
args.OldUserNo = cjiaGridView.GetFocusedDataRow()["user_no"].ToString();
}
args.UserNo = txtUserNO.Text;
args.UserName = txtUserName.Text;
args.UserPhone = txtTelePhone.Text;
args.UserGender = int.Parse(cbGender.EditValue.ToString());
args.UserWorkUnit = txtWorkUnit.Text;
args.UserStatus = int.Parse(cbUserState.EditValue.ToString());
if (imgUser.Image != null && ofUserImage.Text != UserImagePointText)
{
args.UserImage = CJia.PEIS.Tools.Help.GetBytesByFilePath(ofUserImage.Text);
}
else if (imgUser.Image == null)
{
string rootPath = Application.StartupPath;
string defaultPath = rootPath.Substring(0, rootPath.Length - 10) + "\\Resources\\defaultUserImage.png";
args.UserImage = CJia.PEIS.Tools.Help.GetBytesByFilePath(defaultPath);
}
if (imgSign.Image != null && ofUserSign.Text != UserSignPointText)
{
args.UserSignImage = CJia.PEIS.Tools.Help.GetBytesByFilePath(ofUserSign.Text);
}
args.UserNameSpell = CJia.Controls.CJiaSpellEditor.ToChString(txtUserName.Text).ToUpper();
return(args);
}
void view_OnLoad(object sender, Views.AdminHandleEventArgs e)
{
DataTable genderData = Model.GetGender();
DataTable userData = Model.GetAllUsers(e.isShowNoUse);
DataTable userStatusData = Model.GetUserStatus();
View.ExeInitialize(genderData, userData, userStatusData);
}
void view_OnResetPassword(object sender, Views.AdminHandleEventArgs e)
{
bool bol = Model.ResetPasswordByUserID(int.Parse(User.UserData.Rows[0]["user_id"].ToString()), e.UserID);
if (bol)
{
View.ShowMessage("用户【" + e.UserNo + "|" + e.UserName + "】密码初始化成功,密码为8888");
}
}
void view_OnSave(object sender, Views.AdminHandleEventArgs e)
{
if (e.UserID == 0)
{
AddUser(e);
}
else
{
ModifyUser(e);
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="args"></param>
/// <param name="updataBy"></param>
/// <returns></returns>
public bool ModifyUser(Views.AdminHandleEventArgs args, int updataBy)
{
List <object> sqlParams = new List <object>();
StringBuilder str = new StringBuilder("");
sqlParams.Add(args.UserNo);
sqlParams.Add(args.UserName);
sqlParams.Add(args.UserGender);
if (args.UserPhone.Length == 0)
{
sqlParams.Add(DBNull.Value);
}
else
{
sqlParams.Add(args.UserPhone);
}
if (args.UserWorkUnit.Length == 0)
{
sqlParams.Add(DBNull.Value);
}
else
{
sqlParams.Add(args.UserWorkUnit);
}
sqlParams.Add(args.UserStatus);
sqlParams.Add(args.UserNameSpell);
sqlParams.Add(updataBy);
sqlParams.Add(args.UserID);
if (args.UserImage != null)
{
str.Append("user_image=:10,");
sqlParams.Add(args.UserImage);
}
else
{
sqlParams.Add(DBNull.Value);
}
if (args.UserSignImage != null)
{
str.Append("user_sign=:11,");
sqlParams.Add(args.UserSignImage);
}
else
{
sqlParams.Add(DBNull.Value);
}
string sql = string.Format(SqlTools.SqlUpdataUserByUserID, str.ToString());
return(CJia.DefaultPostgre.Execute(sql, sqlParams) > 0 ? true : false);
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="e"></param>
private void AddUser(Views.AdminHandleEventArgs e)
{
if (isExistUserNO(e.UserNo))
{
View.ShowMessage("【" + e.UserNo + "】工号存在");
View.ExeTxtUserNOFocus();
return;
}
bool bol = Model.AddUser(e, int.Parse(User.UserData.Rows[0]["user_id"].ToString()));
if (bol)
{
View.ShowMessage("用户【" + e.UserNo + "|" + e.UserName + "】添加成功");
}
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="args">参数</param>
/// <param name="createBy">创建人</param>
/// <returns></returns>
public bool AddUser(Views.AdminHandleEventArgs args, int createBy)
{
List <object> sqlParams = new List <object>();
sqlParams.Add(args.UserNo);
sqlParams.Add(args.UserName);
sqlParams.Add(args.UserGender);
if (args.UserPhone.Length == 0)
{
sqlParams.Add(DBNull.Value);
}
else
{
sqlParams.Add(args.UserPhone);
}
if (args.UserWorkUnit.Length == 0)
{
sqlParams.Add(DBNull.Value);
}
else
{
sqlParams.Add(args.UserWorkUnit);
}
sqlParams.Add(createBy);
if (args.UserImage == null)
{
sqlParams.Add(DBNull.Value);
}
else
{
sqlParams.Add(args.UserImage);
}
if (args.UserSignImage == null)
{
sqlParams.Add(DBNull.Value);
}
else
{
sqlParams.Add(args.UserSignImage);
}
sqlParams.Add(args.UserStatus);
sqlParams.Add(args.UserNameSpell);
return(CJia.DefaultPostgre.Execute(SqlTools.SqlInsertUser, sqlParams) > 0 ? true : false);
}
void view_OnGridClick(object sender, Views.AdminHandleEventArgs e)
{
DataTable userData = Model.GetUserByUserID(e.UserID);
View.ExeBindUserInfo(userData);
}
void view_OnDelete(object sender, Views.AdminHandleEventArgs e)
{
Model.DeleteUserByUserID(int.Parse(User.UserData.Rows[0]["user_id"].ToString()), e.UserID);
}
void view_OnCheck(object sender, Views.AdminHandleEventArgs e)
{
DataTable data = Model.GetAllUsers(e.isShowNoUse);
View.ExeBindAllUser(data);
}
void view_OnBtnSearchClick(object sender, Views.AdminHandleEventArgs e)
{
DataTable data = Model.GetUsersByKeys(e.isShowNoUse, e.Keys);
View.ExeBindAllUser(data);
}