protected void DdlReceiptPersonBind()
        {
            string sql = "select id per_id,person from jp_receipt_person order by NLSSORT(person,'NLS_SORT = SCHINESE_PINYIN_M')";

            DdlReceiptPerson.DataSource     = DBHelper.createDDLView(sql);
            DdlReceiptPerson.DataTextField  = "person";
            DdlReceiptPerson.DataValueField = "per_id";
            DdlReceiptPerson.DataBind();
        }
        protected void DdlReceiptPersonBind()
        {
            string sql = "select id per_id,person from jp_receipt_person order by last_time desc,use_times desc";

            DdlReceiptPerson.DataSource     = DBHelper.createDDLView(sql);
            DdlReceiptPerson.DataTextField  = "person";
            DdlReceiptPerson.DataValueField = "per_id";
            DdlReceiptPerson.DataBind();
        }
Exemple #3
0
        private void DdlReceiptPersonDataBind(Boolean _date, Boolean _place, Boolean _dept)
        {
            StringBuilder sql = new StringBuilder();

            sql.Append("select distinct receiver,receiver receiver_name from jp_requisition where rowstate='released'and nvl(jjd_qty,0)<release_qty");
            if (_date)
            {
                sql.Append(string.Format(" and receive_date = to_date('{0}','yyyy-mm-dd')", TxtRecieveDate.Text));
            }
            if (_place)
            {
                sql.Append(string.Format(" and place='{0}'", DdlReceiptPlace.SelectedValue));
            }
            if (_dept)
            {
                sql.Append(string.Format(" and receipt_dept='{0}'", DdlReceiptDept.SelectedValue));
            }
            DdlReceiptPerson.DataSource     = DBHelper.createDDLView(sql.ToString());
            DdlReceiptPerson.DataTextField  = "receiver_name";
            DdlReceiptPerson.DataValueField = "receiver";
            DdlReceiptPerson.DataBind();
        }