protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theProgramCode = "ssd1200";
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit2.Date = DateTime.Now;
List <ProductLineEntity> user_plines = ProductLineFactory.GetByUserID(theUserManager.getUserId(), theProgramCode);
ASPxComboBoxPline.DataSource = user_plines;
ASPxComboBoxPline.TextField = "PLINE_NAME";
ASPxComboBoxPline.ValueField = "PLINE_CODE";
ASPxComboBoxPline.DataBind();
}
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
programcode = "ssd2101";
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now;
List <ProductLineEntity> user_plines = ProductLineFactory.GetByUserID(theUserManager.getUserId(), programcode);
ASPxComboBoxPline.DataSource = user_plines;
ASPxComboBoxPline.TextField = "PLINE_NAME";
ASPxComboBoxPline.ValueField = "PLINE_CODE";
ASPxComboBoxPline.DataBind();
ASPxComboBoxPline.SelectedIndex = 0;
}
//string sql1 = "select rmes_id,plan_code,plan_so,plan_qty,pline_code from data_plan where pline_code='" + ASPxComboBoxPline.SelectedItem.Value.ToString() + "' and begin_date=to_date('" + ASPxDateEdit1.Date.ToString("yyyy-MM-dd") + "','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();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
programcode = "ssd1041";
if (!IsPostBack)
{
List<ProductLineEntity> user_plines = ProductLineFactory.GetByUserID(theUserManager.getUserId(), programcode);
ASPxComboBoxPline.DataSource = user_plines;
ASPxComboBoxPline.TextField = "PLINE_NAME";
ASPxComboBoxPline.ValueField = "PLINE_CODE";
ASPxComboBoxPline.DataBind();
ASPxComboBoxPline.SelectedIndex = 0;
List<ProductLineEntity> plines = ProductLineFactory.GetAll();
ASPxComboBoxProcess.DataSource = plines;
ASPxComboBoxProcess.TextField = "PLINE_NAME";
ASPxComboBoxProcess.ValueField = "PLINE_CODE";
ASPxComboBoxProcess.DataBind();
ASPxComboBoxProcess.Value = ASPxComboBoxPline.Value;
//string sql = "select ALINE_CODE,ALINE_NAME from atpu_acrossline";
//dc.setTheSql(sql);
//ASPxComboBoxAcross.DataSource = dc.GetTable();
//ASPxComboBoxAcross.TextField = "ALINE_NAME";
//ASPxComboBoxAcross.ValueField = "ALINE_CODE";
//ASPxComboBoxAcross.DataBind();
//ASPxComboBoxAcross.SelectedIndex = 0;
string sql = "select * from code_station t left join code_station_type a on t.station_type=a.station_type_code where a.station_type_name like '%拆解%' and t.pline_code in (select pline_code from rel_user_pline where user_id='" + theUserManager.getUserId() + "') ";
dc.setTheSql(sql);
CJZD.DataSource = dc.GetTable();
CJZD.TextField = "STATION_NAME";
CJZD.ValueField = "STATION_TYPE";
CJZD.DataBind();
CJZD.SelectedIndex = 0;
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit2.Date = DateTime.Now.AddDays(5);
ASPxBeginDate.Date = DateTime.Now;
ASPxEndDate.Date = DateTime.Now.AddDays(5);
}
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "";
string so = Request["SO"].ToString();
string sql = "select jx,config from copy_engine_property where SO='" + so.ToUpper() + "'";
dc.setTheSql(sql);
if (dc.GetTable().Rows.Count == 0)
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
string config1 = dc.GetTable().Rows[0][1].ToString();
string jx1 = dc.GetTable().Rows[0][0].ToString();
if (jx1 == "")
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
if (jx1.EndsWith("ZZ"))
{
jx1 = jx1.Substring(0, jx1.Length - 2);
}
str1 = jx1;
sql = "select GET_CSKD('" + so + "') from dual";
dc.setTheSql(sql);
string bz1 = dc.GetValue().ToString();
str1 = str1 + "," + bz1;
this.Response.Write(str1);
this.Response.End();
}
string plineSql = "SELECT a.PLINE_CODE,a.PLINE_NAME FROM CODE_PRODUCT_LINE a left join rel_user_pline b on a.rmes_id=b.PLINE_CODE "
+ " WHERE a.COMPANY_CODE='" + theCompanyCode + "' AND b.USER_ID='" + theUserId + "' order by a.pline_code";
SqlDataSource1.SelectCommand = plineSql;
SqlDataSource1.DataBind();
string plineSql1 = "SELECT ALINE_CODE,ALINE_NAME FROM atpu_acrossline ";
SqlDataSource2.SelectCommand = plineSql1;
SqlDataSource2.DataBind();
string plineSql2 = "select * from code_station t left join code_station_type a on t.station_type=a.station_type_code where a.station_type_name like '%拆解%' and t.pline_code in (select pline_code from rel_user_pline where user_id='" + theUserManager.getUserId() + "') ";
SqlDataSource3.SelectCommand = plineSql2;
SqlDataSource3.DataBind();
setCondition();
}
