erp/SiteCore/Handler/sync.getbase.cs

using SQLData;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace SiteCore.Handler
{
    public partial class sync
    {
        public void get_sel_user()
        {
            string ocode = GetString("ocode");
            string pcode = GetString("pcode");
            int me = GetInt("me");
            string sql = "select id,(name+'('+postname+')') as name from view_ErpUser ";
            string whereStr = "";
            if (ocode.Length > 0) whereStr += " where orgcode='" + ocode + "'";
            else if (pcode.Length > 0) whereStr += " where postcode='" + pcode + "'";
            sql += whereStr;

            if (me == 0)
            {
                if (whereStr.Length > 0)
                {
                    sql += "and id<>" + CurrentUser.UserID;
                }
                else
                {
                    sql += "where id<>" + CurrentUser.UserID;
                }

            }
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_customer()
        {

            string sql = "select id, name+'('+tb+')' as name from view_ErpUser where PostCode='CustomerService' or PostCode='Director' or PostCode='CustomerMaster' or  PostCode='CustomerMr' or ID = '1479'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_after_sel_customer()
        {
            string sql = "select id, name+'('+tb+')'+ '(' +CASE isOpen WHEN 1 THEN '开通' ELSE '未开通' END + ')' as name from view_ErpUser where PostCode='CustomerService' or PostCode='Director' or PostCode='CustomerMaster' or  PostCode='CustomerMr' or ID = '1479'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_after_sel_designer()
        {
            string sql = "select id, name + '(' +CASE isOpen WHEN 1 THEN '开通' ELSE '未开通' END + ')' as name from view_ErpUser where PostCode='Designer' or PostCode='wxDesigner' or PostCode='DesignerMr' or PostCode='wxDesignerMr' or OrgID = '10' or PostCode='Designerhd'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_sel_designer()
        {
            string sql = "select id, name+'('+OrgName+')' as name from view_ErpUser where PostCode='Designer' or PostCode='wxDesigner' or PostCode='DesignerMr' or PostCode='wxDesignerMr' or OrgID = '10' or PostCode='Designerhd'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_pen_designer()
        {
            string penShopName = GetString("shop");
            if (penShopName == "")
            {
                penShopName = ",";
            }
            string cusCode = CurrentUser.UserPost.Post.Code;
            StringBuilder sqlbd = new StringBuilder();
            if (cusCode == "CustomerService" || cusCode == "Director" || cusCode == "CustomerMaster")
            {
                if ((cusCode == "Director" && CurrentUser.UserPost.OrgID == 31) || CurrentUser.UserPost.OrgID == 98)
                {
                    sqlbd.AppendFormat("select id, (name+'_'+");
                    sqlbd.AppendFormat("(select convert(varchar,count(ctid)) from view_erptradecell where designuserid=view_ErpUser.id and orderstate=4)");
                    sqlbd.AppendFormat("+ '/' + convert(varchar, OrderDesignLimit) + '__' +");
                    sqlbd.AppendFormat("(select isnull(convert(varchar, sum(payment)), '') from view_erptradecell where designuserid = view_ErpUser.id and orderstate<5)");
                    sqlbd.AppendFormat(") as bname,pemShop from view_ErpUser");
                    sqlbd.AppendFormat(" where (PostCode like '%Designer%' or PostCode like '%Place%' or PostCode='Director' or PostCode='SysAdmin' or PostCode='Summarize' or PostCode='CustomerMr')  and charindex((select ','+convert(varchar(10),ID)+',' from CE_ErpShop where ShopName='{0}'),','+pemShop+',')>0 and isOpen=1", penShopName);

                }
                else
                {
                    sqlbd.AppendFormat("select id, (name+'_'+");
                    sqlbd.AppendFormat("(select convert(varchar,count(ctid)) from view_erptradecell where designuserid=view_ErpUser.id and orderstate=4)");
                    sqlbd.AppendFormat("+ '/' + convert(varchar, OrderDesignLimit) + '__' +");
                    sqlbd.AppendFormat("(select isnull(convert(varchar, sum(payment)), '') from view_erptradecell where designuserid = view_ErpUser.id and orderstate<5)");
                    sqlbd.AppendFormat(") as bname,pemShop from view_ErpUser");
                    sqlbd.AppendFormat(" where (PostCode like '%wxDesigner%' or PostCode like '%Place%' or PostCode='Director' or ID={1} or PostCode='SysAdmin' or PostCode='Summarize' or PostCode='CustomerMr')  and charindex((select ','+convert(varchar(10),ID)+',' from CE_ErpShop where ShopName='{0}'),','+pemShop+',')>0  and isOpen=1", penShopName, CurrentUser.UserID);

                }

            }
            else if (cusCode == "Designerhd")
            {
                sqlbd.AppendFormat("select id, (name+'_'+");
                sqlbd.AppendFormat("(select convert(varchar,count(ctid)) from view_erptradecell where designuserid=view_ErpUser.id and orderstate=4)");
                sqlbd.AppendFormat("+ '/' + convert(varchar, OrderDesignLimit) + '__' +");
                sqlbd.AppendFormat("(select isnull(convert(varchar, sum(payment)), '') from view_erptradecell where designuserid = view_ErpUser.id and orderstate<5)");
                sqlbd.AppendFormat(") as bname,pemShop from view_ErpUser");
                sqlbd.AppendFormat(" where (PostCode like 'Designer%' or PostCode like 'wxDesigner%' or ID={0} or PostCode='SysAdmin'  ) and isOpen=1 ", CurrentUser.UserID);
            }
            else if (cusCode == "SysAdmin" || cusCode == "Summarize" || cusCode == "CustomerMr" || cusCode == "HumanResMr")
            {
                sqlbd.AppendFormat("select id, (name+'_'+");
                sqlbd.AppendFormat("(select convert(varchar,count(ctid)) from view_erptradecell where designuserid=view_ErpUser.id and orderstate=4)");
                sqlbd.AppendFormat("+ '/' + convert(varchar, OrderDesignLimit) + '__' +");
                sqlbd.AppendFormat("(select isnull(convert(varchar, sum(payment)), '') from view_erptradecell where designuserid = view_ErpUser.id and orderstate<5)");
                sqlbd.AppendFormat(") as bname,pemShop from view_ErpUser");
                sqlbd.AppendFormat(" where (PostCode like '%Designer%' or PostCode like 'Place%'or PostCode='Director' or PostCode='CustomerMaster' or ID={0} or PostCode='Summarize' or PostCode='CustomerMr' or PostCode='SysAdmin') and isOpen=1", CurrentUser.UserID);
            }
            else
            {
                sqlbd.AppendFormat("select id, (name+'_'+");
                sqlbd.AppendFormat("(select convert(varchar,count(ctid)) from view_erptradecell where designuserid=view_ErpUser.id and orderstate=4)");
                sqlbd.AppendFormat("+ '/' + convert(varchar, OrderDesignLimit) + '__' +");
                sqlbd.AppendFormat("(select isnull(convert(varchar, sum(payment)), '') from view_erptradecell where designuserid = view_ErpUser.id and orderstate<5)");
                sqlbd.AppendFormat(") as bname,pemShop from view_ErpUser");
                sqlbd.AppendFormat(" where (PostCode like '%Designer%' or PostCode like '%Place%'or PostCode like '%Director%' or ID={1} or PostCode='SysAdmin' or PostCode='Summarize' or PostCode='CustomerMr')  and charindex((select ','+convert(varchar(10),ID)+',' from CE_ErpShop where ShopName='{0}'),','+pemShop+',')>0 and isOpen=1", penShopName, CurrentUser.UserID);
            }
            if (cusCode != "SysAdmin" && cusCode != "Summarize" && CurrentUser.UserID != 73)
            {
                sqlbd.AppendFormat(" and ID <> 3542");
            }

            //string sql = "select id, (name+'_'+(select convert(varchar,count(ctid)) from view_erptradecell where designuserid=view_ErpUser.id and orderstate=4) + '_' + convert(varchar, OrderDesignLimit) + '_' + (select isnull(convert(varchar, sum(payment)), '') from view_erptradecell where designuserid = view_ErpUser.id and orderstate<5) ) as bname,pemShop from view_ErpUser where PostCode = 'Designer'  and charindex((select ',' + convert(varchar(10), ID) + ',' from CE_ErpShop where ShopName = '" + penShopName+"'),',' + pemShop + ',')> 0";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sqlbd.ToString()).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_sameorg_designer()
        {
            int orgid = CurrentUser.UserPost.OrgID;
            string posCode = CurrentUser.UserPost.Post.Code;
            string sql = "";
            if (posCode == "DesignerMr" || posCode == "Designerhd")
            {
                sql = "select id, name from view_ErpUser where (PostCode ='Designer' or PostCode like 'Designer%') and isOpen = '1'";
            }
            else
            {
                sql = "select id, name from view_ErpUser where (PostCode ='Designer' or PostCode ='wxDesigner' or PostCode='DesignerMr' or PostCode='wxDesignerMr') and isOpen = '1' and OrgID=" + orgid;
            }
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_sel_place()
        {
            string sql = "select id, name from view_ErpUser where PostCode='Place' or PostCode='PlaceMr' and isOpen=1";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_after_sel_place()
        {
            string sql = "select id, name + '(' +CASE isOpen WHEN 1 THEN '开通' ELSE '未开通' END + ')' as name from view_ErpUser where PostCode='Place' or PostCode='PlaceMr'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_sel_aftersale()
        {
            string sql = "select id, name from view_ErpUser where PostCode='AfterSale' or PostCode='AfterSaleMaster' and isOpen=1";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_after_sel_aftersale()
        {
            string sql = "select id, name + '(' +CASE isOpen WHEN 1 THEN '开通' ELSE '未开通' END + ')' as name from view_ErpUser where PostCode='AfterSale' or PostCode='AfterSaleMaster' ";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_Operation()
        {
            string sql = "select id, name from view_ErpUser where PostCode='Operation'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_after_sel_Operation()
        {
            string sql = "select id, name + '(' +CASE isOpen WHEN 1 THEN '开通' ELSE '未开通' END + ')' as name from view_ErpUser where PostCode='Operation'";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_product()
        {
            string sql = "select id,PMaterial,ptype as name from ce_erpproduct ";
            string key = GetPostString("key");
            string value = GetPostString("value");

            List<string> where = new List<string>();
            if (!string.IsNullOrEmpty(key))
            {
                where.Add("ptype like '%" + key + "%'");
                if (!string.IsNullOrEmpty(value))
                {
                    where.Add("id not in (" + value + ") ");
                }
            }
            if (CurrentUser.UserPost.Post.Code != "SysAdmin" && CurrentUser.UserPost.Post.Code != "Place" && CurrentUser.User.pemDesign.Length > 0)
            {
                where.Add("  ID in (" + CurrentUser.User.pemDesign + ")");

                if (CurrentUser.User.pemDesign.Length == 0)
                {
                    con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(new DataTable()));
                    return;
                }
            }
            if (where.Count > 0)
            {
                sql += "where " + string.Join(" and ", where);
            }
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_some_product()
        {
            string sql = "select id,PMaterial,ptype as name from ce_erpproduct where id in ('1','14','29', '4', '27', '13', '22', '49', '41', '43') ";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_supplier()
        {
            string poscode = CurrentUser.UserPost.Post.Code;
            string pensup = CurrentUser.User.pemVend;
            if (poscode == "Supplier")
            {
                string sql = "select id,comname as name from ce_erpsupplier where id in (" + pensup + ") order by bsort asc";
                DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
                con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
            }
            else
            {
                string sql = "select id,comname as name from ce_erpsupplier where IsClose = 0 order by bsort asc";
                DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
                con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
            }

        }

        public void get_sel_shop()
        {
            string sql = "select id,shopname as name from ce_erpshop";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));

        }
        public void get_sel_user_shop()
        {
            int userId = GetInt("userId");
            string user_sql = "SELECT OrgID FROM view_ErpUser where ID = " + userId;
            DataTable dt = DbHelper.DbConn.ExecuteDataset(user_sql).Tables[0];
            List<string> ids = new List<string>();
            ids.Add("0");
            if (dt.Rows.Count > 0)
            {
                string shop_sql = "SELECT shopId FROM Ce_ErpDesignInfo where tarId = " + dt.Rows[0]["OrgID"] + " and type = 0 and designId = 0";
                dt = DbHelper.DbConn.ExecuteDataset(shop_sql).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    ids = new List<string>();
                    foreach (DataRow item in dt.Rows)
                    {
                        ids.Add(item["shopId"].ToString());
                    }
                }

            }
            string sql = "select id,shopname as name from ce_erpshop where ID in (" + string.Join(",", ids) + ")";
            dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));

        }
        public void get_sel_user_design()
        {
            int userId = GetInt("userId");
            int shopId = GetInt("shopId");
            string user_sql = "SELECT OrgID FROM view_ErpUser where ID = " + userId;
            DataTable dt = DbHelper.DbConn.ExecuteDataset(user_sql).Tables[0];
            List<string> ids = new List<string>();
            ids.Add("0");
            if (dt.Rows.Count > 0)
            {
                string shop_sql = "SELECT designId FROM Ce_ErpDesignInfo where tarId = " + dt.Rows[0]["OrgID"] + " and type = 0 and designId != 0 and shopId = " + shopId;
                dt = DbHelper.DbConn.ExecuteDataset(shop_sql).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    ids = new List<string>();
                    foreach (DataRow item in dt.Rows)
                    {
                        ids.Add(item["designId"].ToString());
                    }
                }
            }
            string sql = "select id,PMaterial,ptype as name from ce_erpproduct where ID in (" + string.Join(",", ids) + ")";
            dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));

        }
        public void get_sel_pen_shop()
        {
            string shopIds = CurrentUser.User.pemShop;
            if (shopIds.Length <= 0)
            {
                shopIds = "0";
            }
            string sql = "select id,shopname as name from ce_erpshop where id in (" + shopIds + ")";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_org_pen_shop()
        {
            int orgid = 0;
            if (CurrentUser.UserPost.Post.OrgID == 2)
            {
                orgid = CurrentUser.UserPost.Post.OrgID;
            }
            else
            {
                orgid = CurrentUser.UserPost.OrgID;
            }
            string osql = "select * from view_ErpUserPost where OrgID=" + orgid;
            DataTable odt = DbHelper.DbConn.ExecuteDataset(osql).Tables[0];
            string shopIds = "0";
            if (odt.Rows.Count > 0)
            {
                shopIds = odt.Rows[0]["OrgShop"].ToString();
            }

            string sql = "select id,shopname as name from ce_erpshop where id in (" + shopIds + ")";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_waybill_company()
        {
            string curPemExpress = CurrentUser.User.pemExpress;
            string sql = "select * from CE_ErpMailInfo  where cpCode like 'LINK_%' and id in (" + curPemExpress + ");";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));

            //string sql = "select id, ParentID ,Code,Name as name from CE_ErpPrintModel where ParentID=0";
            //DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            //con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_waybill_model()
        {
            int pid = GetInt("pid");
            string sql = "select id, Code ,Name as name from CE_ErpPrintModel where ParentID=" + pid;
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
            //returnSuccess(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));

        }
        public void get_sel_invoicing()
        {
            string sql = "select id,ComName,CName from ce_erpinvoicinginfo ";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_sel_all_org()
        {
            string sql = "";
            sql = "select id,name from CE_ErpOrganization";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_design_org()
        {
            int orgid = CurrentUser.UserPost.OrgID;
            string code = CurrentUser.UserPost.Post.Code;
            string orgIds = CurrentUser.User.ManageOrgIds;
            string sql = "";

            if (code == "Designerhd" || code == "CustomerMr")
            {
                //and id in('11','12','13','99','102')
                if (orgIds == null || orgIds == "")
                {
                    sql = "select id,name from CE_ErpOrganization where (Code='designer' or Code like '%wx%' or Code='zz' ) and id=" + orgid;
                }
                else
                {
                    sql = "select id,name from CE_ErpOrganization where (Code='designer' or Code like '%wx%' or Code='zz' ) and id in (" + orgIds + ")";
                }
            }
            else if (orgid != 1 && orgid != 29 && orgid != 10 && orgid != 6 && orgid != 52)
            {
                sql = "select id,name from CE_ErpOrganization where (Code='designer' or Code like '%wx%' or Code='zz' ) and id=" + orgid;
            }
            else
                sql = "select id,name from CE_ErpOrganization where (Code='designer' or Code like '%wx%' or Code='zz') ";
            sql += " and id in (132,102,13,119,130,134,107,131,104,36,37,81,82,108,110,111,121,122,133,97,112,40)";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }


        public void get_sel_customer_org()
        {
            int orgid = CurrentUser.UserPost.OrgID;
            string sql = "";
            if (orgid != 1 && orgid != 29 && orgid != 10 && orgid != 6)
            {
                sql = "select id,name from CE_ErpOrganization where (Code like '%customer%') and id=" + orgid;
            }
            else
                sql = "select id,name from CE_ErpOrganization where Code like '%customer%'";

            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_product_hour()
        {
            string sql = "select * from view_ErpProductHour order by kfTime asc";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            ReturnSuccess(Utils.Serialization.JsonString.DataTable2AjaxJson(dt));
        }


        public void get_aftersale_method()
        {
            string sql = "select top 30 id,con from CE_ErpMethod order by id desc";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }


        public void get_erp_profession()
        {
            string sql = "select id,name from CE_ErpProfession where pid=-1 order by id desc";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_small_profession()
        {
            int pid = GetInt("pid");
            string sql = "select id,name from CE_ErpProfession where pid='" + pid + "' order by id desc";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_all_mail()
        {
            string sql = "select id, name,cpCode from CE_ErpMailInfo order by name desc";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_all_orgIds()
        {
            string sql = "select id, name,code from CE_ErpOrganization";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }

        public void get_sel_mail()
        {
            string curPemExpress = CurrentUser.User.pemExpress;
            string type = GetString("type");

            string sql = "select id, name,cpCode from CE_ErpMailInfo  where id in (" + curPemExpress + ") ORDER BY name desc;";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            if (!string.IsNullOrEmpty(type))
            {
                foreach (DataRow item in dt.Rows)
                {
                    string name = item["cpCode"].ToString();
                    if ("CAINIAO".Equals(type) && name.Contains("PDD"))
                    {
                        item.Delete();
                    }
                    if ("PDD".Equals(type) && name.Contains("CAINIAO"))
                    {
                        item.Delete();
                    }
                }
                dt.AcceptChanges();
            }
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
        public void get_sel_pddmail()
        {
            string curPemExpress = CurrentUser.User.pemExpress;
            string sql = "select id, name,cpCode from CE_ErpMailInfo  where id in (" + curPemExpress + ") and cpCode like '%PDD%';";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }


        public void get_sel_designerhd()
        {
            string sql = "select id, name, OrgID from view_ErpUser where PostCode='Designerhd' and PostName like '%设计主管%' and isOpen=1";
            DataTable dt = DbHelper.DbConn.ExecuteDataset(sql).Tables[0];
            con.Response.Write(Utils.Serialization.JsonString.DataTable2MiniAjaxJson(dt));
        }
    }
}