protected void btnAdd_Click(object sender, EventArgs e)
{
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
if (Common.GetUserExists(txtUserName.Value.Trim()))
{
JScript.AlertMsg(this, "登录帐号已存在。");
return;
}
if (Common.GetUserExists("Phone", txtUserPhone.Value.Trim()))
{
JScript.AlertMsg(this, "手机号码已存在。");
return;
}
user.UserName = Common.NoHTML(txtUserName.Value.Trim());
user.TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
user.UserPwd = Util.md5(txtUserPwd.Value.Trim());
user.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
user.AuditState = 2;
user.IsEnabled = 1;
user.CreateDate = DateTime.Now;
user.CreateUserID = UserID;
user.ts = DateTime.Now;
user.modifyuser = UserID;
int userid = new Hi.BLL.SYS_Users().Add(user, Tran);
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = KeyID;
CompUser.DisID = 0;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 1;
CompUser.UType = 3;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 2;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = userid;
CompUser.RoleID = 0;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
//新增角色用户
List <Hi.Model.SYS_Role> list = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and IsEnabled=1 and CompID=" + KeyID + " and RoleName='企业管理员'", "");
Hi.Model.SYS_RoleUser RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = userid;
RoleUser.RoleID = list[0].ID;
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
new Hi.BLL.SYS_RoleUser().Add(RoleUser, Tran);
Tran.Commit();
JScript.AlertMsgMo(this, "添加成功", "function(){ window.location.href=window.location.href; }");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.SYS_RoleUser model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.SYS_RoleUser model)
{
return(dal.Add(model));
}
/// <summary>
///核心企业新增经销商
/// </summary>
/// <param name="JSon"></param>
/// <returns></returns>
public ReseltResellerEdit AddReseller(string JSon)
{
string UserID = string.Empty;
string CompID = string.Empty;
try
{
#region//JSon取值
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo["UserID"].ToString().Trim() == "" || JInfo["CompID"].ToString().Trim() == "" || JInfo["Reseller"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "参数异常"
}
}
;
UserID = JInfo["UserID"].ToString();
CompID = JInfo["CompID"].ToString();
JsonData Reseller = JInfo["Reseller"];
//判断登录信息是否异常
Hi.Model.SYS_Users one = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(UserID), out one, Int32.Parse(CompID)))
{
return(new ReseltResellerEdit()
{
Result = "F", Description = "登录信息异常"
});
}
//判断核心企业信息是否异常
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Int32.Parse(CompID));
if (comp == null || comp.dr == 1 || comp.IsEnabled == 0 || comp.AuditState == 0)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "核心企业信息异常"
}
}
;
#endregion
#region//判断传入的经销商信息是否正确
string resellername = Common.NoHTML(Reseller["ResellerName"].ToString().Trim());
string resellercode = Common.NoHTML(Reseller["ResellerCode"].ToString().Trim());
string address = Common.NoHTML(Reseller["Address"].ToString().Trim());
if (resellername == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入经销商名称"
}
}
;
//判断经销商名字是否已存在
if (Common.DisExistsAttribute("DisName", resellername, CompID.ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商名称已经存在"
}
}
;
if (Reseller["ResellerProvince"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的省"
}
}
;
if (Reseller["ResellerCity"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的市"
}
}
;
if (Reseller["ResellerArea"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请选择经销商地址中的区"
}
}
;
if (address == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入经销商地址中的详细地址"
}
}
;
#endregion
#region//判断登录信息的正确信
JsonData account = Reseller["Account"];
string username = Common.NoHTML(account["UserName"].ToString().Trim());
string truename = Common.NoHTML(account["TrueName"].ToString().Trim());
if (account["UserName"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入登录账号"
}
}
;
//判断登录账号是否已经存在
if (Common.GetUserExists(username))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "该登录账号已存在"
}
}
;
if (truename == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请输入姓名"
}
}
;
if (account["Phone"].ToString().Trim() == "")
{
return new ReseltResellerEdit()
{
Result = "F", Description = "请登录信息中的手机号码"
}
}
;
//判断手机号有没被注册过
Regex Phonereg = new Regex("^0?(13[0-9]|15[012356789]|18[0-9]|14[57]|17[7])[0-9]{8}$");
if (!Phonereg.IsMatch(account["Phone"].ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "登录信息中的手机号格式错误"
}
}
;
if (Common.GetUserExists("Phone", account["Phone"].ToString()))
{
return new ReseltResellerEdit()
{
Result = "F", Description = "登录信息中的手机号已被注册"
}
}
;
#endregion
//创建需要导入的经销商实体
Hi.Model.BD_Distributor disModel = new Hi.Model.BD_Distributor();
disModel.CompID = comp.ID;
disModel.DisCode = resellercode;
disModel.DisName = resellername;
//传入分类ID的话，判断分类ID是否正确
if (Reseller["ResellerClassifyID"].ToString().Trim() != "" && Reseller["ResellerClassifyID"].ToString() != "0")
{
Hi.Model.BD_DisType distpye = new Hi.BLL.BD_DisType().GetModel(Int32.Parse(Reseller["ResellerClassifyID"].ToString().Trim()));
if (distpye == null || distpye.CompID != comp.ID)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商分类异常"
}
}
;
if (distpye.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "此经销商分类已被删除"
}
}
;
//if (distpye.IsEnabled != 0)
// return new ReseltResellerEdit() { Result = "F", Description = "此经销商分类已被禁用" };
disModel.DisTypeID = distpye.ID;
}
else
{
disModel.DisTypeID = 0;
}
//传入区域ID的话，判断区域ID是否正确
if (Reseller["AreaID"].ToString().Trim() != "" && Reseller["AreaID"].ToString() != "0")
{
Hi.Model.BD_DisArea disarea = new Hi.BLL.BD_DisArea().GetModel(Int32.Parse(Reseller["AreaID"].ToString().Trim()));
if (disarea == null || disarea.CompanyID != comp.ID)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "经销商区域异常"
}
}
;
if (disarea.dr == 1)
{
return new ReseltResellerEdit()
{
Result = "F", Description = "此经销商区域已被删除"
}
}
;
disModel.AreaID = disarea.ID;
}
else
{
disModel.AreaID = 0;
}
disModel.DisLevel = "";
disModel.Province = Reseller["ResellerProvince"].ToString();
disModel.City = Reseller["ResellerCity"].ToString();
disModel.Area = Reseller["ResellerArea"].ToString();
disModel.Address = address;
//没输入经销商中的联系人，需要将登录信息的姓名赋值给联系人
string principal = Common.NoHTML(Reseller["Principal"].ToString().Trim());
string phone = Common.NoHTML(Reseller["Phone"].ToString().Trim());
if (principal == "")
{
disModel.Principal = truename;
}
else
{
disModel.Principal = principal;
}
//没输入联系人手机号，需要将登录信息中的手机号赋值给联系人手机号
if (phone == "")
{
disModel.Phone = account["Phone"].ToString();
}
else
{
disModel.Phone = phone;
}
disModel.Leading = "";
disModel.LeadingPhone = "";
disModel.Licence = "";
disModel.Tel = Common.NoHTML(Reseller["Tel"].ToString());
disModel.Zip = Common.NoHTML(Reseller["Zip"].ToString());
disModel.Fax = Common.NoHTML(Reseller["Fax"].ToString());
disModel.Remark = "";
disModel.DisAccount = 0;
disModel.IsCheck = 1;
disModel.CreditType = 0;
disModel.CreditAmount = 0;
disModel.Paypwd = Common.md5("123456");
disModel.AuditState = 2;
disModel.IsEnabled = 1;
disModel.CreateUserID = one.ID;
disModel.CreateDate = DateTime.Now;
disModel.ts = DateTime.Now;
disModel.dr = 0;
disModel.modifyuser = one.ID;
//开启事务，并将dismodel插入经销商表中
SqlConnection conn = new SqlConnection(SqlHelper.LocalSqlServer);
//开启数据库连接
if (conn.State.ToString().ToLower() != "open")
{
conn.Open();
}
//开启事务
SqlTransaction mytran = conn.BeginTransaction();
int DisID = 0;
try
{
//在经销商表中插入一条数据
if ((DisID = new Hi.BLL.BD_Distributor().Add(disModel, mytran)) > 0)
{
//经销商表插入成功的话继续新增角色
List <Hi.Model.SYS_Role> list_role = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and DisID=" + DisID + " and RoleName='企业管理员'", "");
if (list_role == null || list_role.Count == 0)
{
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = comp.ID;
role.DisID = DisID;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = one.ID;
role.ts = DateTime.Now;
role.modifyuser = one.ID;
role.dr = 0;
int Roid = new Hi.BLL.SYS_Role().Add(role, mytran);
//新增管理员用户和角色
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = username;
// user.CompID = CompID;
// user.Type = 5;
// user.RoleID = Roid;
user.TrueName = truename;
user.UserPwd = Common.md5("123456");
user.Phone = account["Phone"].ToString();
user.AuditState = 2;
user.IsEnabled = 1;
user.CreateUserID = one.ID;
user.CreateDate = DateTime.Now;
user.ts = DateTime.Now;
user.modifyuser = one.ID;
int AddUserid = new Hi.BLL.SYS_Users().Add(user, mytran);
///用户明细表
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = comp.ID;
CompUser.DisID = DisID;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = one.ID;
CompUser.modifyuser = one.ID;
CompUser.CType = 2;
CompUser.UType = 5;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 2;
CompUser.RoleID = 0;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = AddUserid;
int compuserid = new Hi.BLL.SYS_CompUser().Add(CompUser, mytran);
//新增角色用户
Hi.Model.SYS_RoleUser RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = AddUserid;
RoleUser.RoleID = Roid;
RoleUser.IsEnabled = true;
RoleUser.CreateUser = UserID;
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
int roleuserid = new Hi.BLL.SYS_RoleUser().Add(RoleUser, mytran);
//新增角色权限表
Hi.Model.SYS_RoleSysFun rolesys = null;
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=2", "");
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = comp.ID;
rolesys.DisID = DisID;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = one.ID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = one.ID;
if (new Hi.BLL.SYS_RoleSysFun().Add(rolesys, mytran) <= 0)
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
//新增收货地址
Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr();
addr.Province = disModel.Province;
addr.City = disModel.City;
addr.Area = disModel.Area;
addr.DisID = DisID;
addr.Principal = disModel.Principal;
addr.Phone = disModel.Phone;
addr.Address = disModel.Province + disModel.City + disModel.Area + disModel.Address;
addr.IsDefault = 1;
addr.ts = DateTime.Now;
addr.CreateDate = DateTime.Now;
addr.CreateUserID = one.ID;
addr.modifyuser = one.ID;
int addrid = new Hi.BLL.BD_DisAddr().Add(addr, mytran);
//判断所有表是否都插入成功了吗
if (Roid <= 0 || AddUserid <= 0 || compuserid <= 0 || roleuserid <= 0 || addrid <= 0)
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
else
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
else
{
mytran.Rollback();
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "AddReseller:" + JSon);
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
finally
{
conn.Close();
mytran.Dispose();
}
return(new ReseltResellerEdit()
{
Result = "T", Description = "新增成功"
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "AddReseller:" + JSon);
return(new ReseltResellerEdit()
{
Result = "F", Description = "新增失败"
});
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Hi.Model.SYS_Users User = null;
Hi.Model.SYS_CompUser CompUser = null;
Hi.Model.SYS_RoleUser RoleUser = null;
Hi.BLL.SYS_RoleUser RoleUserService = new Hi.BLL.SYS_RoleUser();
SqlTransaction Tran = null;
if (KeyID != 0)
{
#region 优化权限前的代码
//int userid = ViewState["Userid"].ToString().ToInt(0);
//if (Common.GetUserExists("UserName", txtUserName.Value.Trim(), userid.ToString()))
//{
// JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
// return;
//}
//if (Common.GetUserExists("Phone", txtPhone.Value.Trim(), userid.ToString()))
//{
// JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
// return;
//}
//if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
//{
// JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
// return;
//}
//List<Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("", "id=" + KeyID + " and isnull(dr,0)=0", "");
//if (ListCompUser.Count == 0)
//{
// JScript.AlertMethod(this, "用户明细数据有误！", JScript.IconOption.错误, "function (){ history.go(-1) ; }");
// return;
//}
//if (rdEnabledNo.Checked)
//{
// if (ListCompUser[0].UType == 5)
// {
// JScript.AlertMsgOne(this, "用户为系统管理员，不可禁用！", JScript.IconOption.错误);
// return;
// }
//}
//else
//{
// if (ListCompUser[0].UType != 5)
// {
// List<Hi.Model.SYS_Role> ListRole = new Hi.BLL.SYS_Role().GetList("RoleName,IsEnabled", " dr=0 and id=" + ListCompUser[0].RoleID + "", "");
// if (ListRole.Count > 0)
// {
// if (ListRole[0].IsEnabled == 0)
// {
// JScript.AlertMsgOne(this, "请先启用该人员所在岗位（" + ListRole[0].RoleName + "）！", JScript.IconOption.错误, 2500);
// return;
// }
// }
// }
//}
//Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//User = new Hi.BLL.SYS_Users().GetModel(userid);
//User.TrueName = txtTrueName.Value.Trim();
//User.Identitys = txtIdentitys.Value.Trim();
//User.Address = txtAddress.Value.Trim();
//User.Email = txtEmail.Value.Trim();
//ListCompUser[0].IsEnabled = rdEnabledYes.Checked ? 1 : 0;
//ListCompUser[0].ts = DateTime.Now;
//ListCompUser[0].modifyuser = UserID;
//if (txtUserPwd.Text.Trim() != Util.md5("123456"))
//{
// User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
//}
//if (ListCompUser[0].UType != 4)
//{
// User.UserName = txtUserName.Value.Trim();
// User.Phone = txtPhone.Value.Trim();
//}
//User.ts = DateTime.Now;
//User.modifyuser = UserID;
//new Hi.BLL.SYS_Users().Update(User, Tran);
//new Hi.BLL.SYS_CompUser().Update(ListCompUser[0], Tran);
//Tran.Commit();
//JScript.AlertMethod(this, "操作成功!", JScript.IconOption.正确, "function(){ cancel(); }");
#endregion
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//修改
User = new Hi.BLL.SYS_Users().GetModel(KeyID);
CompUser = new Hi.Model.SYS_CompUser();
if (User.UserName != txtUserName.Value.Trim())
{
if (Common.GetUserExists("UserName", txtUserName.Value.Trim()))
{
JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
return;
}
}
if (User.Phone != txtPhone.Value.Trim())
{
if (txtPhone.Value.Trim() == "")
{
JScript.AlertMsgOne(this, "手机号码不能为空！", JScript.IconOption.错误);
return;
}
if (Common.GetUserExists("Phone", txtPhone.Value.Trim()))
{
JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
return;
}
}
if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
{
JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
return;
}
//禁用时判断
if (rdEnabledNo.Checked)
{
List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("", " CompID=" + CompID + " AND UserID=" + KeyID + " AND dr=0 AND IsEnabled=1 ", "");
if (ListCompUser[0].UType == 5)
{
JScript.AlertMsgOne(this, "用户为管理员，不可禁用！", JScript.IconOption.错误);
return;
}
else
{
User.IsEnabled = 0;
CompUser.IsEnabled = 0;
List <Hi.Model.SYS_RoleUser> roleusers = new Hi.BLL.SYS_RoleUser().GetList("", " UserID=" + KeyID + " AND dr=0 ", "");
if (roleusers.Count > 0)
{
for (int i = 0; i < roleusers.Count; i++)
{
roleusers[i].IsEnabled = false;
}
}
}
}
if (rdEnabledYes.Checked)
{
User.IsEnabled = 1;
CompUser.IsEnabled = 1;
}
User.UserName = Common.NoHTML(txtUserName.Value.Trim());
User.TrueName = Common.NoHTML(txtTrueName.Value.Trim());
User.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
User.Phone = Common.NoHTML(txtPhone.Value.Trim());
if (txtPwd.Text.Trim() != User.UserPwd)
{
User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
}
User.Address = Common.NoHTML(txtAddress.Value.Trim());
User.Email = Common.NoHTML(txtEmail.Value.Trim());
User.Type = 1;
User.ts = DateTime.Now;
User.modifyuser = UserID;
CompUser.UType = 1;
//岗位权限表
List <Hi.Model.SYS_RoleUser> roleuser = new Hi.BLL.SYS_RoleUser().GetList("", " UserID=" + KeyID + " AND dr=0 ", "");
for (int i = 0; i < roleuser.Count; i++)
{
roleuser[i].IsEnabled = false;
roleuser[i].ts = DateTime.Now;
RoleUserService.Update(roleuser[i]);
}
if (hidMyRole.Value != "")
{
string[] rolestr = hidMyRole.Value.Substring(0, hidMyRole.Value.Length - 1).Split(',');
for (int i = 0; i < rolestr.Length; i++)
{
List <Hi.Model.SYS_RoleUser> rolenew = new Hi.BLL.SYS_RoleUser().GetList("", " UserID=" + KeyID + " AND dr=0 AND RoleID=" + rolestr[i].ToInt(0) + " ", "");
if (rolenew.Count > 0)
{
rolenew[0].IsEnabled = true;
rolenew[0].ts = DateTime.Now;
RoleUserService.Update(rolenew[0]);
}
else
{
RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = KeyID;
RoleUser.RoleID = rolestr[i].ToInt(0);
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
RoleUserService.Add(RoleUser, Tran);
}
}
}
new Hi.BLL.SYS_Users().Update(User, Tran);
new Hi.BLL.SYS_CompUser().Update(CompUser, Tran);
Tran.Commit();
Response.Redirect("UserInfo.aspx?KeyId=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
}
else
{
if (Common.GetUserExists("UserName", txtUserName.Value.Trim()))
{
JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
return;
}
if (txtPhone.Value.Trim() == "")
{
JScript.AlertMsgOne(this, "手机号码不能为空！", JScript.IconOption.错误);
return;
}
if (Common.GetUserExists("Phone", txtPhone.Value.Trim()))
{
JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
return;
}
if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
{
JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
return;
}
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
User = new Hi.Model.SYS_Users();
User.UserName = Common.NoHTML(txtUserName.Value.Trim());
User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
//User.UserLoginName = txtUserLoginName.Value.Trim();
User.TrueName = Common.NoHTML(txtTrueName.Value.Trim());
//User.Sex = rdSexYes.Checked ? "男" : "女";
User.Phone = Common.NoHTML(txtPhone.Value.Trim());
//User.Tel = txtTel.Value.Trim();
User.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
User.Address = Common.NoHTML(txtAddress.Value.Trim());
User.Email = Common.NoHTML(txtEmail.Value.Trim());
User.IsEnabled = rdEnabledYes.Checked ? 1 : 0;
User.IsFirst = 0;
User.CreateDate = DateTime.Now;
User.CreateUserID = UserID;
User.AuditUser = UserID.ToString();
User.ts = DateTime.Now;
User.modifyuser = UserID;
int userid = new Hi.BLL.SYS_Users().Add(User, Tran);
CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = CompID;
CompUser.DisID = DisID;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 2;
CompUser.UType = 1;//用户类型
CompUser.RoleID = 0;
CompUser.IsEnabled = rdEnabledYes.Checked ? 1 : 0;
CompUser.IsAudit = 2;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = userid;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
//岗位权限表
if (hidMyRole.Value != "")
{
string[] rolestr = hidMyRole.Value.Split(',');
foreach (string str in rolestr)
{
if (str != "" && Convert.ToInt32(str) > 0)
{
RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = userid;
RoleUser.RoleID = Convert.ToInt32(str);
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
RoleUserService.Add(RoleUser, Tran);
}
}
}
Tran.Commit();
Response.Redirect("UserInfo.aspx?KeyId=" + Common.DesEncrypt(userid.ToString(), Common.EncryptKey));
//this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "msg", "<script>cancel()</script>");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (KeyID > 0)
{
bool Audit = false;
Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(KeyID);
if (comp != null)
{
if (comp.dr == 1)
{
JScript.AlertMsg(this, "厂商不存在！。");
return;
}
string str = string.Empty;
SqlTransaction Tran = null;
try
{
if (comp.AuditState == 2)
{
Audit = true;
}
if (Common.CompExistsAttribute("CompName", txtCompName.Value.Trim(), KeyID.ToString()))
{
JScript.AlertMsg(this, "该厂商名称已存在。");
return;
}
string CompAddr = hidProvince.Value.Trim();
if (!string.IsNullOrWhiteSpace(hidCity.Value.Trim()) && hidCity.Value.Trim() != "选择市")
{
CompAddr += "-" + hidCity.Value.Trim();
}
if (!string.IsNullOrWhiteSpace(hidArea.Value.Trim()) && hidArea.Value.Trim() != "选择区")
{
CompAddr += "-" + hidArea.Value.Trim();
}
comp.CompAddr = CompAddr;
comp.CompName = Common.NoHTML(txtCompName.Value.Trim());
comp.Capital = Capital.Value.Trim();
comp.CompType = Convert.ToInt32(CompType.SelectedValue);
comp.Tel = Common.NoHTML(txtTel.Value.Trim());
if (txtPrincipal.Value.Trim() != "")
{
comp.Principal = Common.NoHTML(txtPrincipal.Value.Trim());
}
else
{
comp.Principal = Common.NoHTML(txtUserTrueName.Value.Trim());
}
comp.Legal = Common.NoHTML(txtLegal.Value.Trim());
if (txtPhone.Value.Trim() != "")
{
comp.Phone = Common.NoHTML(txtPhone.Value.Trim());
}
else
{
comp.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
}
comp.ShortName = Common.NoHTML(txtShotName.Value.Trim());
comp.Zip = Common.NoHTML(txtZip.Value.Trim());
comp.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
comp.Licence = Common.NoHTML(txtLicence.Value.Trim());
comp.LegalTel = Common.NoHTML(txtLegalTel.Value.Trim());
comp.ManageInfo = Common.NoHTML(txtInfo.Value.Trim());
comp.Fax = Common.NoHTML(txtFax.Value.Trim());
comp.Account = Common.NoHTML(txtAccount.Value.Trim());
comp.Address = Common.NoHTML(txtAddress.Value.Trim());
comp.IndID = txtIndusName.SelectedValue.ToInt(0);
comp.Trade = txtIndusName.Items[txtIndusName.SelectedIndex].Text;
comp.AuditState = 2;
comp.AuditDate = DateTime.Now;//add by hgh 审核日期
comp.AuditUser = UserID.ToString();
comp.ts = DateTime.Now;
comp.modifyuser = UserID;
comp.OrganizationCode = Common.NoHTML(txtOrcode.Value.Trim());
comp.IsEnabled = rdEbleYes.Checked ? 1 : 0;
comp.HotShow = rdHotShowYes.Checked ? 1 : 0;
comp.FirstShow = Convert.ToInt32(ddlChkShow.SelectedValue);// rdFirstShowYes.Checked ? 1 : 0;
comp.Remark = Common.NoHTML(txtRemark.Value.Trim());
comp.Erptype = ddlErptype.SelectedValue.ToInt(0);
//企业编号 add by hgh
comp.CompCode = Common.CreateCode(KeyID);
if (HidFfileName.Value != "")
{
if (string.IsNullOrEmpty(comp.Attachment))
{
comp.Attachment = HidFfileName.Value;
}
else
{
comp.Attachment += "," + HidFfileName.Value;
}
}
List <Hi.Model.SYS_CompUser> ListComp = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and Ctype=1 and Utype=4 and CompID=" + KeyID + "", "");
if (ListComp.Count > 0)
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
Audit = ListComp[0].IsAudit == 2;
if (Audit)
{
List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList("", " isnull(dr,0)=0 and compid=" + KeyID + "", "");
foreach (Hi.Model.BD_Distributor model2 in dis)
{
model2.IsEnabled = comp.IsEnabled;
model2.ts = DateTime.Now;
model2.modifyuser = UserID;
new Hi.BLL.BD_Distributor().Update(model2, Tran);
}
new Hi.BLL.BD_Company().Update(comp, Tran);
List <Hi.Model.SYS_Users> user = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and id=" + ListComp[0].UserID + " ", "");
if (user.Count > 0)
{
user[0].TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
user[0].ts = DateTime.Now;
user[0].modifyuser = UserID;
new Hi.BLL.SYS_Users().Update(user[0], Tran);
}
Tran.Commit();
Response.Redirect("CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=5", false);
}
else
{
if (UserType == 3 || UserType == 4)
{
comp.OrgID = OrgID;
comp.SalesManID = SalesManID;
}
if ((new Hi.BLL.BD_Company().Update(comp, Tran)))
{
//新增数据字典
Hi.Model.BD_DefDoc doc = new Hi.Model.BD_DefDoc();
doc.CompID = KeyID;
doc.AtCode = "";
doc.AtName = "计量单位";
doc.ts = DateTime.Now;
doc.modifyuser = UserID;
doc.dr = 0;
List <Hi.Model.BD_DefDoc> ll = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + KeyID + " and atname='计量单位'", "", Tran);
if (ll.Count == 0)
{
new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
//代理商加盟是否需要审核
Hi.Model.SYS_SysName sysname = new Hi.Model.SYS_SysName();
sysname.CompID = KeyID;
sysname.Code = "";
sysname.Name = "代理商加盟是否需要审核";
sysname.Value = "0";
sysname.ts = DateTime.Now;
sysname.modifyuser = UserID;
List <Hi.Model.SYS_SysName> sysl = new Hi.BLL.SYS_SysName().GetList("", "Name='代理商加盟是否需要审核' and CompID=" + KeyID, "", Tran);
if (sysl != null && sysl.Count == 0)
{
new Hi.BLL.SYS_SysName().Add(sysname, Tran);
}
//费用科目
Hi.Model.BD_DefDoc doc1 = new Hi.Model.BD_DefDoc();
doc1.CompID = KeyID;
doc1.AtCode = "";
doc1.AtName = "费用科目";
doc1.ts = DateTime.Now;
doc1.modifyuser = UserID;
doc1.dr = 0;
List <Hi.Model.BD_DefDoc> ll1 = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + KeyID + " and atname='费用科目'", "", Tran);
if (ll1.Count == 0)
{
new Hi.BLL.BD_DefDoc().Add(doc1, Tran);
}
doc.CompID = KeyID;
doc.AtCode = "";
doc.AtName = "代理商等级";
doc.ts = DateTime.Now;
doc.modifyuser = UserID;
doc.dr = 0;
List <Hi.Model.BD_DefDoc> lll = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + KeyID + " and atname='代理商等级'", "", Tran);
if (lll.Count == 0)
{
new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
List <Hi.Model.SYS_Role> l = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and compid=" + KeyID + " and RoleName='企业管理员'", "");
if (l.Count == 0)
{
//新增角色（企业管理员）
Hi.Model.SYS_Role role = new Hi.Model.SYS_Role();
role.CompID = KeyID;
role.RoleName = "企业管理员";
role.IsEnabled = 1;
role.SortIndex = "1";
role.CreateDate = DateTime.Now;
role.CreateUserID = UserID;
role.ts = DateTime.Now;
role.modifyuser = UserID;
role.dr = 0;
int Roid = new Hi.BLL.SYS_Role().Add(role, Tran);
//新增角色用户
Hi.Model.SYS_RoleUser RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = ListComp[0].UserID;
RoleUser.RoleID = Roid;
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
new Hi.BLL.SYS_RoleUser().Add(RoleUser, Tran);
//修改用户对应的角色
List <Hi.Model.SYS_Users> ListUser = new Hi.BLL.SYS_Users().GetList("", " isnull(dr,0)=0 and id=" + ListComp[0].UserID + " ", "");
if (ListUser.Count > 0)
{
ListUser[0].TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
ListUser[0].ts = DateTime.Now;
ListUser[0].modifyuser = UserID;
ListUser[0].AuditState = 2;
new Hi.BLL.SYS_Users().Update(ListUser[0], Tran);
}
ListComp[0].IsAudit = 2;
ListComp[0].modifyuser = UserID;
ListComp[0].ts = DateTime.Now;
ListComp[0].RoleID = Roid;
new Hi.BLL.SYS_CompUser().Update(ListComp[0], Tran);
Hi.Model.BD_CompNews CNew = new Hi.Model.BD_CompNews();
CNew.NewsTitle = "欢迎登录" + ConfigurationManager.AppSettings["PhoneSendName"].ToString() + "平台";
CNew.NewsContents = "”" + ConfigurationManager.AppSettings["PhoneSendName"].ToString() + "”平台为企业和代理商之间搭建了电子商务平台，通过企业入驻及代理商的加盟，形成覆盖全行业的线上销售网络。同时，充分利用平台信息化整合优势，帮助入驻企业销售模式电商化改造，以及为代理商信息化建设提供有力支持。另外，还将为供应链上的相关各方提供全渠道的结算服务以及授信融资等多项互联网金融服务。";
CNew.IsEnabled = 1;
CNew.IsTop = 0;
CNew.NewsType = 2;
CNew.ShowType = "1,2";
CNew.CompID = KeyID;
CNew.CreateDate = DateTime.Now;
CNew.CreateUserID = UserID;
CNew.ts = DateTime.Now;
CNew.modifyuser = UserID;
new Hi.BLL.BD_CompNews().Add(CNew, Tran);
//新增角色权限表
Hi.Model.SYS_RoleSysFun rolesys = null;
//add by hgh 增加了：and funcode<>'1030'
List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=1 and funcode<>'1030'", "");
foreach (Hi.Model.SYS_SysFun sys in funList)
{
rolesys = new Hi.Model.SYS_RoleSysFun();
rolesys.CompID = KeyID;
rolesys.RoleID = Roid;
rolesys.FunCode = sys.FunCode;
rolesys.FunName = sys.FunName;
rolesys.IsEnabled = 1;
rolesys.CreateUserID = UserID;
rolesys.CreateDate = DateTime.Now;
rolesys.ts = DateTime.Now;
rolesys.modifyuser = UserID;
new Hi.BLL.SYS_RoleSysFun().Add(rolesys, Tran);
}
//新增代理商分类
Hi.Model.BD_DisType distype = new Hi.Model.BD_DisType();
distype.CompID = KeyID;
distype.TypeName = "全部";
distype.ParentId = 0;
distype.TypeCode = "1001";
distype.SortIndex = "1000";
distype.IsEnabled = 0;
distype.CreateUserID = UserID;
distype.CreateDate = DateTime.Now;
distype.ts = DateTime.Now;
distype.modifyuser = UserID;
distype.dr = 0;
new Hi.BLL.BD_DisType().Add(distype, Tran);
Tran.Commit();
//审核成功 添加一条默认的商品分类 -开始
string Typecode = "";//商品大类
//Hi.Model.SYS_GType gtype = new Hi.BLL.SYS_GType().GetList(" top 1 *", " Deep=3 and FullCode like '"+ Typecode + "-%' and IsEnabled=1 and dr=0 ", " parentid,ID")[0];
//Hi.Model.BD_GoodsCategory DisType = new Hi.Model.BD_GoodsCategory();
//DisType.Code = NewCategoryCode("1");
//DisType.Deep = 1;
//DisType.ParCode = "";
//DisType.ParentId = 0;
//DisType.CompID = KeyID;
//DisType.CategoryName = "默认";
//DisType.GoodsTypeID = gtype.ID;
//DisType.SortIndex = "1000";
//DisType.CreateDate = DateTime.Now;
//DisType.CreateUserID = 0;
//DisType.IsEnabled = 1;
//DisType.ts = DateTime.Now;
//DisType.modifyuser = 0;
//SqlTransaction trans = SqlHelper.CreateStoreTranSaction();
//try
//{
// int countID = 0;
// if ((countID = new Hi.BLL.BD_GoodsCategory().Add(DisType, trans)) > 0)
// {
// List<Hi.Model.BD_Goods> gList = new Hi.BLL.BD_Goods().GetList("", " CategoryID=''", "");
// if (gList != null && gList.Count > 0)
// {
// foreach (var bdGoodse in gList)
// {
// bdGoodse.CategoryID = countID;
// new Hi.BLL.BD_Goods().Update(bdGoodse, trans);
// }
// }
// trans.Commit();
// }
//}
//catch (Exception ex)
//{
// Tiannuo.LogHelper.LogHelper.Error("Error", ex);
// if (trans != null)
// {
// if (trans.Connection != null)
// {
// trans.Rollback();
// }
// }
// return;
//}
//finally
//{
// SqlHelper.ConnectionClose();
// if (trans != null)
// {
// if (trans.Connection != null)
// {
// trans.Connection.Close();
// }
// }
//}
//审核成功 添加一条默认的商品分类 -结束
DBUtility.GetPhoneCode getphonecode = new DBUtility.GetPhoneCode();
str = getphonecode.ReturnSTRS(ListUser[0].Phone, comp.CompName, ListUser[0].UserName);
if (str != "Success")
{
JScript.AlertMsgMo(this, "审核通过的通知短信发送失败！请自行发送短信通知企业。", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=" + Request.QueryString["type"] + "" + "'; }");
}
else
{
JScript.AlertMsgMo(this, "审核成功", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=5'; }");
}
}
else
{
ListComp[0].IsAudit = 2;
ListComp[0].modifyuser = UserID;
ListComp[0].ts = DateTime.Now;
new Hi.BLL.SYS_CompUser().Update(ListComp[0], Tran);
Hi.Model.SYS_Users user = null;
List <Hi.Model.SYS_CompUser> User2 = new Hi.BLL.SYS_CompUser().GetList("", " dr=0 and utype=4 and CompID=" + KeyID + "", "");
if (User2.Count > 0)
{
user = new Hi.BLL.SYS_Users().GetModel(User2[0].UserID);
}
Tran.Commit();
// 发短信通知
DBUtility.GetPhoneCode getphonecode = new DBUtility.GetPhoneCode();
getphonecode.GetUser(ConfigurationManager.AppSettings["PhoneCodeAccount"].ToString(), ConfigurationManager.AppSettings["PhoneCodePwd"].ToString());
str = getphonecode.ReturnSTRS(user.Phone, comp.CompName, user.UserName);
if (str != "Success")
{
JScript.AlertMsgMo(this, "审核通过的通知短信发送失败！请自行发送短信通知企业。", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=" + Request.QueryString["type"] + "" + "'; }");
}
else
{
JScript.AlertMsgMo(this, "审核成功", "function(){ window.location.href='CompInfo.aspx?go=1&KeyID=" + KeyID + "&type=5'; }");
}
}
}
}
}
else
{
JScript.AlertMsg(this, "用户明细数据异常！。");
return;
}
}
catch (Exception ex)
{
Tiannuo.LogHelper.LogHelper.Error("Error", ex);
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
JScript.AlertMsgMo(this, "审核失败", "function(){ window.location.href=window.location.href; }");
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
}
}
else
{
JScript.AlertMsg(this, "厂商不存在！。");
return;
}
//cust by ggh 20180327 begin 审核通过时，默认给核心企业设置手续费
Settings(KeyID);
//cust by ggh 20180327 end 审核通过时，默认给核心企业设置手续费
}
else
{
if (Common.GetUserExists(txtUsername.Value.Trim()))
{
JScript.AlertMsg(this, "该登录帐号已存在。");
return;
}
if (Common.CompExistsAttribute("CompName", txtCompName.Value.Trim()))
{
JScript.AlertMsg(this, "该厂商名称已存在。");
return;
}
Regex Phonereg = new Regex("^0?1[0-9]{10}$");
if (!Phonereg.IsMatch(txtUserPhone.Value.Trim()))
{
JScript.AlertMsg(this, "手机号码格式错误！");
return;
}
if (Common.GetUserExists("Phone", txtUserPhone.Value.Trim()))
{
JScript.AlertMsg(this, "手机号码已被注册！");
return;
}
Hi.Model.BD_Company comp = new Hi.Model.BD_Company();
if (UserType == 3 || UserType == 4)
{
comp.OrgID = OrgID;
comp.SalesManID = SalesManID;
}
comp.CompName = Common.NoHTML(txtCompName.Value.Trim());
comp.Capital = Capital.Value.Trim();
comp.CompType = Convert.ToInt32(CompType.SelectedValue);
comp.Tel = Common.NoHTML(txtTel.Value.Trim());
if (txtPrincipal.Value.Trim() != "")
{
comp.Principal = Common.NoHTML(txtPrincipal.Value.Trim());
}
else
{
comp.Principal = Common.NoHTML(txtUserTrueName.Value.Trim());
}
comp.Legal = Common.NoHTML(txtLegal.Value.Trim());
comp.LegalTel = Common.NoHTML(txtLegalTel.Value.Trim());
if (txtPhone.Value.Trim() != "")
{
comp.Phone = Common.NoHTML(txtPhone.Value.Trim());
}
else
{
comp.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
}
comp.ShortName = Common.NoHTML(txtShotName.Value.Trim());
comp.Zip = Common.NoHTML(txtZip.Value.Trim());
comp.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
comp.Licence = Common.NoHTML(txtLicence.Value.Trim());
comp.ManageInfo = Common.NoHTML(txtInfo.Value.Trim());
comp.Fax = Common.NoHTML(txtFax.Value.Trim());
comp.OrganizationCode = Common.NoHTML(txtOrcode.Value.Trim());
comp.Trade = txtIndusName.Items[txtIndusName.SelectedIndex].Text;
comp.Account = Common.NoHTML(txtAccount.Value.Trim());
comp.Attachment = HidFfileName.Value;
comp.Address = Common.NoHTML(txtAddress.Value.Trim());
comp.CustomCompinfo = "本公司产品种类丰富、质量优良、价格公道、服务周到。感谢您长期的支持与厚爱，您的满意是我们最高的追求，我们将竭诚为您提供优质、贴心的服务！";
string CompAddr = hidProvince.Value.Trim();
if (!string.IsNullOrWhiteSpace(hidCity.Value.Trim()) && hidCity.Value.Trim() != "选择市")
{
CompAddr += "-" + hidCity.Value.Trim();
}
if (!string.IsNullOrWhiteSpace(hidArea.Value.Trim()) && hidArea.Value.Trim() != "选择区")
{
CompAddr += "-" + hidArea.Value.Trim();
}
comp.CompAddr = CompAddr;
comp.IndID = txtIndusName.SelectedValue.ToInt(0);
comp.CreateDate = DateTime.Now;
comp.CreateUserID = UserID;
comp.ts = DateTime.Now;
comp.modifyuser = UserID;
comp.IsEnabled = rdEbleYes.Checked ? 1 : 0;
comp.HotShow = rdHotShowYes.Checked ? 1 : 0;
comp.FirstShow = Convert.ToInt32(ddlChkShow.SelectedValue);// rdFirstShowYes.Checked ? 1 : 0;
comp.SortIndex = "001";
comp.Remark = Common.NoHTML(txtRemark.Value.Trim());
comp.Erptype = ddlErptype.SelectedValue.ToInt(0);
comp.AuditState = 0;
int comid = 0;
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
comid = new Hi.BLL.BD_Company().Add(comp, Tran);
comp.CompCode = Common.CreateCode(comid);
comp.ID = comid;
new Hi.BLL.BD_Company().Update(comp, Tran);
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
user.UserName = Common.NoHTML(txtUsername.Value.Trim());
user.TrueName = Common.NoHTML(txtUserTrueName.Value.Trim());
user.UserPwd = Util.md5(txtUpwd.Text.Trim());
user.Phone = Common.NoHTML(txtUserPhone.Value.Trim());
user.AuditState = 2;
user.IsEnabled = 1;
user.AuditUser = UserID.ToString();
user.CreateUserID = UserID;
user.CreateDate = DateTime.Now;
user.ts = DateTime.Now;
user.modifyuser = UserID;
int userid = 0;
userid = new Hi.BLL.SYS_Users().Add(user, Tran);
Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = comid;
CompUser.DisID = 0;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 1;
CompUser.UType = 4;
CompUser.IsEnabled = 1;
CompUser.IsAudit = 0;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = userid;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
Tran.Commit();
Response.Redirect("CompInfo.aspx?go=1&KeyID=" + comid, false);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
#region 没有优化岗位权限前的代码
//SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//Hi.Model.SYS_Users User = null;
//if (KeyID != 0)
//{
// //修改
// int userid = KeyID;
// User = new Hi.BLL.SYS_Users().GetModel(userid);
// if (Common.GetUserExists("UserName", txtUserName.Value.Trim(), userid.ToString()))
// {
// JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
// return;
// }
// if (Common.GetUserExists("Phone", txtPhone.Value.Trim(), userid.ToString()))
// {
// JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
// return;
// }
// if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
// {
// JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
// return;
// }
// List<Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("", " CompID="+CompID+" AND UserID="+KeyID+" AND dr=0 AND IsEnabled=1 ", "");
// if (ListCompUser.Count == 0)
// {
// JScript.AlertMethod(this, "员工帐号信息有误！", JScript.IconOption.错误, "function (){ history.go(-1) ; }");
// return;
// }
// if (ListCompUser[0].UType != 4)
// {
// User.UserName = txtUserName.Value.Trim();
// User.Phone = txtPhone.Value.Trim();
// }
// if (rdEnabledNo.Checked)
// {
// if (ListCompUser[0].UType == 4)
// {
// JScript.AlertMsgOne(this, "用户为系统管理员，不可禁用！", JScript.IconOption.错误);
// return;
// }
// }
// User.TrueName = txtTrueName.Value.Trim();
// User.Identitys = txtIdentitys.Value.Trim();
// User.Address = txtAddress.Value.Trim();
// User.Email = txtEmail.Value.Trim();
// ListCompUser[0].IsEnabled = rdEnabledYes.Checked ? 1 : 0;
// ListCompUser[0].ts = DateTime.Now;
// ListCompUser[0].modifyuser = UserID;
// if (txtUserPwd.Text.Trim() != Util.md5("123456"))
// {
// User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
// }
// User.ts = DateTime.Now;
// User.modifyuser = UserID;
// List<Hi.Model.SYS_RoleUser> list = new Hi.BLL.SYS_RoleUser().GetList("", " dr=0 and IsEnabled=1 and UserID=" + KeyID + "", "");
// if (list.Count > 0)
// {
// for (int i = 0; i < list.Count; i++)
// {
// Hi.Model.SYS_RoleUser roleu = new Hi.Model.SYS_RoleUser();
// roleu.ID = list[0].ID;
// roleu.FunType = list[0].FunType;
// roleu.UserID = list[0].UserID;
// roleu.RoleID = list[0].RoleID;
// roleu.IsEnabled = true;//禁用
// roleu.CreateUser = list[0].CreateUser;
// roleu.CreateDate = list[0].CreateDate;
// roleu.ts = DateTime.Now;
// roleu.dr = list[0].dr;
// bool sss = new Hi.BLL.SYS_RoleUser().Update(roleu);
// }
// }
// else
// {
// //岗位权限表
// if (hidMyRole.Value != "")
// {
// string[] rolestr = hidMyRole.Value.Split(',');
// Hi.BLL.SYS_RoleUser RoleUserService = new Hi.BLL.SYS_RoleUser();
// Hi.Model.SYS_RoleUser RoleUser = null;
// foreach (string str in rolestr)
// {
// if (str != "" && Convert.ToInt32(str) > 0)
// {
// RoleUser = new Hi.Model.SYS_RoleUser();
// RoleUser.FunType = 1;
// RoleUser.UserID = userid;
// RoleUser.RoleID = Convert.ToInt32(str);
// RoleUser.IsEnabled = true;
// RoleUser.CreateUser = this.UserID.ToString();
// RoleUser.CreateDate = DateTime.Now;
// RoleUser.ts = DateTime.Now;
// RoleUser.dr = 0;
// RoleUserService.Add(RoleUser, Tran);
// }
// }
// }
// }
// new Hi.BLL.SYS_Users().Update(User, Tran);
// new Hi.BLL.SYS_CompUser().Update(ListCompUser[0], Tran);
// Tran.Commit();
// JScript.AlertMethod(this, "操作成功!", JScript.IconOption.正确, "UserInfo.aspx?KeyId="+KeyID);
//}
//else
//{
// //新增
// if (Common.GetUserExists("UserName", txtUserName.Value.Trim()))
// {
// JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
// return;
// }
// if (Common.GetUserExists("Phone", txtPhone.Value.Trim()))
// {
// JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
// return;
// }
// if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
// {
// JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
// return;
// }
// User = new Hi.Model.SYS_Users();
// User.CompID = CompID;//厂商ID
// User.DisID = 0;
// User.Type = 3;
// User.AuditState = 2;
// User.UserName = txtUserName.Value.Trim();
// User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
// User.TrueName = txtTrueName.Value.Trim();
// User.Phone = txtPhone.Value.Trim();
// User.Identitys = txtIdentitys.Value.Trim();
// User.Address = txtAddress.Value.Trim();
// User.Email = txtEmail.Value.Trim();
// User.IsEnabled = rdEnabledYes.Checked ? 1 : 0;
// User.IsFirst = 0;
// User.CreateDate = DateTime.Now;
// User.CreateUserID = UserID;
// User.AuditUser = UserID.ToString();
// User.ts = DateTime.Now;
// User.modifyuser = UserID;
// int userid = new Hi.BLL.SYS_Users().Add(User, Tran);
// //多角色表
// Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser();
// CompUser.CompID = CompID;
// CompUser.DisID = 0;
// CompUser.CreateDate = DateTime.Now;
// CompUser.CreateUserID = UserID;
// CompUser.modifyuser = UserID;
// CompUser.CType = 1;
// CompUser.UType = 3;
// CompUser.RoleID = 0;//权限屏蔽掉
// CompUser.IsEnabled = rdEnabledYes.Checked ? 1 : 0;
// CompUser.IsAudit = 2;
// CompUser.ts = DateTime.Now;
// CompUser.dr = 0;
// CompUser.UserID = userid;
// new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
// //岗位权限表
// if (hidMyRole.Value != "")
// {
// string[] rolestr = hidMyRole.Value.Split(',');
// Hi.BLL.SYS_RoleUser RoleUserService = new Hi.BLL.SYS_RoleUser();
// Hi.Model.SYS_RoleUser RoleUser = null;
// foreach (string str in rolestr)
// {
// if (str != "" && Convert.ToInt32(str) > 0)
// {
// RoleUser = new Hi.Model.SYS_RoleUser();
// RoleUser.FunType = 1;
// RoleUser.UserID = userid;
// RoleUser.RoleID = Convert.ToInt32(str);
// RoleUser.IsEnabled = true;
// RoleUser.CreateUser = this.UserID.ToString();
// RoleUser.CreateDate = DateTime.Now;
// RoleUser.ts = DateTime.Now;
// RoleUser.dr = 0;
// RoleUserService.Add(RoleUser, Tran);
// }
// }
// }
// Tran.Commit();
// //this.Page.ClientScript.RegisterStartupScript(Page.GetType(), "msg", "<script>cancel()</script>");
// Response.Redirect("UserInfo.aspx?KeyId=" + userid);
//}
#endregion
Hi.Model.SYS_Users User = null;
Hi.Model.SYS_CompUser CompUser = null;
Hi.Model.SYS_RoleUser RoleUser = null;
Hi.BLL.SYS_RoleUser RoleUserService = new Hi.BLL.SYS_RoleUser();
if (KeyID != 0)
{
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//修改
User = new Hi.BLL.SYS_Users().GetModel(KeyID);
CompUser = new Hi.Model.SYS_CompUser();
if (User.UserName != txtUserName.Value.Trim())
{
if (Common.GetUserExists("UserName", txtUserName.Value.Trim()))
{
JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
return;
}
}
if (User.Phone != txtPhone.Value.Trim())
{
if (txtPhone.Value.Trim() == "")
{
JScript.AlertMsgOne(this, "手机号码不能为空！", JScript.IconOption.错误);
return;
}
if (Common.GetUserExists("Phone", txtPhone.Value.Trim()))
{
JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
return;
}
}
if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
{
JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
return;
}
List <Hi.Model.SYS_CompUser> ListCompUser = new Hi.BLL.SYS_CompUser().GetList("*", " CompID=" + CompID + " AND UserID=" + KeyID + " AND dr=0 AND IsEnabled=1 ", "");
CompUser = ListCompUser[0];
//禁用时判断
if (rdEnabledNo.Checked)
{
if (ListCompUser[0].UType == 4)
{
JScript.AlertMsgOne(this, "用户为管理员，不可禁用！", JScript.IconOption.错误);
return;
}
else
{
User.IsEnabled = 0;
CompUser.IsEnabled = 0;
List <Hi.Model.SYS_RoleUser> roleusers = new Hi.BLL.SYS_RoleUser().GetList("", " UserID=" + KeyID + " AND dr=0 ", "");
if (roleusers.Count > 0)
{
for (int i = 0; i < roleusers.Count; i++)
{
roleusers[i].IsEnabled = false;
}
}
}
}
if (rdEnabledYes.Checked)
{
User.IsEnabled = 1;
CompUser.IsEnabled = 1;
}
User.UserName = Common.NoHTML(txtUserName.Value.Trim());
User.TrueName = Common.NoHTML(txtTrueName.Value.Trim());
User.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
if (txtPwd.Text.Trim() != User.UserPwd)
{
User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
}
User.Address = Common.NoHTML(txtAddress.Value.Trim());
User.Email = Common.NoHTML(txtEmail.Value.Trim());
User.Type = 3;
User.ts = DateTime.Now;
User.modifyuser = UserID;
if (DisSalesManID.Value != "0")
{
if (CompUser.UType == 4)
{
JScript.AlertMsgOne(this, "用户为管理员，不可修改类型！", JScript.IconOption.错误);
return;
}
CompUser.UType = 6;
CompUser.DisSalesManID = Convert.ToInt32(DisSalesManID.Value);
}
else
{
if (CompUser.UType == 4)
{
CompUser.UType = 4;
}
else
{
CompUser.UType = 3;
}
CompUser.DisSalesManID = 0;
}
//岗位权限表
List <Hi.Model.SYS_RoleUser> roleuser = new Hi.BLL.SYS_RoleUser().GetList("", " UserID=" + KeyID + " AND dr=0 ", "");
for (int i = 0; i < roleuser.Count; i++)
{
roleuser[i].IsEnabled = false;
roleuser[i].ts = DateTime.Now;
RoleUserService.Update(roleuser[i]);
}
if (hidMyRole.Value != "")
{
string[] rolestr = hidMyRole.Value.Substring(0, hidMyRole.Value.Length - 1).Split(',');
for (int i = 0; i < rolestr.Length; i++)
{
List <Hi.Model.SYS_RoleUser> rolenew = new Hi.BLL.SYS_RoleUser().GetList("", " UserID=" + KeyID + " AND dr=0 AND RoleID=" + rolestr[i].ToInt(0) + " ", "");
if (rolenew.Count > 0)
{
rolenew[0].IsEnabled = true;
rolenew[0].ts = DateTime.Now;
RoleUserService.Update(rolenew[0]);
}
else
{
RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = KeyID;
RoleUser.RoleID = rolestr[i].ToInt(0);
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
RoleUserService.Add(RoleUser, Tran);
}
}
}
new Hi.BLL.SYS_Users().Update(User, Tran);
new Hi.BLL.SYS_CompUser().Update(CompUser, Tran);
Tran.Commit();
Response.Redirect("UserInfo.aspx?KeyId=" + Common.DesEncrypt(KeyID.ToString(), Common.EncryptKey));
}
else
{
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//新增
if (Common.GetUserExists("UserName", txtUserName.Value.Trim()))
{
JScript.AlertMsgOne(this, "该登录帐号已存在！", JScript.IconOption.错误);
return;
}
if (txtPhone.Value.Trim() == "")
{
JScript.AlertMsgOne(this, "手机号码不能为空！", JScript.IconOption.错误);
return;
}
if (Common.GetUserExists("Phone", txtPhone.Value.Trim()))
{
JScript.AlertMsgOne(this, "该手机号码已存在！", JScript.IconOption.错误);
return;
}
if (txtPwd.Text.Trim() != txtUserPwd.Text.Trim())
{
JScript.AlertMsgOne(this, "确认密码填写不一致！", JScript.IconOption.错误);
return;
}
User = new Hi.Model.SYS_Users();
User.CompID = CompID;//厂商ID
User.DisID = 0;
User.AuditState = 2;
User.UserName = Common.NoHTML(txtUserName.Value.Trim());
User.UserPwd = Util.md5(txtUserPwd.Text.Trim());
User.TrueName = Common.NoHTML(txtTrueName.Value.Trim());
User.Phone = Common.NoHTML(txtPhone.Value.Trim());
User.Identitys = Common.NoHTML(txtIdentitys.Value.Trim());
User.Address = Common.NoHTML(txtAddress.Value.Trim());
User.Email = Common.NoHTML(txtEmail.Value.Trim());
User.IsEnabled = rdEnabledYes.Checked ? 1 : 0;
User.IsFirst = 0;
User.CreateDate = DateTime.Now;
User.CreateUserID = UserID;
User.AuditUser = UserID.ToString();
User.ts = DateTime.Now;
User.modifyuser = UserID;
int userid = new Hi.BLL.SYS_Users().Add(User, Tran);
//多角色表
CompUser = new Hi.Model.SYS_CompUser();
CompUser.CompID = CompID;
CompUser.DisID = 0;
CompUser.CreateDate = DateTime.Now;
CompUser.CreateUserID = UserID;
CompUser.modifyuser = UserID;
CompUser.CType = 1;
if (DisSalesManID.Value != "0")
{
CompUser.UType = 6;
CompUser.DisSalesManID = Convert.ToInt32(DisSalesManID.Value);
}
else
{
CompUser.UType = 3;
}
CompUser.RoleID = 0;//权限屏蔽掉
CompUser.IsEnabled = rdEnabledYes.Checked ? 1 : 0;
CompUser.IsAudit = 2;
CompUser.ts = DateTime.Now;
CompUser.dr = 0;
CompUser.UserID = userid;
new Hi.BLL.SYS_CompUser().Add(CompUser, Tran);
//岗位权限表
if (hidMyRole.Value != "")
{
string[] rolestr = hidMyRole.Value.Split(',');
foreach (string str in rolestr)
{
if (str != "" && Convert.ToInt32(str) > 0)
{
RoleUser = new Hi.Model.SYS_RoleUser();
RoleUser.FunType = 1;
RoleUser.UserID = userid;
RoleUser.RoleID = Convert.ToInt32(str);
RoleUser.IsEnabled = true;
RoleUser.CreateUser = this.UserID.ToString();
RoleUser.CreateDate = DateTime.Now;
RoleUser.ts = DateTime.Now;
RoleUser.dr = 0;
RoleUserService.Add(RoleUser, Tran);
}
}
}
Tran.Commit();
Response.Redirect("UserInfo.aspx?KeyId=" + Common.DesEncrypt(userid.ToString(), Common.EncryptKey));
}
}
