Beispiel #1
0
    /// <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'}");
        }
    }
Beispiel #2
0
    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);
                }
            }
        }
    }
Beispiel #3
0
    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 = "新增失败"
            });
        }
    }
Beispiel #4
0
    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 = "异常"
            });
        }
    }
Beispiel #5
0
    /// <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 = "新增失败"
            });
        }
    }
Beispiel #6
0
    /// <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();
        }
    }
Beispiel #7
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Hi.Model.BD_DisAddr model)
 {
     return(dal.Update(model));
 }
Beispiel #8
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(Hi.Model.BD_DisAddr model)
 {
     return(dal.Add(model));
 }
Beispiel #9
0
    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();
                }
            }
        }
    }