Beispiel #1
0
        /// <summary>
        /// 获取数字字典名称
        /// </summary>
        /// <param name="id">主键ID</param>
        /// <returns></returns>
        public string GetDic(object id)
        {
            string     str;
            Mod_TS_DIC mod = ts_dic.GetModel(id.ToString());

            str = mod.C_DETAILNAME;
            return(str);
        }
Beispiel #2
0
        private void GetArea()
        {
            #region //需求区域

            Mod_TS_DIC mod = new Mod_TS_DIC();
            mod.C_TYPECODE = "ConArea";
            DataTable dt = ts_dic.GetList(mod).Tables[0];
            if (dt.Rows.Count > 0)
            {
                dropneedarea.DataSource     = dt;
                dropneedarea.DataTextField  = "C_DETAILNAME";
                dropneedarea.DataValueField = "C_DETAILNAME";
                dropneedarea.DataBind();
            }
            else
            {
                dropneedarea.DataSource = null;
                dropneedarea.DataBind();
            }
            #endregion

            var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];

            string dept = ts_user.GetDept(vUser.Account);

            dropneedarea.SelectedIndex = dropneedarea.Items.IndexOf(dropneedarea.Items.FindByText(dept));


            #region //线材库区域

            DataTable dtxcarea = tmo_order.GetXCAREA().Tables[0];
            if (dtxcarea.Rows.Count > 0)
            {
                dropsalearea.DataSource     = dtxcarea;
                dropsalearea.DataTextField  = "C_SALE_AREA";
                dropsalearea.DataValueField = "C_SALE_AREA";
                dropsalearea.DataBind();
                dropsalearea.Items.Insert(0, new ListItem("全部区域", "-1"));//
            }
            else
            {
                dropsalearea.DataSource = null;
                dropsalearea.DataBind();
            }
            #endregion

            #region //质量
            DataTable dtzl = tmo_order.GetXC_JUDGE_LEV_ZH("").Tables[0];
            if (dtzl.Rows.Count > 0)
            {
                dropzldj.DataSource     = dtzl;
                dropzldj.DataTextField  = "C_JUDGE_LEV_ZH";
                dropzldj.DataValueField = "C_JUDGE_LEV_ZH";
                dropzldj.DataBind();
                dropzldj.Items.Insert(0, new ListItem("全部质量", ""));
            }
            #endregion
        }
Beispiel #3
0
        /// <summary>
        /// 获取数字字典
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        private DataTable GetData(string code)
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = code;
            DataTable dt = ts_dic.GetList(mod).Tables[0];

            return(dt);
        }
Beispiel #4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Mod_TS_DIC DataRowToModel(DataRow row)
        {
            Mod_TS_DIC model = new Mod_TS_DIC();

            if (row != null)
            {
                if (row["C_ID"] != null)
                {
                    model.C_ID = row["C_ID"].ToString();
                }
                if (row["C_TYPECODE"] != null)
                {
                    model.C_TYPECODE = row["C_TYPECODE"].ToString();
                }
                if (row["C_TYPENAME"] != null)
                {
                    model.C_TYPENAME = row["C_TYPENAME"].ToString();
                }
                if (row["C_DETAILCODE"] != null)
                {
                    model.C_DETAILCODE = row["C_DETAILCODE"].ToString();
                }
                if (row["C_DETAILNAME"] != null)
                {
                    model.C_DETAILNAME = row["C_DETAILNAME"].ToString();
                }
                if (row["C_INDEX"] != null && row["C_INDEX"].ToString() != "")
                {
                    model.C_INDEX = decimal.Parse(row["C_INDEX"].ToString());
                }
                if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
                {
                    model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
                }
                if (row["N_ISGPS"] != null && row["N_ISGPS"].ToString() != "")
                {
                    model.N_ISGPS = decimal.Parse(row["N_ISGPS"].ToString());
                }
                if (row["C_EMP_ID"] != null)
                {
                    model.C_EMP_ID = row["C_EMP_ID"].ToString();
                }
                if (row["C_EMP_NAME"] != null)
                {
                    model.C_EMP_NAME = row["C_EMP_NAME"].ToString();
                }
                if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
                {
                    model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
                }
            }
            return(model);
        }
Beispiel #5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Mod_TS_DIC model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update TS_DIC set ");
            strSql.Append("C_TYPECODE=:C_TYPECODE,");
            strSql.Append("C_TYPENAME=:C_TYPENAME,");
            strSql.Append("C_DETAILCODE=:C_DETAILCODE,");
            strSql.Append("C_DETAILNAME=:C_DETAILNAME,");
            strSql.Append("C_INDEX=:C_INDEX,");
            strSql.Append("N_STATUS=:N_STATUS,");
            strSql.Append("N_ISGPS=:N_ISGPS,");
            strSql.Append("C_EMP_ID=:C_EMP_ID,");
            strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
            strSql.Append("D_MOD_DT=:D_MOD_DT");
            strSql.Append(" where C_ID=:C_ID ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_TYPECODE",   OracleDbType.Varchar2,  80),
                new OracleParameter(":C_TYPENAME",   OracleDbType.Varchar2,  80),
                new OracleParameter(":C_DETAILCODE", OracleDbType.Varchar2,  80),
                new OracleParameter(":C_DETAILNAME", OracleDbType.Varchar2,  80),
                new OracleParameter(":C_INDEX",      OracleDbType.Int32,      3),
                new OracleParameter(":N_STATUS",     OracleDbType.Int16,      1),
                new OracleParameter(":N_ISGPS",      OracleDbType.Int16,      1),
                new OracleParameter(":C_EMP_ID",     OracleDbType.Varchar2, 100),
                new OracleParameter(":C_EMP_NAME",   OracleDbType.Varchar2,  20),
                new OracleParameter(":D_MOD_DT",     OracleDbType.Date),
                new OracleParameter(":C_ID",         OracleDbType.Varchar2, 100)
            };
            parameters[0].Value  = model.C_TYPECODE;
            parameters[1].Value  = model.C_TYPENAME;
            parameters[2].Value  = model.C_DETAILCODE;
            parameters[3].Value  = model.C_DETAILNAME;
            parameters[4].Value  = model.C_INDEX;
            parameters[5].Value  = model.N_STATUS;
            parameters[6].Value  = model.N_ISGPS;
            parameters[7].Value  = model.C_EMP_ID;
            parameters[8].Value  = model.C_EMP_NAME;
            parameters[9].Value  = model.D_MOD_DT;
            parameters[10].Value = model.C_ID;

            int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        /// <summary>
        /// 获取数字字典名称
        /// </summary>
        /// <param name="id">主键ID</param>
        /// <returns></returns>
        private string GetDic(object id)
        {
            string str = string.Empty;

            if (!string.IsNullOrEmpty(id.ToString()))
            {
                Mod_TS_DIC mod = ts_dic.GetModel(id.ToString());
                str = mod.C_DETAILNAME;
            }

            return(str);
        }
Beispiel #7
0
        public AjaxResult GetArea([FromBody] dynamic Json)
        {
            AjaxResult result = new AjaxResult();

            #region //数据操作
            Mod_TS_DIC mod = new Mod_TS_DIC();
            mod.C_TYPECODE = "ConArea";
            DataTable dt = ts_dic.GetList(mod).Tables[0];
            result.Code   = DoResult.Success;
            result.Result = JsonConvert.SerializeObject(dt);
            #endregion
            return(result);
        }
Beispiel #8
0
        /// <summary>
        /// 获取等级
        /// </summary>
        /// <param name="code">编码</param>
        /// <returns></returns>
        private string GetLev(string code)
        {
            string     result = "";
            Mod_TS_DIC mod    = new Mod_TS_DIC();

            mod.C_TYPECODE = code;
            DataTable dt = ts_dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                result = dt.Rows[0]["C_DETAILNAME"].ToString();
            }
            return(result);
        }
Beispiel #9
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(Mod_TS_DIC model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_EXTEND1,C_EXTEND2,C_EXTEND3,C_EXTEND4,C_EXTEND5 ");
            strSql.Append(" FROM TS_DIC where N_STATUS=1 ");
            if (!string.IsNullOrEmpty(model.C_TYPECODE))
            {
                strSql.Append(" and C_TYPECODE='" + model.C_TYPECODE + "'");
            }
            if (!string.IsNullOrEmpty(model.C_DETAILCODE))
            {
                strSql.Append(" and C_DETAILCODE='" + model.C_DETAILCODE + "'");
            }
            strSql.Append(" order by C_INDEX asc");
            return(DbHelperOra.Query(strSql.ToString()));
        }
Beispiel #10
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Mod_TS_DIC model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into TS_DIC(");
            strSql.Append("C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT)");
            strSql.Append(" values (");
            strSql.Append(":C_ID,:C_TYPECODE,:C_TYPENAME,:C_DETAILCODE,:C_DETAILNAME,:C_INDEX,:N_STATUS,:N_ISGPS,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_ID",         OracleDbType.Varchar2, 100),
                new OracleParameter(":C_TYPECODE",   OracleDbType.Varchar2,  80),
                new OracleParameter(":C_TYPENAME",   OracleDbType.Varchar2,  80),
                new OracleParameter(":C_DETAILCODE", OracleDbType.Varchar2,  80),
                new OracleParameter(":C_DETAILNAME", OracleDbType.Varchar2,  80),
                new OracleParameter(":C_INDEX",      OracleDbType.Int32,      3),
                new OracleParameter(":N_STATUS",     OracleDbType.Int16,      1),
                new OracleParameter(":N_ISGPS",      OracleDbType.Int16,      1),
                new OracleParameter(":C_EMP_ID",     OracleDbType.Varchar2, 100),
                new OracleParameter(":C_EMP_NAME",   OracleDbType.Varchar2,  20),
                new OracleParameter(":D_MOD_DT",     OracleDbType.Date)
            };
            parameters[0].Value  = model.C_ID;
            parameters[1].Value  = model.C_TYPECODE;
            parameters[2].Value  = model.C_TYPENAME;
            parameters[3].Value  = model.C_DETAILCODE;
            parameters[4].Value  = model.C_DETAILNAME;
            parameters[5].Value  = model.C_INDEX;
            parameters[6].Value  = model.N_STATUS;
            parameters[7].Value  = model.N_ISGPS;
            parameters[8].Value  = model.C_EMP_ID;
            parameters[9].Value  = model.C_EMP_NAME;
            parameters[10].Value = model.D_MOD_DT;

            int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #11
0
        private void GetArea()
        {
            #region //需求区域

            Mod_TS_DIC mod = new Mod_TS_DIC();
            mod.C_TYPECODE = "ConArea";
            DataTable dt = ts_dic.GetList(mod).Tables[0];
            if (dt.Rows.Count > 0)
            {
                dropsalearea.DataSource     = dt;
                dropsalearea.DataTextField  = "C_DETAILNAME";
                dropsalearea.DataValueField = "C_DETAILNAME";
                dropsalearea.DataBind();
                dropsalearea.Items.Insert(0, new ListItem("全部区域", ""));
            }

            #endregion
        }
Beispiel #12
0
        //加载数据
        private void BindData()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "ShipVia";
            DataTable dt = dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                rptList.DataSource = dt;
                rptList.DataBind();
            }
            else
            {
                rptList.DataSource = null;
                rptList.DataBind();
            }
        }
Beispiel #13
0
        private void BindArea()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "ConArea";
            DataTable dt = ts_dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                dropArea.DataSource     = dt;
                dropArea.DataTextField  = "C_DETAILNAME";
                dropArea.DataValueField = "C_DETAILNAME";
                dropArea.DataBind();
            }
            else
            {
                dropArea.DataSource = null;
                dropArea.DataBind();
            }
        }
Beispiel #14
0
        /// <summary>
        /// 获取公告分类
        /// </summary>
        private void GetClass()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "NoticeType";
            DataTable dt = dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                dropClass.DataSource     = dt;
                dropClass.DataTextField  = "C_DETAILNAME";
                dropClass.DataValueField = "C_ID";
                dropClass.DataBind();
            }
            else
            {
                dropClass.DataSource = null;
                dropClass.DataBind();
            }
        }
Beispiel #15
0
        /// <summary>
        /// 合同状态
        /// </summary>
        private void BindConSate()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "ContractStatus";
            DataTable dt = ts_dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                dropState.DataSource     = dt;
                dropState.DataTextField  = "C_DETAILNAME";
                dropState.DataValueField = "C_DETAILCODE";
                dropState.Items.Insert(0, new ListItem("全部", ""));
            }
            else
            {
                dropState.DataSource = null;
                dropState.DataBind();
            }
        }
Beispiel #16
0
        /// <summary>
        /// 业务类型
        /// </summary>
        private void GetBusinessType()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "BusinessType";
            DataTable dt = dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                dropYeWuType.DataSource     = dt;
                dropYeWuType.DataTextField  = "C_DETAILNAME";
                dropYeWuType.DataValueField = "C_DETAILNAME";
                dropYeWuType.DataBind();
            }
            else
            {
                dropYeWuType.DataSource = null;
                dropYeWuType.DataBind();
            }
        }
Beispiel #17
0
        /// <summary>
        /// 发运方式
        /// </summary>
        private void GetShipVia()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "ShipVia";
            DataTable dt = dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                dropFaYun.DataSource     = dt;
                dropFaYun.DataTextField  = "C_DETAILNAME";
                dropFaYun.DataValueField = "C_DETAILNAME";
                dropFaYun.DataBind();
            }
            else
            {
                dropFaYun.DataSource = null;
                dropFaYun.DataBind();
            }
        }
Beispiel #18
0
        private void GetArea()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "ConArea";
            dtArea         = ts_dic.GetList(mod).Tables[0];
            if (dtArea.Rows.Count > 0)
            {
                dropsalearea.DataSource     = dtArea;
                dropsalearea.DataTextField  = "C_DETAILNAME";
                dropsalearea.DataValueField = "C_DETAILNAME";
                dropsalearea.DataBind();
                dropsalearea.Items.Insert(0, new ListItem("全部", ""));//
            }
            else
            {
                dropsalearea.DataSource = null;
                dropsalearea.DataBind();
                dropsalearea.Items.Insert(0, new ListItem("全部", ""));//
            }
        }
Beispiel #19
0
        private void BindInfo()
        {
            Mod_TS_DIC mod = new Mod_TS_DIC();

            mod.C_TYPECODE = "ConArea";
            DataTable dt = ts_dic.GetList(mod).Tables[0];

            if (dt.Rows.Count > 0)
            {
                dropneedarea.DataSource     = dt;
                dropneedarea.DataTextField  = "C_DETAILNAME";
                dropneedarea.DataValueField = "C_DETAILNAME";
                dropneedarea.DataBind();
                dropneedarea.Items.Add(new ListItem("空白", ""));
            }
            else
            {
                dropneedarea.DataSource = null;
                dropneedarea.DataBind();
            }
        }
Beispiel #20
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Mod_TS_DIC GetModel(string C_ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select C_ID,C_TYPECODE,C_TYPENAME,C_DETAILCODE,C_DETAILNAME,C_INDEX,N_STATUS,N_ISGPS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TS_DIC ");
            strSql.Append(" where C_ID=:C_ID ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
            };
            parameters[0].Value = C_ID;

            Mod_TS_DIC model = new Mod_TS_DIC();
            DataSet    ds    = DbHelperOra.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Beispiel #21
0
        //是否下发审核
        protected void btnNo_Click(object sender, EventArgs e)
        {
            List <Mod_TS_DIC> list = new List <Mod_TS_DIC>();

            foreach (RepeaterItem item in rptList.Items)
            {
                HtmlInputCheckBox chkSelect    = (HtmlInputCheckBox)item.FindControl("chkSelect");
                Literal           ltlnextcheck = (Literal)item.FindControl("ltlnextcheck");

                if (chkSelect.Checked)
                {
                    Mod_TS_DIC mod = new Mod_TS_DIC();
                    mod.C_ID      = chkSelect.Value;
                    mod.C_EXTEND2 = ltlnextcheck.Text == "N" ? "Y" : "N";
                    list.Add(mod);
                }
            }
            if (dic.UpdateAreaCust(list))
            {
                ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('设置成功')", true);
                //WebMsg.MessageBox("设置成功");
                BindData();
            }
        }
Beispiel #22
0
        //发运方式GPS控制
        protected void btnOk_Click(object sender, EventArgs e)
        {
            List <Mod_TS_DIC> list = new List <Mod_TS_DIC>();

            foreach (RepeaterItem item in rptList.Items)
            {
                HtmlInputCheckBox chkSelect = (HtmlInputCheckBox)item.FindControl("chkSelect");
                Literal           ltlgps    = (Literal)item.FindControl("ltlfygps");

                if (chkSelect.Checked)
                {
                    Mod_TS_DIC mod = new Mod_TS_DIC();
                    mod.C_ID    = chkSelect.Value;
                    mod.N_ISGPS = Convert.ToDecimal(ltlgps.Text == "N" ? "1" : "0");
                    list.Add(mod);
                }
            }
            if (dic.UpdateAreaGPS(list))
            {
                ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('设置成功')", true);
                //WebMsg.MessageBox("设置成功");
                BindData();
            }
        }
Beispiel #23
0
 /// <summary>
 /// 获得数据列表
 /// </summary>
 public DataSet GetList(Mod_TS_DIC model)
 {
     return(dal.GetList(model));
 }
Beispiel #24
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Mod_TS_DIC model)
 {
     return(dal.Add(model));
 }
Beispiel #25
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Mod_TS_DIC model)
 {
     return(dal.Update(model));
 }
Beispiel #26
0
        private void BindInfo()
        {
            #region //质量
            DataTable dtzl = tmo_order.GetXC_JUDGE_LEV_ZH("").Tables[0];
            if (dtzl.Rows.Count > 0)
            {
                dropzldj.DataSource     = dtzl;
                dropzldj.DataTextField  = "C_JUDGE_LEV_ZH";
                dropzldj.DataValueField = "C_JUDGE_LEV_ZH";
                dropzldj.DataBind();
                dropzldj.Items.Insert(0, new ListItem("全部", ""));
            }
            #endregion

            #region //特殊信息
            DataTable dtts = tmo_order.GetTS().Tables[0];
            if (dtts.Rows.Count > 0)
            {
                droptsxx.DataSource     = dtts;
                droptsxx.DataTextField  = "C_PCINFO";
                droptsxx.DataValueField = "C_PCINFO";
                droptsxx.DataBind();
                droptsxx.Items.Insert(0, new ListItem("全部", ""));
            }
            #endregion

            #region //线材库区域
            DataTable dtxcarea = tmo_order.GetXCAREA("").Tables[0];
            if (dtxcarea.Rows.Count > 0)
            {
                dropsalearea.DataSource     = dtxcarea;
                dropsalearea.DataTextField  = "C_SALE_AREA";
                dropsalearea.DataValueField = "C_SALE_AREA";
                dropsalearea.DataBind();
                dropsalearea.Items.Insert(0, new ListItem("全部", "-1"));//
            }
            else
            {
                dropsalearea.DataSource = null;
                dropsalearea.DataBind();
            }
            #endregion

            #region //需求区域

            Mod_TS_DIC mod = new Mod_TS_DIC();
            mod.C_TYPECODE = "ConArea";
            DataTable dt = ts_dic.GetList(mod).Tables[0];
            if (dt.Rows.Count > 0)
            {
                dropneedarea.DataSource     = dt;
                dropneedarea.DataTextField  = "C_DETAILNAME";
                dropneedarea.DataValueField = "C_DETAILNAME";
                dropneedarea.DataBind();
                dropneedarea.Items.Add(new ListItem("空白", ""));
            }
            else
            {
                dropneedarea.DataSource = null;
                dropneedarea.DataBind();
            }
            #endregion
        }
Beispiel #27
0
        private void GetInfo()
        {
            try
            {
                #region //物料名称
                DataTable dtMat = tmo_order.GetOrderMat().Tables[0];
                if (dtMat.Rows.Count > 0)
                {
                    dropMatName.DataSource     = dtMat;
                    dropMatName.DataTextField  = "C_MAT_NAME";
                    dropMatName.DataValueField = "C_MAT_NAME";
                    dropMatName.DataBind();
                    dropMatName.Items.Insert(0, new ListItem("全部", ""));//
                }
                #endregion

                #region /区域

                Mod_TS_DIC mod = new Mod_TS_DIC();
                mod.C_TYPECODE = "ConArea";
                DataTable dtArea = ts_dic.GetList(mod).Tables[0];
                if (dtArea.Rows.Count > 0)
                {
                    dropArea.DataSource     = dtArea;
                    dropArea.DataTextField  = "C_DETAILNAME";
                    dropArea.DataValueField = "C_DETAILNAME";
                    dropArea.DataBind();
                    dropArea.Items.Insert(0, new ListItem("全部", ""));//
                }


                #endregion

                #region 规格
                DataTable dtSpec = tmo_order.GetSpec().Tables[0];
                if (dtSpec.Rows.Count > 0)
                {
                    dropSpec.DataSource     = dtSpec;
                    dropSpec.DataValueField = "C_SPEC";
                    dropSpec.DataTextField  = "C_SPEC";
                    dropSpec.DataBind();
                    dropSpec.Items.Insert(0, new ListItem("全部规格", ""));
                }
                #endregion

                #region //包装
                DataTable dtpack = pack.GetPackList("", "").Tables[0];
                if (dtpack.Rows.Count > 0)
                {
                    dropPack.DataSource     = dtpack;
                    dropPack.DataValueField = "C_PACK_TYPE_CODE";
                    dropPack.DataTextField  = "C_PACK_TYPE_CODE";
                    dropPack.DataBind();
                    dropPack.Items.Insert(0, new ListItem("全部", ""));
                }
                #endregion
            }

            catch (Exception ex)
            {
                WebMsg.MessageBox(ex.Message);
            }
        }