protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { string MachineName = Request.UserHostAddress; string hostIPAddress = Page.Request.UserHostAddress; //IPHostEntry hostInfo = System.Net.Dns.GetHostByAddress(hostIPAddress); MachineName = hostIPAddress; //删除原来记录 string sql = "DELETE FROM RST_QAD_BOMPART_LQ_TEMP where ABOM_USER='******'"; dc.ExeSql(sql); //逐行显示 YXH2016/12/17 21:15 #region 逐行显示 DataTable dt1 = new DataTable(); dt1.Columns.Add("ABOM_JHDM"); dt1.Columns.Add("ABOM_COMP"); dt1.Columns.Add("ABOM_DESC"); dt1.Columns.Add("ABOM_WKCTR"); dt1.Columns.Add("ABOM_QTY"); dt1.Columns.Add("SJ_FLAG"); //批量生成 if (listPlan.Items.Count > 0) { for (int i = 0; i < listPlan.Items.Count; i++) { string str = listPlan.Items[i].Text; BomReplaceFactory.QAD_CREATE_PRTPART_LQ(str, MachineName); string sqlSo = "select t.plan_code,a.plan_so ABOM_COMP from ms_sfjit_plan_log t left join data_plan a on a.plan_code=t.plan_code where t.SF_JIT_ID='" + str + "' and t.PLAN_CODE IN (SELECT plan_code FROM data_plan WHERE LQ_FLAG='Y') "; DataTable dt = dc.GetTable(sqlSo); if (dt.Rows.Count < 1) { return; } for (int s = 0; s < dt.Rows.Count; s++) { dt1.Rows.Add(dt.Rows[s][0], dt.Rows[s][1], "", "", "", ""); string sqlSn = "select sn from data_product where plan_code='" + dt.Rows[s][0].ToString() + "'"; DataTable dt2 = dc.GetTable(sqlSn); int integer = dt2.Rows.Count / 6; for (int n = 0; n <= integer; n++) { DataRow dr2 = dt1.NewRow(); for (int m = 0; m < 6; m++) { dr2[m] = dt2.Rows[m + n * 6][0]; if (m > dt2.Rows.Count - 2 - 6 * n) { break; } } dt1.Rows.Add(dr2); } } string sqlDh = "select ABOM_JHDM ,ABOM_COMP ,ABOM_DESC ,ABOM_WKCTR ,ABOM_QTY ,SJ_FLAG from RST_QAD_BOMPART_LQ where ABOM_USER='******' order by SJ_FLAG DESC,ABOM_JHDM,ABOM_WKCTR"; DataTable dt3 = dc.GetTable(sqlDh); if (dt3.Rows.Count < 1) { return; } dt1.Rows.Add("MES单号", "零件代码", "零件名称", "工位", "数量", "是否随机件"); for (int x = 0; x < dt3.Rows.Count; x++) { dt1.Rows.Add(dt3.Rows[x][0], dt3.Rows[x][1], dt3.Rows[x][2], dt3.Rows[x][3], dt3.Rows[x][4], dt3.Rows[x][5]); } } } #endregion Session["MaterialSend_YXH"] = dt1; ASPxGridView1.DataSource = dt1; ASPxGridView1.DataBind(); }
public void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim()); DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim()); if (DT1.AddDays(31) < DT2) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天,请重新选择!"); return; } else if (ASPxListBoxUsed.Items.Count <= 0) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", " 请选择要查询的零件!"); return; } DataTable Table1 = new DataTable(); //string iteam_code = ""; Table1.Columns.Add("日期"); Table1.Columns.Add("SO"); Table1.Columns.Add("计划"); Table1.Columns.Add("流水号"); for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++) { string part = ASPxListBoxUsed.Items[a].ToString(); string delsql = "delete from RSTBOMQD_ITEM8 where udesc='" + part + "'"; dc.ExeSql(delsql); Table1.Columns.Add(part); Table1.Columns.Add(part + "数量"); //Table1.Columns.Add(part+'▍↔'+"数量"); } string plancode = "", PlanSo = "", PlanCode = "", RQbegin = "", plinecode = "", xl = "", scode = "", PlanQty = ""; int PlanSl = 0; string snSql = "select lsh,max(ptime) ptime from ATPUDQYQDYB where PTIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') and PTIME<=to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') group by lsh order by ptime,lsh"; DataTable sndt = dc.GetTable(snSql); for (int j = 0; j < sndt.Rows.Count; j++) { RQbegin = sndt.Rows[j][1].ToString(); string soSql = "select plan_code from data_plan_sn where sn='" + sndt.Rows[j][0].ToString() + "' and pline_code='" + txtPCode.Value.ToString() + "' "; plancode = dc.GetValue(soSql); //DataTable sodt = dc.GetTable(soSql); //if (sodt.Rows.Count > 0) { plancode = sodt.Rows[0][0].ToString(); } string sql1 = "select distinct begin_date,plan_so,plan_qty from data_plan where pline_code='" + txtPCode.Value.ToString() + "' and plan_code='" + plancode + "' and plan_type<>'C' and plan_type<>'D' "; DataTable dt1 = dc.GetTable(sql1); if (dt1.Rows.Count <= 0) { continue; } PlanSo = dt1.Rows[0][1].ToString(); PlanQty = dt1.Rows[0][2].ToString(); PlanSl = Convert.ToInt32(PlanQty); plinecode = txtPCode.Value.ToString(); PlanCode = plancode; DataRow dr = Table1.NewRow(); dr[0] = RQbegin; dr[1] = PlanSo; dr[2] = PlanCode; dr[3] = sndt.Rows[j][0].ToString(); for (int i = 0, m = 0; i < ASPxListBoxUsed.Items.Count; i++) { string part2 = ASPxListBoxUsed.Items[i].ToString(); if (plinecode == "E") { scode = "ZF5"; } if (plinecode == "W") { scode = "ATPU-T560"; } //string delsql = "delete from RSTBOMQD_ITEM8 where udesc='" + part2 + "'"; //dc.ExeSql(delsql); PL_BOMZJTS_ITEM8 sp = new PL_BOMZJTS_ITEM8() { PLANSO1 = PlanSo, SCODE1 = scode, PLANCODE1 = PlanCode, PART1 = part2, MACHINENAME1 = MachineName }; Procedure.run(sp); PL_UPDATE_BOMZJTS_ITEM8 sp2 = new PL_UPDATE_BOMZJTS_ITEM8() { PLANSO1 = PlanSo, SCODE1 = scode, PLANCODE1 = PlanCode, PLINECODE1 = plinecode, MACHINENAME1 = MachineName }; Procedure.run(sp2); PL_UPDATE_ITEM8 sp4 = new PL_UPDATE_ITEM8() { PLANSO1 = PlanSo, PLANCODE1 = PlanCode, SCODE1 = scode }; Procedure.run(sp4); //string ChSql22 = "select comp ,qty from RSTBOMQD_ITEM8 where udesc='" + part2 + "' and zddm='" + scode + "' "; string ChSql1 = "select replace ( a.comp,'#','') comp ,a.qty,a.gysmc from RSTBOMQD_ITEM8 a where a.udesc='" + part2 + "' and a.zddm='" + scode + "' and a.plan_Code='" + PlanCode + "' "; if (PlanSo != "") { ChSql1 = ChSql1 + " and a.plan_so='" + PlanSo + "'"; } DataTable dt2 = dc.GetTable(ChSql1); string code = "", qty = ""; int sl; if (dt2.Rows.Count > 0) { code = dt2.Rows[0][0].ToString(); qty = dt2.Rows[0][1].ToString(); sl = Convert.ToInt32(qty); //dr[m + 4] = code; //dr[m + 5] = sl * PlanSl; //m = m + 2; dr[m + 4] = code; dr[m + 5] = sl; m = m + 2; } else { dr[m + 4] = code; dr[m + 5] = ""; m = m + 2; } } Table1.Rows.Add(dr); } Session["rept3400table"] = Table1; ASPxGridView1.DataSource = Table1; ASPxGridView1.DataBind(); }
public void GetClassification(string group) { try { if (ASPxComboBox1.Value != null) { if (ASPxComboBox1.Value.ToString() == "USER_ROLE") { ASPxMenu3.Items.FindByName("btnNew").Enabled = false; ASPxMenu3.Items.FindByName("btnDelete").Enabled = false; } else { ASPxMenu3.Items.FindByName("btnNew").Enabled = true; ASPxMenu3.Items.FindByName("btnDelete").Enabled = true; } } ASPxGridView1.Columns["VALUE_TEXT_CLASSIFICATION"].Caption = "Valor Texto"; ASPxGridView1.Columns["MPC01"].Caption = "Tipo Interface"; switch (group) { case "SKU": ASPxGridView1.Caption = "Clasificaciones SKU"; break; case "WEATHER": ASPxGridView1.Caption = "Clasificaciones Clima"; break; case "LOCATION": ASPxGridView1.Caption = "Clasificaciones Ubicacion"; break; case "CUSTOMER": ASPxGridView1.Caption = "Clasificaciones Cliente"; break; case "PROVIDER": ASPxGridView1.Caption = "Clasificaciones Proveedor"; break; case "VEHICLE": ASPxGridView1.Caption = "Clasificaciones Vehículo"; break; case "RECEPTION": ASPxGridView1.Caption = "Clasificaciones Recepción"; break; case "USER_ROLE": ASPxGridView1.Caption = "Roles de Usuario"; break; case "BANK_ACCOUNTS": ASPxGridView1.Caption = "Bancos"; ASPxGridView1.Columns["VALUE_TEXT_CLASSIFICATION"].Caption = "Número de Cuenta"; ASPxGridView1.Columns["MPC01"].Caption = "Nombre del Banco"; break; case "VOID_REASONS": ASPxGridView1.Caption = "Razones de anulación"; break; case "ALL": ASPxGridView1.Caption = "Clasificaciones"; break; default: ASPxGridView1.Caption = "Clasificaciones"; break; } if (group == "ALL") { var pResult = ""; var ds = _objClassification.GetAllClassification(Session["connectionString"].ToString(), ref pResult); if (pResult == "") { ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); Session["dsClassification"] = ds; } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } else { var pResult = ""; var ds = _objClassification.GetClassification(Session["connectionString"].ToString(), group, ref pResult); if (pResult == "") { ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); Session["selectedClassification"] = group; } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
protected void Page_Load(object sender, EventArgs e) { ASPxGridView1.DataSource = Enumerable.Range(0, 10).Select(i => new { Col1 = i, Col2 = i * 2 }); ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ASPxGridView1.DataSource = GridData; ASPxGridView1.DataBind(); ASPxGridView1.SettingsEditing.BatchEditSettings.AllowRegularDataItemTemplate = supportDataItemTemplate.Checked; }
private void setCondition() { string sql = "select * from dp_kcb where "; if (txtPCode.Text.Trim() != "") { sql = sql + " gzdd = '" + txtPCode.Value.ToString() + "'"; } else { sql = sql + " gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') "; } if (ASPxDateEdit1.Text.Trim() != "") { sql = sql + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') "; } if (ASPxDateEdit2.Text.Trim() != "") { sql = sql + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')"; } if (textSO.Text.Trim() != "") { sql = sql + " AND so like '%" + textSO.Text.Trim() + "%'"; } if (txtPc.Text.Trim() != "") { sql = sql + " AND gzrq like '%" + txtPc.Text.Trim() + "%'"; } sql = sql + " order by so,ghtm"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string sql2 = "select SO,COUNT(*) SL from dp_kcb where "; if (txtPCode.Text.Trim() != "") { sql2 = sql2 + " gzdd = '" + txtPCode.Value.ToString() + "'"; } else { sql2 = sql2 + " gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') "; } if (ASPxDateEdit1.Text.Trim() != "") { sql2 = sql2 + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')>= to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')"; } if (ASPxDateEdit2.Text.Trim() != "") { sql2 = sql2 + " AND to_date(gzrq,'yyyy-mm-dd hh24:mi:ss')<= to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss')"; } if (textSO.Text.Trim() != "") { sql2 = sql2 + " AND so like '%" + textSO.Text.Trim() + "%'"; } if (txtPc.Text.Trim() != "") { sql2 = sql2 + " AND gzrq like '%" + txtPc.Text.Trim() + "%'"; } sql2 = sql2 + " GROUP BY SO order by So"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ASPxGridView1.DataBind(); }
//初始化gridview //private void setCondition() //{ // string sql = ""; // //查询发动机状态,不随出入库删除 // sql = "select A.ROWID,a.ghtm,b.PLAN_CODE,a.so,a.rqsj,a.ggxhmc,a.zdmc,a.bcmc,a.bzmc,a.ygmc " // + " from sjcbb_ndel a " // + " left join data_product b on b.SN=a.ghtm " // + " left join code_station c on c.STATION_NAME=a.zdmc " // + " left join data_plan d on d.PLAN_CODE=b.PLAN_CODE " // + " where 1=1 "; // //+" where 1=" + m_show + " "; // if (txtPCode.Text.Trim() != "") // { // sql += " AND b.PLINE_CODE = '" + txtPCode.Value.ToString() + "' "; // } // //if (cmbJhdm.Text.Trim() != "" && Check1.Value.ToString() == "true") // //{ // // sql += " AND b.PLAN_CODE = '" + cmbJhdm.Text.Trim() + "' "; // // if (txtSO.Text.Trim() != "") // // { // // sql += " AND a.so = '" + txtSO.Text.Trim() + "' "; // // } // //} // //如果列表中没有条件,则查询的数据为空 // if (List1.Items.Count < 1) // { // sql += " AND b.PLAN_CODE = '' "; // } // //??取不到选中的列,怎么设置只能选一行 // if (List1.Items.Count == 1 && Check1.Checked == true) // { // int listindex = List1.Items.IndexOfText("--"); // //这里只取一行吗? // string planCode = List1.SelectedItems[0].ToString().Substring(0, listindex); // sql += " AND B.PLAN_CODE = '" + planCode + "' "; // if (txtSO.Text.Trim() != "") // { // sql += " AND A.SO = '" + txtSO.Text.Trim() + "' "; // } // } // if (Check1.Checked == false && List1.Items.Count >= 1) // { // //为什么获取不到,因为IndexOfText取的是文本对应item在items中的位置 // //int listindex = List1.Items.IndexOfText("2016P0926-01--SO22064"); // //test // string item = List1.Items[0].ToString(); // int listindex = item.IndexOf("--"); // if (listindex >= 0) // { // //不能用SelectedItems,好像取不到,待测试 // sql += " AND ( b.PLAN_CODE = '" + List1.Items[0].ToString().Substring(0, List1.Items[0].ToString().IndexOf("--")) + "' "; // for (int i = 2; i <= List1.Items.Count; i++) // { // listindex = List1.Items[i - 1].ToString().IndexOf("--"); // sql += " OR B.PLAN_CODE = '" + List1.Items[i - 1].ToString().Substring(0, listindex) + "' "; // } // sql += ") "; // } // } // //if (cmbJhdm.Text.Trim() != "") // //{ // // sql += " AND b.PLAN_CODE = '" + cmbJhdm.Text.Trim() + "' "; // //} // if (cmbzd.Text.Trim() != "") // { // sql += " AND a.ZDMC = '" + cmbzd.Text.Trim() + "' "; // } // if (cmbqy.Text.Trim() != "") // { // sql += " AND a.ZDQY = '" + cmbqy.Text.Trim() + "' "; // } // if (cmbfl.Text.Trim() != "") // { // sql += " AND a.ZDFL = '" + cmbfl.Text.Trim() + "' "; // } // if (txtGhtm.Text.Trim() != "") // { // sql += " AND a.GHTM = '" + txtGhtm.Text.Trim() + "' "; // } // //数据量太大,先取前二十条数据 // //sql += " AND ROWNUM <= 20 "; // sql += " ORDER BY A.GHTM,A.RQSJ "; // DataTable dt = dc.GetTable(sql); // ASPxGridView1.DataSource = dt; // ASPxGridView1.DataBind(); //} //初始化gridview private void setCondition() { string sql = ""; //查询发动机状态,不随出入库删除 sql = " SELECT A.ROWID,A.SN,A.PLAN_CODE,A.PLAN_SO,A.START_TIME,A.PRODUCT_MODEL,B.STATION_NAME,C.SHIFT_NAME,D.TEAM_NAME,E.USER_NAME " + " FROM DATA_STORE_NDEL A " + " LEFT JOIN CODE_STATION B ON B.STATION_CODE = A.STATION_CODE " + " LEFT JOIN CODE_SHIFT C ON C.SHIFT_CODE = A.SHIFT_CODE " + " LEFT JOIN CODE_TEAM D ON D.TEAM_CODE = A.TEAM_CODE " + " LEFT JOIN CODE_USER E ON E.USER_NAME = A.USER_ID " + " WHERE 1=1 "; //若生产线为空,则取生产线为空的值 if (txtPCode.Text.Trim() == "") { sql += " AND A.PLINE_CODE = '' "; } if (txtPCode.Text.Trim() != "") { sql += " AND A.PLINE_CODE = '" + txtPCode.Value.ToString() + "' "; } //如果列表中没有条件,则查询的数据为空 if (List1.Items.Count < 1) { sql += " AND A.PLAN_CODE = '' "; } //??取不到选中的列,怎么设置只能选一行 if (List1.Items.Count == 1 && Check1.Checked == true) { int listindex = List1.Items.IndexOfText("--"); //这里只取一行吗? string planCode = List1.SelectedItems[0].ToString().Substring(0, listindex); sql += " AND A.PLAN_CODE = '" + planCode + "' "; if (txtSO.Text.Trim() != "") { sql += " AND A.SO = '" + txtSO.Text.Trim() + "' "; } } if (Check1.Checked == false && List1.Items.Count >= 1) { //为什么获取不到,因为IndexOfText取的是文本对应item在items中的位置 //int listindex = List1.Items.IndexOfText("2016P0926-01--SO22064"); //test string item = List1.Items[0].ToString(); int listindex = item.IndexOf("--"); if (listindex >= 0) { //不能用SelectedItems,好像取不到,待测试 sql += " AND ( A.PLAN_CODE = '" + List1.Items[0].ToString().Substring(0, List1.Items[0].ToString().IndexOf("--")) + "' "; for (int i = 2; i <= List1.Items.Count; i++) { listindex = List1.Items[i - 1].ToString().IndexOf("--"); sql += " OR A.PLAN_CODE = '" + List1.Items[i - 1].ToString().Substring(0, listindex) + "' "; } sql += ") "; } } if (cmbzd.Text.Trim() != "") { sql += " AND B.STATION_NAME = '" + cmbzd.Text.Trim() + "' "; } //if (cmbqy.Text.Trim() != "") //{ // sql += " AND A.ZDQY = '" + cmbqy.Text.Trim() + "' "; //} //if (cmbfl.Text.Trim() != "") //{ // sql += " AND A.ZDFL = '" + cmbfl.Text.Trim() + "' "; //} //if (txtGhtm.Text.Trim() != "") //{ // sql += " AND A.GHTM = '" + txtGhtm.Text.Trim() + "' "; //} sql += " ORDER BY A.SN,A.START_TIME "; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ASPxGridView1.DataBind(); Session["FocusedRow"] = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, new string[] { ASPxGridView1.KeyFieldName }); }
protected void Page_Init(object sender, EventArgs e) { ASPxGridView1.DataSource = DataProvider.GetData(); ASPxGridView1.DataBind(); }
private void setCondition() { string chose = ""; if (txtChose.Text.Trim() != "") { chose = txtChose.Value.ToString(); string pmodel = "", so = "", plancode = "", plinecode = "", xl = "", scode = "", pos = ""; switch (chose) { case "A": string sql = "SELECT product_model,plan_so,plan_code,pline_code FROM DATA_PRODUCT where sn='" + txtSN.Text.Trim() + "'"; DataTable dt = dc.GetTable(sql); if (dt.Rows.Count <= 0) { return; } else { pmodel = dt.Rows[0][0].ToString(); so = dt.Rows[0][1].ToString(); plancode = dt.Rows[0][2].ToString(); plinecode = dt.Rows[0][3].ToString(); string sql2 = "select xl from copy_engine_property where so='" + so.ToUpper() + "' and rownum=1 "; DataTable dt2 = dc.GetTable(sql2); if (dt2.Rows.Count > 0) { xl = dt2.Rows[0][0].ToString(); } if (plinecode == "E") { scode = "ZDE068"; } if (plinecode == "W") { scode = "ZD910"; } if (plinecode == "R") { scode = "RONE001"; } //else //{ // ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); // ASPxGridView1.JSProperties.Add("cpCallbackRet", "没有记录!"); //} PL_QUERY_BOMZJTS3 sp = new PL_QUERY_BOMZJTS3() { SO1 = so, ZDDM1 = scode, GZDD1 = plinecode, FDJXL1 = xl, JHDM1 = plancode }; Procedure.run(sp); PL_UPDATE_BOMZJTS_CRM3 sp2 = new PL_UPDATE_BOMZJTS_CRM3() { SO1 = so, ZDDM1 = scode, JHDM1 = plancode, GZDD1 = plinecode }; Procedure.run(sp2); PL_UPDATE_BOMLSHTS3 sp3 = new PL_UPDATE_BOMLSHTS3() { LSH1 = txtSN.Text.Trim(), ZDDM1 = scode }; Procedure.run(sp3); PL_UPDATE_BOMSOTHTS3 sp4 = new PL_UPDATE_BOMSOTHTS3() { SO1 = so, JHDM1 = plancode, ZDDM1 = scode }; Procedure.run(sp4); } string ChSql1 = "select gwmc 工位,comp 零件代码,udesc 描述,qty 数量,gxmc 工序,gysmc 供应商 from rstbomqd_CRM where zddm='" + scode + "' order by gwmc,gxmc"; DataTable dt1 = dc.GetTable(ChSql1); ASPxGridView1.DataSource = dt1; ASPxGridView1.DataBind(); ASPxGridView2.DataSource = null; ASPxGridView2.DataBind(); break; case "B": //string sql22 = "SELECT ggxhmc,so,jhdm FROM SJSXB WHERE GHTM='" + txtSN.Text.Trim() + "' "; //DataTable dt22 = dc.GetTable(sql22); //pmodel = dt22.Rows[0][0].ToString(); //so = dt22.Rows[0][1].ToString(); //plancode = dt22.Rows[0][2].ToString(); string ChSql2 = " SELECT item_code 零件代码,item_name 零件名称,item_qty 数量,process_code 工序,location_code 工位 FROM vw_data_plan_standard_bom WHERE plan_code='" + txtPlanCode.Text.Trim() + "' AND plan_so='" + txtSO.Text.Trim() + "' ORDER BY location_code,process_code"; DataTable dt22 = dc.GetTable(ChSql2); ASPxGridView1.DataSource = dt22; ASPxGridView1.DataBind(); string Csql2 = "SELECT ljdm1,ljdm2,gwmc FROM sjbomsoth WHERE so='" + txtSO.Text.Trim() + "'and jhdm='" + txtPlanCode.Text.Trim() + "' and istrue=1 order by gwmc,ljdm1"; DataTable dt12 = dc.GetTable(Csql2); ASPxGridView2.DataSource = dt12; ASPxGridView2.DataBind(); break; case "C": //string ChSql3 = "select LOCATION_CODE 工位,ITEM_CODE 零件代码,ITEM_NAME 零件名称,ITEM_CODE 数量,PROCESS_CODE 工序,STATION_CODE 站点,VENDOR_NAME 供应商 from VW_rstlshbomqd where SN='" + txtSN.Text.Trim() + "' order by LOCATION_CODE,PROCESS_CODE"; //DataTable dt3 = dc.GetTable(ChSql3); //ASPxGridView1.DataSource = dt3; //ASPxGridView1.DataBind(); break; default: ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "查询方式有误!"); break; } } }
protected void ToSelect(object sender, EventArgs e) { YxBtn.SetViewState(divSel); ASPxGridView1.DataBind(); }
private void setCondition() { //绑定表数据 ASPxGridView1.DataSource = DepartmentFactory.GetAll(); ASPxGridView1.DataBind(); }
private void setCondition() { string m_YearStr, m_MonthStr, m_FromrqStr, m_TorqStr, m_MonthDateStr, m_SO; m_YearStr = ASPxDateEdit1.Date.Year.ToString(); m_MonthStr = ASPxDateEdit2.Date.Month.ToString(); m_FromrqStr = ASPxDateEdit1.Text.Trim(); m_TorqStr = ASPxDateEdit2.Text.Trim(); if (ASPxDateEdit1.Date.AddDays(31) < ASPxDateEdit2.Date) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天,请重新选择!"); return; } string sql = "DELETE FROM DP_REPORTSOTEMP WHERE MACHINENAME='" + MachineName + "'"; dc.ExeSql(sql); string Insql1 = " insert into dp_reportsotemp(so,Machinename) select distinct so,'" + MachineName + "' from dp_monthkcb where year='" + m_YearStr + "' and month='" + m_MonthStr + "' and periodline='Begin' and gzdd='" + txtPCode.Value.ToString() + "'"; dc.ExeSql(Insql1); string ChSql = "select monthdate from dp_monthkcb where year='" + m_YearStr + "' and month='" + m_MonthStr + "' and periodline='Begin' and gzdd='" + txtPCode.Value.ToString() + "' order by monthdate desc"; DataTable dt = dc.GetTable(ChSql); if (dt.Rows.Count <= 0) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "没有期初库存数据!"); return; } else { string strMonD = dt.Rows[0][0].ToString(); m_MonthDateStr = strMonD; } string Insql2 = " insert into dp_reportsotemp(so,Machinename) select distinct so,'" + MachineName + "' from dp_rckwcb where gzrq>='" + m_MonthDateStr + "' and gzrq<='" + m_TorqStr + "' and gzdd='" + txtPCode.Value.ToString() + "' and so not in (select so from dp_reportsotemp where MachineName='" + MachineName + "')"; dc.ExeSql(Insql2); string ChSql2 = "select SO from dp_reportsotemp where machinename='" + MachineName + "' order by So"; DataTable dt2 = dc.GetTable(ChSql2); DataTable Table = new DataTable(); Table.Columns.Add("SO"); Table.Columns.Add("QCKC"); Table.Columns.Add("RK1"); Table.Columns.Add("CK1"); Table.Columns.Add("RK0"); Table.Columns.Add("RK2"); Table.Columns.Add("RK3"); Table.Columns.Add("RK4"); Table.Columns.Add("RK5"); Table.Columns.Add("RK6"); Table.Columns.Add("RK7"); Table.Columns.Add("RK8"); Table.Columns.Add("RK9"); Table.Columns.Add("RK10"); Table.Columns.Add("RKHJ"); Table.Columns.Add("WXK"); Table.Columns.Add("SYK"); Table.Columns.Add("QT"); Table.Columns.Add("CKHJ"); Table.Columns.Add("KC"); Table.TableName = "报表"; for (int i = 0; i < dt2.Rows.Count; i++) { m_SO = dt2.Rows[i][0].ToString(); string outstr; PL_CREATE_REPORT sp = new PL_CREATE_REPORT() { SO1 = m_SO, YEAR1 = m_YearStr, MONTH1 = m_MonthStr, GZDD1 = txtPCode.Value.ToString(), FROMRQ1 = m_FromrqStr, TORQ1 = m_TorqStr, MONTHDATE1 = m_MonthDateStr, OUTSTR1 = "" }; Procedure.run(sp); //ProductDataFactory.PL_CREATE_REPORT(m_SO, m_YearStr, m_MonthStr, txtPCode.Value.ToString(), m_FromrqStr, m_TorqStr, m_MonthDateStr, out outstr); outstr = sp.OUTSTR1; string[] param = outstr.Split('#'); if (param.Length < 19) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "查询失败!"); return; } else { Table.Rows.Add(m_SO, param[0], param[1], param[2], param[3], param[4], param[5], param[6], param[7], param[8], param[9], param[10], param[11], param[12], param[13], param[14], param[15], param[16], param[17], param[18]); } } ASPxGridView1.DataSource = Table; ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } LookupWarehouse.GridView.Width = 300; LookupRoles.GridView.Width = 300; ASPxTextBox5.Enabled = true; ASPxMenu3.Items.FindByName("btnAgregarCliente").Visible = AgregarCliente(); if (!Page.IsPostBack) { GetUsers(); GetUserRole(); GetSellers(); GetWarehouseNotAsign(""); GetWarehousePreSale(); GetAllZones(); //UsuarioSeleccionoUsuario?.Invoke(this,new RutaArgumento{ Data = new Ruta{CODE_ROUTE = "" }, Usuario = new Usuario{ LOGIN = ""}}); return; } Connection = Session["connectionString"].ToString(); if (!Page.IsPostBack) { Session["ACTION"] = "UPDATE"; Session["base64Profile"] = null; } if (Page.IsPostBack) { ReportView(); } if (Session["DS_USER"] != null) { ASPxGridView1.DataSource = Session["DS_USER"]; ASPxGridView1.DataBind(); } else { GetUsers(); } if (Session["DS_USER_ROLE"] != null) { CmbUserRole.DataSource = Session["DS_USER_ROLE"]; CmbUserRole.ValueField = "NAME_CLASSIFICATION"; CmbUserRole.TextField = "VALUE_TEXT_CLASSIFICATION"; CmbUserRole.DataBind(); } else { GetUserRole(); } if (Session["DS_SELLER_USER"] != null) { LookupSeller.DataSource = Session["DS_SELLER_USER"]; LookupSeller.DataBind(); } else { GetSellers(); } if (Session["DS_WAREHOUSE_NOTASIGN"] != null) { LookupWarehouse.DataSource = Session["DS_WAREHOUSE_NOTASIGN"]; LookupWarehouse.DataBind(); } else { if (!Page.IsPostBack) { GetWarehouseNotAsign(""); } } if (Session["DS_WAREHOUSE_PRESALE"] != null) { LookupWarehousePre.DataSource = Session["DS_WAREHOUSE_PRESALE"]; LookupWarehousePre.DataBind(); } else { GetWarehousePreSale(); } if (Session["UiVistaPoligonosDeRuta"] != null) { UiVistaPoligonosDeRuta.DataSource = Session["UiVistaPoligonosDeRuta"]; UiVistaPoligonosDeRuta.DataBind(); } if (Session["ListaRuta"] != null) { UiListaRuta.DataSource = Session["ListaRuta"]; UiListaRuta.DataBind(); } if (Session["UiListaZona"] != null) { UiListaZona.DataSource = Session["UiListaZona"]; UiListaZona.DataBind(); } }
public void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim()); DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim()); if (DT1.AddDays(31) < DT2) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", "选择日期范围不能超过31天,请重新选择!"); return; } else if (ASPxListBoxUsed.Items.Count <= 0) { ASPxGridView1.JSProperties.Add("cpCallbackName", "Fail"); ASPxGridView1.JSProperties.Add("cpCallbackRet", " 请选择要查询的零件!"); return; } DataTable Table1 = new DataTable(); //string iteam_code = ""; Table1.Columns.Add("日期"); Table1.Columns.Add("SO"); Table1.Columns.Add("计划"); for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++) { string part = ASPxListBoxUsed.Items[a].ToString(); Table1.Columns.Add(part + "----数量"); //Table1.Columns.Add(part+'▍↔'+"数量"); } string plancode = "", PlanSo = "", PlanCode = "", RQbegin = "", plinecode = "", xl = "", scode = ""; string snSql = "select lsh,ptime from ATPUDQYQDYB where PTIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') and PTIME<=to_date('" + ASPxDateEdit2.Text.Trim() + "', 'yyyy-mm-dd hh24:mi:ss') "; DataTable sndt = dc.GetTable(snSql); for (int j = 0; j < sndt.Rows.Count; j++) { RQbegin = sndt.Rows[j][1].ToString(); string soSql = "select plan_code from data_plan_sn where sn='" + sndt.Rows[j][0].ToString() + "'"; DataTable sodt = dc.GetTable(soSql); if (sodt.Rows.Count > 0) { plancode = sodt.Rows[0][0].ToString(); } string sql1 = "select distinct begin_date,plan_so from data_plan where pline_code='" + txtPCode.Value.ToString() + "' and plan_code='" + plancode + "' "; DataTable dt1 = dc.GetTable(sql1); if (dt1.Rows.Count > 0) { PlanSo = dt1.Rows[0][1].ToString(); //RQbegin = dt1.Rows[0][0].ToString(); } plinecode = txtPCode.Value.ToString(); PlanCode = plancode; DataRow dr = Table1.NewRow(); dr[0] = RQbegin; dr[1] = PlanSo; dr[2] = PlanCode; for (int i = 0; i < ASPxListBoxUsed.Items.Count; i++) { string part2 = ASPxListBoxUsed.Items[i].ToString(); //string sql2 = "(select a.item_code,a.item_qty from data_sn_bom a left join data_plan b on a.plan_code=b.plan_code where a.plan_code='" + PlanCode + "' and b.plan_so='" + PlanSo + "' and a.item_name='" + part2 + "') union " // + "select a.item_code,a.item_qty from data_sn_bom_temp a left join data_plan b on a.plan_code=b.plan_code where a.plan_code='" + PlanCode + "' and b.plan_so='" + PlanSo + "' and a.item_name='" + part2 + "'"; //DataTable dt2 = dc.GetTable(sql2); string sql3 = "select xl from copy_engine_property where so='" + PlanSo.ToUpper() + "' and rownum=1 "; DataTable dt3 = dc.GetTable(sql3); if (dt3.Rows.Count > 0) { xl = dt3.Rows[0][0].ToString(); } if (plinecode == "E") { scode = "ZF5"; } if (plinecode == "W") { scode = "ATPU-T560"; } //if (plinecode == "R") //{ // scode = "RONE001"; //} PL_QUERY_BOMZJTS3 sp = new PL_QUERY_BOMZJTS3() { SO1 = PlanSo, ZDDM1 = scode, GZDD1 = plinecode, FDJXL1 = xl, JHDM1 = PlanCode }; Procedure.run(sp); PL_UPDATE_BOMZJTS_CRM3 sp2 = new PL_UPDATE_BOMZJTS_CRM3() { SO1 = PlanSo, ZDDM1 = scode, JHDM1 = PlanCode, GZDD1 = plinecode }; Procedure.run(sp2); //PL_UPDATE_BOMLSHTS3 sp3 = new PL_UPDATE_BOMLSHTS3() //{ // LSH1 = txtSN.Text.Trim(), // ZDDM1 = scode //}; //Procedure.run(sp3); PL_UPDATE_BOMSOTHTS3 sp4 = new PL_UPDATE_BOMSOTHTS3() { SO1 = PlanSo, JHDM1 = PlanCode, ZDDM1 = scode }; Procedure.run(sp4); string ChSql1 = "select comp ,qty from RSTBOMQD_CRM where udesc='" + part2 + "' and zddm='" + scode + "' "; DataTable dt2 = dc.GetTable(ChSql1); if (dt2.Rows.Count > 0) { string code = dt2.Rows[0][0].ToString(); string qty = dt2.Rows[0][1].ToString(); //iteam_code = iteam_code + '#' + code; dr[i + 3] = code + "----" + qty; //dr[i + 4] = qty; } } Table1.Rows.Add(dr); } Session["rept3400table"] = Table1; ASPxGridView1.DataSource = Table1; ASPxGridView1.DataBind(); }