protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.IsValid)
{
IUserService service = ServiceFactory.GetService<IUserService>();
UserInfo entity = null;
if (this.IsInsert)
{
entity = new UserInfo()
{
UserAccount = this.txtUserAccount.Text.Trim(),
UserPwd = this.txtUserPwd.Text.DESEncrypt(),
UserNickName = this.txtUserNickName.Text.Trim(),
UserEmail = this.txtUserEmail.Text.Trim(),
UserPhone = this.txtUserPhone.Text.Trim(),
UserStatus = this.ddlUserStatus.SelectedValue.ToByte(0),
RoleId = this.ddlUserRole.SelectedValue.ToByte(0),
OrgId = this.hfOrgId.Value.ToInt(0)
};
if (service.CheckExists_Info(entity))
{
this.JscriptMsg("用户帐户已存在", null, "Error");
return;
}
}
else
{
entity = service.GetObject_Info(this.PkId);
if (entity != null)
{
entity.UserPwd = this.txtUserPwd.Text.DESEncrypt();
entity.UserNickName = this.txtUserNickName.Text.Trim();
entity.UserEmail = this.txtUserEmail.Text.Trim();
entity.UserPhone = this.txtUserPhone.Text.Trim();
entity.UserStatus = this.ddlUserStatus.SelectedValue.ToByte(0);
entity.RoleId = this.ddlUserRole.SelectedValue.ToByte(0);
entity.OrgId = this.hfOrgId.Value.ToInt(0);
}
}
service.Save_Info(entity);
if (this.IsInsert && (sender as Button).CommandName == "SubmitContinue")
{
this.ReturnUrl = this.Request.Url.PathAndQuery;
}
this.JscriptMsg("数据保存成功", this.ReturnUrl, "Success");
}
UserConvert.ClearCache();
}
public bool CheckExists(UserInfo objUserInfo)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
sql = " select count(*) from tbl_user_info where UserAccount=:UserAccount ";
parameterList.Add(new OracleParameter(":UserAccount", objUserInfo.UserAccount));
return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0;
}
public bool CheckExists_Info(UserInfo objUserInfo)
{
var repository = ServiceFactory.GetService<IUserInfoRepository>();
return repository.CheckExists(objUserInfo);
}
public void Save_Info(UserInfo objUserInfo)
{
var repository = ServiceFactory.GetService<IUserInfoRepository>();
repository.Save(objUserInfo);
}
public void Save(UserInfo objUserInfo)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objUserInfo.PkId == 0)
{
sql = " insert into tbl_user_info(PkId, UserAccount, UserPwd, UserNickName, UserEmail, UserPhone, UserStatus, RoleId, OrgId) " +
" values(TUI_PKID.NEXTVAL, :UserAccount, :UserPwd, :UserNickName, :UserEmail, :UserPhone, :UserStatus, :RoleId, :OrgId) ";
parameterList.Add(new OracleParameter(":UserAccount", objUserInfo.UserAccount));
parameterList.Add(new OracleParameter(":UserPwd", objUserInfo.UserPwd));
parameterList.Add(new OracleParameter(":UserNickName", objUserInfo.UserNickName));
parameterList.Add(new OracleParameter(":UserEmail", objUserInfo.UserEmail));
parameterList.Add(new OracleParameter(":UserPhone", objUserInfo.UserPhone));
parameterList.Add(new OracleParameter(":UserStatus", objUserInfo.UserStatus));
parameterList.Add(new OracleParameter(":RoleId", objUserInfo.RoleId));
parameterList.Add(new OracleParameter(":OrgId", objUserInfo.OrgId));
}
else
{
sql = " update tbl_user_info set UserAccount=:UserAccount, UserPwd=:UserPwd, UserNickName=:UserNickName, " +
" UserEmail=:UserEmail, UserPhone=:UserPhone, UserStatus=:UserStatus, RoleId=:RoleId, " +
" OrgId=:OrgId where PkId=:PkId ";
parameterList.Add(new OracleParameter(":UserAccount", objUserInfo.UserAccount));
parameterList.Add(new OracleParameter(":UserPwd", objUserInfo.UserPwd));
parameterList.Add(new OracleParameter(":UserNickName", objUserInfo.UserNickName));
parameterList.Add(new OracleParameter(":UserEmail", objUserInfo.UserEmail));
parameterList.Add(new OracleParameter(":UserPhone", objUserInfo.UserPhone));
parameterList.Add(new OracleParameter(":UserStatus", objUserInfo.UserStatus));
parameterList.Add(new OracleParameter(":RoleId", objUserInfo.RoleId));
parameterList.Add(new OracleParameter(":OrgId", objUserInfo.OrgId));
parameterList.Add(new OracleParameter(":PkId", objUserInfo.PkId));
}
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
public void Save(UserInfo objUserInfo)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objUserInfo.PkId == 0)
{
sql = " insert into tbl_user_info(UserAccount, UserPwd, UserNickName, UserEmail, UserPhone, UserStatus, RoleId, OrgId) " +
" values(@UserAccount, @UserPwd, @UserNickName, @UserEmail, @UserPhone, @UserStatus, @RoleId, @OrgId) ";
parameterList.Add(new MySqlParameter("@UserAccount", objUserInfo.UserAccount));
parameterList.Add(new MySqlParameter("@UserPwd", objUserInfo.UserPwd));
parameterList.Add(new MySqlParameter("@UserNickName", objUserInfo.UserNickName));
parameterList.Add(new MySqlParameter("@UserEmail", objUserInfo.UserEmail));
parameterList.Add(new MySqlParameter("@UserPhone", objUserInfo.UserPhone));
parameterList.Add(new MySqlParameter("@UserStatus", objUserInfo.UserStatus));
parameterList.Add(new MySqlParameter("@RoleId", objUserInfo.RoleId));
parameterList.Add(new MySqlParameter("@OrgId", objUserInfo.OrgId));
}
else
{
sql = " update tbl_user_info set UserAccount=@UserAccount, UserPwd=@UserPwd, UserNickName=@UserNickName, " +
" UserEmail=@UserEmail, UserPhone=@UserPhone, UserStatus=@UserStatus, RoleId=@RoleId, " +
" OrgId=@OrgId where PkId=@PkId ";
parameterList.Add(new MySqlParameter("@PkId", objUserInfo.PkId));
parameterList.Add(new MySqlParameter("@UserAccount", objUserInfo.UserAccount));
parameterList.Add(new MySqlParameter("@UserPwd", objUserInfo.UserPwd));
parameterList.Add(new MySqlParameter("@UserNickName", objUserInfo.UserNickName));
parameterList.Add(new MySqlParameter("@UserEmail", objUserInfo.UserEmail));
parameterList.Add(new MySqlParameter("@UserPhone", objUserInfo.UserPhone));
parameterList.Add(new MySqlParameter("@UserStatus", objUserInfo.UserStatus));
parameterList.Add(new MySqlParameter("@RoleId", objUserInfo.RoleId));
parameterList.Add(new MySqlParameter("@OrgId", objUserInfo.OrgId));
}
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
