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); } }
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); } }
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE; if (e.NewValues["IsDefault"] == null) { e.NewValues["IsDefault"] = false; } if (Util.isExistXpoObject <AccountingPeriodType>("Name", (string)e.NewValues["Name"])) { e.Cancel = true; throw(new Exception("Trùng tên thể loại chu kì")); } if ((bool)e.NewValues["IsDefault"] == true) { CriteriaOperator criteria = new BinaryOperator("IsDefault", true, BinaryOperatorType.Equal); AccountingPeriodType type = session.FindObject <AccountingPeriodType>(criteria); e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE; if (type != null) { if (AccountingPeriodTypeBO.IsUsedAccoutingPeriodType(session, type.AccountingPeriodTypeId)) { ASPxGridView2.CancelEdit(); throw new Exception("Loại chu kì nhỏ nhất " + type.Name + " đang được sử dụng nên không thể thay đổi"); } type.IsDefault = false; type.Save(); } } }
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(); }
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(); }
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) { 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 ASPxMenu2_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e) { if (ValidarConexionYUsuarioLogueado(new object())) { return; } try { var fieldValues = ASPxGridView2.GetSelectedFieldValues(new[] { "CODE_SKU" }); foreach (var t in fieldValues) { _objSeller.InsertSellerBySku(Session["connectionString"].ToString(), t.ToString(), Session["SELLER_CODE_BY_SKU"].ToString(), Session["USER"].ToString()); } for (var i = 0; i < ASPxGridView2.VisibleRowCount; i++) { if (!ASPxGridView2.Selection.IsRowSelected(i)) { var fieldValues2 = ASPxGridView2.GetRowValues(i, new[] { "CODE_SKU" }); _objSeller.DeleteSellerBySku(Session["connectionString"].ToString(), fieldValues2.ToString(), Session["SELLER_CODE_BY_SKU"].ToString()); //fieldValues2.ToString(); } } GetSellerBySku(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } }
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); } }
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(); }
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxComboBox uGxdm = ASPxGridView2.FindEditFormTemplateControl("txtGxdm") as ASPxComboBox; ASPxTextBox uPath = ASPxGridView2.FindEditFormTemplateControl("txtPath") as ASPxTextBox; ASPxTextBox uCzts = ASPxGridView2.FindEditFormTemplateControl("txtCzts") as ASPxTextBox; string gxdm = uGxdm.Text.Trim(); string path = uPath.Text.Trim(); string czts = uCzts.Text.Trim(); string part = ASPxGridView2.GetRowValues(ASPxGridView2.EditingRowVisibleIndex, new string[] { "PART" }).ToString(); //string part = e.NewValues["PART"].ToString(); //修改前数据插入到日志表 string Lsql = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE)select PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT, " + "'" + theUserName + "','BEFOREDIT',SYSDATE FROM RST_ATPU_ZJTS WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "' "; dc.ExeSql(Lsql); string Sql = "UPDATE RST_ATPU_ZJTS SET CZTS='" + czts + "', WJPATH='" + path + "'" + " WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "' "; dc.ExeSql(Sql); //修改后数据插入到日志表 string Lsql2 = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE)select PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT, " + "'" + theUserName + "','AFTEREDIT',SYSDATE FROM RST_ATPU_ZJTS WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "'"; dc.ExeSql(Lsql2); e.Cancel = true; ASPxGridView2.CancelEdit(); //if (Session["inv9501sql"] as string != "") //{ // DataTable dt2 = dc.GetTable(Session["inv9501sql"] as string); // ASPxGridView2.DataSource = dt2; // ASPxGridView2.DataBind(); //} SetCondition(); }
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(); }
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 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() { //初始化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 ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxComboBox NaturalPerson = ASPxGridView2.FindEditFormLayoutItemTemplateControl("PersonnePysique") as ASPxComboBox; cn.Open(); string req = "select Id from NaturalPerson where FirstName= '" + NaturalPerson.SelectedItem.ToString() + "'"; SqlCommand cmd = new SqlCommand(req, cn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { e.NewValues["PersonnePysique_Id"] = dr["Id"].ToString(); } cn.Close(); ASPxComboBox Adresse = ASPxGridView2.FindEditFormLayoutItemTemplateControl("PartnerDocs") as ASPxComboBox; cn.Open(); string req1 = "select Id from PartnerDocs where DocRef= '" + Adresse.SelectedItem.ToString() + "'"; SqlCommand cmd1 = new SqlCommand(req1, cn); SqlDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { e.NewValues["PartnerDocs_Id"] = dr1["Id"].ToString(); } cn.Close(); }
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); } }
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); } }
protected void ASPxGridView2_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } try { var formLayout = ASPxGridView2.FindEditFormTemplateControl("ASPxFormLayout1") as ASPxFormLayout; if (formLayout != null) { var gridLookupVendedor = formLayout.FindControl("GridLookupVendedor") as ASPxGridLookup; var memoComentarios = formLayout.FindControl("MemoComentarios") as ASPxMemo; var timeEditHoraVisita = formLayout.FindControl("TimeEditHoraVisita") as ASPxTimeEdit; var spinPrioridad = formLayout.FindControl("SpinPrioridad") as ASPxSpinEdit; var customerCode = ASPxGridView2.GetRowValuesByKeyValue(e.Keys[0], "CUSTOMER_CODE"); var customerName = ASPxGridView2.GetRowValuesByKeyValue(e.Keys[0], "CUSTOMER_NAME"); var pResult = ""; _objTask.UpdateInsertPresaleTasks(Session["connectionString"].ToString(), customerCode.ToString(), customerName.ToString(), gridLookupVendedor.Text, memoComentarios.Text, timeEditHoraVisita.DateTime, ASPxCalendar1.SelectedDate, Convert.ToInt32(spinPrioridad.Number), ref pResult); } GetTasksByDate(ASPxCalendar1.SelectedDate); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } ASPxGridView2.CancelEdit(); e.Cancel = true; }
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridLookup uSO = ASPxGridView2.FindEditFormTemplateControl("txtSO2") as ASPxGridLookup; ASPxTextBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxTextBox; ASPxTextBox uPQBAK = ASPxGridView2.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox; ASPxTextBox uREMARK = ASPxGridView2.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox; string strSO = uSO.Value.ToString(); string strJX = uJX.Text.Trim(); string strPQBAK = uPQBAK.Text.Trim(); string strREMARK = uREMARK.Text.Trim(); string Sql = "INSERT INTO PAINT_SO (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,input_person,input_time) " + "VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserId + "',sysdate)"; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)" + " VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserCode + "' , 'ADD', SYSDATE) "; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView2.CancelEdit(); setCondition(); }
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxTextBox uSO = ASPxGridView2.FindEditFormTemplateControl("TextSO") as ASPxTextBox; string strSO = uSO.Text.Trim(); string Sql = "INSERT INTO NONPPIF_ATPU (SO,input_person,input_time)VALUES( '" + strSO + "','" + theUserId + "',sysdate) "; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO NONPPIF_ATPU_LOG (SO,user_code,flag,rqsj)" + " SELECT SO,'" + theUserCode + "' , 'ADD', SYSDATE FROM NONPPIF_ATPU WHERE SO = '" + strSO + "' "; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView2.CancelEdit(); setCondition(); }
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(); } }
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 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 ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxComboBox; ASPxComboBox uPD = ASPxGridView2.FindEditFormTemplateControl("txtPD") as ASPxComboBox; string strJX = uJX.Value.ToString(); string strPD = uPD.Value.ToString(); string Sql = "INSERT INTO JWYF (JXREMARK,PANDUAN,INPUT_PERSON,INPUT_TIME) " + "VALUES('" + strJX + "', '" + strPD + "','" + theUserId + "',SYSDATE)"; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO JWYF_LOG (JXREMARK,PANDUAN,user_code,flag,rqsj)" + " VALUES('" + strJX + "', '" + strPD + "','" + theUserCode + "' , 'ADD', SYSDATE) "; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView2.CancelEdit(); setCondition(); }
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 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; } }
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox plineCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; ASPxTextBox ljmc = ASPxGridView2.FindEditFormTemplateControl("txtName") as ASPxTextBox; //取RMES_ID的值 string sql_rmes_id = "SELECT SEQ_RMES_ID.NEXTVAL FROM DUAL "; dc.setTheSql(sql_rmes_id); string rmes_id = dc.GetTable().Rows[0][0].ToString(); string Sql = ""; Sql = "INSERT INTO DMZYLJB_NAME (RMES_ID,LJMC,PLINE_CODE,INPUT_PERSON,INPUT_TIME)" + "VALUES('" + rmes_id + "', '" + ljmc.Text.Trim() + "','" + plineCode.Value.ToString() + "','"+theUserId+"',SYSDATE)"; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO DMZYLJB_NAME_LOG (RMES_ID,LJMC,PLINE_CODE,user_code,flag,rqsj)" + " SELECT RMES_ID,LJMC,PLINE_CODE,'" + theUserCode + "' , 'ADD', SYSDATE FROM DMZYLJB_NAME WHERE RMES_ID = '" + rmes_id + "'"; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView2.CancelEdit(); setCondition(); }
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox plineCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; ASPxTextBox ljmc = ASPxGridView2.FindEditFormTemplateControl("txtName") as ASPxTextBox; ASPxComboBox partNAME_ABC = ASPxGridView2.FindEditFormTemplateControl("comboLJLB_NAME") as ASPxComboBox; string Sql = "INSERT INTO ATPUSMLJB (PLINE_CODE,ABOM_DESC,PART_ABC,INPUT_PERSON,INPUT_TIME) " + "VALUES( '" + plineCode.Value.ToString() + "','" + ljmc.Text.Trim() + "','" + partNAME_ABC.Value.ToString() + "','" + theUserId + "',SYSDATE)"; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO ATPUSMLJB_LOG (PLINE_CODE,ABOM_DESC,PART_ABC,user_code,flag,rqsj)" + " SELECT PLINE_CODE,ABOM_DESC,PART_ABC,'" + theUserCode + "' , 'ADD', SYSDATE FROM ATPUSMLJB " + "WHERE PLINE_CODE = '" + plineCode.Value.ToString() + "' and ABOM_DESC = '" + ljmc.Text.Trim() + "'"; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView2.CancelEdit(); setCondition(); }
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); } }