Ejemplo n.º 1
0
        /// <summary>
        /// 查询交易员
        /// </summary>
        protected void SelectEditer()
        {
            SOSOshop.BLL.MemberInfo mbll = new SOSOshop.BLL.MemberInfo();
            string    sqlText5           = "SELECT DISTINCT adminid AS id,name FROM yxs_administrators WHERE name<>'admin'";
            DataTable dt = mbll.ExecuteTable(sqlText5);

            if (dt != null && dt.Rows.Count > 0)
            {
                sqlText5 = "SELECT ',' + REPLACE(REPLACE(STUFF((SELECT CAST(i AS varchar) + ',' AS a  FROM (SELECT DISTINCT b.name AS i FROM memberinfo a INNER JOIN yxs_administrators b ON a.Editer=b.adminid) AS t FOR XML path('')), 1, 0, ''), '<a>', ''), '</a>', '')";
                string _101Admin = Convert.ToString(mbll.ExecuteScalarForCache(sqlText5));
                dt.Columns.Add("OK", typeof(int));
                //sqlText5 = "SELECT ',' + REPLACE(REPLACE(STUFF((SELECT CAST(i AS varchar) + ',' AS a  FROM (SELECT DISTINCT LTRIM(RTRIM(zhiyname)) AS i FROM zhiyzl WHERE beactive='是' AND issp='是' AND jigid='000') AS t FOR XML path('')), 1, 0, ''), '<a>', ''), '</a>', '')";
                //DbBase db2 = new DbBase(); db2.ChangeDB("ConnectionStringERP");
                //string ErpAdmin = Convert.ToString(db2.ExecuteScalarForCache(sqlText5));
                //foreach (DataRow dr in dt.Rows)
                //{
                //    //处理Erp中有没有
                //    if (!_101Admin.Contains("," + dr[1] + ",") && !ErpAdmin.Contains("," + dr[1] + ",")) dr.Delete();
                //}
                ddl_Editer.Items.Clear();
                ddl_Editer.DataSource = dt;
                ddl_Editer.DataBind();
            }
            ListItem li = new ListItem("全部人员", "0");

            ddl_Editer.Items.Insert(0, li);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 查询采购员
        /// </summary>
        protected void SelectCgyEditer()
        {
            SOSOshop.BLL.MemberInfo mbll = new SOSOshop.BLL.MemberInfo();
            cgy.Items.Clear();
            cgy.DataSource = mbll.ExecuteTable("SELECT isnull(cgy,'无') cgy FROM [dbo].[Product] GROUP BY cgy");
            cgy.DataBind();
            ListItem li = new ListItem("全部人员", "");

            cgy.Items.Insert(0, li);
            //li = new ListItem("无", "-1");
            //cgy.Items.Add(li);
            if (!string.IsNullOrEmpty(Request["cgy"]))
            {
                try { cgy.SelectedValue = Request["cgy"]; } catch { }
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 绑定外销人员
        /// </summary>
        protected void BindOutSellPerson()
        {
            SOSOshop.BLL.MemberInfo mbll = new SOSOshop.BLL.MemberInfo();
            string    sql = @"SELECT DISTINCT name as ospname, adminid as ospid
                           FROM dbo.yxs_administrators  ";
            DataTable dt  = mbll.ExecuteTable(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                ddlOSP.Items.Clear();
                ddlOSP.DataSource = dt;
                ddlOSP.DataBind();
            }

            ListItem li = new ListItem("全部人员", "0");

            ddlOSP.Items.Insert(0, li);
        }