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();
}
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();
}