protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
//获取MachineName
//MachineName = System.Net.Dns.GetHostName();
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
MachineName = hostIPAddress;
theProgramCode = "rept3400";
//ASPxListBoxPart1.Attributes.Add("ondblclick", "ListBoxDblClick(this);");
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now;
ASPxDateEdit2.Date = DateTime.Now.AddDays(1);
}
//if (Session["rept3400table"] as DataTable != null)
//{
// ASPxGridView1.DataSource = Session["rept3400table"];
// ASPxGridView1.DataBind();
//}
initCode();
setCondition();
ASPxListBoxUnused_Init();
//ASPxListBoxUnused.ClientSideEvents.ItemDoubleClick = "function(s,e) {var index = ListBoxUnused.GetSelectedIndex();if(index!=-1) ListBoxUnused.RemoveItem(index);}";
ASPxListBoxUsed.ClientSideEvents.ItemDoubleClick = "function(s,e) {var index = ListBoxUsed.GetSelectedIndex();if(index!=-1){ ListBoxUsed.RemoveItem(index);}}";
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
//获取MachineName
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
MachineName = hostIPAddress;
//MachineName = System.Net.Dns.GetHostName();
theProgramCode = "inv8600";
//ASPxListBoxPart1.Attributes.Add("ondblclick", "ListBoxDblClick(this);");
if (!IsPostBack)
{
//放在外面每次都初始化
ToRq.Date = DateTime.Now;
txtPCode.Value = "E";
initPlineCode();
}
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "inv1100";
v_CurrentBatchId = "%";
GV_MachineName = System.Net.Dns.GetHostName();
if (comboPline.Value != null)
{
GV_Depot = comboPline.Value.ToString();
}
//根据登录人员去初始化生产线
//string sqlNew = "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";
string sqlNew = "select depotid pline_code,depotname pline_name from dp_dmdepot ";
//+ "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";
comboPline.DataSource = dc.GetTable(sqlNew);
comboPline.DataBind();
//初始化入库类型
string SQlstr = "SELECT lxmc FROM DP_rklx where lxdm like 'I%' ORDER BY lxdm";
comboRKLX.DataSource = dc.GetTable(SQlstr);
comboRKLX.TextField = "LXMC";
comboRKLX.ValueField = "LXMC";
comboRKLX.DataBind();
SqlRklx.SelectCommand = "SELECT lxmc FROM DP_rklx where lxdm like 'I%' ORDER BY lxdm";
//初始化员工
string sql = "SELECT ygmc FROM DP_ygb ORDER BY ygmc";
comboUser.DataSource = dc.GetTable(sql);
comboUser.TextField = "YGMC";
comboUser.ValueField = "YGMC";
comboUser.DataBind();
//初始化柳汽标识
string sqlL = "SELECT internal_code,internal_name FROM code_internal where internal_type_code='010' ORDER BY internal_code";
comboJCJ.DataSource = dc.GetTable(sqlL);
comboJCJ.ValueField = "internal_name";
comboJCJ.TextField = "internal_name";
comboJCJ.DataBind();
initBatch();
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 btnDelete_Click(object sender, EventArgs e)
{
//ASPxGridView atl1 = (ASPxGridView)sender;
List <object> rowid = grid.GetSelectedFieldValues("ROWID");
//List<object> planCode = grid.GetSelectedFieldValues("JHDM");
//List<object> oldPart = grid.GetSelectedFieldValues("LJDM1");
//List<object> newPart = grid.GetSelectedFieldValues("LJDM2");
//List<object> SO = grid.GetSelectedFieldValues("SO");
//List<object> locationCode = grid.GetSelectedFieldValues("GWMC");
//List<object> isTrue = grid.GetSelectedFieldValues("ISTRUE");
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
string companyCode = theUserManager.getCompanyCode();
for (int i = 0; i < rowid.Count; i++)
{
string planCode = dc.GetValue("select jhdm from sjbomsoth where rowid='" + rowid[i].ToString() + "'");
string SO = dc.GetValue("select SO from sjbomsoth where rowid='" + rowid[i].ToString() + "'");;
string oldPart = dc.GetValue("select LJDM1 from sjbomsoth where rowid='" + rowid[i].ToString() + "'");;
string newPart = dc.GetValue("select LJDM2 from sjbomsoth where rowid='" + rowid[i].ToString() + "'");;
string locationCode = dc.GetValue("select GWMC from sjbomsoth where rowid='" + rowid[i].ToString() + "'");
string sql = "select IS_JHOFFLINE('" + planCode.ToString() + "','" + SO.ToString()
+ "','" + plineCode.ToString() + "') from dual";
if (dc.GetValue(sql) == "1")
{
Response.Write("<script>alert('计划已经全部下线,不能删除');</script>");
continue;
}
sql = "select IS_JHONLINE('" + planCode.ToString() + "','" + SO.ToString()
+ "','" + plineCode + "') from dual";
//yxh 修改 增加未确认的直接删除逻辑
{
}
//如果已经确认，删除将提交确认流程 xuying 2016.9.9
//if (isTrue[i].ToString() == "1") {
if (dc.GetValue(sql) == "1")
{
Response.Write("<script>alert('计划已上线，进入审批流程');</script>");
BomReplaceFactory.MW_MODIFY_SJBOMTHCFM_DEL("ADD", planCode.ToString(), SO.ToString(), oldPart.ToString(),
newPart.ToString(), userName, locationCode.ToString(), plineCode);
}
else
{
sql = "delete FROM SJBOMSOTH WHERE JHDM='" + planCode.ToString() + "' and ljdm1='" + oldPart.ToString()
+ "' and ljdm2='" + newPart.ToString() + "' and so='" + SO.ToString() + "' AND GWMC='" + locationCode.ToString()
+ "' AND GZDD='" + plineCode + "' and ygmc='" + userName + "'";
dc.ExeSql(sql);
}
}
setCondition("");
}
protected void ASPxGridView2_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
BomReplaceFactory.MW_CREATE_BOMCOMPRST("NOOP", txtSO1.Text, txtPlanCode1.Text, txtSO2.Text, txtPlanCode2.Text, userName);
//显示改制bom
initBom();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
userName = theUserManager.getUserName();
if (!IsPostBack)
{
listPlan.ClientSideEvents.ItemDoubleClick = "function(s,e) {var index = listPlan.GetSelectedIndex();if(index!=-1) listPlan.RemoveItem(index);}";
}
}
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();
theTime = DateTime.Now;
theUserId = theUserManager.getUserName();
theUserCode = theUserManager.getUserCode();
setCondition();
}
protected void BtnConfirm_Click(object sender, EventArgs e)
{
//一对一替换确定
string thisPart = cmbPart1.Text.Trim().ToUpper(); // cmbPart.Value.ToString();
string thisPartNew = cmbPartNew1.Text.Trim().ToUpper(); //cmbPartNew.Value.ToString();
string check1 = CheckNoQAD.Value.ToString().ToUpper();
//校验零件
string sql = "select count(1) from copy_pt_mstr where pt_phantom=0 and pt_status in ('a','A','b','B','d','D','e','E','l','L','m','M','p','P','t','T') and pt_group in ('raw','RAW','M') and upper(pt_part)='" + thisPart + "'";
if (dc.GetValue(sql) == "0")
{
Response.Write("<script>alert('BOM零件" + thisPart + "非法！');</script>");
return;
}
if (check1 == "TRUE")
{
sql = "select count(1) from atpubkflpart t where gzdd='" + cmbPline.Value.ToString() + "' and part_type='1' and upper(part)='" + thisPartNew + "'";
if (dc.GetValue(sql) == "0")
{
Response.Write("<script>alert('替换零件" + thisPartNew + "非法！');</script>");
return;
}
}
else
{
sql = "select count(1) from copy_pt_mstr where pt_phantom=0 and pt_status in ('a','A','b','B','d','D','e','E','l','L','m','M','p','P','t','T') and pt_group in ('raw','RAW','M') and upper(pt_part)='" + thisPartNew + "'";
if (dc.GetValue(sql) == "0")
{
Response.Write("<script>alert('替换零件" + thisPartNew + "非法！');</script>");
return;
}
}
string thisPe = txtPe.Text.Trim();
//站点
string thisSite = cmbPline.Value.ToString();
//登录人
userManager theUserManager = (userManager)Session["theUserManager"];
string userNmae = theUserManager.getUserName();
string thisFromDate = DateFrom.Date.ToString("yyyy-MM-dd");
string thisToDate = DateTo.Date.ToString("yyyy-MM-dd");
string thisXL = txtXl.Text.Trim();
for (int i = 0; i < ListConfig.Items.Count; i++)
{
string thisSO = ListConfig.Items[i].Value.ToString().ToUpper();
BomReplaceFactory.MW_MODIFY_SJBOMTHSET("ADD", thisPart, thisPartNew, thisSO, thisPe, thisSite, userNmae, thisFromDate, thisToDate, "", "0", thisXL);
}
Response.Write("<script>alert('新增成功！');window.opener.location.href = '../mmsReplaceRelationshipSet/mmsReplaceRelationshipSet.aspx';window.location.href = '../mmsReplaceRelationshipSet/mmsReplaceRelationshipSetNew.aspx';</script>");
}
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 = "atpu1E00";
setCondition();
}
protected void btnSave_Click(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
string sql11 = "select nvl(item_flag,'N') from data_plan where plan_code='" + Request["planCode"].ToString() + "' ";
if (dc.GetValue(sql11) == "Y")
{
showAlert(this, "计划已库房确认，不能替换！");
return;
}
//先删除
BomReplaceFactory.MW_INSERT_SJBOMSOTHMUTI("DELETE", Request["so"].ToString(), "", "", userName, Request.UserHostAddress,
Request["planCode"].ToString(), "", "", "", Request["plineCode"].ToString(), cmbGroup.Text, "", "");
//逐条新增
string sql = "select distinct a.oldpart ,b.pt_desc2 oldpart_name, a.newpart ,c.pt_desc2 newpart_name,a.sl from sjbomthset a"
+ " left outer join copy_pt_mstr b on a.oldpart=b.pt_part"
+ " left outer join copy_pt_mstr c on a.newpart=c.pt_part"
+ " left join DATA_PLAN_STANDARD_BOM d on a.oldpart = d.item_code and plan_code='" + Request["planCode"].ToString() + "' "
+ " where (so='" + Request["so"].ToString() + "' or so='" + thgxjx
+ "') and settype='1' and usetime<=to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd') and endtime>=to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd') and thgroup='" + cmbGroup.Text + "'";
DataTable dt = dc.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
string locationcode1 = dc.GetValue("select location_code from (select location_code from DATA_PLAN_STANDARD_BOM where plan_code='" + Request["planCode"].ToString() + "' and item_code='" + dt.Rows[i]["oldpart"].ToString() + "' order by location_code) where rownum=1 ");
BomReplaceFactory.MW_INSERT_SJBOMSOTHMUTI("ADD", Request["so"].ToString(), dt.Rows[i]["oldpart"].ToString(),
dt.Rows[i]["newPart"].ToString(), userName, Request.UserHostAddress, Request["planCode"].ToString(),
locationcode1, locationcode1, "", Request["plineCode"].ToString(), cmbGroup.Text,
dt.Rows[i]["sl"].ToString(), "");
}
initGrid2();
////逐条新增
//string sql = "select a.oldpart ,b.pt_desc2 oldpart_name, a.newpart ,c.pt_desc2 newpart_name,a.sl,d.location_code from sjbomthset a"
// + " left outer join copy_pt_mstr b on a.oldpart=b.pt_part"
// + " left outer join copy_pt_mstr c on a.newpart=c.pt_part"
// + " left join DATA_PLAN_STANDARD_BOM d on a.oldpart = d.item_code and plan_code='" + Request["planCode"].ToString() + "' "
// + " where (so='" + Request["so"].ToString() + "' or so='" + thgxjx
// + "') and settype='1' and usetime<=to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd') and endtime>=to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd') and thgroup='" + cmbGroup.Text + "'";
//DataTable dt = dc.GetTable(sql);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// BomReplaceFactory.MW_INSERT_SJBOMSOTHMUTI("ADD", Request["so"].ToString(), dt.Rows[i]["oldpart"].ToString(),
// dt.Rows[i]["newPart"].ToString(), userName, Request.UserHostAddress, Request["planCode"].ToString(),
// dt.Rows[i]["location_code"].ToString(), dt.Rows[i]["location_code"].ToString(), "", Request["plineCode"].ToString(), cmbGroup.Text,
// dt.Rows[i]["sl"].ToString(), "");
//}
}
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
//判断是否有人在转换,如果是退出，提示随后再加
string sql = "select bomrunning,bomuser from atpusysstate1";
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == "1")
{
return;
}
}
//加入转换用户
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
sql = "update atpusysstate1 set bomuser='******',bomrunning=1";
//删除原来记录
sql = "DELETE FROM RST_QAD_MOVEPART";
dc.ExeSql(sql);
string MachineName = Request.UserHostAddress;
//批量生成
if (listPlan.Items.Count > 0)
{
for (int i = 0; i < listPlan.Items.Count; i++)
{
string str = listPlan.Items[i].Text;
string[] strs = str.Split(';');
string planCode = strs[0].ToString();
string so = strs[1].ToString();
string qty = strs[2].ToString();
BomReplaceFactory.QAD_CREATE_MOVEPART_LQ2(cmbPline.Value.ToString(), so, planCode, qty);
}
}
string qadsite = dc.GetValue("select FUNC_GET_PLANSITE( '" + cmbPline.Value.ToString() + "', 'D') from dual");
sql = "SELECT ABOM_COMP ,ABOM_WKCTR ,ABOM_KW ,SUM(ABOM_QTY) QTY1 from rst_qad_movepart WHERE gzdd='" + qadsite
+ "' GROUP BY ABOM_COMP,ABOM_WKCTR,ABOM_KW ORDER BY ABOM_COMP,ABOM_WKCTR";
//sql = "SELECT ABOM_COMP ,ABOM_WKCTR ,ABOM_KW ,SUM(ABOM_QTY) QTY1 from rst_qad_movepart WHERE abom_user='******' GROUP BY ABOM_COMP,ABOM_WKCTR,ABOM_KW ORDER BY ABOM_COMP,ABOM_WKCTR";
Session["mmsMaterialMoveLineside001"] = sql;
ASPxGridView1.DataSource = dc.GetTable(sql);
ASPxGridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserName = theUserManager.getUserName();
theUserId = theUserManager.getUserId();
theProgramCode = "rept2500";
MachineName = System.Net.Dns.GetHostName();
if (!IsPostBack)
{
}
initCode();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
plineCode = Request["plineCode"].ToString();
userManager theUserManager = (userManager)Session["theUserManager"];
userName = theUserManager.getUserName();
if (!IsPostBack)
{
DatePlan.Date = System.DateTime.Today;
Plan_code = "";
Plan_so = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theTime = DateTime.Now;
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "atpu2900";
if (!IsPostBack)
{
initCode();
}
setCondition();
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
//确认
//ASPxGridView atl1 = (ASPxGridView)sender;
List <object> rowid = grid.GetSelectedFieldValues("ROWID");
//List<object> planCode = grid.GetSelectedFieldValues("JHDM");
//List<object> oldPart = grid.GetSelectedFieldValues("LJDM1");
//List<object> newPart = grid.GetSelectedFieldValues("LJDM2");
//List<object> SO = grid.GetSelectedFieldValues("SO");
//List<object> locationCode = grid.GetSelectedFieldValues("GWMC");
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
string companyCode = theUserManager.getCompanyCode();
for (int i = 0; i < rowid.Count; i++)
{
string planCode = dc.GetValue("select jhdm from sjbomsoth where rowid='" + rowid[i].ToString() + "'");
string SO = dc.GetValue("select SO from sjbomsoth where rowid='" + rowid[i].ToString() + "'");;
string oldPart = dc.GetValue("select LJDM1 from sjbomsoth where rowid='" + rowid[i].ToString() + "'");;
string newPart = dc.GetValue("select LJDM2 from sjbomsoth where rowid='" + rowid[i].ToString() + "'");;
string locationCode = dc.GetValue("select GWMC from sjbomsoth where rowid='" + rowid[i].ToString() + "'");
//string sql = "select IS_JHONLINE('" + planCode.ToString() + "','" + SO.ToString()
// + "','" + plineCode + "') from dual";
//string retVal = dc.GetValue(sql);
string sql = "select IS_JHPASSGW('" + planCode.ToString() + "','" + SO.ToString() + "','" + locationCode + "') from dual";
if (dc.GetValue(sql) == "0")//未经过该工位的可以进行替换确认
{
sql = "update SJBOMSOTH set istrue=1,qrygmc='" + userName + "' WHERE to_date(to_char(LRSJ,'yyyy-mm-dd'),'yyyy-mm-dd')>=to_date('" + DateFrom.Text
+ "','yyyy-mm-dd') AND to_date(to_char(LRSJ,'yyyy-mm-dd'),'yyyy-mm-dd')<=to_date('" + DateTo.Text
+ "','yyyy-mm-dd') AND GZDD='" + plineCode + "' and istrue<>1 and ygmc='" + userName + "' and jhdm='" + planCode.ToString()
+ "' and ljdm1='" + oldPart.ToString() + "' and gwmc='" + locationCode.ToString() + "'";
dc.ExeSql(sql);
}
else
{
//修改 yxh
Response.Write("<script>alert('计划已上线且经过该工位，将提交给调度确认');</script>");
BomReplaceFactory.MW_MODIFY_SJBOMTHCFM("ADD", planCode, SO, oldPart, newPart,
userName, locationCode, plineCode);
}
}
setCondition("");
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
userName = theUserManager.getUserName();
plineCode = Request["plineCode"].ToString();
if (!IsPostBack)
{
DateFrom.Date = System.DateTime.Today;
DateTo.Date = System.DateTime.Today;
//setCondition("");
}
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 = "part1700";
if (!IsPostBack)
{
ASPxDateEdit2.Date = DateTime.Now;
ASPxDateEdit1.Date = DateTime.Now.AddDays(-1);
}
initCode();
setCondition();
}
protected void gridOnePlace_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
string QRYH = gridOnePlace.GetRowValues(e.VisibleIndex, "QRYH") as string;
string flag = gridOnePlace.GetRowValues(e.VisibleIndex, "FLAG") as string;
string JHDM = gridOnePlace.GetRowValues(e.VisibleIndex, "JHDM") as string;
string SO = gridOnePlace.GetRowValues(e.VisibleIndex, "SO") as string;
string LJDM1 = gridOnePlace.GetRowValues(e.VisibleIndex, "LJDM1") as string;
string LJDM2 = gridOnePlace.GetRowValues(e.VisibleIndex, "LJDM2") as string;
string GWDM = gridOnePlace.GetRowValues(e.VisibleIndex, "GWDM") as string;
//删除
if (e.ButtonID == "Delete")
{
string sql = "delete from sjbomthcfm where jhdm='" + JHDM + "' and so='" + SO + "' and ljdm1='" + LJDM1
+ "' and upper(gwdm)='" + GWDM + "'";
dc.ExeSql(sql);
}
//加入替换
if (e.ButtonID == "Replace")
{
string sql = "select is_zdgys('" + JHDM + "','" + SO + "','" + LJDM1 + "','" + cmbPline.Value.ToString() + "') from dual";
string isZdgys = dc.GetValue(sql);
if (isZdgys == "1")
{
Response.Write("<script>alert('已经指定供应商,不能替换" + LJDM1 + "');</script>");
return;
}
BomReplaceFactory.PL_INSERT_SJBOMSOTH("ADD1", SO, LJDM1, LJDM2, "", "", "", userName, Request.UserHostAddress, JHDM, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), GWDM, "0", "", "0", cmbPline.Value.ToString());
}
//确认
if (e.ButtonID == "Confirm")
{
string sql = "update sjbomthcfm set qrsj=sysdate,qryh='" + userName + "',flag='2' where jhdm='" + JHDM + "' and so='" + SO + "' and ljdm1='" + LJDM1 + "' and gwdm='" + GWDM + "'";
dc.ExeSql(sql);
}
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "atpu1C00";
string Sql3 = "SELECT distinct a.PT_PART FROM COPY_PT_MSTR a left join copy_ptp_det b on a.PT_PART=b.PTP_PART "
+ "where b.ptp_phantom=0 and upper(a.pt_group)='M' and upper(b.ptp_site) in('DCEC-B','DCEC-C') order by PT_PART ";
SqlDataSource3.SelectCommand = Sql3;
SqlDataSource3.DataBind();
setCondition1();
setCondition2();
}
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();
theUserName = theUserManager.getUserName();
theUserId = theUserManager.getUserId();
theProgramCode = "rept2500";
//MachineName = System.Net.Dns.GetHostName();
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
MachineName = hostIPAddress;
if (!IsPostBack)
{
}
initCode();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theTime = DateTime.Now;
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "atpu2900";
if (!IsPostBack)
{
initCode();
}
setCondition();
if (Request["opFlag"] == "getEditSeries")
{
string str1 = "", sql = "";
string so = Request["SO"].ToString().Trim();
string fr = Request["FR"].ToString().Trim();
if (so == "" || so == "null")
{
sql = "select JX,GL,'','',PL,XL,DS,'',XNBH,'',ZS,'','','',JZL,'',EDGYL,HB,'','','',BYGL1,BYZS1,BYGL2,BYZS2,'','','','','','','',FR,'',XZJD,DYGLD,ZDJGL,ZXBZ,XZMC,'','',HCLZZLX,'','' from ATPUFRNAMEPLATE where FR='" + fr + "'";
}
else
{
sql = "select JX,GL,QFJQ,QFPQ,PL,XL,DS,FHCX,XNBH,DYJX,ZS,KHH,GD,PRSG,JZL,PYZS,EDGYL,HB,ENYN,GL1,ZS1,BYGL1,BYZS1,BYGL2,BYZS2,NOX,PM,KHGG,PEL,EPA,PFJD,PFJDHZH,FR,MPLJH,XZJD,DYGLD,ZDJGL,ZXBZ,XZMC,CZYG,XSHZHHMLY,HCLZZLX,SCXKZ,bzso from NAMEPLATE_SO where bzso='" + so + "' ";
}
DataTable dt = dc.GetTable(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < 44; i++)
{
string str = dt.Rows[0][i].ToString();
str1 = str1 + "@" + str;
}
}
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();
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 gridMultiPlace_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
string THEGROUP = gridMultiPlace.GetRowValues(e.VisibleIndex, "THEGROUP") as string;
string flag = gridMultiPlace.GetRowValues(e.VisibleIndex, "FLAG") as string;
string JHDM = gridMultiPlace.GetRowValues(e.VisibleIndex, "JHDM") as string;
string SO = gridMultiPlace.GetRowValues(e.VisibleIndex, "SO") as string;
//确认
if (e.ButtonID == "Confirm")
{
string sql = "update SJBOMTHMUTICFM set qrsj=sysdate,qryh='" + userName + "',flag='1' where jhdm='" + JHDM + "' and THEGROUP='" + THEGROUP + "' ";
dc.ExeSql(sql);
}
setCondition();
}
protected void CmdCopy_Click(object sender, EventArgs e)
{
List <object> theSetType = ASPxGridView1.GetSelectedFieldValues("SETTYPE");
List <object> theOldPart = ASPxGridView1.GetSelectedFieldValues("OLDPART");
List <object> theNewPart = ASPxGridView1.GetSelectedFieldValues("NEWPART");
List <object> thePeFile = ASPxGridView1.GetSelectedFieldValues("PEFILE");
List <object> theUseTime = ASPxGridView1.GetSelectedFieldValues("USETIME");
List <object> theEndTime = ASPxGridView1.GetSelectedFieldValues("ENDTIME");
List <object> theXl = ASPxGridView1.GetSelectedFieldValues("XL");
List <object> theGroup = ASPxGridView1.GetSelectedFieldValues("THGROUP");
userManager theUserManager = (userManager)Session["theUserManager"];
string userName = theUserManager.getUserName();
string companyCode = theUserManager.getCompanyCode();
for (int i = 0; i < theSetType.Count; i++)
{
if (theSetType[i].ToString() == "1")
{
for (int j = 0; j < ListToSo.Items.Count; j++)
{
BomReplaceFactory.MW_MODIFY_SJBOMTHSET("ADD3", theOldPart[i].ToString(), theNewPart[i].ToString()
, ListToSo.Items[i].Value.ToString(), thePeFile[i].ToString(), cmbPline.Value.ToString()
, userName, Convert.ToDateTime(theUseTime[i]).ToString("yyyy-MM-dd"),
Convert.ToDateTime(theEndTime[i]).ToString("yyyy-MM-dd"), theGroup[i].ToString(), "0", theXl[i].ToString());
}
}
if (theSetType[i].ToString() == "0")
{
for (int j = 0; j < ListToSo.Items.Count; j++)
{
BomReplaceFactory.MW_MODIFY_SJBOMTHSET("ADD", theOldPart[i].ToString(), theNewPart[i].ToString()
, ListToSo.Items[i].Value.ToString(), thePeFile[i].ToString(), cmbPline.Value.ToString()
, userName, Convert.ToDateTime(theUseTime[i]).ToString("yyyy-MM-dd")
, Convert.ToDateTime(theEndTime[i]).ToString("yyyy-MM-dd"), "", "0", theXl[i].ToString());
}
}
}
Response.Write("<script>alert('复制成功！');</script>");
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theUserName = theUserManager.getUserName();
theProgramCode = "rept2700";
string hostIPAddress = Page.Request.UserHostAddress;
//IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress);
MachineName = hostIPAddress;
if (!IsPostBack)
{
ASPxDateEdit1.Date = DateTime.Now.AddDays(-3);
ASPxDateEdit2.Date = DateTime.Now;
}
setCondition();
}
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 Sql = "SELECT SO FROM copy_engine_property order by so ";
SqlDataSource1.SelectCommand = Sql;
SqlDataSource1.DataBind();
string sql2 = "select distinct tjlx from dmtjb order by tjlx";
SqlDataSource2.SelectCommand = sql2;
SqlDataSource2.DataBind();
}
