/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.SYS_Role model) { return(dal.Update(model)); }
public void btnAddList_Click(object sender, EventArgs e) { string path = ""; int count = 0; int index = 0; SqlTransaction Tran = null; try { if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件 { JScript.AlertMsgOne(this, "请您选择代理商Excel模板文件", JScript.IconOption.错误); return; //当无文件时,返回 } string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); //System.IO.Path.GetExtension获得文件的扩展名 if (IsXls != ".xls" && IsXls != ".xlsx") { JScript.AlertMsgOne(this, "请您选择代理商Excel模板文件", JScript.IconOption.错误); return;//当选择的不是Excel文件时,返回 } if (!Directory.Exists(Server.MapPath("TemplateFile"))) { Directory.CreateDirectory(Server.MapPath("TemplateFile")); } string filename = FileUpload1.FileName; string name = filename.Replace(IsXls, ""); path = Server.MapPath("TemplateFile/") + name + "-" + DateTime.Now.ToString("yyyyMMddhhmmssffff") + IsXls; FileUpload1.SaveAs(path); DataTable dt = Common.ExcelToDataTable(path, TitleIndex); if (dt == null) { throw new Exception("Excel表中无数据"); } if (dt.Rows.Count == 0) { throw new Exception("Excel表中无数据"); } string Discode = string.Empty; string DisName = string.Empty; string DisUserName = string.Empty; string DisAddrees = string.Empty; string DisPerson = string.Empty; string DisPhone = string.Empty; string DisRemark = string.Empty; string Provice = string.Empty; string City = string.Empty; string Area = string.Empty; string DisCategory = string.Empty; string DisLevel = string.Empty; DataRow[] rows = dt.Select(); Tran = DBUtility.SqlHelper.CreateStoreTranSaction(); Eroor = false; TitleError = string.Empty; foreach (DataRow row in rows) { int typeID = 0; int AreaID = 0; try { //这个判断有bug呀,是遇到空行就停止的意思吗? if (row["代理商名称 *\n(2-20个汉字或字母,推荐使用中文名称)"].ToString().Trim() == "" && row["管理员姓名 *\n(请填写真实姓名,以便更好地为您服务)"].ToString().Trim() == "" && row["详细地址 *\n(常用收货地址)"].ToString().Trim() == "") { break; } index++; if (row["代理商名称 *\n(2-20个汉字或字母,推荐使用中文名称)"].ToString().Trim() == "示例代理商名称1" || row["代理商名称 *\n(2-20个汉字或字母,推荐使用中文名称)"].ToString().Trim() == "示例代理商名称2" || row["代理商名称 *\n(2-20个汉字或字母,推荐使用中文名称)"].ToString().Trim() == "示例代理商名称3") { continue; } DisName = DisExistsAttribute("DisName", CheckDisLen(CheckVal(row["代理商名称 *\n(2-20个汉字或字母,推荐使用中文名称)"].ToString().Trim(), "代理商名称", index), index), "代理商名称", index, Tran); DisPerson = CheckVal(row["管理员姓名 *\n(请填写真实姓名,以便更好地为您服务)"].ToString().Trim(), "管理员姓名", index); DisUserName = UserExistsAttribute("username", CheckVal(row["管理员登录帐号 *\n(2-20个文字、字母、数字,可以录入代理商姓名、简称等,一经设定无法更改,将来可用手机号进行登录)"].ToString().Trim(), "管理员登录帐号", index), "管理员登录帐号", index, Tran); DisPhone = CheckPhone(CheckVal(row["管理员手机 *\n(登录、发送验证短信)"].ToString().Trim(), "管理员手机", index), "管理员手机", index, Tran); Provice = CheckVal(row["所在省*"].ToString().Trim(), "省", index); City = CheckVal(row["所在市*"].ToString().Trim(), "市", index); if (City.IndexOf("_") > 0) { City = City.Substring(City.IndexOf("_") + 1, City.Length - City.IndexOf("_") - 1); } Area = CheckVal(row["所在区*"].ToString().Trim(), "区", index); DisAddrees = CheckVal(row["详细地址 *\n(常用收货地址)"].ToString().Trim(), "详细地址(常用收货地址)", index); DisCategory = row["代理商分类"].ToString().Trim(); DisLevel = row["代理商区域"].ToString().Trim(); bool disType = true; if (!string.IsNullOrEmpty(DisCategory)) { disType = CheckDisCategory(DisCategory, index, out typeID); } if (!string.IsNullOrEmpty(DisLevel)) { CheckDisLevel(DisLevel, index, out AreaID); } DisRemark = row["备注"].ToString().Trim(); if (Eroor) { continue; } } catch (Exception ex) { if (ex is ApplicationException) { Eroor = true; TitleError += ex.Message; continue; } else { throw new Exception("代理商Excel模版格式错误,请重新下载模版填入数据后导入。"); } } Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor(); //Dis.DisCode = Discode; Dis.CompID = CompID; Dis.DisName = DisName; Dis.Province = Provice; Dis.City = City; Dis.Area = Area; Dis.Address = DisAddrees; Dis.Principal = DisPerson; Dis.Phone = DisPhone; Dis.DisTypeID = typeID; //add by 2016.5.9 Dis.AreaID = AreaID; //add by 2016.5.10 Dis.Remark = DisRemark; Dis.IsCheck = 0; Dis.CreditType = 0; //不可以赊销 Dis.Paypwd = Util.md5("123456"); Dis.IsEnabled = 1; Dis.AuditState = 2; Dis.CreateDate = DateTime.Now; Dis.CreateUserID = UserID; Dis.ts = DateTime.Now; Dis.modifyuser = UserID; int disid = 0; if ((disid = new Hi.BLL.BD_Distributor().Add(Dis, Tran)) > 0) { List <Hi.Model.SYS_Role> l = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and DisID=" + disid + " and RoleName='企业管理员'", "", Tran); if (l.Count == 0) { //新增角色(企业管理员) Hi.Model.SYS_Role role = new Hi.Model.SYS_Role(); role.CompID = CompID; role.DisID = disid; 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_Users user = new Hi.Model.SYS_Users(); user.UserName = DisUserName; user.Phone = DisPhone; user.TrueName = DisPerson; user.UserPwd = Util.md5("123456"); user.IsEnabled = 1; user.AuditState = 2; user.CreateDate = DateTime.Now; user.CreateUserID = UserID; user.ts = DateTime.Now; user.modifyuser = UserID; int AddUserid = new Hi.BLL.SYS_Users().Add(user, Tran); ///用户明细表 Hi.Model.SYS_CompUser 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 = 5; CompUser.IsEnabled = 1; CompUser.IsAudit = 2; CompUser.RoleID = Roid; CompUser.ts = DateTime.Now; CompUser.dr = 0; CompUser.UserID = AddUserid; new Hi.BLL.SYS_CompUser().Add(CompUser, Tran); //新增角色权限表 //暂时屏蔽下 Hi.Model.SYS_RoleSysFun rolesys = null; List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=2", "", Tran); foreach (Hi.Model.SYS_SysFun sys in funList) { rolesys = new Hi.Model.SYS_RoleSysFun(); rolesys.CompID = CompID; rolesys.DisID = disid; 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_DisAddr addr = new Hi.Model.BD_DisAddr(); addr.Province = Provice; addr.City = City; addr.Area = Area; addr.DisID = disid; addr.Principal = DisPerson; addr.Phone = DisPhone; addr.Address = Provice + City + Area + DisAddrees; addr.IsDefault = 1; addr.ts = DateTime.Now; addr.CreateDate = DateTime.Now; addr.CreateUserID = UserID; addr.modifyuser = UserID; new Hi.BLL.BD_DisAddr().Add(addr, Tran); } else { throw new ApplicationException("导入失败,服务器异常请重试。"); } count++; } if (!Eroor) { Tran.Commit(); if (Request["nextstep"] + "" == "1") { JScript.AlertMethod(this, "导入成功,共导入" + count + "条代理商", JScript.IconOption.笑脸, "function(){ window.location.href=window.location.href+'?nextstep=1'; /* $(window.parent.leftFrame.document).find('.menuson li.active').removeClass('active');window.parent.leftFrame.document.getElementById('ktxzjxs').className = 'active';*/}"); } else { JScript.AlertMethod(this, "导入成功,共导入" + count + "条代理商", JScript.IconOption.笑脸, "function(){ window.location.href=window.location.href; }"); } } else { Tran.Rollback(); JScript.AlertMethod(this, TitleError, JScript.IconOption.错误, "function(){ addList(); }"); } } catch (Exception ex) { if (Tran != null) { if (Tran.Connection != null) { Tran.Rollback(); } } JScript.AlertMethod(this, ex.Message, JScript.IconOption.错误, "function(){ $('a.bulk').trigger('click'); }"); } finally { if (!string.IsNullOrEmpty(path)) { if (File.Exists(path)) { File.Delete(path); } } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.SYS_Role model) { return(dal.Add(model)); }
/// <summary> /// 确定导入 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnImport_Click(object sender, EventArgs e) { if (HttpContext.Current.Session["DisTable"] != null) { SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction(); try { DataTable dt = HttpContext.Current.Session["DisTable"] as DataTable; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["chkstr"].ToString() == "数据正确!") { Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor(); //Dis.DisCode = Discode; Dis.CompID = CompID; Dis.DisName = dt.Rows[i]["disname"].ToString().Trim(); Dis.Province = dt.Rows[i]["pro"].ToString().Trim(); Dis.City = dt.Rows[i]["city"].ToString().Trim(); Dis.Area = dt.Rows[i]["quxian"].ToString().Trim(); Dis.Address = dt.Rows[i]["address"].ToString().Trim(); Dis.Principal = dt.Rows[i]["principal"].ToString().Trim(); Dis.Phone = dt.Rows[i]["phone"].ToString().Trim(); Dis.DisTypeID = Convert.ToInt32(dt.Rows[i]["distypeid"].ToString().Trim()); //add by 2016.5.9 Dis.AreaID = Convert.ToInt32(dt.Rows[i]["areaid"].ToString().Trim()); //add by 2016.5.10 Dis.Remark = dt.Rows[i]["remark"].ToString().Trim(); Dis.IsCheck = 0; Dis.CreditType = 0; //不可以赊销 Dis.Paypwd = Util.md5("123456"); Dis.IsEnabled = 1; Dis.AuditState = 2; Dis.CreateDate = DateTime.Now; Dis.CreateUserID = UserID; Dis.ts = DateTime.Now; Dis.modifyuser = UserID; int disid = 0; if ((disid = new Hi.BLL.BD_Distributor().Add(Dis, Tran)) > 0) { List <Hi.Model.SYS_Role> l = new Hi.BLL.SYS_Role().GetList("", "isnull(dr,0)=0 and isenabled=1 and DisID=" + disid + " and RoleName='企业管理员'", "", Tran); if (l.Count == 0) { //新增角色(企业管理员) Hi.Model.SYS_Role role = new Hi.Model.SYS_Role(); role.CompID = CompID; role.DisID = disid; 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_Users user = new Hi.Model.SYS_Users(); user.UserName = dt.Rows[i]["username"].ToString().Trim(); user.Phone = dt.Rows[i]["phone"].ToString().Trim(); user.TrueName = dt.Rows[i]["principal"].ToString().Trim(); user.UserPwd = Util.md5("123456"); user.IsEnabled = 1; user.AuditState = 2; user.CreateDate = DateTime.Now; user.CreateUserID = UserID; user.ts = DateTime.Now; user.modifyuser = UserID; int AddUserid = new Hi.BLL.SYS_Users().Add(user, Tran); ///用户明细表 Hi.Model.SYS_CompUser 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 = 5; CompUser.IsEnabled = 1; CompUser.IsAudit = 2; CompUser.RoleID = Roid; CompUser.ts = DateTime.Now; CompUser.dr = 0; CompUser.UserID = AddUserid; new Hi.BLL.SYS_CompUser().Add(CompUser, Tran); //新增角色权限表 //暂时屏蔽下 Hi.Model.SYS_RoleSysFun rolesys = null; List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("", " Type=2", "", Tran); foreach (Hi.Model.SYS_SysFun sys in funList) { rolesys = new Hi.Model.SYS_RoleSysFun(); rolesys.CompID = CompID; rolesys.DisID = disid; 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_DisAddr addr = new Hi.Model.BD_DisAddr(); addr.Province = dt.Rows[i]["pro"].ToString().Trim(); addr.City = dt.Rows[i]["city"].ToString().Trim(); addr.Area = dt.Rows[i]["quxian"].ToString().Trim(); addr.DisID = disid; addr.Principal = dt.Rows[i]["principal"].ToString().Trim(); addr.Phone = dt.Rows[i]["phone"].ToString().Trim(); addr.Address = dt.Rows[i]["pro"].ToString().Trim() + dt.Rows[i]["city"].ToString().Trim() + dt.Rows[i]["quxian"].ToString().Trim() + dt.Rows[i]["address"].ToString().Trim(); addr.IsDefault = 1; addr.ts = DateTime.Now; addr.CreateDate = DateTime.Now; addr.CreateUserID = UserID; addr.modifyuser = UserID; new Hi.BLL.BD_DisAddr().Add(addr, Tran); } else { throw new ApplicationException("导入失败,服务器异常请重试。"); } } } Tran.Commit(); Response.Redirect("ImportDis3.aspx", false); //ClientScript.RegisterStartupScript(this.GetType(), "Add", "<script>addlis(" + count + "," + count2 + ",'" + str + "');</script>"); } catch (Exception ex) { if (Tran != null) { if (Tran.Connection != null) { Tran.Rollback(); } } HttpContext.Current.Session["DisTable"] = null; JScript.AlertMethod(this, ex.Message, JScript.IconOption.错误, "function(){location.href='ImportDis.aspx'}"); } } else { JScript.AlertMethod(this, "Excel没有数据,请重新导入", JScript.IconOption.错误, "function(){location.href='ImportDis.aspx'}"); } }
/// <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 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) { try { Hi.Model.SYS_Role role = null; if (KeyID != 0) { //修改 if (rdAuditNo.Checked) { string sql = "select * from SYS_AdminUser where ISNULL(dr,0)=0 and IsEnabled=1 and RoleID=" + KeyID; DataTable userDT = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0]; if (userDT.Rows.Count > 0) { if (Request["nextstep"] + "" == "1") { JScript.AlertMethod(this, "请先禁用该岗位下的人员!", JScript.IconOption.错误, "function (){ location.replace('" + ("RoleEdit.aspx?nextstep=1&KeyID=" + KeyID) + "'); }"); return; } else { JScript.AlertMethod(this, "请先禁用该岗位下的人员!", JScript.IconOption.错误, "function (){ location.replace('" + ("RoleInfo.aspx?KeyID=" + KeyID) + "'); }"); return; } } } role = new Hi.BLL.SYS_Role().GetModel(KeyID); role.RoleName = Common.NoHTML(txtRoleName.Text.Trim()); if (RoleExistsAttribute("RoleName", role.RoleName, KeyID.ToString())) { JScript.AlertMsgOne(this, "该角色名称已存在,不能重复!", JScript.IconOption.错误); return; } role.IsEnabled = rdAuditYes.Checked ? 1 : 0; role.Remark = Common.NoHTML(txtRemark.Value.Trim()); role.SortIndex = Common.NoHTML(txtSortIndex.Value.Trim()); role.ts = DateTime.Now; role.modifyuser = UserID; if (new Hi.BLL.SYS_Role().Update(role)) { if (Request["nextstep"] + "" == "1") { JScript.AlertMethod(this, "编辑成功!", JScript.IconOption.正确, "function(){ window.location.href='RoleInfo.aspx?nextstep=1&KeyID=" + KeyID + "'; }"); } else { JScript.AlertMethod(this, "编辑成功!", JScript.IconOption.正确, "function(){ window.location.href='RoleInfo.aspx?KeyID=" + KeyID + "'; }"); // Response.Redirect("RoleInfo.aspx?KeyID=" + KeyID); } } else { JScript.AlertMsgOne(this, "编辑失败!", JScript.IconOption.错误); return; } } else { //新增 role = new Hi.Model.SYS_Role(); role.CompID = UserID; role.RoleName = Common.NoHTML(txtRoleName.Text.Trim()); if (RoleExistsAttribute("RoleName", role.RoleName)) { JScript.AlertMsgOne(this, "该角色名称已存在,不能重复!", JScript.IconOption.错误); return; } role.IsEnabled = rdAuditYes.Checked ? 1 : 0; role.Remark = Common.NoHTML(txtRemark.Value.Trim()); role.SortIndex = Common.NoHTML(txtSortIndex.Value.Trim()); role.CreateDate = DateTime.Now; role.CreateUserID = UserID; role.ts = DateTime.Now; role.modifyuser = UserID; role.dr = 0; int newid = new Hi.BLL.SYS_Role().Add(role); if (newid > 0) { //JScript.AlertMsgMo(this, "新增成功!", "function(){ window.location.href='RoleList.aspx'; }"); //下一步的操作 if (Request["nextstep"] + "" == "1") { Response.Redirect("MenuEdit.aspx?type=1&nextstep=1&RoleId=" + newid); } else { Response.Redirect("MenuEdit.aspx?type=1&RoleId=" + newid); } } else { JScript.AlertMsgOne(this, "新增失败!", JScript.IconOption.错误); return; } } } catch (Exception ex) { throw ex; } }
private bool RegisterDistributor(string distributorName, string phone, string password, SqlTransaction Tran) { try { int Compid = 0; int UserID = 0; Hi.Model.BD_Distributor Distributor = new Hi.Model.BD_Distributor(); Distributor.CompID = Compid; Distributor.DisName = distributorName; Distributor.IsEnabled = 1; Distributor.Paypwd = new GetPhoneCode().md5(password); Distributor.Phone = phone; Distributor.AuditState = 2; Distributor.CreateDate = DateTime.Now; Distributor.CreateUserID = UserID; Distributor.ts = DateTime.Now; Distributor.modifyuser = UserID; Distributor.IsCheck = 0; Distributor.CreditType = 0; int DistributorID = 0; if ((DistributorID = new Hi.BLL.BD_Distributor().Add(Distributor, Tran)) > 0) { int Roid = 0; //新增角色(企业管理员) Hi.Model.SYS_Role role = new Hi.Model.SYS_Role(); role.CompID = Compid; role.DisID = DistributorID; 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; Roid = new Hi.BLL.SYS_Role().Add(role, Tran); //新增角色权限表 Hi.Model.SYS_RoleSysFun rolesys = null; List <Hi.Model.SYS_SysFun> funList = new Hi.BLL.SYS_SysFun().GetList("FunCode,FunName", " Type=2", ""); foreach (Hi.Model.SYS_SysFun sys in funList) { rolesys = new Hi.Model.SYS_RoleSysFun(); rolesys.CompID = Compid; rolesys.DisID = DistributorID; 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.SYS_Users user = new Hi.Model.SYS_Users(); user.UserName = phone; user.TrueName = phone; user.DisID = DistributorID; user.TrueName = ""; user.UserPwd = new GetPhoneCode().md5(password); user.IsEnabled = 1; user.Phone = phone; user.CreateDate = DateTime.Now; user.CreateUserID = UserID; user.ts = DateTime.Now; user.modifyuser = UserID; user.AuditState = 2; int userid = 0; userid = new Hi.BLL.SYS_Users().Add(user, Tran); ///用户明细表 Hi.Model.SYS_CompUser CompUser = new Hi.Model.SYS_CompUser(); CompUser.CompID = Compid; CompUser.DisID = DistributorID; CompUser.CreateDate = DateTime.Now; CompUser.CreateUserID = UserID; CompUser.modifyuser = UserID; CompUser.CType = 2; CompUser.UType = 5; //CompUser.IsEnabled = 1; CompUser.IsAudit = 2; CompUser.RoleID = Roid; CompUser.ts = DateTime.Now; CompUser.dr = 0; CompUser.UserID = userid; CompUser.IsEnabled = 1; new Hi.BLL.SYS_CompUser().Add(CompUser, Tran); } else { return(false); } Tran.Commit(); return(true); } catch (Exception) { if (Tran != null && Tran.Connection != null) { Tran.Rollback(); } return(false); } finally { if (Tran != null && Tran.Connection != null) { Tran.Rollback(); } } }