private void setCondition() { string sql = "select * from sjbomsothxc where 1=1 "; if (txtDH.Text.Trim() != "") { sql = sql + "and THGROUP='" + txtDH.Value.ToString() + "'"; } if (txtJHDM.Text.Trim() != "") { sql = sql + "and JHDM='" + txtJHDM.Value.ToString() + "'"; } sql = sql + " order by rqsj desc"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); sql = "select * from RST_ATPU_ZJTS_LOG where 1=1 "; if (txtJHDM.Text.Trim() != "") { sql = sql + "and JHDM='" + txtJHDM.Value.ToString() + "'"; } sql = sql + " order by rqsj desc"; DataTable dt1 = dc.GetTable(sql); ASPxGridView2.DataSource = dt1; ASPxGridView2.DataBind(); }
public void GetSapData(string erpDoc, string tipo) { var pResult = ""; var ds = new DataSet(); switch (tipo) { case "SO": ds = _wscalled.GetSapPicking(Session["connectionString"].ToString(), erpDoc, ref pResult); break; case "IT": ds = _wscalled.GetSapPickingItr(Session["connectionString"].ToString(), erpDoc, ref pResult); break; } if (pResult == "") { Session["SAP_PICKING_DATA"] = ds; ASPxGridView2.DataSource = ds; ASPxGridView2.DataBind(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } }
public void GetLocation(string codeWarehouse) { try { var pResult = ""; var ds = _objLocation.GetLocation(Session["connectionString"].ToString(), codeWarehouse, ref pResult); if (pResult == "") { ASPxGridView2.DataSource = ds.Tables[0]; var regionCombo = (ASPxGridView2.Columns["CLASSIFICATION_LOCATION"] as GridViewDataComboBoxColumn); if (regionCombo != null) { regionCombo.PropertiesComboBox.DataSource = ds.Tables[0].DefaultView.ToTable(true, "CLASSIFICATION_LOCATION"); regionCombo.PropertiesComboBox.ValueField = "CLASSIFICATION_LOCATION"; regionCombo.PropertiesComboBox.TextField = "CLASSIFICATION_LOCATION"; } ASPxGridView2.DataBind(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
//初始化物料清单 private void setCondition() { string sql = ""; sql = " SELECT ITEM_CODE,SUM(ITEM_QTY) AS SUM FROM DATA_SN_BOM_TEMP WHERE 1=1 "; //若生产线为空,则取空值 if (txtPCode.Text.Trim() == "") { sql += " AND PLINE_CODE = '' "; } if (txtPCode.Text.Trim() != "") { sql += " AND PLINE_CODE = '" + txtPCode.Value.ToString() + "' "; } //如果列表中没有条件,则查询的数据为空 //后端取控件用ID,前端用ClientInstanceName if (ASPxGridView3.VisibleRowCount < 1) { sql += " AND SN = '' "; } if (ASPxGridView3.VisibleRowCount >= 1 && txtPCode.Text.Trim() != "") { sql += " AND SN IN (SELECT SN FROM DATA_SN_BOM_TEMP_SNTEMP WHERE PLINE_CODE = '" + txtPCode.Value.ToString() + "' AND FLAG = 'ADD') "; } sql += " GROUP BY ITEM_CODE ORDER BY ITEM_CODE "; DataTable dt = dc.GetTable(sql); ASPxGridView2.DataSource = dt; ASPxGridView2.DataBind(); }
protected void ASPxButton3_Click(object sender, EventArgs e) { try { var fieldValues2 = ASPxGridView2.GetSelectedFieldValues(new[] { "TASK_ID" }); foreach (var t in fieldValues2) { _objTask.DeleteTask(Session["connectionString"].ToString(), t.ToString()); } var fieldValues3 = ASPxGridView2.GetSelectedFieldValues(new[] { "TASK_ID", "OPERADOR" }); foreach (object[] value in fieldValues3) { ScriptManager.RegisterStartupScript(this, GetType(), "FuncionNJS", "ConnectNJS('" + value[1].ToString().ToUpper() + "' , 'CANCEL_TASK')", true); } var pResult = ""; var ds = _objTask.GetAllTaskStatus(Session["connectionString"].ToString(), ASPxDateEdit4.Date, ASPxDateEdit3.Date, ref pResult); if (pResult == "") { Session["DATA_TASK2"] = ds; ASPxGridView2.DataSource = ds; ASPxGridView2.DataBind(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
private void setCondition() { string plancode = ASPxTextPlanCode.Text.Trim().ToUpper(); //if (plancode != "") //{ // string sql = "select t.*,t.rowid from ms_over_mat_log t where 1=1 "; // if (plancode != "") // { // sql = sql + " and bill_code='DEL-" + plancode + "' "; // } // sql = sql + ""; //order by MATERIAL_CODE // DataTable dt = dc.GetTable(sql); // ASPxGridView1.DataSource = dt; // ASPxGridView1.DataBind(); //} //else //{ // string sql = "select t.*,t.rowid from ms_over_mat_log t where 1=2 "; // sql = sql + ""; //order by MATERIAL_CODE // DataTable dt = dc.GetTable(sql); // ASPxGridView1.DataSource = dt; // ASPxGridView1.DataBind(); //} string sql1 = "select t.*,t.rowid from ms_plan_adjust_log t where 1=1 "; sql1 = sql1 + " and gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + programcode + "' and company_code='" + theCompanyCode + "' )"; sql1 = sql1 + " order by log_time desc "; DataTable dt1 = dc.GetTable(sql1); ASPxGridView2.DataSource = dt1; ASPxGridView2.DataBind(); }
private void setCondition() { DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim()); DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim()); if (DT1.AddDays(31) < DT2 || ASPxListBoxUsed.Items.Count <= 0 || txtPCode.Text.Trim() == "") { ASPxGridView2.DataSource = null; ASPxGridView2.DataBind(); return; } string QtySql = "", part = ""; //QtySql = "select c.sn ,a.udesc,replace (a.comp,'#','') comp, sum(b.plan_qty*a.qty) sl from RSTBOMQD_ITEM8 a left join data_plan b " //+"on a.plan_code=b.plan_code left join data_plan_sn c on a.plan_code=c.plan_code where udesc='&*北自所信息部' "; QtySql = "select a.udesc,replace (a.comp,'#','') comp, sum(b.plan_qty*a.qty) sl from RSTBOMQD_ITEM8 a left join data_plan b on a.plan_code=b.plan_code where machinename='" + MachineName + "' and (udesc='&*北自所信息部' "; for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++) { QtySql = QtySql + "or "; part = ASPxListBoxUsed.Items[a].ToString(); QtySql = QtySql + " a.udesc='" + part + "' "; } QtySql = QtySql + " ) group by a.comp,a.udesc order by a.udesc,a.comp "; DataTable QtyDt = dc.GetTable(QtySql); ASPxGridView2.DataSource = QtyDt; ASPxGridView2.DataBind(); }
public void GetHistSku() { try { var objInventory = new WSInventory.SwiftExpressWSInventory(); var param = string.Empty; var fieldValues = ASPxGridView1.GetSelectedFieldValues(new[] { "SKU" }); param = fieldValues.Aggregate(param, (current, t) => current + t + ","); //dataset para grid 2 var pResult = ""; var ds = objInventory.GetHistSku(Session["connectionString"].ToString(), param.Substring(0, param.Length - 1), ASPxDateEdit2.Date, ASPxDateEdit1.Date.AddDays(-1), ref pResult); if (pResult == "") { ASPxGridView2.DataSource = ds; Session["SKU_HIST"] = ds; ASPxGridView2.DataBind(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } objInventory.Dispose(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
private void setCondition() { //初始化GRIDVIEW string sql = "SELECT A.RMES_ID,A.COMPANY_CODE,A.PLINE_CODE,D.PLINE_CODE PLINECODE1,D.PLINE_NAME,A.LOCATION_CODE,B.LOCATION_NAME,B.LOCATION_CODE AS LOCATION_CODE1," + "A.STATION_CODE,C.STATION_NAME,C.STATION_CODE AS STATION_CODE1,A.LOCATION_FLAG,A.LOCATION_FLAG1," + "E.INTERNAL_NAME LOCATION_FLAG_NAME,F.INTERNAL_NAME LOCATION_FLAG1_NAME FROM REL_STATION_LOCATION A " + " LEFT JOIN CODE_LOCATION B ON A.LOCATION_CODE =B.RMES_ID AND A.PLINE_CODE=B.PLINE_CODE LEFT JOIN CODE_STATION C ON A.STATION_CODE =C.RMES_ID AND A.PLINE_CODE=C.PLINE_CODE " + " LEFT JOIN CODE_PRODUCT_LINE D ON A.PLINE_CODE =D.RMES_ID " + " LEFT JOIN (select * from CODE_INTERNAL where internal_type_code='001') E ON A.LOCATION_FLAG=E.INTERNAL_CODE " + " LEFT JOIN (select * from CODE_INTERNAL where internal_type_code='002') F ON A.LOCATION_FLAG1=F.INTERNAL_CODE " + " WHERE A.COMPANY_CODE = '" + theCompanyCode + "' " + "and a.pline_code in(select w.rmes_id from VW_USER_ROLE_PROGRAM t left join code_product_line w on t.pline_code=w.pline_code " + "where t.user_id='" + theUserId + "' and t.program_code='" + theProgramCode + "') order by a.INPUT_TIME desc nulls last";//20161031增加时间列倒序排列 DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string sql2 = "SELECT A.*,B.LOCATION_CODE LOCATION ,C.STATION_NAME STATION from REL_STATION_LOCATION_LOG A LEFT JOIN CODE_LOCATION B on A.LOCATION_CODE =B.RMES_ID LEFT JOIN CODE_STATION C ON A.STATION_CODE =C.RMES_ID " + " WHERE A.COMPANY_CODE = '" + theCompanyCode + "' " + "and A.pline_code in(select w.rmes_id from VW_USER_ROLE_PROGRAM t left join code_product_line w on t.pline_code=w.pline_code " + "where t.user_id='" + theUserId + "' and t.program_code='" + theProgramCode + "') order by RQSJ desc"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
protected void AspxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { switch (e.Item.Name) { case "btnNew": Session["GridManifiesto"] = null; ASPxGridView2.DataSource = null; ASPxGridView2.DataBind(); GetPicking(); break; case "btnExcel": ASPxGridViewExporter1.WriteXlsxToResponse(); break; case "btnPdf": ASPxGridViewExporter1.Landscape = true; ASPxGridViewExporter1.WritePdfToResponse(); break; case "btnReport": ReportViewer(); ASPxPopupControl1.ShowOnPageLoad = true; break; } }
private void setCondition() { //初始化GRIDVIEW //string sql = "SELECT '装配重要零件' as ZYLJLB, A.LJDM,A.LJMC,A.XH,A.GZDD,A.LJLB,B.PLINE_NAME,B.PLINE_CODE FROM DMZYLJB A " // + " LEFT JOIN CODE_PRODUCT_LINE B ON A.GZDD=B.PLINE_CODE " // + " WHERE A.GZDD in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' " // + "and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')" // + " union SELECT '检查重要零件' as ZYLJLB, C.LJDM,C.LJMC,C.XH,C.GZDD,'' as LJLB,D.PLINE_NAME,D.PLINE_CODE FROM DMJCLJB C " // + " LEFT JOIN CODE_PRODUCT_LINE D ON C.GZDD=D.PLINE_CODE " // + " WHERE C.GZDD in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' " // +"and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')" // + " ORDER BY ZYLJLB,GZDD,LJDM"; string sql = "SELECT * from vw_zyljb WHERE GZDD in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' " + "and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') " + " ORDER BY INPUT_TIME DESC NULLS LAST "; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); initLJDM(); initPline(); initLJLB(); initLJJB(); //新增的按零件名称维护标签页 YXH string sql2 = "SELECT * from DMZYLJB_NAME WHERE PLINE_CODE in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' " + "and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ORDER BY INPUT_TIME DESC NULLS LAST"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.Cookies["user"] == null) { Response.Redirect("~/Default.aspx"); } else { if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.ViewProduct, Request.Cookies["user"]["Permission"].ToString())) { Response.Redirect("~/Finance_Module/UnAuthorized.aspx"); } } if (Convert.ToInt32(Request.QueryString["ID"].ToString()) > 0) { Product product = new Product(); product.get(Convert.ToInt32(Request.QueryString["ID"].ToString())); lblProductID.Text = product.ID.ToString(); lblProductName.Text = product.Name.ToString(); lblCreationDate.Text = product.CreationDate.ToShortDateString(); lblLastModifiedDate.Text = product.LastModifiedDate.ToShortDateString(); lblType.Text = product.TypeID.ToString(); lblCost.Text = product.Cost.ToString(); lblPrice.Text = product.Price.ToString(); ProductPriceItems PPI = new ProductPriceItems(); ASPxGridView2.DataSource = PPI.getByProductID(Convert.ToInt32(Request.QueryString["ID"].ToString())); ASPxGridView2.DataBind(); DataTable dt = product.getProductCustomers(Convert.ToInt32(Request.QueryString["ID"].ToString())); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } lockupBatch.GridView.Width = 300; if (Session["DATA_BATCH_BY_TAG"] == null) { GetBatchByTags(); } else { ASPxGridView1.DataSource = Session["DATA_BATCH_BY_TAG"]; ASPxGridView1.DataBind(); } if (Session["SKU_BY_BATCH"] != null) { ASPxGridView2.DataSource = Session["SKU_BY_BATCH"]; ASPxGridView2.DataBind(); } if (Session["TAGS_FOR_LOOKUP"] != null) { lockupBatch.DataSource = Session["TAGS_FOR_LOOKUP"]; lockupBatch.DataBind(); } }
private void initBom() { string sql = "select ljbgy ,ljdm ,ljmc ,ljdd ,ljgw ,ljsl ,rowid from RST_QAD_TEMPPRTPART where jhdm='GZ" + txtPlanCode2.Text + "'"; ASPxGridView2.DataSource = dc.GetTable(sql); ASPxGridView2.DataBind(); }
protected void Page_Init(object sender, EventArgs e) { if (Session["InitialData"] == null) { DataTable dt = new DataTable(); dt.Columns.Add("ID", typeof(int)); dt.Columns.Add("Data", typeof(string)); for (int i = 0; i < 5; i++) { dt.Rows.Add(new object[] { i, "Data_" + i.ToString() }); Session["InitialData"] = dt; } } if (Session["TargetData"] == null) { DataTable dt1 = new DataTable(); dt1.Columns.Add("ID", typeof(int)); dt1.Columns.Add("Data", typeof(string)); DataColumn[] keys = new DataColumn[1]; keys[0] = dt1.Columns["ID"]; dt1.PrimaryKey = keys; Session["TargetData"] = dt1; } ASPxGridView1.DataSource = Session["InitialData"] as DataTable; ASPxGridView1.DataBind(); ASPxGridView2.DataSource = Session["TargetData"] as DataTable; ASPxGridView2.DataBind(); }
private void setCondition() { string sql = ""; sql = "select * from MS_JIT_LOG WHERE JITTIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') AND JITTIME<=to_date('" + ASPxDateEdit3.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') "; if (ComboTabN.Text.Trim() == "三方物流要料") { sql = sql + " and JITFLAG='SF' "; } else { sql = sql + " and JITFLAG='KF' "; } sql = sql + " order by JITTIME desc"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string sql2 = "SELECT NVL(JITUSER,'SYSTEM') JITUSER,DECODE(MANUALFLAG,'0','还未计算','1','已经计算') MANUALFLAG,TO_CHAR(COMMITTIME,'YYYY-MM-DD HH24:MI:SS') COMMITTIME,NVL(TO_CHAR(ONLINETIME,'YYYY-MM-DD HH24:MI:SS'),'') ONLINETIME,NVL(TO_CHAR(JITTIME,'YYYY-MM-DD HH24:MI:SS'),'') JITTIME FROM MS_JIT_MANUALFLAG WHERE " + "GZDD IN ( select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') and jitflag='SF' and committime>sysdate-3 order by committime"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
public void GetSku(string codeSeller) { try { var pResult = ""; var ds = _objSeller.GetSkuSellerBySku(Session["connectionString"].ToString(), codeSeller, ref pResult); //ds = objSKU.getSKU(Session["connectionString"].ToString()); if (pResult == "") { Session["DS_SKU_SELLER_BY_SKU"] = ds; ASPxGridView2.DataSource = ds; ASPxGridView2.DataBind(); for (var i = 0; ds.Tables[0].Rows.Count > i; i++) { if (ds.Tables[0].Rows[i]["VALOR"].ToString() == "1") { ASPxGridView2.Selection.SetSelection(i, true); } else { ASPxGridView2.Selection.SetSelection(i, false); } } } else { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
protected void ToSelect(object sender, EventArgs e) { YxBtn.SetViewState(divSel); ASPxGridView2.DataBind(); WebChartControl1.Series.Clear(); ReportData rep = new ReportData(); for (int j = ASPxDateEdit1.Date.Year; j <= ASPxDateEdit2.Date.Year; j++) { Series series1 = new Series(j + "年", ViewType.Line); series1.Label.Visible = false; for (int s = 1; s <= 12; s++) { bool b = false; DataTable dt1 = rep.Report4_1(ASPxButtonEditcCus.Text.Trim(), ASPxButtonEditcInv.Text.Trim(), ASPxDateEdit1.Text, ASPxDateEdit2.Text, j.ToString()); for (int i = 0; i < dt1.Rows.Count; i++) { if (s.ToString() == dt1.Rows[i]["iMonth"].ToString()) { SeriesPoint point = new SeriesPoint(dt1.Rows[i]["iMonth"].ToString() + "月", dt1.Rows[i]["iQuantity"].ToString()); series1.Points.Add(point); b = true; } } if (b == false) { SeriesPoint point = new SeriesPoint(s.ToString() + "月", 0); series1.Points.Add(point); } } WebChartControl1.Series.Add(series1); } }
private void SetCondition() { string Chsql2 = "SELECT PLAN_SO,PLINE_CODE FROM DATA_PLAN WHERE PLAN_CODE='" + ASPxTextPlanCode.Text.Trim() + "'"; DataTable Chdt2 = dc.GetTable(Chsql2); if (Chdt2.Rows.Count <= 0) { } else { string Chsql3 = "SELECT STATION_CODE FROM CODE_STATION WHERE STATION_NAME='" + ASPxTextSation.Text.ToUpper().Trim() + "'"; DataTable Chdt3 = dc.GetTable(Chsql3); if (Chdt3.Rows.Count <= 0) { } } string sql2 = "SELECT JHDM,PART,GXDM,CZTS,WJPATH,TSTYPE FROM RST_ATPU_ZJTS where JHDM='" + ASPxTextPlanCode.Text.Trim() + "' AND GXDM IN (select a.process_code from rel_location_process a ," + "rel_station_location b,code_station c where c.station_code=b.station_code and b.location_code=a.location_code and c.station_name='" + ASPxTextSation.Text.ToUpper().Trim() + "')"; DataTable dt2 = dc.GetTable(sql2); //Session["inv9501sql"] = sql2; ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
private void Query() { string sql = "SELECT PART,PART_DESC,DECODE(PART_TYPE,'1','非QAD零件','0','QAD零件') PART_TYPE,EDIT_NAME,EDIT_DATE,DEL_DATE,BGY,GZDD FROM ATPUBKFLPART_LOG WHERE "; if (txtPlineCode.Text.Trim() == "") { sql = sql + " GZDD IN (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')"; } else { sql = sql + " GZDD='" + txtPlineCode.Value.ToString() + "'"; } if (ASPxDateEdit1.Text.Trim() != "") { sql = sql + " AND DEL_DATE>=to_date('" + ASPxDateEdit1.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') "; } if (ASPxDateEdit3.Text.Trim() != "") { sql = sql + " AND DEL_DATE<=to_date('" + ASPxDateEdit3.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') "; } if (TextPart.Text.Trim() != "") { sql = sql + " AND PART LIKE '%" + TextPart.Text.Trim() + "%'"; } sql = sql + " ORDER BY PART"; DataTable dt = dc.GetTable(sql); ASPxGridView2.DataSource = dt; ASPxGridView2.DataBind(); }
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(); }
private void setCondition2() { string selSql2 = "select material_code,gys_code,cur_handle_num,to_char(CUR_HANDLE_TIME,'yyyy-mm-dd hh24:mi:ss') CUR_HANDLE_TIME,bill_code " + "from ms_inv_mat_log " + "where gzdd='" + comPLQ.Value.ToString() + "'"; if (txtMatCodeLog.Text != "") { selSql2 = selSql2 + " and material_code like UPPER('%" + txtMatCodeLog.Text.Trim() + "%') "; } if (txtGysCodeLog.Text != "") { selSql2 = selSql2 + " and gys_code like UPPER('%" + txtGysCodeLog.Text.Trim() + "%') "; } if (txtBillCodeQ.Text != "") { selSql2 = selSql2 + " and bill_code like UPPER('%" + txtBillCodeQ.Text.Trim() + "%') "; } if (StartDateQ.Value != null) { selSql2 = selSql2 + " and CUR_HANDLE_TIME >= to_date('" + StartDateQ.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss') "; } if (EndDateQ.Value != null) { selSql2 = selSql2 + " and CUR_HANDLE_TIME <= to_date('" + EndDateQ.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss') "; } selSql2 = selSql2 + " order by 1,2"; DataTable dt2 = dc.GetTable(selSql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
private void setCondition() { string selSql = "select a.material_code,a.gys_code,a.material_num,a.add_yh,to_char(a.ADD_TIME,'yyyy-mm-dd hh24:mi:ss') ADD_TIME,a.ready_flag," + "to_char(a.last_handle_time,'yyyy-mm-dd hh24:mi:ss') last_handle_time,a.last_handle_num,a.bill_code,a.gzdd,b.PT_DESC2,c.ad_name " + " from ms_inv_mat a " + " left join copy_pt_mstr b on a.material_code=b.pt_part " + " left join copy_ad_mstr c on a.gys_code=c.ad_addr " + "where 1=1 "; //生产线必选,否则没数据 if (comPLQ.Value == null) { selSql += " AND a.GZDD = '' "; } else { selSql += " and a.gzdd='" + comPLQ.Value.ToString() + "' "; } if (TxtMatCodeQ.Text != "") { selSql = selSql + " and a.material_code like '" + TxtMatCodeQ.Text.Trim() + "%'"; } if (txtGysCodeQ.Text != "") { selSql = selSql + " and a.gys_code like '" + txtGysCodeQ.Text.Trim() + "%'"; } selSql = selSql + " order by 1,2"; DataTable dt = dc.GetTable(selSql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string selSql2 = "select material_code,gys_code,cur_handle_num,to_char(CUR_HANDLE_TIME,'yyyy-mm-dd hh24:mi:ss') CUR_HANDLE_TIME,bill_code,gzdd " + "from ms_inv_mat_log " + "where 1=1 "; //生产线必选,否则没数据 if (comPLQ.Value == null) { selSql2 += " AND GZDD = '' "; } else { selSql2 += " and gzdd='" + comPLQ.Value.ToString() + "' "; } if (TxtMatCodeQ.Text != "") { selSql2 = selSql2 + " and material_code like UPPER('%" + TxtMatCodeQ.Text.Trim() + "%') "; } if (txtGysCodeQ.Text != "") { selSql2 = selSql2 + " and gys_code like UPPER('%" + txtGysCodeQ.Text.Trim() + "%') "; } selSql2 = selSql2 + " order by 1,2"; DataTable dt2 = dc.GetTable(selSql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
private void setCondition() { string sn1 = txtLSH1.Text.Trim(); string sn2 = txtLSH2.Text.Trim(); string ZD1 = txtSCode.Text.Trim(); if (txtLSH1.Text.Trim() != "" && txtLSH2.Text.Trim() != "") { int lsh1 = Convert.ToInt32(txtLSH1.Text.Trim()); int lsh2 = Convert.ToInt32(txtLSH2.Text.Trim()); string Chsql1 = "select * from DATA_PRODUCT where SN='" + txtLSH1.Text.Trim() + "' "; DataTable Chdt1 = dc.GetTable(Chsql1); if (Chdt1.Rows.Count <= 0) { sn1 = ""; sn2 = ""; } string Chsql2 = "select * from DATA_PRODUCT where SN='" + txtLSH2.Text.Trim() + "' "; DataTable Chdt2 = dc.GetTable(Chsql2); if (Chdt2.Rows.Count <= 0) { sn1 = ""; sn2 = ""; } if (lsh1 > lsh2) { sn1 = ""; sn2 = ""; } } else { sn1 = ""; sn2 = ""; } if (ZD1 != "") { string sql = " select * from DATA_SCAN_ITEM where STATION_NAME='" + ZD1 + "' AND SN>='" + sn1 + "' and SN <='" + sn2 + "' and machinename='" + MachineName + "' order by SN"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string sql2 = " select ITEM_CODE ,ITEM_NAME ,sum(ITEM_QTY) as QTY from DATA_SCAN_ITEM where STATION_NAME='" + ZD1 + "' AND SN>='" + sn1 + "' and SN <='" + sn2 + "' and machinename='" + MachineName + "' group by ITEM_CODE,ITEM_NAME"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); } else { string sql = " select * from DATA_SCAN_ITEM where SN>='" + sn1 + "' and SN <='" + sn2 + "' and machinename='" + MachineName + "' order by SN"; DataTable dt = dc.GetTable(sql); ASPxGridView1.DataSource = dt; ASPxGridView1.DataBind(); string sql2 = " select ITEM_CODE ,ITEM_NAME ,sum(ITEM_QTY) as QTY from DATA_SCAN_ITEM where SN>='" + sn1 + "' and SN <='" + sn2 + "' and machinename='" + MachineName + "' group by ITEM_CODE,ITEM_NAME"; DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); } }
//初始化分装总成维护 private void setCondition2() { string sql = "SELECT * FROM ATPUFZZCB ORDER BY INPUT_TIME desc nulls last, SCXDM"; DataTable dt = dc.GetTable(sql); ASPxGridView2.DataSource = dt; ASPxGridView2.DataBind(); }
protected void ASPxGridView2_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string sql2 = "SELECT * FROM ATPUFRLOG order by RQSJ desc "; //WHERE YHMC='" + theUserId + "' DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ASPxGridView2.DataSource = new[] { new{ c1 = 1, c2 = "MS001", c3 = "Ví dụ 1", c4 = "Ví dụ 1", c5 = 5, c6 = "01/07/2015", c7 = 500, grossamount = 500, c8 = "5.000", c9 = "2.500.000", c10 = "5%", c11 = "Ví dụ" }, new{ c1 = 2, c2 = "MS002", c3 = "Ví dụ 2", c4 = "Ví dụ 2", c5 = 5, c6 = "01/08/2014", c7 = 500, grossamount = 400, c8 = "5.000", c9 = "2.500.000", c10 = "6%", c11 = "Ví dụ" }, new{ c1 = 3, c2 = "MS003", c3 = "Ví dụ 3", c4 = "Ví dụ 3", c5 = 5, c6 = "01/09/2016", c7 = 500, grossamount = 450, c8 = "5.000", c9 = "2.500.000", c10 = "8%", c11 = "Ví dụ" } }; ASPxGridView2.KeyFieldName = "c1"; ASPxGridView2.DataBind(); ASPxGridView2_hanghoa.DataSource = new[] { new{ c1 = 1, c2 = "MS001", c3 = "Ví dụ 1", c4 = "Ví dụ 1", c5 = 5, c6 = "01/07/2015", c7 = 500, grossamount = 500, c8 = "5.000", c9 = "2.500.000", c10 = "5%", c11 = "Ví dụ" }, new{ c1 = 2, c2 = "MS002", c3 = "Ví dụ 2", c4 = "Ví dụ 2", c5 = 5, c6 = "01/08/2014", c7 = 500, grossamount = 400, c8 = "5.000", c9 = "2.500.000", c10 = "6%", c11 = "Ví dụ" }, new{ c1 = 3, c2 = "MS003", c3 = "Ví dụ 3", c4 = "Ví dụ 3", c5 = 5, c6 = "01/09/2016", c7 = 500, grossamount = 450, c8 = "5.000", c9 = "2.500.000", c10 = "8%", c11 = "Ví dụ" } }; ASPxGridView2_hanghoa.KeyFieldName = "c1"; ASPxGridView2_hanghoa.DataBind(); ASPxGridView3_dichvu.DataSource = new[] { new{ gia = "60.000", c1 = 1, c2 = 1, c3 = "Ví dụ 1", c4 = "Ví dụ 1", c5 = 5, c6 = "300.000", c7 = "Ví dụ 1", ck = "5%" }, new{ gia = "5.000.000", c1 = 2, c2 = 2, c3 = "Ví dụ 2", c4 = "Ví dụ 2", c5 = 5, c6 = "25.000.000", c7 = "Ví dụ 2", ck = "7%" }, new{ gia = "2.000.000", c1 = 3, c2 = 3, c3 = "Ví dụ 3", c4 = "Ví dụ 3", c5 = 5, c6 = "10.000.000", c7 = "Ví dụ 3", ck = "6%" } }; ASPxGridView3_dichvu.KeyFieldName = "c1"; ASPxGridView3_dichvu.DataBind(); ASPxGridView_khuyenmai.DataSource = new[] { new { TenQuaTang = "Phiếu Giảm Giá", GiaTri = 15000, MoTa = "NAAN Solution" }, new { TenQuaTang = "Gấu Bông", GiaTri = 15000, MoTa = "NAAN Solution" }, }; ASPxGridView_khuyenmai.DataBind(); grdData0.DataSource = new[] { new { key = "123", code = "ML0001", supplier = "Khách hàng 1", date = "25-07-2013", order = "1", status = "Dang dở", sum = "1.000.000" }, new { key = "1234", code = "ML0002", supplier = "Khách hàng 2", date = "28-07-2013", order = "2", status = "Gốc", sum = "1.500.000" }, }; grdData0.KeyFieldName = "key"; grdData0.DataBind(); grdData1.DataSource = new[] { new { key = "123", code = "ML0001", supplier = "Khách hàng 1", date = "25-07-2013", order = "1", status = "Dang dở", sum = "1.000.000" }, new { key = "1234", code = "ML0002", supplier = "Khách hàng 2", date = "28-07-2013", order = "2", status = "Gốc", sum = "1.500.000" }, }; grdData1.KeyFieldName = "key"; grdData1.DataBind(); grdData.DataSource = new[] { new { key = "123", code = "MAT001", supplier = "Khách hàng 1", date = "25-07-2013", reciept = "HD001", recieptamount = "100", realamount = "90", difamount = "10", unit = "Thùng", description = "Mặt hàng 1" }, new { key = "1234", code = "MAT002", supplier = "Khách hàng 2", date = "28-02-2013", reciept = "HD001", recieptamount = "150", realamount = "130", difamount = "20", unit = "Hộp", description = "Mặt hàng 2" }, }; grdData.KeyFieldName = "key"; grdData.DataBind(); }
protected void AddRow(DataRow row) { DataRow rw = (Session["TargetData"] as DataTable).NewRow(); rw[0] = row[0]; rw[1] = row[1]; (Session["TargetData"] as DataTable).Rows.Add(rw); ASPxGridView2.DataBind(); }
protected void ASPxGridView2_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string sql2 = "select material_code,gys_code,cur_handle_num,to_char(CUR_HANDLE_TIME,'yyyy-mm-dd hh24:mi:ss') CUR_HANDLE_TIME,bill_code " + "from ms_inv_mat_log order by cur_handle_time desc"; //WHERE YHMC='" + theUserId + "' DataTable dt2 = dc.GetTable(sql2); ASPxGridView2.DataSource = dt2; ASPxGridView2.DataBind(); }
protected void AddSingleEmploy(object sender, EventArgs e) { int UserId = Convert.ToInt32(AddSingleEmployeeUserId.Value); insert_Employee_Train_Record(UserId); //ASPxGridView1.DataBind(); ASPxGridView2.DataBind(); }