protected void Page_Load(object sender, EventArgs e)
{
theProgramCode = "rept3300";
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
//test
//theUserCode = "ZZ098";
if (!IsPostBack)
{
}
initPlineCode();
setCondition();
System.Data.DataTable dt;
if (Request["opFlag"] == "getEditSeries")
{
string result = "";
string sn = Request["SN"].ToString().Trim();
string plineCode = Request["PLINE_CODE"].ToString().Trim();
string sql = "select SN,PLAN_CODE,PLAN_SO,PLINE_CODE from VW_DATA_PRODUCT where SN = '" + sn + "' "
//+ " and ZDMC='管理' "
//只有返修改制计划的流水号才可以
+ " and PLAN_CODE in (select PLAN_CODE from DATA_PLAN where ( PLAN_TYPE = 'C' OR PLAN_TYPE = 'D') AND PLINE_CODE='" + plineCode + "')";
dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
//??或者是取不到list里的数据，或者是已被清空，待测试 前端是用ClientInstanceName取，后台用ID?
for (int i = 0; i < listLsh.Items.Count; i++)
{
//根据“&”分割出SN
string[] str = listLsh.Items[i].ToString().Trim().Split("&".ToCharArray());
if (sn == str[0])
{
//为1时前端显示“流水号已录入！”
result = "1";
}
}
sn = dt.Rows[0][0].ToString();
string planCode = dt.Rows[0][1].ToString().Trim();
string planSO = dt.Rows[0][2].ToString().Trim();
string plineCode1 = dt.Rows[0][3].ToString();
result = sn + "&" + planCode + "&" + planSO + "&" + plineCode1;
}
else
{
//为0时前端显示“流水号不存在！”
result = "0";
}
this.Response.Write(result);
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part1900";
initCode();
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", whyh = "", whsj = "";
string pcode = Request["Pcode"].ToString().Trim();
if (pcode != "")
{
string sql3 = "select nvl(whyh,' '),nvl(to_char(whsj,'yyyy-mm-dd hh24:mi:ss'),' ') from ms_skip_password where gzdd='" + pcode + "' ";
DataTable dt3 = dc.GetTable(sql3);
if (dt3.Rows.Count > 0)
{
whyh = dt3.Rows[0][0].ToString();
whsj = dt3.Rows[0][1].ToString();
//txtWHYH.Text = whyh;
//txtWHSJ.Text = whsj;
}
}
str1 = whyh + "," + whsj;
this.Response.Write(str1);
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "part2700";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theUserName = theUserManager.getUserName();
//初始查询条件生产线
string Sql = " select distinct a.pline_code,b.pline_name as showtext from vw_user_role_program a left join code_product_line b on a.pline_code=b.pline_code where a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' and a.company_code='" + theCompanyCode + "' ";
comPLQ.DataSource = dc.GetTable(Sql);
comPLQ.DataBind();
//初始查询条件状态
string SqlStatus = " select internal_code,internal_name from code_internal where internal_type_code='013' order by internal_code";
comboStatusQ.DataSource = dc.GetTable(SqlStatus);
comboStatusQ.DataBind();
setCondition();
if (!IsPostBack)
{
//comPLQ.SelectedIndex = comPLQ.Items.Count >= 0 ? 0 : -1;//
StartDateQ.Date = DateTime.Now.AddDays(-1);
EndDateQ.Date = DateTime.Now.AddDays(1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theDisplayProgramName = theUserManager.getProgName();
theDisplayPlineName = theUserManager.getPlineName();
theDisplayUserName = theUserManager.getUserName();
theDisplayCompanyCode = theUserManager.getCompanyCode();
theDisplayProgramCode = theUserManager.getProgCode();
theProgValue = theUserManager.getProgVlaue();
string theMenuCompanyCode = theUserManager.getCompanyCode();
theMenuUserCode = theUserManager.getUserCode();
Response.Cookies["CurrentProgramCode"].Value = theDisplayProgramCode;
////打印
//thePrintSql = (string)Session["thePrintSql"];
//显示提示信息 20071219
//string str = theDisplayPlineName + "-->" + theDisplayUserName + "___" + theDisplayProgramName;
//Response.Write("<script>window.status='" + str + "';</script>");
//theHelpFile = theUrlTemp + "/Rmes/Help/" + theDisplayProgramCode + ".htm";
//考虑以后可能对程序内容做一些处理，暂且定义变量
//string theProgTemp = "";
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
GV_MachineName = hostIPAddress;
//GV_MachineName = System.Net.Dns.GetHostName();
theProgramCode = "epd3700";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
string sql = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
comboPlineCode.DataSource = dc.GetTable(sql);
comboPlineCode.DataBind();
setCondition();
if (!IsPostBack)
{
string sqlD = "DELETE from REL_STATION_PRESTATION_TEMP";
dc.ExeSql(sqlD);
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part1800";
initPlanCode();
initCode();
initMcode();
setCondition();
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", str2 = "";
string MCode = Request["MCODE"].ToString().Trim();
string pcode = Request["Pcode"].ToString().Trim();
if (pcode == "E")
{
str2 = "DCEC-B";
}
else if (pcode == "W")
{
str2 = "DCEC-C";
}
else
{
str2 = "";
}
string sql = "select pt_desc2 from copy_pt_mstr where pt_part='" + MCode + "'";
dc.setTheSql(sql);
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count == 0)
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
string strMCode = dc.GetTable().Rows[0][0].ToString();
if (strMCode == "")
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
else
{
str1 = strMCode;
}
str1 = str1 + "," + str2;
this.Response.Write(str1);
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part1600";
//initRLocation();
initCode();
setCondition();
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", str2 = "";
string RLOCATION = Request["RLOCATION"].ToString().Trim();
string pcode = Request["Pcode"].ToString().Trim();
if (pcode != "R" && pcode != "L")
{
str2 = RLOCATION;
}
else
{
str2 = "";
}
if (pcode == "L")
{
string sql = "select PLINE_CODE from code_product_line where pline_code='E' OR PLINE_CODE='W'";
DataTable dt = dc.GetTable(sql);
string Rgzdd1 = dt.Rows[0][0].ToString();
string Rgzdd2 = dt.Rows[1][0].ToString();
str1 = str1 + Rgzdd1 + "@" + Rgzdd2;
}
else if (pcode != "R")
{
string sql = "select PLINE_CODE from code_product_line where pline_code ='" + pcode + "'";
DataTable dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
string code1 = dt.Rows[i][0].ToString();
//string code2 = dt.Rows[i][1].ToString();
str1 = str1 + "@" + code1;
}
//str1 = str1 + "@" + pcode;
}
else
{
string sql = "select PLINE_CODE from code_product_line where pline_code='E'OR PLINE_CODE='W' OR PLINE_CODE='R'";
DataTable dt = dc.GetTable(sql);
string Rgzdd1 = dt.Rows[0][0].ToString();
string Rgzdd2 = dt.Rows[1][0].ToString();
string Rgzdd3 = dt.Rows[2][0].ToString();
str1 = Rgzdd1 + "@" + Rgzdd2 + "@" + Rgzdd3;
}
str1 = str1 + "," + str2;
this.Response.Write(str1);
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserCode = theUserManager.getUserCode();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserCode = theUserManager.getUserCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "inv9900";
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit2.Date = DateTime.Now.AddDays(1);
}
initCode();
initYG();
initFrom();
setCondition();
//if (Request["opFlag"] == "getBatch")
//{
// string str1 = "", str2 = "", str = "", rc = "", str3 = "";
// string DateEdit1 = Request["DATEEDIT1"].ToString().Trim();
// string DateEdit2 = Request["DATEEDIT2"].ToString().Trim();
// string Chose = Request["CHOSE"].ToString().Trim();
// string PCode = Request["PCODE"].ToString().Trim();
// //Server.UrlDecode（request.form["a"].ToString()）
// DateTime dt1 = Convert.ToDateTime(DateEdit1);
// DateTime dt2 = Convert.ToDateTime(DateEdit2);
// dt1.AddDays(30);
// if (Chose == "RK") { rc = "入库"; }
// else { rc = "出库"; }
// if (dt1.AddDays(30) < dt2)
// {
// str1 = "Overtime";
// }
// else
// {
// str1 = "ok";
// string sql = "select distinct gzrq from dp_rckwcb where to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + DateEdit1 + "', 'yyyy-mm-dd hh24:mi:ss') and to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + DateEdit2 + "', 'yyyy-mm-dd hh24:mi:ss') AND GZDD='" + PCode + "' and Rc='" + rc + "' order by Gzrq";
// DataTable dt = dc.GetTable(sql);
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// string batch = dt.Rows[i][0].ToString();
// str2 = str2 + "@" + batch;
// }
// }
// str = str1 + "," + str2 + "," + str3;
// this.Response.Write(str);
// this.Response.End();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theusercode = theUserManager.getUserCode();
theProgramCode = "ssd3100";
SetCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "epdQualityAlert";
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theUserName = theUserManager.getUserName();
theProgramCode = "inv9400";
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit3.Date = DateTime.Now.AddDays(1);
Session["inv9400sql"] = "";
}
initCode();
if (Session["inv9400sql"] as string != "")
{
DataTable dt = dc.GetTable(Session["inv9400sql"] as string);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
}
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", str2 = "", str = "", str3 = "";
string lsh = Request["LSH"].ToString().Trim();
//string qad = Request["QAD"].ToString().Trim();
string sql = "select PLAN_SO,PLAN_CODE from DATA_PRODUCT where SN='" + lsh + "'";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
str1 = dt.Rows[0][0].ToString();
str2 = dt.Rows[0][1].ToString();
}
string sql2 = "select t.station_code from data_store t where t.SN='" + lsh + "'";
DataTable dt2 = dc.GetTable(sql2);
if (dt2.Rows.Count > 0)
{
str3 = dt2.Rows[0][0].ToString();
}
str = str1 + "," + str2 + "," + str3;
this.Response.Write(str);
this.Response.End();
}
//if (Session["inv9400sql"] as string != "")
//{
// DataTable dt = dc.GetTable(Session["inv99400sql"] as string);
// ASPxGridView1.DataSource = dt;
// ASPxGridView1.DataBind();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "epd3600";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
queryFunction();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part1300";
initLocation();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part1200";
OracleSQLTime = DB.GetInstance().ExecuteScalar <DateTime>("Select sysdate from dual");
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "atpu1500";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
//初始化新增模版里生产线下拉列表
initCode();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
if (!IsPostBack)
{
//OracleEntityTime = DB.GetServerTime();
OracleSQLTime = DB.GetInstance().ExecuteScalar <DateTime>("Select sysdate from dual");
}
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "qms1300";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
string sql = "select RMES_ID PLINE_CODE,PLINE_NAME from code_product_line where pline_code in ( select distinct pline_code from vw_user_role_program t where company_code='" + theCompanyCode + "' and program_code='" + theProgramCode + "' and user_id='" + theUserId + "' )";
sqlPline.SelectCommand = sql;
sqlPline.DataBind();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "epd3600";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
string sql = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
comboPlineCode.DataSource = dc.GetTable(sql);
comboPlineCode.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "atpu2000";
setCondition();
initSO();
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
GV_MachineName = hostIPAddress;
//GV_MachineName = System.Net.Dns.GetHostName();
theProgramCode = "epd3400";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
string sql = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
comboPlineCode.DataSource = dc.GetTable(sql);
comboPlineCode.DataBind();
SetCondition();
if (!IsPostBack)
{
comboPlineCode.SelectedIndex = 0;
string sql23 = "select RMES_ID,STATION_NAME from CODE_STATION where PLINE_CODE='" + comboPlineCode.Value.ToString() + "' order by STATION_NAME";
DataTable dt = dc.GetTable(sql23);
comboStationCode.DataSource = dt;
comboStationCode.ValueField = "RMES_ID";
comboStationCode.TextField = "STATION_NAME";
comboStationCode.DataBind();
sql = "select A.RMES_ID, A.LOCATION_CODE, A.LOCATION_CODE LOCATION_NAME from code_location a where pline_code = '" + comboPlineCode.Value.ToString() + "' and not exists(select * from vw_rel_station_location b where b.pline_id = '" + comboPlineCode.Value.ToString() + "' "
+ " 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 dt1 = dc.GetTable(sql);
ASPxListBox1.DataSource = dt1;
ASPxListBox1.DataBind();
string sqlD = "DELETE from REL_STATION_LOCATION_TEMP";
dc.ExeSql(sqlD);
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "epd3400";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
string sql = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
comboPlineCode.DataSource = dc.GetTable(sql);
comboPlineCode.DataBind();
//string sql1 = "select INTERNAL_CODE,INTERNAL_NAME from CODE_INTERNAL where COMPANY_CODE='" + theCompanyCode + "' AND INTERNAL_TYPE_CODE='001' order by INTERNAL_CODE desc";
//locationPro.DataSource = dc.GetTable(sql1);
//locationPro.DataBind();
if (!IsPostBack)
{
comboPlineCode.SelectedIndex = 0;
string sql23 = "select RMES_ID,STATION_NAME from CODE_STATION where PLINE_CODE='" + comboPlineCode.Value.ToString() + "' order by STATION_NAME";
DataTable dt = dc.GetTable(sql23);
comboStationCode.DataSource = dt;
comboStationCode.ValueField = "RMES_ID";
comboStationCode.TextField = "STATION_NAME";
comboStationCode.DataBind();
string sql2 = "SELECT A.RMES_ID,A.LOCATION_CODE,A.LOCATION_CODE LOCATION_NAME FROM CODE_LOCATION A WHERE location_code not in (select location_code from vw_rel_station_location ) ORDER BY A.LOCATION_CODE";
DataTable dt2 = dc.GetTable(sql2);
ASPxListBox1.DataSource = dt2;
ASPxListBox1.ValueField = "RMES_ID";
ASPxListBox1.TextField = "LOCATION_NAME";
ASPxListBox1.DataBind();
//sql = "SELECT A.RMES_ID,A.LOCATION_CODE,A.LOCATION_CODE LOCATION_NAME FROM CODE_LOCATION A WHERE location_code not in (select location_code from vw_rel_station_location where pline_id='" + comboPlineCode.Value.ToString() + "' and location_flag='A' ) and pline_code='" + comboPlineCode.Value.ToString() + "' ORDER BY A.LOCATION_CODE";
sql = "select A.RMES_ID, A.LOCATION_CODE, A.LOCATION_CODE LOCATION_NAME from code_location a where pline_code = '" + comboPlineCode.Value.ToString() + "' and not exists(select * from vw_rel_station_location b where b.pline_id = '" + comboPlineCode.Value.ToString() + "' "
+ " and b.location_flag = 'A' and a.location_code=b.location_code and a.pline_code=b.pline_id ) ORDER BY A.LOCATION_CODE";
dt = dc.GetTable(sql);
ASPxListBox1.DataSource = dt;
ASPxListBox1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserCode = theUserManager.getUserCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "part1700";
if (!IsPostBack)
{
ASPxDateEdit2.Date = DateTime.Now;
ASPxDateEdit1.Date = DateTime.Now.AddDays(-1);
}
initCode();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part1400";
initPlanCode();
initPlineCode();
setCondition();
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit3.Date = DateTime.Now.AddDays(1);
}
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", str2 = "";
string pcode = Request["PCode"].ToString().Trim();
string plancode = Request["PlanCode"].ToString().Trim();
string sql = "select PLAN_SO,PLAN_QTY from data_plan where pline_code='" + pcode.ToUpper() + "' and plan_code='" + plancode.ToUpper() + "'";
dc.setTheSql(sql);
if (dc.GetTable().Rows.Count == 0)
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
string Pqty = dc.GetTable().Rows[0][1].ToString();
string Pso = dc.GetTable().Rows[0][0].ToString();
if (Pso == "")
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
str1 = Pso;
str2 = Pqty;
str1 = str1 + "," + str2;
this.Response.Write(str1);
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "epd3900";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
queryFunction();
setCondition();
string plineSql = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
SqlDataSource1.SelectCommand = plineSql;
SqlDataSource1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theUserCode = theUserManager.getUserCode();
theProgramCode = "atpu1B00";
setCondition();
string sql2 = "select distinct tjlx from dmtjb order by tjlx";
SqlDataSource2.SelectCommand = sql2;
SqlDataSource2.DataBind();
//SO合法性判断begin
if (Request["opFlag"] == "getEditSO")
{
string str1 = "";
string strSO = Request["SoC"].ToString();
string sql = "SELECT SO FROM copy_engine_property where SO='" + strSO + "'";
dc.setTheSql(sql);
if (dc.GetTable().Rows.Count == 0)
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
string strSO1 = dc.GetTable().Rows[0][0].ToString();
if (strSO == "")
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
str1 = strSO1;
this.Response.Write(str1);
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
theProgramCode = "part2800";
//GV_MachineName = GV_MachineName = System.Net.Dns.GetHostName();
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
//MachineName = System.Web.HttpContext.Current.Request.UserHostAddress;
GV_MachineName = hostIPAddress;
string sql = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
comboPlineCode.DataSource = dc.GetTable(sql);
comboPlineCode.DataBind();
if (!IsPostBack)
{
//ASPxGridView4.Visible = false;
//ASPxGridView5.Visible = false;
string dsql = "delete from DATA_SN_TEMP";
dc.ExeSql(dsql);
}
//if (!IsPostBack)
//{
// comboPlineCode.SelectedIndex = comboPlineCode.Items.Count >= 0 ? 0 : -1;
// string sql2 = "select PLAN_CODE from DATA_PLAN where PLINE_CODE='" + comboPlineCode.Value.ToString() + "' and BEGIN_DATE>sysdate-100 order by BEGIN_DATE,PLAN_CODE";
// comboPlanCode.DataSource = dc.GetTable(sql2);
// comboPlanCode.DataBind();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserCode = theUserManager.getUserCode();
theUserName = theUserManager.getUserName();
theUserId = theUserManager.getUserId();
this.txtUserCode.Text = theUserCode;
this.txtUserName.Text = theUserName;
this.txtUserCode.Enabled = false;
this.txtUserName.Enabled = false;
TextBoxOldPass.Focus();
getPassword();
//string a = thePubCs.AESDecrypt("VxFs8B7jBINGy8nozGdmqJmxBmbIIiuekpQAT9FFlpY=");
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theProgramCode = "atpu1E00";
theUserId = theUserManager.getUserId();
theUserCode = theUserManager.getUserCode();
//string Sql2 = "SELECT STATION_CODE,STATION_NAME FROM CODE_STATION order by STATION_CODE ";
//SqlDataSource2.SelectCommand = Sql2;
//SqlDataSource2.DataBind();
string Sql4 = "select a.pline_code,b.rmes_id,b.pline_name from VW_USER_ROLE_PROGRAM a "
+ "left join code_product_line b on a.pline_code=b.pline_code "
+ "where a.COMPANY_CODE = '" + theCompanyCode + "' and a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' order by b.PLINE_NAME";
SqlDataSource4.SelectCommand = Sql4;
SqlDataSource4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theUserCode = theUserManager.getUserCode();
programcode = "ssd2200";
if (!IsPostBack)
{
}
if (Request["opFlag"] == "getPlan")
{
string str1 = "";
string plancode = Request["PLAN"].ToString();
string sql = "select plan_so,plan_qty from data_plan where plan_code='" + plancode.ToUpper() + "'";
dc.setTheSql(sql);
if (dc.GetTable().Rows.Count == 0)
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
string planso = dc.GetTable().Rows[0][0].ToString();
string planqty = dc.GetTable().Rows[0][1].ToString();
if (planso == "")
{
str1 = "";
this.Response.Write(str1);
this.Response.End();
return;
}
str1 = planso + "," + planqty;
this.Response.Write(str1);
this.Response.End();
}
setCondition();
}
