public void BindProID()
{
DataSet dsProID = CTMFunction.GetProID();
cobProID.DataSource = dsProID.Tables[0];
cobProID.TextField = "PRODUCT_CODE";
cobProID.ValueField = "PRODUCT_CODE";
cobProID.DataBind();
cobProID.Items.Insert(0, new ListEditItem("ALL", "ALL"));
cobProID.SelectedIndex = 0;
}
public void BindFactory()
{
DataSet dsFactory = CTMFunction.GetFactoryWorkPlace();
cobFactory.DataSource = dsFactory.Tables[0];
cobFactory.TextField = "LOCATION_NAME";
cobFactory.ValueField = "LOCATION_KEY";
cobFactory.DataBind();
cobFactory.Items.Insert(0, new ListEditItem("ALL", "ALL"));
cobFactory.SelectedIndex = 0;
}
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"));
}
}
protected void btnQuery_Click(object sender, EventArgs e)
{
string sFactoryKey, sProID, sWO, sStartSN, sEndSN, sStartDate, sEndDate, sDeviceNo, sDefault;
sFactoryKey = Convert.ToString(cobFactory.Value);
sProID = Convert.ToString(cobProID.Value);
//sWO = Convert.ToString(cobWO.Value);
sWO = ddeWO.Text.Trim();
sStartSN = txtStartSN.Text.Trim();
sEndSN = txtEndSN.Text.Trim();
sStartDate = dStartDate.Text;
sEndDate = dEndDate.Text;
sDeviceNo = txtDeviceNo.Text.Trim();
if (sFactoryKey == "ALL")
{
sFactoryKey = "";
}
if (sProID == "ALL")
{
sProID = "";
}
if (!string.IsNullOrEmpty(sStartDate))
{
sStartDate = Convert.ToDateTime(sStartDate).ToString("yyy-MM-dd") + " 00:00:00";
}
if (!string.IsNullOrEmpty(sEndDate))
{
sEndDate = Convert.ToDateTime(sEndDate).ToString("yyyy-MM-dd") + " 23:59:59";
}
if (chDefault.Checked == true)
{
sDefault = "1";
}
else
{
sDefault = "0";
}
string partNumber = this.txtPartNumber.Text;
if (partNumber.ToUpper() == "ALL")
{
partNumber = string.Empty;
}
if (sFactoryKey == "" && sProID == "" && sWO == "" && sStartSN == "" && sEndSN == "" && sStartDate == "" && sEndDate == "" && sDeviceNo == "")
{
base.ShowMessageBox(this.Page, "查询参数不能都为空！");
return;
}
try
{
CTMFunction ctmFunction = new CTMFunction();
DataSet dsCTM = ctmFunction.GetCTMListData(sFactoryKey, sProID, sWO, partNumber, sStartSN, sEndSN, sStartDate, sEndDate, sDeviceNo, sDefault);
Cache[Session.SessionID + "CTM"] = dsCTM.Tables[0];
this.gvCTMRport.Columns.Clear();
this.gvCTMRport.AutoGenerateColumns = true;
this.gvCTMRport.DataSource = dsCTM.Tables[0];
this.gvCTMRport.DataBind();
this.gvCTMRport.AutoGenerateColumns = false;
this.UpdatePanelResult.Update();
}
catch (Exception ex)
{
base.ShowMessageBox(this.Page, "错误：" + ex.Message);
return;
}
}
