/// <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'}"); } }
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); } } } }
public EditResult AddResellerShippingAddressList(string JSon) { string UserID = string.Empty; string disID = string.Empty; string Principal = string.Empty; string Phone = string.Empty; string Province = string.Empty; string City = string.Empty; string Area = string.Empty; string Address = string.Empty; string IsDefault = string.Empty; try { #region JSon取值 JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count <= 0 || JInfo["UserID"].ToString() == "" || JInfo["ResellerID"].ToString() == "" || JInfo["Province"].ToString() == "" || JInfo["City"].ToString() == "" || JInfo["Area"].ToString() == "" || JInfo["IsDefault"].ToString() == "") { return new EditResult() { Result = "F", Description = "参数异常" } } ; UserID = JInfo["UserID"].ToString(); disID = JInfo["ResellerID"].ToString(); Province = JInfo["Province"].ToString(); City = JInfo["City"].ToString(); Area = JInfo["Area"].ToString(); IsDefault = JInfo["IsDefault"].ToString(); if (JInfo["Principal"].ToString() == "") { return new EditResult() { Result = "F", Description = "联系人不能为空" } } ; if (JInfo["Phone"].ToString() == "") { return new EditResult() { Result = "F", Description = "联系电话不能为空" } } ; if (JInfo["Address"].ToString() == "") { return new EditResult() { Result = "F", Description = "详细地址不能为空" } } ; Principal = JInfo["Principal"].ToString(); Phone = JInfo["Phone"].ToString(); Address = JInfo["Address"].ToString(); #endregion //判断登录信息是否正确 Hi.Model.SYS_Users one = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(Int32.Parse(UserID), out one, 0, Int32.Parse(disID == "" ? "0" : disID))) { return(new EditResult() { Result = "F", Description = "登录信息异常" }); } Hi.Model.BD_DisAddr disaddr = new Hi.Model.BD_DisAddr(); disaddr.DisID = Int32.Parse(disID); disaddr.Principal = Principal; disaddr.Phone = Phone; disaddr.Province = Province; disaddr.City = City; disaddr.Area = Area; disaddr.Address = Address; disaddr.IsDefault = IsDefault == "0" ? 0 : 1; disaddr.CreateUserID = one.ID; disaddr.CreateDate = DateTime.Now; disaddr.ts = DateTime.Now; disaddr.dr = 0; disaddr.modifyuser = one.ID; List <Hi.Model.BD_DisAddr> list_addr = null; if (IsDefault != "0") { list_addr = new Hi.BLL.BD_DisAddr().GetList("", "DisID=" + disID + " and isnull(IsDefault,0) =1 and isnull(dr,0) = 0", ""); } SqlConnection conn = new SqlConnection(SqlHelper.LocalSqlServer); conn.Open(); SqlTransaction mytran = conn.BeginTransaction(); try { if (new Hi.BLL.BD_DisAddr().Add(disaddr, mytran) <= 0) { mytran.Rollback(); return(new EditResult() { Result = "F", Description = "新增失败" }); } if (list_addr != null && list_addr.Count > 0) { foreach (Hi.Model.BD_DisAddr addr in list_addr) { addr.IsDefault = 0; if (!new Hi.BLL.BD_DisAddr().Update(addr, mytran)) { mytran.Rollback(); return(new EditResult() { Result = "F", Description = "新增失败" }); } } } } catch (Exception ex) { mytran.Rollback(); conn.Close(); Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "AddResellerShippingAddressList:" + JSon); return(new EditResult() { Result = "F", Description = "新增失败" }); } mytran.Commit(); return(new EditResult() { Result = "T", Description = "新增成功" }); } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "AddResellerShippingAddressList:" + JSon); return(new EditResult() { Result = "F", Description = "新增失败" }); } }
public ResultAddrAdd ResellerAddrAdd(string JSon) { try { #region JSon取值 string userID = string.Empty; string disID = string.Empty; string phoneCodeID = string.Empty; string MessageCode = string.Empty; string Principal = string.Empty; string Phone = string.Empty; string Province = string.Empty; string City = string.Empty; string Area = string.Empty; string Address = string.Empty; JsonData JInfo = JsonMapper.ToObject(JSon); if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["ResellerID"].ToString() != "" && JInfo["ChangePasswordID"].ToString() != "" && JInfo["MessageCode"].ToString() != "" && JInfo["Phone"].ToString() != "" && JInfo["Principal"].ToString() != "" && JInfo["Province"].ToString() != "" && JInfo["City"].ToString() != "" && JInfo["Area"].ToString() != "" && JInfo["Address"].ToString() != "") { userID = JInfo["UserID"].ToString(); disID = JInfo["ResellerID"].ToString(); phoneCodeID = JInfo["ChangePasswordID"].ToString(); MessageCode = JInfo["MessageCode"].ToString(); Phone = JInfo["Phone"].ToString(); Principal = JInfo["Principal"].ToString(); Province = JInfo["Province"].ToString(); City = JInfo["City"].ToString(); Area = JInfo["Area"].ToString(); Address = JInfo["Address"].ToString(); } else { return(new ResultAddrAdd() { Result = "F", Description = "参数异常" }); } Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if (!new Common().IsLegitUser(int.Parse(userID), out user, 0, int.Parse(disID == "" ? "0" : disID))) { return new ResultAddrAdd() { Result = "F", Description = "登录信息异常" } } ; #endregion Hi.Model.SYS_PhoneCode code = new Hi.BLL.SYS_PhoneCode().GetModel(int.Parse(phoneCodeID)); if (code != null) { if (code.ts.AddMinutes(30) < DateTime.Now || code.IsPast == 1) { return new ResultAddrAdd() { Result = "F", Description = "验证码过期" } } ; if (code.UserID.ToString() != userID) { return new ResultAddrAdd() { Result = "F", Description = "非本人操作" } } ; if (code.PhoneCode != MessageCode) { return new ResultAddrAdd() { Result = "F", Description = "验证码错误" } } ; } else { return(new ResultAddrAdd() { Result = "F", Description = "验证码异常" }); } List <Hi.Model.BD_DisAddr> addrList = new Hi.BLL.BD_DisAddr().GetList("", "disid='" + disID + "' and ", ""); if (addrList != null) { if (addrList.Count >= 10) { return new ResultAddrAdd() { Result = "F", Description = "一个经销商收货地址最多为10个" } } ; if (addrList.Select(p => p.Address).Contains(Province + City + Area + Address)) { return new ResultAddrAdd() { Result = "F", Description = "经销商收货地址已经存在" } } ; } Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr() { IsDefault = 0, Principal = Principal, Phone = Phone, Province = Province, City = City, Area = Area, Address = Province + City + Area + Address, CreateDate = DateTime.Now, CreateUserID = Convert.ToInt32(userID), modifyuser = Convert.ToInt32(userID), dr = 0 }; int count = new Hi.BLL.BD_DisAddr().Add(addr); if (count > 0) { return new ResultAddrAdd() { Result = "T", Description = "新增成功", AddrID = count } } ; else { return(new ResultAddrAdd() { Result = "F", Description = "新增失败" }); } } catch (Exception ex) { Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "ResellerAddrAdd :" + JSon); return(new ResultAddrAdd { Result = "F", Description = "异常" }); } }
/// <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 = "新增失败" }); } }
/// <summary> /// 同步代理商基本档案方法 /// </summary> public void DisTransfer(XmlDocument Doc, string Method) { Regex rgx = null; try { int SumDisAdd = 0; int SumDisTB = 0; int SumTypeAdd = 0; int SumTypeTB = 0; int SumAddressAdd = 0; int SumAddressTB = 0; DataTable dt = null; int Disid = 0; TranSaction = DBUtility.SqlHelper.CreateStoreTranSaction(); if (Method == "InsertCusClass") { #region 代理商分类新增/同步方法 XmlElement elment = Doc.DocumentElement; XmlNodeList nodeList = Doc.DocumentElement.SelectNodes("bill"); foreach (XmlNode nodel in nodeList) { XmlNode nodel1 = nodel.SelectSingleNode("header"); string TypeCode = nodel1.SelectSingleNode("customerclasscode").InnerText.Trim(); string ParentCode = nodel1.SelectSingleNode("customerclassprecode").InnerText.Trim(); string TypeName = nodel1.SelectSingleNode("customerclassname").InnerText.Trim(); Hi.Model.BD_DisType type = null; dt = ImportDisProD.GetDataSource("*", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction); if (dt.Rows.Count > 0) { if (string.IsNullOrWhiteSpace(TypeName)) { CreateReturnXML(TypeCode, false, "分类(同步):分类名称为空"); SetErrorTb("分类(同步)", "分类名称为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(TypeCode)) { CreateReturnXML(TypeCode, false, "分类(同步):分类编码为空"); SetErrorTb("分类(同步)", "分类编码为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if ((FindTb = ImportDisProD.GetDataSource("1 name", "BD_DisType", " and isnull(dr,0)=0 and TypeName='" + TypeName + "' and Typecode<>'" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { CreateReturnXML(TypeCode, false, "分类(同步):分类名称已存在"); SetErrorTb("分类(同步)", "分类名称已存在【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } type = Common.GetEntity <Hi.Model.BD_DisType>(dt); type.TypeName = TypeName; if (new Hi.BLL.BD_DisType().Update(type, TranSaction)) { CreateReturnXML(TypeCode, true); SumTypeTB++; } } else { if (string.IsNullOrWhiteSpace(TypeName)) { CreateReturnXML(TypeCode, false, "分类(新增):分类名称为空"); SetErrorTb("分类(新增)", "分类名称为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(TypeCode)) { CreateReturnXML(TypeCode, false, "分类(新增):分类编码为空"); SetErrorTb("分类(新增)", "分类编码为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "BD_DisType", " and isnull(dr,0)=0 and (TypeName='" + TypeName + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { CreateReturnXML(TypeCode, false, "分类(新增):分类名称或编码已存在"); SetErrorTb("分类(新增)", "分类名称或编码已存在【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } if (!string.IsNullOrWhiteSpace(ParentCode)) { FindTb = ImportDisProD.GetDataSource(" ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + ParentCode + "' and CompID=" + CompID + "", "", TranSaction); if (FindTb.Rows.Count > 0) { type = new Hi.Model.BD_DisType(); type.CreateDate = DateTime.Now; type.CreateUserID = UserID; type.IsEnabled = 1; type.modifyuser = UserID; type.TypeName = TypeName; type.TypeCode = TypeCode; type.ts = DateTime.Now; type.CompID = CompID; type.ParentId = FindTb.Rows[0]["ID"].ToString().ToInt(0); if (new Hi.BLL.BD_DisType().Add(type, TranSaction) > 0) { CreateReturnXML(TypeCode, true); SumTypeAdd++; } } else { CreateReturnXML(TypeCode, false, "分类(新增):查找不到父分类"); SetErrorTb("分类(新增)", "查找不到父分类,【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); } } else { type = new Hi.Model.BD_DisType(); type.CreateDate = DateTime.Now; type.CreateUserID = UserID; type.IsEnabled = 1; type.CompID = CompID; type.modifyuser = UserID; type.TypeName = TypeName; type.TypeCode = TypeCode; type.ts = DateTime.Now; type.ParentId = 0; if (new Hi.BLL.BD_DisType().Add(type, TranSaction) > 0) { CreateReturnXML(TypeCode, true); SumTypeAdd++; } } } } #endregion } else if (Method == "InsertDisArea") { #region 代理商地址新增/同步 XmlElement elment = Doc.DocumentElement; rgx = new Regex(@"^0?1[0-9]{10}$"); XmlNodeList nodeList1 = Doc.DocumentElement.SelectNodes("bill"); foreach (XmlNode nodel2 in nodeList1) { XmlNode nodel3 = nodel2.SelectSingleNode("header"); string addcode = nodel3.SelectSingleNode("addresscode").InnerText.Trim(); string DisCode = nodel3.SelectSingleNode("customercode").InnerText.Trim(); string Principal = nodel3.SelectSingleNode("linkperson").InnerText.Trim(); string Address = nodel3.SelectSingleNode("address").InnerText.Trim(); string Phone = nodel3.SelectSingleNode("handphone").InnerText.Trim(); string Tel = nodel3.SelectSingleNode("phone").InnerText.Trim(); int isdefault = nodel3.SelectSingleNode("default").InnerText.Trim().ToInt(0); if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_Distributor", " and isnull(dr,0)=0 and DisCode='" + DisCode + "' and CompID=" + CompID + " ", "", TranSaction)).Rows.Count == 0) { CreateReturnXML(addcode, false, "代理商地址:查找不到代理商,代理商编码:" + DisCode + ""); SetErrorTb("代理商地址", "查找不到代理商【地址:" + Address + ",地址编码:" + addcode + ",代理商编码:" + DisCode + "】"); continue; } Disid = FindTb.Rows[0]["ID"].ToString().ToInt(0); dt = ImportDisProD.GetDataSource("*", "BD_DisAddr", " and isnull(dr,0)=0 and Code='" + addcode + "' and Disid=" + Disid + "", "", TranSaction); if (dt.Rows.Count > 0) { if (string.IsNullOrWhiteSpace(addcode)) { CreateReturnXML(addcode, false, "代理商地址(同步):地址编码为空"); SetErrorTb("代理商地址(同步)", "地址编码为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (string.IsNullOrWhiteSpace(Principal)) { //CreateReturnXML(addcode, false, "代理商地址(同步):联系人为空"); //SetErrorTb("代理商地址(同步)", "联系人为空【地址:" + Address + ",地址编码:" + addcode + "】"); //continue; Principal = ""; } else if (string.IsNullOrWhiteSpace(Address)) { CreateReturnXML(addcode, false, "代理商地址(同步):地址为空"); SetErrorTb("代理商地址(同步)", "地址为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { //CreateReturnXML(addcode, false, "代理商地址(同步):手机格式不正确"); //SetErrorTb("代理商地址(同步)", "手机格式不正确【地址:" + Address + ",地址编码:" + addcode + "】"); //continue; Phone = ""; } Hi.Model.BD_DisAddr addr = Common.GetEntity <Hi.Model.BD_DisAddr>(dt); addr.Address = addr.Province + addr.City + addr.Area + Address; addr.Principal = Principal; addr.Phone = Phone; addr.Tel = Tel; addr.IsDefault = isdefault; if (new Hi.BLL.BD_DisAddr().Update(addr, TranSaction)) { CreateReturnXML(addcode, true); SumAddressTB++; } } else { if (string.IsNullOrWhiteSpace(addcode)) { CreateReturnXML(addcode, false, "代理商地址(同步):地址编码为空"); SetErrorTb("代理商地址(新增)", "地址编码为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (string.IsNullOrWhiteSpace(Principal)) { //CreateReturnXML(addcode, false, "代理商地址(同步):联系人为空"); //SetErrorTb("代理商地址(新增)", "联系人为空【地址:" + Address + ",地址编码:" + addcode + "】"); //continue; Principal = ""; } else if (string.IsNullOrWhiteSpace(Address)) { CreateReturnXML(addcode, false, "代理商地址(同步):地址为空"); SetErrorTb("代理商地址(新增)", "地址为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { //CreateReturnXML(addcode, false, "代理商地址(同步):手机格式不正确"); //SetErrorTb("代理商地址(新增)", "手机格式不正确【地址:" + Address + ",地址编码:" + addcode + "】"); //continue; Phone = ""; } else if ((ImportDisProD.GetDataSource("1 name", "BD_DisAddr", " and isnull(dr,0)=0 and (Code='" + addcode + "') and Disid=" + Disid + "", "", TranSaction)).Rows.Count > 0) { CreateReturnXML(addcode, false, "代理商地址(同步):地址编码已存在"); SetErrorTb("代理商地址(新增)", "地址编码已存在【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr(); addr.DisID = Disid; addr.Province = "上海市"; addr.City = "市辖区"; addr.Area = "徐汇区"; addr.Code = addcode; addr.Address = addr.Province + addr.City + addr.Area + Address; addr.Phone = Phone; addr.Principal = Principal; addr.Tel = Tel; addr.IsDefault = isdefault; addr.CreateDate = DateTime.Now; addr.CreateUserID = UserID; addr.ts = DateTime.Now; addr.modifyuser = UserID; if (new Hi.BLL.BD_DisAddr().Add(addr, TranSaction) > 0) { CreateReturnXML(addcode, true); SumAddressAdd++; } } } #endregion } else if (Method == "InsertCus") { #region 代理商新增/同步 XmlElement elment = Doc.DocumentElement; XmlNodeList nodeList = Doc.DocumentElement.SelectNodes("bill"); foreach (XmlNode nodel in nodeList) { XmlNode nodel1 = nodel.SelectSingleNode("header"); string DisCode = nodel1.SelectSingleNode("customercode").InnerText.Trim(); string DisName = nodel1.SelectSingleNode("customername").InnerText.Trim(); string TypeCode = IsSelectNode(nodel1, "customerclasscode") ? nodel1.SelectSingleNode("customerclasscode").InnerText.Trim() : ""; string Address = IsSelectNode(nodel1, "address") ? nodel1.SelectSingleNode("address").InnerText.Trim() : ""; string Principal = IsSelectNode(nodel1, "person") ? nodel1.SelectSingleNode("person").InnerText.Trim() : ""; string Phone = IsSelectNode(nodel1, "handphone") ? nodel1.SelectSingleNode("handphone").InnerText.Trim() : ""; string Leading = IsSelectNode(nodel1, "lperson") ? nodel1.SelectSingleNode("lperson").InnerText.Trim() : ""; string Tel = IsSelectNode(nodel1, "phone") ? nodel1.SelectSingleNode("phone").InnerText.Trim() : ""; string Zip = IsSelectNode(nodel1, "postcode") ? nodel1.SelectSingleNode("postcode").InnerText.Trim() : ""; string Fax = IsSelectNode(nodel1, "fax") ? nodel1.SelectSingleNode("fax").InnerText.Trim() : ""; dt = ImportDisProD.GetDataSource("*", "BD_Distributor", " and isnull(dr,0)=0 and DisCode='" + DisCode + "' and CompID=" + CompID + " and AuditState=2", "", TranSaction); if (dt.Rows.Count > 0) { rgx = new Regex(@"^0?1[0-9]{10}$"); if (string.IsNullOrWhiteSpace(DisName)) { CreateReturnXML(TypeCode, false, "代理商(同步):代理商名称为空"); SetErrorTb("代理商(同步)", "代理商名称为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(DisCode)) { CreateReturnXML(TypeCode, false, "代理商(同步):代理商编码为空"); SetErrorTb("代理商(同步)", "代理商编码为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { //CreateReturnXML(TypeCode, false, "代理商(同步):手机号码格式错误"); //SetErrorTb("代理商(同步)", "手机号码格式错误【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); //continue; Phone = ""; } else if ((ImportDisProD.GetDataSource("1 name", "BD_Distributor", " and isnull(dr,0)=0 and (DisName='" + DisName + "' and DisCode<>'" + DisCode + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { CreateReturnXML(TypeCode, false, "代理商(同步):代理商名称已存在"); SetErrorTb("代理商(同步)", "代理商名称已存在【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } Hi.Model.BD_Distributor Dis = Common.GetEntity <Hi.Model.BD_Distributor>(dt); Dis.DisName = DisName; if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { Dis.DisTypeID = FindTb.Rows[0]["ID"].ToString().ToInt(0); } Dis.Address = Address; Dis.Principal = Principal; Dis.Leading = Leading; Dis.Phone = Phone; Dis.LeadingPhone = Phone; Dis.Tel = Tel; Dis.Zip = Zip; Dis.Fax = Fax; if (new Hi.BLL.BD_Distributor().Update(Dis, TranSaction)) { CreateReturnXML(TypeCode, true); SumDisTB++; } } else { rgx = new Regex(@"^0?1[0-9]{10}$"); if (string.IsNullOrWhiteSpace(DisName)) { CreateReturnXML(TypeCode, false, "代理商(新增):代理商名称为空"); SetErrorTb("代理商(新增)", "代理商名称为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(DisCode)) { CreateReturnXML(TypeCode, false, "代理商(新增):代理商编码为空"); SetErrorTb("代理商(新增)", "代理商编码为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { //CreateReturnXML(TypeCode, false, "代理商(新增):手机号码格式错误"); //SetErrorTb("代理商(新增)", "手机号码格式错误【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); //continue; Phone = ""; } else if ((ImportDisProD.GetDataSource("1 name", "SYS_Users", " and isnull(dr,0)=0 and (Phone='" + Phone + "' and isnull(Phone,'')<>'')", "", TranSaction)).Rows.Count > 0) { CreateReturnXML(TypeCode, false, "代理商(新增):代理商手机号码已存在"); SetErrorTb("代理商(新增)", "代理商手机号码已存在【代理商名称:" + DisName + ",代理商编码:" + DisCode + ",手机号码:" + Phone + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "BD_Distributor", " and isnull(dr,0)=0 and (DisName='" + DisName + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { CreateReturnXML(TypeCode, false, "代理商(新增):代理商名称/编码已存在"); SetErrorTb("代理商(新增)", "代理商名称/编码已存在【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor(); Dis.DisName = DisName; Dis.DisCode = DisCode; if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { Dis.DisTypeID = FindTb.Rows[0]["ID"].ToString().ToInt(0); } Dis.Address = Address; Dis.Province = "上海市"; Dis.City = "市辖区"; Dis.Area = "徐汇区"; Dis.Principal = Principal; Dis.Leading = Leading; Dis.Phone = Phone; Dis.LeadingPhone = Phone; Dis.Tel = Tel; Dis.Zip = Zip; Dis.Fax = Fax; Dis.SMID = 0; Dis.IsCheck = 0; Dis.CreditType = 0; Dis.AuditState = 2; Dis.AuditUser = UserID.ToString(); Dis.CompID = CompID; Dis.AuditDate = DateTime.Now; Dis.CreateDate = DateTime.Now; Dis.CreateUserID = UserID; Dis.ts = DateTime.Now; Dis.modifyuser = UserID; Dis.IsEnabled = 1; Dis.Paypwd = Util.md5("123456"); Dis.Remark = ""; Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if ((Disid = new Hi.BLL.BD_Distributor().Add(Dis, TranSaction)) > 0) { CreateReturnXML(TypeCode, true); user.UserName = Enum.GetName(typeof(Enums.Erptype), Erptype) + DisCode; user.UserPwd = Util.md5("123456"); user.IsEnabled = 1; user.AuditState = 2; user.IsFirst = 0; user.Type = 5; user.CompID = CompID; user.DisID = Disid; user.AddType = 0; user.Phone = Phone; user.TrueName = Principal; user.Tel = Tel; user.RoleID = 0; user.CreateDate = DateTime.Now; user.CreateUserID = UserID; user.ts = DateTime.Now; user.modifyuser = UserID; if (new Hi.BLL.SYS_Users().Add(user, TranSaction) > 0) { SumDisAdd++; } } } } #endregion } else { ReturnBill = ""; ErrTb.Rows.Clear(); CreateReturnXML("", false, "导入类型异常"); SetErrorTb("", "导入类型异常"); return; } TranSaction.Commit(); LogManager.WriteLog2(LogFile.Trace.ToString(), "新增(代理商:" + SumDisAdd + "条;类别:" + SumTypeAdd + "条;地址:" + SumAddressAdd + "条),同步(代理商:" + SumDisTB + "条;类别:" + SumTypeTB + "条;地址:" + SumAddressTB + "条)"); } catch (Exception ex) { ReturnBill = ""; ErrTb.Rows.Clear(); if (ex is XmlException) { CreateReturnXML("", false, "读取XML出现错误"); SetErrorTb("", "读取XML出现错误"); } else if (ex is XPathException) { CreateReturnXML("", false, "格式错误"); SetErrorTb("", "XML格式错误"); } else { CreateReturnXML("", false, ex.Message); SetErrorTb("", "同步失败:" + ex.Message + ""); } if (TranSaction != null) { if (TranSaction.Connection != null) { TranSaction.Rollback(); } } } finally { if (TranSaction != null) { if (TranSaction.Connection != null) { TranSaction.Rollback(); } } TableWriteLog(); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.BD_DisAddr model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.BD_DisAddr model) { return(dal.Add(model)); }
protected void btnDisTransfer_Click(object sender, EventArgs e) { SqlTransaction TranSaction = null; Regex rgx = null; string ShowStr = "<i style='color:red;'>{0}</i>"; try { int SumDisAdd = 0; int SumDisTB = 0; int SumTypeAdd = 0; int SumTypeTB = 0; int SumAddressAdd = 0; int SumAddressTB = 0; #region 代理商分类新增/同步方法 XmlDocument Xdoc = null;//ImportDisProD.GetServiceXmlStr(Enum.GetName(typeof(Enums.Erptype), Erptype), "GetCusClass", "获取代理商分类"); TranSaction = DBUtility.SqlHelper.CreateStoreTranSaction(); XmlElement elment = Xdoc.DocumentElement; if (elment.GetAttribute("result") == "True") { XmlNodeList nodeList = Xdoc.DocumentElement.SelectNodes("bill"); foreach (XmlNode nodel in nodeList) { XmlNode nodel1 = nodel.SelectSingleNode("header"); string TypeCode = nodel1.SelectSingleNode("customerclasscode").InnerText.Trim(); string ParentCode = nodel1.SelectSingleNode("customerclassprecode").InnerText.Trim(); string TypeName = nodel1.SelectSingleNode("customerclassprecode").InnerText.Trim(); Hi.Model.BD_DisType type = null; DataTable dt = ImportDisProD.GetDataSource("*", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction); if (dt.Rows.Count > 0) { if (string.IsNullOrWhiteSpace(TypeName)) { SetErrorTb("分类(同步)", "分类名称为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(TypeCode)) { SetErrorTb("分类(同步)", "分类编码为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if ((FindTb = ImportDisProD.GetDataSource("1 name", "BD_DisType", " and isnull(dr,0)=0 and TypeName='" + TypeName + "' and Typecode<>'" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { SetErrorTb("分类(同步)", "分类名称已存在【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } type = Common.GetEntity <Hi.Model.BD_DisType>(dt); type.TypeName = TypeName; if (new Hi.BLL.BD_DisType().Update(type, TranSaction)) { SumTypeTB++; } } else { if (string.IsNullOrWhiteSpace(TypeName)) { SetErrorTb("分类(新增)", "分类名称为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(TypeCode)) { SetErrorTb("分类(新增)", "分类编码为空【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "BD_DisType", " and isnull(dr,0)=0 and (TypeName='" + TypeName + "' or Typecode='" + TypeCode + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { SetErrorTb("分类(新增)", "分类名称或编码已存在【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); continue; } if (!string.IsNullOrWhiteSpace(ParentCode)) { FindTb = ImportDisProD.GetDataSource(" ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + ParentCode + "' and CompID=" + CompID + "", "", TranSaction); if (FindTb.Rows.Count > 0) { type = new Hi.Model.BD_DisType(); type.CreateDate = DateTime.Now; type.CreateUserID = UserID; type.IsEnabled = 1; type.modifyuser = UserID; type.TypeName = TypeName; type.TypeCode = TypeCode; type.ts = DateTime.Now; type.CompID = CompID; type.ParentId = FindTb.Rows[0]["ID"].ToString().ToInt(0); if (new Hi.BLL.BD_DisType().Add(type) > 0) { SumTypeAdd++; } } else { SetErrorTb("分类(新增)", "查找不到父分类,【分类名称:" + TypeName + ",分类编码:" + TypeCode + "】"); } } else { type = new Hi.Model.BD_DisType(); type.CreateDate = DateTime.Now; type.CreateUserID = UserID; type.IsEnabled = 1; type.CompID = CompID; type.modifyuser = UserID; type.TypeName = TypeName; type.TypeCode = TypeCode; type.ts = DateTime.Now; type.ParentId = 0; if (new Hi.BLL.BD_DisType().Add(type) > 0) { SumTypeAdd++; } } } } } else { throw new ApplicationException("获取分类错误:" + elment.GetAttribute("err")); } #endregion #region 代理商(地址)新增/同步方法 #region 代理商新增/同步 Xdoc = null;//ImportDisProD.GetServiceXmlStr(Enum.GetName(typeof(Enums.Erptype), Erptype), "GetCus", "获取代理商档案"); elment = Xdoc.DocumentElement; if (elment.GetAttribute("result") == "True") { XmlNodeList nodeList = Xdoc.DocumentElement.SelectNodes("bill"); foreach (XmlNode nodel in nodeList) { XmlNode nodel1 = nodel.SelectSingleNode("header"); string DisCode = nodel1.SelectSingleNode("customercode").InnerText.Trim(); string DisName = nodel1.SelectSingleNode("customername").InnerText.Trim(); string TypeCode = nodel1.SelectSingleNode("customerclasscode").InnerText.Trim(); string Address = nodel1.SelectSingleNode("address").InnerText.Trim(); string Principal = nodel1.SelectSingleNode("person").InnerText.Trim(); string Phone = nodel1.SelectSingleNode("handphone").InnerText.Trim(); string Leading = nodel1.SelectSingleNode("lperson").InnerText.Trim(); string Tel = nodel1.SelectSingleNode("phone").InnerText.Trim(); string Zip = nodel1.SelectSingleNode("postcode").InnerText.Trim(); string Fax = nodel1.SelectSingleNode("fax").InnerText.Trim(); int Disid = 0; DataTable dt = ImportDisProD.GetDataSource("*", "BD_Distributor", " and isnull(dr,0)=0 and DisCode='" + DisCode + "' and CompID=" + CompID + " and AuditState=2", "", TranSaction); if (dt.Rows.Count > 0) { rgx = new Regex(@"^0?1[0-9]{10}$"); if (string.IsNullOrWhiteSpace(DisName)) { SetErrorTb("代理商(同步)", "代理商名称为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(DisCode)) { SetErrorTb("代理商(同步)", "代理商编码为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { SetErrorTb("代理商(同步)", "手机号码格式错误【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "BD_Distributor", " and isnull(dr,0)=0 and (DisName='" + DisName + "' and DisCode<>'" + DisCode + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { SetErrorTb("代理商(同步)", "代理商名称已存在【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } Hi.Model.BD_Distributor Dis = Common.GetEntity <Hi.Model.BD_Distributor>(dt); Disid = Dis.ID; Dis.DisName = DisName; if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { Dis.DisTypeID = FindTb.Rows[0]["ID"].ToString().ToInt(0); } Dis.Address = Address; Dis.Principal = Principal; Dis.Leading = Leading; Dis.Phone = Phone; Dis.LeadingPhone = Phone; Dis.Tel = Tel; Dis.Zip = Zip; Dis.Fax = Fax; if (new Hi.BLL.BD_Distributor().Update(Dis, TranSaction)) { SumDisTB++; } } else { rgx = new Regex(@"^0?1[0-9]{10}$"); if (string.IsNullOrWhiteSpace(DisName)) { SetErrorTb("代理商(新增)", "代理商名称为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (string.IsNullOrWhiteSpace(DisCode)) { SetErrorTb("代理商(新增)", "代理商编码为空【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { SetErrorTb("代理商(新增)", "手机号码格式错误【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "SYS_Users", " and isnull(dr,0)=0 and (Phone='" + Phone + "')", "", TranSaction)).Rows.Count > 0) { SetErrorTb("代理商(新增)", "代理商手机号码已存在【代理商名称:" + DisName + ",代理商编码:" + DisCode + ",手机号码:" + Phone + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "BD_Distributor", " and isnull(dr,0)=0 and (DisName='" + DisName + "' or DisCode='" + DisCode + "') and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { SetErrorTb("代理商(新增)", "代理商名称/编码已存在【代理商名称:" + DisName + ",代理商编码:" + DisCode + "】"); continue; } Hi.Model.BD_Distributor Dis = new Hi.Model.BD_Distributor(); Dis.DisName = DisName; Dis.DisCode = DisCode; if ((FindTb = ImportDisProD.GetDataSource("ID", "BD_DisType", " and isnull(dr,0)=0 and TypeCode='" + TypeCode + "' and CompID=" + CompID + "", "", TranSaction)).Rows.Count > 0) { Dis.DisTypeID = FindTb.Rows[0]["ID"].ToString().ToInt(0); } Dis.Address = Address; Dis.Province = "上海市"; Dis.City = "市辖区"; Dis.Area = "徐汇区"; Dis.Principal = Principal; Dis.Leading = Leading; Dis.Phone = Phone; Dis.LeadingPhone = Phone; Dis.Tel = Tel; Dis.Zip = Zip; Dis.Fax = Fax; Dis.SMID = 0; Dis.IsCheck = 0; Dis.CreditType = 0; Dis.AuditState = 2; Dis.AuditUser = UserID.ToString(); Dis.CompID = CompID; Dis.AuditDate = DateTime.Now; Dis.CreateDate = DateTime.Now; Dis.CreateUserID = UserID; Dis.ts = DateTime.Now; Dis.modifyuser = UserID; Dis.IsEnabled = 1; Dis.Paypwd = Util.md5("123456"); Dis.Remark = ""; Hi.Model.SYS_Users user = new Hi.Model.SYS_Users(); if ((Disid = new Hi.BLL.BD_Distributor().Add(Dis, TranSaction)) > 0) { user.UserName = Enum.GetName(typeof(Enums.Erptype), Erptype) + DisCode; user.UserPwd = Util.md5("123456"); user.IsEnabled = 1; user.IsFirst = 0; user.Type = 5; user.CompID = CompID; user.DisID = Disid; user.AddType = 0; user.Phone = Phone; user.TrueName = Principal; user.Tel = Tel; user.RoleID = 0; user.CreateDate = DateTime.Now; user.CreateUserID = UserID; user.ts = DateTime.Now; user.modifyuser = UserID; if (new Hi.BLL.SYS_Users().Add(user, TranSaction) > 0) { SumDisAdd++; } } } #endregion #region 代理商地址新增/同步 string XMLbody = "<bill><header><customercode>" + DisCode + "</customercode></header></bill>"; XmlDocument Doc1 = null;//ImportDisProD.GetServiceXmlStr(Enum.GetName(typeof(Enums.Erptype), Erptype), "GetCusAddress", "获取代理商收货地址", XMLbody); elment = Xdoc.DocumentElement; if (elment.GetAttribute("result") == "True") { rgx = new Regex(@"^0?1[0-9]{10}$"); XmlNodeList nodeList1 = Xdoc.DocumentElement.SelectNodes("bill"); foreach (XmlNode nodel2 in nodeList1) { XmlNode nodel3 = nodel2.SelectSingleNode("header"); string addcode = nodel3.SelectSingleNode("addresscode").InnerText.Trim(); Principal = nodel3.SelectSingleNode("linkperson").InnerText.Trim(); Address = nodel3.SelectSingleNode("address").InnerText.Trim(); Phone = nodel3.SelectSingleNode("handphone").InnerText.Trim(); Tel = nodel3.SelectSingleNode("phone").InnerText.Trim(); int isdefault = nodel3.SelectSingleNode("default").InnerText.Trim().ToInt(0); dt = ImportDisProD.GetDataSource("*", "BD_DisAddr", " and isnull(dr,0)=0 and Code='" + addcode + "' and Disid=" + Disid + "", "", TranSaction); if (dt.Rows.Count > 0) { if (string.IsNullOrWhiteSpace(addcode)) { SetErrorTb("代理商地址(同步)", "地址编码为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (string.IsNullOrWhiteSpace(Principal)) { SetErrorTb("代理商地址(同步)", "联系人为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (string.IsNullOrWhiteSpace(Address)) { SetErrorTb("代理商地址(同步)", "地址为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { SetErrorTb("代理商地址(同步)", "手机格式不正确【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } Hi.Model.BD_DisAddr addr = Common.GetEntity <Hi.Model.BD_DisAddr>(dt); addr.Address = Address; addr.Principal = Principal; addr.Phone = Phone; addr.Tel = Tel; addr.IsDefault = isdefault; if (new Hi.BLL.BD_DisAddr().Update(addr, TranSaction)) { SumAddressTB++; } } else { if (string.IsNullOrWhiteSpace(addcode)) { SetErrorTb("代理商地址(新增)", "地址编码为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (string.IsNullOrWhiteSpace(Principal)) { SetErrorTb("代理商地址(新增)", "联系人为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (string.IsNullOrWhiteSpace(Address)) { SetErrorTb("代理商地址(新增)", "地址为空【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if (!rgx.IsMatch(Phone)) { SetErrorTb("代理商地址(新增)", "手机格式不正确【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } else if ((ImportDisProD.GetDataSource("1 name", "BD_DisAddr", " and isnull(dr,0)=0 and (Code='" + addcode + "') and Disid=" + Disid + "", "", TranSaction)).Rows.Count > 0) { SetErrorTb("代理商地址(新增)", "地址编码已存在【地址:" + Address + ",地址编码:" + addcode + "】"); continue; } Hi.Model.BD_DisAddr addr = new Hi.Model.BD_DisAddr(); addr.DisID = Disid; addr.Province = "上海市"; addr.City = "市辖区"; addr.Area = "徐汇区"; addr.Code = addcode; addr.Address = Address; addr.Phone = Phone; addr.Principal = Principal; addr.Tel = Tel; addr.IsDefault = isdefault; addr.CreateDate = DateTime.Now; addr.CreateUserID = UserID; addr.ts = DateTime.Now; addr.modifyuser = UserID; if (new Hi.BLL.BD_DisAddr().Add(addr) > 0) { SumAddressAdd++; } } } } #endregion } } #endregion TranSaction.Commit(); lblDisIpResult.InnerHtml = "新增(代理商:" + string.Format(ShowStr, SumDisAdd) + "条;类别:" + string.Format(ShowStr, SumTypeAdd) + "条;地址:" + string.Format(ShowStr, SumAddressAdd) + "条),同步(代理商:" + string.Format(ShowStr, SumDisTB) + "条;类别:" + string.Format(ShowStr, SumTypeTB) + "条;地址:" + string.Format(ShowStr, SumAddressTB) + "条)"; if (ErrTb.Rows.Count > 0) { HERCount.InnerText = ErrTb.Rows.Count.ToString(); DivError.Visible = true; Rpt_Error.DataSource = ErrTb; Rpt_Error.DataBind(); } } catch (Exception ex) { if (ex is XmlException) { lblDisIpResult.InnerHtml = string.Format(ShowStr, "读取XML出现错误"); } else if (ex is XPathException) { lblDisIpResult.InnerHtml = string.Format(ShowStr, "XML格式错误"); } else { lblDisIpResult.InnerHtml = string.Format(ShowStr, "同步失败:" + ex.Message + ""); } if (TranSaction != null) { if (TranSaction.Connection != null) { TranSaction.Rollback(); } } } }