protected void ASPxListBox1_Callback(object sender, CallbackEventArgsBase e)
{
string[] param = e.Parameter.Split(',');
string type = param[0];
string pline1 = ASPxComboBoxPline.SelectedItem.Value.ToString();
//string pline1 = param[1];
//string begindate1 = param[1] ;
string begindate1 = ASPxDateEdit1.Date.ToString("yyyy-MM-dd");
ASPxListBox location = sender as ASPxListBox;
if (type == "ALL")
{
//大线和改制返修如何区分，根据计划制定人员？
string sql = "select plan_code||'; '||plan_so||'; '||plan_qty||'; '||pline_code ID1 from data_plan where pline_code='" + pline1 + "' and (plan_type='C' or plan_type='D') and begin_date=to_date('" + begindate1 + "','yyyy-mm-dd') and confirm_flag='Y' and bom_flag='N' and item_flag='N' and third_flag='N' and run_flag='N' order by plan_code";
DataTable dt = dc.GetTable(sql);
location.DataSource = dt;
location.DataBind();
}
if (type == "ALLW")
{
string sql = "select plan_code||'; '||plan_so||'; '||plan_qty||'; '||pline_code ID1 from data_plan where pline_code='" + pline1 + "' and (plan_type='C' or plan_type='D') and confirm_flag='Y' and bom_flag='N' and item_flag='N' and third_flag='N' and run_flag='N' order by plan_code";
DataTable dt = dc.GetTable(sql);
location.DataSource = dt;
location.DataBind();
}
string sql1 = "select rmes_id,plan_code,plan_so,plan_qty,pline_code from data_plan where pline_code='" + pline1 + "' and (plan_type='C' or plan_type='D') and begin_date=to_date('" + begindate1 + "','yyyy-mm-dd') and confirm_flag='Y' and bom_flag='N' and item_flag='N' and third_flag='N' and run_flag='N' order by plan_code";
ASPxListBoxLocation.DataSource = dc.GetTable(sql1);
ASPxListBoxLocation.DataBind();
}
protected void ProdCat_ListBox_Init(object sender, EventArgs e)
{
string docnum = MOPNum_Combo.Text.ToString();
empty = string.IsNullOrEmpty(docnum);
ASPxListBox list = sender as ASPxListBox;
list.Columns.Clear();
list.Items.Clear();
//if (empty)
list.DataSource = MRPClass.ProCategoryTable_WithoutAll();
//else
//list.DataSource = MRPClass.ProCategoryTable_Filter("");
ListBoxColumn l_value = new ListBoxColumn();
l_value.FieldName = "NAME";
l_value.Caption = "Code";
l_value.Width = 100;
list.Columns.Add(l_value);
ListBoxColumn l_text = new ListBoxColumn();
l_text.FieldName = "DESCRIPTION";
l_text.Caption = "Description";
l_text.Width = 350;
list.Columns.Add(l_text);
list.ValueField = "NAME";
list.TextField = "DESCRIPTION";
list.DataBind();
list.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
list.ClientEnabled = false;
}
protected void listBoxLocation_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
//string pline = e.Parameter;
string[] param = e.Parameter.Split(',');
string sss1 = param[0];
string sss2 = param[1];
string sss3 = param[2];
ASPxListBox location = sender as ASPxListBox;
//如果是装配工位排除已经对应过站点的工位
string sql = "";
if (sss2 == "A")
{
sql = "SELECT A.RMES_ID,A.LOCATION_CODE,A.LOCATION_CODE LOCATION_NAME FROM CODE_LOCATION A WHERE A.PLINE_CODE='"
+ sss1 + "' AND NOT EXISTS(SELECT * FROM REL_STATION_LOCATION C WHERE C.LOCATION_CODE=A.RMES_ID and c.LOCATION_FLAG='A' and PLINE_CODE='" + sss1 + "' ) "
+ " AND NOT EXISTS(SELECT * FROM REL_STATION_LOCATION D WHERE D.LOCATION_CODE=A.RMES_ID and D.station_code='" + sss3 + "' ) " //and c.LOCATION_FLAG='B'
+ " ORDER BY A.LOCATION_CODE"; //
}
if (sss2 == "B")
{
sql = "SELECT A.RMES_ID,A.LOCATION_CODE,A.LOCATION_CODE LOCATION_NAME FROM CODE_LOCATION A WHERE A.PLINE_CODE='" + sss1 + "' "
+ " AND NOT EXISTS(SELECT * FROM REL_STATION_LOCATION C WHERE C.LOCATION_CODE=A.RMES_ID and c.station_code='" + sss3 + "' ) " //and c.LOCATION_FLAG='B'
+ " ORDER BY A.LOCATION_CODE";
}
//如果是查看工位显示所有工位
DataTable dt = dc.GetTable(sql);
location.DataSource = dt;
location.DataBind();
}
//初始化JHDM
//private void initJHDM()
//{
// string sql = " select distinct b.PLAN_CODE||'--'||b.PLAN_SO AS PLAN_CODE,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b "
// + " where b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') "
// + " AND B.PLINE_CODE = rh_get_data('G','" + txtPCode.Text.Trim() + "','','','') ";
// //string sql = " select distinct b.PLAN_CODE, b.PLAN_SO ,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b WHERE "
// // + " b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') AND "
// // + " B.PLINE_CODE in(select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
// if (txtSO.Text.Trim() != "")
// {
// sql += " AND b.PLAN_SO = '" + txtSO.Text.Trim() + "' ";
// }
// sql += " ORDER BY PLAN_CODE ";
// //sqlJhdm.SelectCommand = sql;
// //sqlJhdm.DataBind();
// DataTable dt = dc.GetTable(sql);
// listJhdm.DataSource = dt;
// listJhdm.DataBind();
//}
//使用callback初始化JHDM
protected void listJhdm_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
ASPxListBox jhdmList = sender as ASPxListBox;
string sql = " select distinct b.PLAN_CODE||'--'||b.PLAN_SO AS PLAN_CODE,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b "
+ " where b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') ";
if (txtPCode.Text.Trim() != "")
{
sql += " AND b.PLINE_CODE = '" + txtPCode.Value.ToString() + "' ";
}
//string sql = " select distinct b.PLAN_CODE, b.PLAN_SO ,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b WHERE "
// + " b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') AND "
// + " B.PLINE_CODE in(select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
if (txtSO.Text.Trim() != "")
{
sql += " AND b.PLAN_SO = UPPER('" + txtSO.Text.Trim() + "') ";
}
sql += " ORDER BY PLAN_CODE ";
//sqlJhdm.SelectCommand = sql;
//sqlJhdm.DataBind();
DataTable dt = dc.GetTable(sql);
jhdmList.DataSource = dt;
jhdmList.DataBind();
}
public static ASPxListBox MontaListMult(ASPxListBox pCombo, string pTabela, string[] pCamposExibe, string pCampoValor, Boolean pExibeValor)
{
//Documentação - Chamada da Função
//
//String[] Campos = { "tipo", "descricao", "apelido" };
//RgbDbLib.MontaListMult(ListBoxModelo2, "tcobran", Campos, "tipo", true);
//
//O Search será sempre pelo 1o. campo do Select
//O Campo de valor Não precisa ser passado na lista de campos, porque ele vem através de pCampoValor
//Fim Documentação - Chamada da Função
String script = "SELECT ";
foreach (String item in pCamposExibe)
{
script = script + item + ",";
}
script = script + pCampoValor + " FROM " + pTabela + " WITH(NOLOCK)";
DataSet ds = SreDblib.GetDsScript(script);
pCombo.DataSource = ds;
pCombo.ValueField = pCampoValor;
pCombo.DataBind();
return(pCombo);
}
protected void lbAvailable_callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
ASPxListBox lstBox = sender as ASPxListBox;
DataSet ds = SqlHelper.ExecuteDataset(strconn, "[HRM_GET_KHOADAOTAO]", e.Parameter, 1, 1);
lstBox.DataSource = ds.Tables[0];
lstBox.TextField = "hoten";
lstBox.ValueField = "id";
lstBox.DataBind();
}
protected void UsedByServersListoBox_OnDataBinding(object sender, EventArgs e)
{
ASPxListBox lb = (ASPxListBox)sender;
DataTable dt = VSWebBL.ConfiguratorBL.TravelerBL.Ins.GetTravelerTestWhenScan();
lb.DataSource = dt;
lb.TextField = "TestScanServer";
lb.ValueField = "TestScanServer";
lb.DataBind();
}
protected void lbAvailable_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
string pline = e.Parameter;
ASPxListBox detectData = sender as ASPxListBox;
string sql = "SELECT A.RMES_ID,A.DETECT_CODE,A.DETECT_CODE||';'||A.DETECT_NAME DETECT_NAME FROM CODE_DETECT A WHERE A.PLINE_CODE='"
+ pline + "' AND NOT EXISTS(SELECT * FROM REL_STATION_DETECT C WHERE C.DETECT_CODE=A.DETECT_CODE ) ORDER BY A.DETECT_CODE";//
DataTable dt = dc.GetTable(sql);
detectData.DataSource = dt;
detectData.DataBind();
}
public static void SetDataSource(ASPxListBox lst, object src, string valField, string txtField)
{
if (src == null)
{
return;
}
lst.DataSource = src;
lst.ValueField = valField;
lst.TextField = txtField;
lst.DataBind();
GC.Collect();
}
//工位初始化callback
protected void listLocationTH_Callback(object sender, CallbackEventArgsBase e)
{
string plineNew = e.Parameter;
string sql = "select RMES_ID,LOCATION_NAME,LOCATION_CODE from CODE_LOCATION where PLINE_CODE='" + plineNew + "' order by LOCATION_CODE";
DataTable dt = dc.GetTable(sql);
ASPxListBox location = sender as ASPxListBox;
location.DataSource = dt;
location.DataBind();
}
//protected void ProdCategory_Combo_Init(object sender, EventArgs e)
//{
// ASPxComboBox combo = sender as ASPxComboBox;
// combo.DataSource = MRPClass.ProCategoryTable();
// ListBoxColumn l_value = new ListBoxColumn();
// l_value.FieldName = "NAME";
// l_value.Caption = "CODE";
// l_value.Width = 100;
// combo.Columns.Add(l_value);
// ListBoxColumn l_text = new ListBoxColumn();
// l_text.FieldName = "DESCRIPTION";
// l_text.Width = 350;
// combo.Columns.Add(l_text);
// combo.ValueField = "NAME";
// combo.TextField = "DESCRIPTION";
// combo.DataBind();
// combo.TextFormatString = "{1}";
//}
private void ProdCat_DataBind()
{
ASPxListBox list = ProdCat_ListBox as ASPxListBox;
list.Columns.Clear();
list.Items.Clear();
string monthyear = MonthYear_Combo.Text;
//if (!string.IsNullOrEmpty(monthyear) && ((MOPNum_Combo.Value != null) || (CheckboxAll.Checked)))
//if ((!string.IsNullOrEmpty(monthyear) && MOPNum_Combo.Value != null) || (!string.IsNullOrEmpty(monthyear) && CheckboxAll.Checked))
if (!string.IsNullOrEmpty(monthyear))
{
if (!string.IsNullOrEmpty(MOPNum_Combo.Text.ToString()) || CheckboxAll.Checked)
{
string[] strarr = monthyear.Split(' ');
string month = strarr[0].ToString();
string year = strarr[1].ToString();
string docnum = "";
int monthindex = Convertion.MONTH_TO_INDEX(month);
if (!string.IsNullOrEmpty(MOPNum_Combo.Text.ToString()))
{
docnum = MOPNum_Combo.Text.ToString();
}
//MRPClass.PrintString("pass");
//MRPClass.PrintString(docnum);
list.DataSource = MRPClass.ProCategoryTable_Filter_SelectItemPO(Convert.ToInt32(year), monthindex, docnum);
ListBoxColumn l_value = new ListBoxColumn();
l_value.FieldName = "NAME";
l_value.Caption = "Code";
l_value.Width = 100;
list.Columns.Add(l_value);
ListBoxColumn l_text = new ListBoxColumn();
l_text.FieldName = "DESCRIPTION";
l_text.Caption = "Description";
l_text.Width = 350;
list.Columns.Add(l_text);
list.ValueField = "NAME";
list.TextField = "DESCRIPTION";
list.DataBind();
list.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True;
list.ClientEnabled = true;
}
}
}
public void BindPowerLevel()
{
DataSet dsPowerLevel = Astronergy.MES.Report.DataAccess.WareHouse.WareHouseDate.GetPowerLever("", "", "");
ASPxListBox lstPowerLevel = this.ddePowerLevel.FindControl("lstPowerLevel") as ASPxListBox;
if (lstPowerLevel != null)
{
lstPowerLevel.DataSource = dsPowerLevel.Tables[0];
lstPowerLevel.TextField = "PMAXSTAB";
lstPowerLevel.ValueField = "PMAXSTAB";
lstPowerLevel.DataBind();
lstPowerLevel.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
/// <summary>
/// 绑定线别
/// </summary>
private void BindLine()
{
DataTable dtLine = CommonFunction.GetLine();
ASPxListBox lst = this.ddLine.FindControl("lstLine") as ASPxListBox;
if (lst != null)
{
lst.DataSource = dtLine;
lst.TextField = "LINE_NAME";
lst.ValueField = "LINE_NAME";
lst.DataBind();
lst.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
public void BindProMode()
{
DataSet dsProMode = CTMReportFunction.GetProMode("");
ASPxListBox lst = this.ddeProMode.FindControl("lstProMode") as ASPxListBox;
if (lst != null)
{
lst.DataSource = dsProMode.Tables[0];
lst.TextField = "PROMODEL_NAME";
lst.ValueField = "PROMODEL_NAME";
lst.DataBind();
lst.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
protected void listBoxLSH1_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
string[] param = e.Parameter.Split(',');
//string pline1 = param[0];
string pline1 = ASPxComboBoxPline.SelectedItem.Value.ToString();
//string begindate1 = param[1] ;
string begindate1 = ASPxDateEdit1.Date.ToString("yyyy-MM-dd");
string sql = "select rmes_id,plan_code,plan_so,plan_qty,pline_code from data_plan where pline_code='" + pline1 + "' and begin_date=to_date('" + begindate1 + "','yyyy-mm-dd') and (plan_type='C' or plan_type='D') and confirm_flag='Y' and bom_flag='N' and item_flag='N' and third_flag='N' and run_flag='N' order by plan_code";
ASPxListBox location = sender as ASPxListBox;
DataTable dt = dc.GetTable(sql);
location.DataSource = dt;
location.DataBind();
}
protected void listBoxProgram_Callback(object sender, CallbackEventArgsBase e)
{
string user = e.Parameter;
string sql = "select a.program_code,b.program_name from vw_user_role_program a left join code_program b on a.program_code=b.program_code where user_id='" + user + "' ORDER BY PROGRAM_CODE ";
DataTable dt = dc.GetTable(sql);
ASPxListBox program = sender as ASPxListBox;
program.DataSource = dt;
program.ValueField = "PROGRAM_CODE";
program.TextField = "PROGRAM_NAME";
program.DataBind();
}
protected void listBoxPreStation_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
string pline = e.Parameter;
ASPxListBox preStation = sender as ASPxListBox;
string sql = "SELECT A.RMES_ID,A.STATION_CODE,A.STATION_NAME STATION_NAME FROM CODE_STATION A WHERE A.PLINE_CODE='" + pline + "' "
+ " ORDER BY A.STATION_NAME";
DataTable dt = dc.GetTable(sql);
preStation.DataSource = dt;
preStation.DataBind();
}
/// <summary>
/// 绑定客户类别。
/// </summary>
private void BindCustomerType()
{
DataTable dtCustomerType = CommonFunction.GetCustomerType();
ASPxListBox lst = this.ddeCustomerType.FindControl("lstCustomerType") as ASPxListBox;
if (lst != null)
{
lst.DataSource = dtCustomerType;
lst.TextField = "CUSTOMER_TYPE";
lst.ValueField = "CUSTOMER_TYPE";
lst.DataBind();
lst.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
private void BindProvidername()
{
DataSet ds = new DataSet();
ASPxListBox lstProviderName = (ASPxListBox)this.ddleProviderName.FindControl("lstProviderName");
ds = loadProvidername(companyId);
lstProviderName.TextField = "DESCRIPTION";
lstProviderName.ValueField = "CODE";
lstProviderName.DataSource = ds;
lstProviderName.DataBind();
DevExpress.Web.ListEditItem Item = new DevExpress.Web.ListEditItem("---Select All---", "NA");
lstProviderName.Items.Insert(0, Item);
//lstProviderName.SelectedIndex = 0;
}
private void BindCaseType()
{
DataSet ds = new DataSet();
ds = loadcaseType(companyId);
ASPxListBox lstCaseType = (ASPxListBox)this.ddleCaseType.FindControl("lstCaseType");
lstCaseType.ValueField = "CODE";
lstCaseType.TextField = "DESCRIPTION";
lstCaseType.DataSource = ds;
lstCaseType.DataBind();
DevExpress.Web.ListEditItem Item = new DevExpress.Web.ListEditItem("---Select All ---", "NA");
lstCaseType.Items.Insert(0, Item);
}
private void BindCarrier()
{
DataSet ds = new DataSet();
ASPxListBox lstCarrier = (ASPxListBox)this.ddleCarrier.FindControl("lstCarrier");
ds = loadCarrier(companyId);
lstCarrier.TextField = "DESCRIPTION";
lstCarrier.ValueField = "CODE";
lstCarrier.DataSource = ds;
lstCarrier.DataBind();
DevExpress.Web.ListEditItem Item = new DevExpress.Web.ListEditItem("---Select All---", "NA");
lstCarrier.Items.Insert(0, Item);
//lstCarrier.SelectedIndex = 0;
}
private void BindSpeciality()
{
DataSet ds = new DataSet();
ASPxListBox lstSpeciality = (ASPxListBox)this.ddleSpeciality.FindControl("lstSpeciality");
ds = loadSpeciality(companyId);
lstSpeciality.TextField = "description";
lstSpeciality.ValueField = "code";
lstSpeciality.DataSource = ds;
lstSpeciality.DataBind();
DevExpress.Web.ListEditItem Item = new DevExpress.Web.ListEditItem("---Select All---", "NA");
lstSpeciality.Items.Insert(0, Item);
//lstSpeciality.SelectedIndex = 0;
}
/// <summary>
/// 产品ID号
/// </summary>
private void BindProductModel()
{
DataTable dtProduct = CommonFunction.GetProId();
ASPxListBox lst = this.ddeProductId.FindControl("lstProductId") as ASPxListBox;
if (lst != null)
{
lst.DataSource = dtProduct;
lst.TextField = "PRODUCT_CODE";
lst.ValueField = "PRODUCT_CODE";
lst.DataBind();
lst.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
protected void ASPxListBox1_Callback(object sender, CallbackEventArgsBase e)
{
ASPxListBox location = sender as ASPxListBox;
string pline = e.Parameter;
string sql = "";
sql = "select A.RMES_ID, A.LOCATION_CODE, A.LOCATION_CODE LOCATION_NAME from code_location a where pline_code = '" + pline + "' and not exists(select * from vw_rel_station_location b where b.pline_id = '" + pline + "' "
+ " and b.location_flag = 'A' and a.location_code=b.location_code and a.pline_code=b.pline_id ) ORDER BY A.LOCATION_CODE ";
DataTable dt = dc.GetTable(sql);
location.DataSource = dt;
location.DataBind();
}
private void BindLawfirm()
{
DataSet ds = new DataSet();
ds = loadLawfirm();
ASPxListBox lstLawfirm = (ASPxListBox)this.ddleLawfirm.FindControl("lstLawfirm");
lstLawfirm.ValueField = "CODE";
lstLawfirm.TextField = "DESCRIPTION";
lstLawfirm.DataSource = ds;
lstLawfirm.DataBind();
DevExpress.Web.ListEditItem Item = new DevExpress.Web.ListEditItem("---Select All---", "NA");
lstLawfirm.Items.Insert(0, Item);
//lstLawfirm.SelectedIndex = 0;
}
protected void listBoxUser_Callback(object sender, CallbackEventArgsBase e)
{
string pline = e.Parameter;
ASPxListBox listUser = sender as ASPxListBox;
string sql = "SELECT A.USER_ID,A.USER_CODE,A.USER_CODE||';'||A.USER_NAME USER_NAME FROM CODE_USER A "
+ " WHERE NOT EXISTS(SELECT * FROM REL_STATION_USER C WHERE C.user_id=A.user_id ) and user_type='B' "
+ " ORDER BY A.USER_CODE";
DataTable dt = dc.GetTable(sql);
listUser.DataSource = dt;
listUser.DataBind();
}
//初始化JHDM
//private void initJHDM()
//{
// string sql = " select distinct b.PLAN_CODE||'--'||b.PLAN_SO AS PLAN_CODE,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b "
// + " where b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') "
// + " AND B.PLINE_CODE = rh_get_data('G','" + txtPCode.Text.Trim() + "','','','') ";
// //string sql = " select distinct b.PLAN_CODE, b.PLAN_SO ,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b WHERE "
// // + " b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') AND "
// // + " B.PLINE_CODE in(select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
// if (txtSO.Text.Trim() != "")
// {
// sql += " AND b.PLAN_SO = '" + txtSO.Text.Trim() + "' ";
// }
// sql += " ORDER BY PLAN_CODE ";
// //sqlJhdm.SelectCommand = sql;
// //sqlJhdm.DataBind();
// DataTable dt = dc.GetTable(sql);
// listJhdm.DataSource = dt;
// listJhdm.DataBind();
//}
//使用callback初始化JHDM
protected void listJhdm_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
string flag = e.Parameter.ToString();
if (flag == "查询计划")
{
//重新查询计划时要把已选的计划号列表清空一下
List1.Items.Clear();
ASPxListBox jhdmList = sender as ASPxListBox;
string sql = " select distinct b.PLAN_CODE||'--'||b.PLAN_SO AS PLAN_CODE,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b "
+ " where b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') ";
if (txtPCode.Text.Trim() != "")
{
sql += " AND b.PLINE_CODE = '" + txtPCode.Value.ToString() + "' ";
}
//string sql = " select distinct b.PLAN_CODE, b.PLAN_SO ,b.PLAN_SEQ, b.PLAN_QTY,b.BEGIN_DATE from DATA_PLAN b WHERE "
// + " b.BEGIN_DATE>=to_date('" + DTPicker1.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') and b.BEGIN_DATE<=to_date('" + DTPicker2.Date.ToString("yyyy/MM/dd") + "','yyyy-MM-dd') AND "
// + " B.PLINE_CODE in(select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ";
if (txtSO.Text.Trim() != "")
{
sql += " AND b.PLAN_SO = UPPER('" + txtSO.Text.Trim() + "') ";
}
sql += " ORDER BY PLAN_CODE ";
//sqlJhdm.SelectCommand = sql;
//sqlJhdm.DataBind();
DataTable dt = dc.GetTable(sql);
jhdmList.DataSource = dt;
jhdmList.DataBind();
}
if (flag == "增加")
{
//DataTable dt = new DataTable();
//dt.Columns.Add("PLAN_CODE");
//if (listJhdm.Items.Count != 0 && listJhdm.Items != null)
//{
// for (int i = 0; i < listJhdm.Items.Count; i++)
// {
// dt.Rows.Add(listJhdm.Items[i].ToString());
// }
//}
//listJhdm.DataSource = dt;
//listJhdm.DataBind();
}
}
/// <summary>
/// 绑定工单
/// </summary>
public void BindWorkOrderNumber(string roomKey)
{
if (roomKey == "ALL")
{
roomKey = string.Empty;
}
DataTable dtWorkOrderNo = CommonFunction.GetLotWorkOrderNumber(roomKey);
ASPxListBox lst = this.ddeWorkOrderNumber.FindControl("lstWorkOrderNumber") as ASPxListBox;
if (lst != null)
{
lst.DataSource = dtWorkOrderNo;
lst.TextField = "WORK_ORDER_NO";
lst.ValueField = "WORK_ORDER_NO";
lst.DataBind();
lst.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
private void BindLine()
{
//DataTable dtLine = CommonFunction.GetLine();
//this.cmbLine.DataSource = dtLine;
//this.cmbLine.DataBind();
//this.cmbLine.Items.Insert(0, new ListEditItem("ALL", "ALL"));
//this.cmbLine.SelectedIndex = 0;
DataTable dtLine = CommonFunction.GetLine();
ASPxListBox lstWO = this.ddeWO.FindControl("lstWO") as ASPxListBox;
if (lstWO != null)
{
lstWO.DataSource = dtLine;
lstWO.TextField = "LINE_NAME";
lstWO.ValueField = "LINE_NAME";
lstWO.DataBind();
lstWO.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}
public void BindWO()
{
DataSet dsWO = CTMFunction.GetWO();
//cobWO.DataSource = dsWO.Tables[0];
//cobWO.TextField = "ORDER_NUMBER";
//cobWO.ValueField = "ORDER_NUMBER";
//cobWO.DataBind();
//cobWO.Items.Insert(0,new ListEditItem("ALL","ALL"));
//cobWO.SelectedIndex = 0;
ASPxListBox lstWO = this.ddeWO.FindControl("lstWO") as ASPxListBox;
if (lstWO != null)
{
lstWO.DataSource = dsWO.Tables[0];
lstWO.TextField = "ORDER_NUMBER";
lstWO.ValueField = "ORDER_NUMBER";
lstWO.DataBind();
lstWO.Items.Insert(0, new ListEditItem("ALL", "ALL"));
}
}