protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; string theDisplayCompanyCode = theUserManager.getCompanyCode(); string theMenuUserId = theUserManager.getUserId(); //根据默认首页判断转向页面 string theSql = "SELECT PROGRAM_VALUE FROM REL_USER_DEFAULTPAGE A " + "LEFT JOIN CODE_PROGRAM B ON A.DEFAULT_PAGE = B.PROGRAM_CODE AND A.COMPANY_CODE = B.COMPANY_CODE " + "WHERE A.COMPANY_CODE = '" + theDisplayCompanyCode + "' AND USER_ID = '" + theMenuUserId + "'"; dc.setTheSql(theSql); DataTable dt = dc.GetTable(); string currentPage = ""; if (dt.Rows.Count > 0) { currentPage = dc.GetTable().Rows[0]["PROGRAM_VALUE"].ToString(); Response.Write("<script>location.href='" + "../.." + currentPage + "';</script>"); } else { Response.Write("<script>location.href='../Login/RmesDefaultPage.aspx';</script>"); } }
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 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(), ""); } }
private void setCondition() { //绑定表数据 userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); string theUserId = theUserManager.getUserId(); List <WorkShopEntity> workShop = WorkShopFactory.GetUserWorkShops(theUserId); ASPxGridView1.DataSource = LineSideStockFactory.GetByWorkShopID(workShop[0].RMES_ID); GridViewDataComboBoxColumn col = ASPxGridView1.Columns["PLINE_CODE"] as GridViewDataComboBoxColumn; col.PropertiesComboBox.DataSource = ProductLineFactory.GetAll(); col.PropertiesComboBox.ValueField = "RMES_ID"; col.PropertiesComboBox.TextField = "PLINE_NAME"; GridViewDataComboBoxColumn col1 = ASPxGridView1.Columns["LOCATION_CODE"] as GridViewDataComboBoxColumn; col1.PropertiesComboBox.DataSource = db.Fetch <LocationEntity>(""); col1.PropertiesComboBox.ValueField = "RMES_ID"; col1.PropertiesComboBox.TextField = "LOCATION_NAME"; ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserID = theUserManager.getUserId(); if (string.IsNullOrEmpty(Request.QueryString["rmesid"])) { return; } rmesID = Request.QueryString["rmesid"].ToString(); BomExchangeEntity bomRule = db.First <BomExchangeEntity>("where rmes_id=@0", rmesID); oldBom = bomRule.ITEM_CODE_FROM; oldName = bomRule.ITEM_NAME_FROM; newBom = bomRule.ITEM_CODE_TO; newName = bomRule.ITEM_NAME_TO; TextOldBOM.Text = oldBom; TextOldName.Text = oldName; TextNewBOM.Text = newBom; TextNewName.Text = newName; string sql = "select t.project_code,t.project_code||'-'||t.project_name SHOWNAME from data_project t " + " where t.status='Y' and exists(select distinct a.project_code from data_xk_oldbom a where a.item_code in" + " ( '" + oldBom + "','" + newBom + "') and t.project_code = a.project_code) order by t.project_code"; comboProject.DataSource = dc.GetTable(sql); comboProject.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { theProgramCode = "part2200"; userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserId = theUserManager.getUserId(); if (!IsPostBack) { //第一次访问将生产线设为E //plineCode = "E"; //test ComboGzdd.Value = "E"; DateStart.Date = DateTime.Now; DateEnd.Date = DateTime.Now; initGzdd(); } //将生产线设为combobox的值 if (ComboGzdd.Value != null) { plineCode = ComboGzdd.Value.ToString(); } setCondition(); }
protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; theUserCode = theUserManager.getUserId(); if (!IsPostBack) { theCompanyCode = theUserManager.getCompanyCode(); Session["company"] = theCompanyCode; ASPxGridView1.SettingsDetail.AllowOnlyOneMasterRowExpanded = true; queryFunction(); //Session.Remove("billCode"); } theCompanyCode = Session["company"].ToString(); SqlUser.SelectCommand = "SELECT USER_ID,USER_NAME FROM CODE_USER WHERE COMPANY_CODE='" + theCompanyCode + "'"; SqlDept.SelectCommand = "select dept_code,dept_name from code_dept where company_code='" + theCompanyCode + "'"; }
public void handleRetrieveUserDatas(string[] Packets) { try { int roomID = int.Parse(Packets[4]); Room _room = (Room)roomManager.getInstance(roomManager.getClientRoomID(roomID)); int pL = Packets.Length; string returnPacket = "{\"t\":\"xt\",\"b\":{\"r\":-1,\"o\":{\"cmd\":\"initUserDatas\",\"a\":["; if (pL > 4) { for (int i = 5; i < pL - 1; i++) { if (i != 5) { returnPacket += ","; } userManager _user = (userManager)_room.getUserInstance(int.Parse(Packets[i])); User _userInfo = (User)_user.Session.userInfo; Hair _userHair = (Hair)hairManager.getInstance(_userInfo.HairID); returnPacket += "{\"uid\":" + _userInfo.userID + ",\"strFrame\":\"" + _userInfo.Frame + "\",\"strPad\":\"" + _userInfo.Pad + "\",\"data\":{\"intColorAccessory\":\"" + _userInfo.ColorAccessory + "\",\"intColorTrim\":\"" + _userInfo.ColorTrim + "\",\"intMP\":" + _userInfo.MP + ",\"intLevel\":\"" + _userInfo.Level + "\",\"intColorSkin\":\"" + _userInfo.ColorSkin + "\",\"intMPMax\":" + _userInfo.MaxMP + ",\"intAccessLevel\":\"" + _userInfo.Access + "\",\"intHP\":" + _userInfo.HP + ",\"intColorBase\":\"" + _userInfo.ColorBase + "\",\"strHairFilename\":\"" + _userHair.Filename + "\",\"intHPMax\":" + _userInfo.MaxHP + ",\"intColorHair\":\"" + _userInfo.ColorHair + "\",\"HairID\":\"" + _userInfo.HairID + "\",\"intColorEye\":\"" + _userInfo.ColorEye + "\",\"strHairName\":\"" + _userHair.Name + "\",\"strGender\":\"" + _userInfo.Gender + "\",\"strUsername\":\"" + _userInfo.Username + "\",\"strClassName\":\"" + _userInfo.className + "\",\"eqp\":{" + userItemManager.getEquippedItems(_userInfo.userID) + "}}}"; } } returnPacket += "]}}}"; Connection.sendMessage(returnPacket); } catch (Exception ex) { Logging.logError(ex.Message); } }
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 == "Delete") { string sql = "delete from SJBOMTHMUTICFM where jhdm='" + JHDM + "' and so='" + SO + "' and THEGROUP='" + THEGROUP + "' "; dc.ExeSql(sql); } //加入替换 if (e.ButtonID == "Replace") { BomReplaceFactory.MW_INSERT_SJBOMSOTHMUTI("KFCONFIRM", SO, "", "", userName, Request.UserHostAddress, JHDM, "", "", "", cmbPline.Value.ToString(), THEGROUP, "", ""); //BomReplaceFactory.PL_INSERT_SJBOMSOTH("ADD", 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 SJBOMTHMUTICFM set qrsj=sysdate,qryh='" + userName + "',flag='2' where jhdm='" + JHDM + "' and THEGROUP='" + THEGROUP + "' "; dc.ExeSql(sql); } setCondition(); }
protected void cmdReplaceByPlan_Click(object sender, EventArgs e) { //按计划替换 userManager theUserManager = (userManager)Session["theUserManager"]; string userName = theUserManager.getUserName(); dataConn theDataConn = new dataConn(); theDataConn.theComd.CommandType = CommandType.StoredProcedure; theDataConn.theComd.CommandText = "MW_HANDLE_LJTH"; theDataConn.theComd.Parameters.Add("JHRQ1", OracleDbType.Varchar2).Value = dtRq.Text; theDataConn.theComd.Parameters.Add("JHDM1", OracleDbType.Varchar2).Value = gridPlan.SelectedItem.GetValue("PLAN_CODE"); theDataConn.theComd.Parameters.Add("JHSO1", OracleDbType.Varchar2).Value = gridPlan.SelectedItem.GetValue("PLAN_SO"); theDataConn.theComd.Parameters.Add("GZDD1", OracleDbType.Varchar2).Value = cmbPline.Value.ToString(); theDataConn.theComd.Parameters.Add("USER1", OracleDbType.Varchar2).Value = userName; theDataConn.theComd.Parameters.Add("THRQBS1", OracleDbType.Varchar2).Value = "0"; theDataConn.theComd.Parameters.Add("THLXBS1", OracleDbType.Varchar2).Value = "0"; theDataConn.theComd.Parameters.Add("OUTSTR1", OracleDbType.Varchar2, 50).Direction = ParameterDirection.Output; theDataConn.OpenConn(); theDataConn.theComd.ExecuteNonQuery(); string retVal = theDataConn.theComd.Parameters["OUTSTR1"].Value.ToString(); theDataConn.CloseConn(); if (retVal == "0") { Response.Write("<script>alert('处理完毕,请到手工处理界面检查需手工处理部分!');</script>"); } else { Response.Write("<script>alert('" + retVal + "');</script>"); } }
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 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_del where jhdm='" + JHDM + "' and so='" + SO + "' and ljdm1='" + LJDM1 + "' and upper(gwdm)='" + GWDM + "'"; dc.ExeSql(sql); } //确认 if (e.ButtonID == "Confirm") { string sql = "delete FROM SJBOMSOTH WHERE JHDM='" + JHDM + "' and ljdm1='" + LJDM1 + "' and ljdm2='" + LJDM2 + "' and so='" + SO + "' AND GWMC='" + GWDM + "' AND GZDD='" + cmbPline.Value.ToString() + "' and ygmc='" + userName + "'"; dc.ExeSql(sql); sql = "delete from sjbomthcfm_del where jhdm='" + JHDM + "' and so='" + SO + "' and ljdm1='" + LJDM1 + "' and upper(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(); string Sql32 = "SELECT ABOM_COMP FROM ATPUBOMKZB order by ABOM_COMP "; SqlDataSource32.SelectCommand = Sql32; SqlDataSource32.DataBind(); string Sql33 = "SELECT ABOM_COMP FROM ATPUBOMKZB order by ABOM_COMP "; SqlDataSource33.SelectCommand = Sql32; SqlDataSource33.DataBind(); setCondition1(); setCondition2(); setCondition3(); }
protected void WorkUnit_DataBinding(object sender, EventArgs e) { ASPxComboBox workUnit = sender as ASPxComboBox; DataTable dt = new DataTable(); dt.Columns.Add("DISPLAY"); dt.Columns.Add("VALUE"); userManager theUserManager = (userManager)Session["theUserManager"]; List <LocationEntity> locations = LocationFactory.GetAll(); List <ProductLineEntity> PLines = ProductLineFactory.GetAll(); foreach (ProductLineEntity p in PLines) { dt.Rows.Add(p.PLINE_NAME, p.RMES_ID); } foreach (LocationEntity l in locations) { dt.Rows.Add(l.LOCATION_NAME, l.RMES_ID); } workUnit.DataSource = dt; workUnit.ValueField = "VALUE"; workUnit.TextField = "DISPLAY"; //workUnit.DataBind(); }
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(); theUserId = theUserManager.getUserId(); theProgramCode = "rept1300"; //MachineName = System.Net.Dns.GetHostName(); string hostIPAddress = Page.Request.UserHostAddress; //IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress); MachineName = hostIPAddress; if (!IsPostBack) { ASPxDateEdit1.Date = DateTime.Now; ASPxDateEdit2.Date = DateTime.Now; //.AddDays(1); ASPxDateEdit3.Date = DateTime.Now; ASPxDateEdit4.Date = DateTime.Now; //.AddDays(1); ASPxDateEdit5.Date = DateTime.Now; ASPxDateEdit6.Date = DateTime.Now; //.AddDays(1); ASPxDateEdit7.Date = DateTime.Now; ASPxDateEdit8.Date = DateTime.Now; //.AddDays(1); //txtPCode.SelectedIndex = 0; } setCondition(); }
//控制首次进入页面不显示数据的变量 //private int m_show; protected void Page_Load(object sender, EventArgs e) { theProgramCode = "rept3100"; userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserId = theUserManager.getUserId(); if (!IsPostBack) { //m_show = 0; //txtPCode.Value = "E"; initPlineCode(); DTPicker1.Date = DateTime.Now; DTPicker2.Date = DateTime.Now; initZd(); } //else //{ // m_show = 1; //} //initQy(); //initfl(); //initZd(); //必须放在这里才能避免被刷新吗 //放这里有问题 //initJHDM(); //生产线不为空且计划号不为空的时候才进行查询,否则数据量太大,显示地特慢 //修改:将计划号判断取消,因为会使页面一直有之前的数据,即使点击在制品查询也无法刷新数据 //if (txtPCode.Text.Trim() != null && txtPCode.Text.Trim() != "" && List1.Items.Count >= 1) //if (txtPCode.Text.Trim() != null && txtPCode.Text.Trim() != "") //{ setCondition(); //} }
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 cmdReplaceByPlan_Click(object sender, EventArgs e) { //按计划替换 userManager theUserManager = (userManager)Session["theUserManager"]; string userName = theUserManager.getUserName(); dataConn theDataConn = new dataConn(); theDataConn.theComd.CommandType = CommandType.StoredProcedure; theDataConn.theComd.CommandText = "MW_HANDLE_LJTH"; theDataConn.theComd.Parameters.Add("JHRQ1", OracleDbType.Varchar2).Value = dtRq.Text; theDataConn.theComd.Parameters.Add("JHDM1", OracleDbType.Varchar2).Value = Session["planCode"].ToString(); theDataConn.theComd.Parameters.Add("JHSO1", OracleDbType.Varchar2).Value = Session["so"].ToString(); theDataConn.theComd.Parameters.Add("GZDD1", OracleDbType.Varchar2).Value = cmbPline.Value.ToString(); theDataConn.theComd.Parameters.Add("USER1", OracleDbType.Varchar2).Value = userName; theDataConn.theComd.Parameters.Add("THRQBS1", OracleDbType.Varchar2).Value = "0"; theDataConn.theComd.Parameters.Add("THLXBS1", OracleDbType.Varchar2).Value = "0"; theDataConn.theComd.Parameters.Add("OUTSTR1", OracleDbType.Varchar2, 50).Direction = ParameterDirection.Output; theDataConn.OpenConn(); theDataConn.theComd.ExecuteNonQuery(); string retVal = theDataConn.theComd.Parameters["OUTSTR1"].Value.ToString(); theDataConn.CloseConn(); if (retVal == "0") { showAlert(this, "处理完毕,请到手工处理界面检查需手工处理部分!"); } else { showAlert(this, retVal); } }
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(); setCondition(); }
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(); theTime = DateTime.Now; theUserId = theUserManager.getUserId(); theUserName = theUserManager.getUserName(); theProgramCode = "atpu2900"; if (!IsPostBack) { initCode(); } setCondition(); if (Request["opFlag"] == "getEditSeries") { string str1 = ""; string so = Request["SO"].ToString().Trim(); string 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 from NAMEPLATE_SO where bzso='" + so + "' "; DataTable dt = dc.GetTable(sql); if (dt.Rows.Count > 0) { for (int i = 0; i < 43; 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(); theUserId = theUserManager.getUserId(); theProgramCode = "atpu1400"; initPlineCode(); //string sql="SELECT PLAN_CODE,PLINE_CODE,BZSO,JX,GL,ZS,QFJQ 气阀进气,QFPQ 气阀排气,PL 排量,DS 怠速,XL 系列,FHCX 发火次序, " // +"XNBH 性能表号,DYJX 打印机型,KHH 客户号,GD 固定日期,JZL 净重量,PYZS 喷油正时,EDGYL 额定供油率,HB 海拔, " // +"ENYN 是否英文,PRSG 是否客户号代替总成号,GL1 额定功率二,ZS1 额定转速二,BYGL1 备用功率一,BYZS1 备用转速一, " // +"BYGL2 备用功率二,BYZS2 备用转速二,NOX,PM ,KHGG 客户规格,SCXKZ 生产许可证,EPA,PFJD 排放阶段,PFJDHZH 排放阶段核准号, " // +"FR,MPLJH 铭牌零件号,XZJD 限值阶段,DYGLD 对应功率段,ZDJGL 最大净功率,ZXBZ 执行标准,XZMC 系族名称, " // +"XSHZHHMLY 形式核准号豁免理由,HCLZZLX 后处理装置类型 FROM atpuplannameplate"; string sql = "select * from atpuplannameplate where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') and plan_code='" + txtPlan.Text.ToUpper() + "'"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string sql2 = "SELECT * FROM COPY_VEPS_DATA where so='" + txtSoQry.Text.Trim().ToUpper() + "'"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
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(); theProgramCode = "inv8800"; if (!IsPostBack) { ASPxDateEdit1.Date = DateTime.Now; ASPxDateEdit2.Date = DateTime.Now; //ASPxDateEdit2.Date = DateTime.Now.AddDays(1); //Session["inv8800table"] = null; } 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 = "inv8700"; //ASPxListBoxPart1.Attributes.Add("ondblclick", "ListBoxDblClick(this);"); if (!IsPostBack) { txtPCode.Value = "E"; //放在外面每次都初始化 initPlineCode(); } setCondition(); }
//private string BillCode = ""; protected void Page_Load(object sender, EventArgs e) { theProgramCode = "part2100"; userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserId = theUserManager.getUserId(); if (!IsPostBack) { //初始化plineCode ComboGzdd.Value = "E"; DateStart.Date = DateTime.Now; DateEnd.Date = DateTime.Now; initGzdd(); } //if (ComboGzdd.Value != null) //{ //往初始化combo的函数里加gzdd参数时使用 //string gzdd = ComboGzdd.Value.ToString(); //initBillCode(); initLocationCode(); initBgyCode(); //} setCondition(); queryPlan1(); }
protected void Page_Load(object sender, EventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); theUserId = theUserManager.getUserId(); theProgramCode = "rept3500"; MachineName = System.Net.Dns.GetHostName(); if (!IsPostBack) { initCode(); } setCondition(); if (Request["opFlag"] == "getEditSeries2") { string str1 = "", Site = "", So = ""; //string so = Request["SO"].ToString().Trim().ToUpper(); string plancode = Request["PLANCODE"].ToString().Trim(); string sql = "SELECT CUSTOMER_NAME ,PLAN_SO,ROUNTING_SITE FROM DATA_PLAN WHERE PLAN_CODE='" + plancode + "' "; DataTable dt = dc.GetTable(sql); if (dt.Rows.Count > 0) { str1 = dt.Rows[0][0].ToString(); So = dt.Rows[0][1].ToString(); Site = dt.Rows[0][2].ToString(); } str1 = str1 + "@" + So + "@" + Site; 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 = "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 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 == "Delete") { string sql = "delete from SJBOMTHMUTICFM_DEL where jhdm='" + JHDM + "' and so='" + SO + "' and THEGROUP='" + THEGROUP + "' "; dc.ExeSql(sql); } //确认 if (e.ButtonID == "Confirm") { string sql = "delete from SJBOMSOTHMUTI where jhdm='" + JHDM + "' and so='" + SO + "' and thgroup='" + THEGROUP + "' and gzdd='" + cmbPline.Value.ToString() + "'"; dc.ExeSql(sql); sql = "delete from SJBOMTHMUTICFM_DEL where jhdm='" + JHDM + "' and so='" + SO + "' and THEGROUP='" + THEGROUP + "' "; dc.ExeSql(sql); } setCondition(); }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { userManager theUserManager = (userManager)Session["theUserManager"]; theCompanyCode = theUserManager.getCompanyCode(); ASPxComboBox plineCode = ASPxGridView1.FindEditFormTemplateControl("plineCode") as ASPxComboBox; ASPxComboBox productSeries = ASPxGridView1.FindEditFormTemplateControl("productSeries") as ASPxComboBox; string sql1 = "select pline_code,pline_name from code_product_line where company_code=" + theCompanyCode; DataTable dt = dc.GetTable(sql1); plineCode.DataSource = dt; plineCode.TextField = "pline_name"; plineCode.ValueField = "pline_code"; //plineCode.DataBind(); string sql2 = "select distinct MODEL_CODE from data_xk_oldbom"; DataTable dt1 = dc.GetTable(sql2); productSeries.DataSource = dt1; productSeries.TextField = "MODEL_CODE"; productSeries.ValueField = "MODEL_CODE"; //productSeries.DataBind(); 前台使用了<%# Bind("") %>后台就不能使用DataBind() //创建Editform,对其中某些字段进行属性设置 //if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) //{ // ///主键不可以修改 // (ASPxGridView1.FindEditFormTemplateControl("txtPlanCode") as ASPxTextBox).Enabled = false; //} }
protected void RolleBtn_Click(object sender, EventArgs e) { userManager UM = new userManager(); Label_Rolle.Text = UM.nyrolle(TextBoxRolle.Text); TextBoxRolle.Text = ""; }
protected void oBButton_Click(object sender, EventArgs e) { userManager UM = new userManager(); errorLabel.Text = UM.opretBruger(TextBoxNavn.Text, TextBoxPass.Text, TextBoxMail.Text); // tøm textboxe for data TextBoxNavn.Text = ""; TextBoxMail.Text = ""; }