protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("comboLJZL") as ASPxComboBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("comboPCode") as ASPxComboBox).Enabled = false; //(ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxComboBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("ASPxTextBox1") as ASPxTextBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtLJMC") as ASPxTextBox).Enabled = false; if (theZYLJZL == "检查重要零件") { (ASPxGridView1.FindEditFormTemplateControl("comboLJJB") as ASPxComboBox).Enabled = false; } } if (ASPxGridView1.IsNewRowEditing) { theZYLJZL = ""; (ASPxGridView1.FindEditFormTemplateControl("comboLJZL") as ASPxComboBox).Text = ""; if (theZYLJZL == "检查重要零件") { (ASPxGridView1.FindEditFormTemplateControl("comboLJJB") as ASPxComboBox).Enabled = false; } } string PSql = "select PLINE_CODE,PLINE_NAME from CODE_PRODUCT_LINE where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')"; DataTable Pdt = dc.GetTable(PSql); ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("comboPCode") as ASPxComboBox; uPcode.DataSource = Pdt; uPcode.TextField = Pdt.Columns[1].ToString(); uPcode.ValueField = Pdt.Columns[0].ToString(); uPcode.SelectedIndex = uPcode.Items.Count >= 0 ? 0 : -1; }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql = " select distinct a.pline_code,b.pline_name as 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 + "' "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[1].ToString(); uPCode.ValueField = dt.Columns[0].ToString(); //try //{ // if (Session["9100USER"].ToString() != "") // { // string sql = Session["9100USER"] as string; // SqlBgy.SelectCommand = sql; // SqlBgy.DataBind(); // } //} //catch //{ } //try //{ // if (Session["9100PART"].ToString() != "") // { // string sql = Session["9100PART"] as string; // SqlPart.SelectCommand = sql; // SqlPart.DataBind(); // } //} //catch //{ } }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { 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 + "' "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[1].ToString(); uPCode.ValueField = dt.Columns[0].ToString(); string Sql2 = "select distinct LOCATION_CODE,LOCATION_CODE||' '||LOCATION_NAME from CODE_LOCATION where LOCATION_CODE not like 'OP%' and LOCATION_CODE not in (select location_code from ms_location_time where gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "'))" + "and pline_code in (select pline_id from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') order by LOCATION_CODE"; DataTable dt2 = dc.GetTable(Sql2); ASPxComboBox uLCode = ASPxGridView1.FindEditFormTemplateControl("txtLCode") as ASPxComboBox; uLCode.DataSource = dt2; uLCode.TextField = dt2.Columns[1].ToString(); uLCode.ValueField = dt2.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtLCode") as ASPxComboBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false; } else { //uTcode.SelectedIndex = 0; } }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql3 = "SELECT PT_PART,PT_DESC2 FROM COPY_PT_MSTR where pt_phantom=0 order by PT_PART "; SqlDataSource3.SelectCommand = Sql3; SqlDataSource3.DataBind(); }
//创建EDITFORM前 protected void ASPxGridView3_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView3.IsNewRowEditing && ASPxGridView3.IsEditing) { ///主键不可以修改 (ASPxGridView3.FindEditFormTemplateControl("comboLJDM3") as ASPxComboBox).Enabled = false; //处理ASPxCheckBox if (ASPxGridView3.GetRowValues(ASPxGridView3.FocusedRowIndex, "SFHC").ToString() == "1") { (ASPxGridView3.FindEditFormTemplateControl("chHCFlag") as ASPxCheckBox).Checked = true; } else { (ASPxGridView3.FindEditFormTemplateControl("chHCFlag") as ASPxCheckBox).Checked = false; } //处理ASPxCheckBox if (ASPxGridView3.GetRowValues(ASPxGridView3.FocusedRowIndex, "SFZC").ToString() == "1") { (ASPxGridView3.FindEditFormTemplateControl("chHCZCFlag") as ASPxCheckBox).Checked = true; } else { (ASPxGridView3.FindEditFormTemplateControl("chHCZCFlag") as ASPxCheckBox).Checked = false; } } }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql = "select distinct a.pline_code,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 + "' "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[1].ToString(); uPCode.ValueField = dt.Columns[0].ToString(); // string strPCode = uPCode.Value.ToString(); string Sql1 = "select distinct PLAN_SO,PLAN_SO as showtext from DATA_PLAN "; DataTable dt1 = dc.GetTable(Sql1); ASPxComboBox txtSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxComboBox; txtSO.DataSource = dt1; txtSO.TextField = dt1.Columns[1].ToString(); txtSO.ValueField = dt1.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxComboBox).Enabled = false; } else { //uTcode.SelectedIndex = 0; } }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { //创建Editform,对其中某些字段进行属性设置 ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox; ASPxComboBox uScode = ASPxGridView1.FindEditFormTemplateControl("dropStationCode") as ASPxComboBox; string Sql2 = "select pline_code,pline_code||' '||pline_name as showtext from CODE_PRODUCT_LINE"; DataTable dt2 = dc.GetTable(Sql2); uPcode.DataSource = dt2; uPcode.TextField = dt2.Columns[1].ToString(); uPcode.ValueField = dt2.Columns[0].ToString(); string Sql3 = "SELECT STATION_CODE,STATION_CODE||' '||STATION_NAME AS SHOWTEXT FROM CODE_STATION"; DataTable dt3 = dc.GetTable(Sql3); uScode.DataSource = dt3; uScode.TextField = dt3.Columns[1].ToString(); uScode.ValueField = dt3.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtSubCode") as ASPxTextBox).Enabled = false; } }
protected void grid_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (this.grid.EditingRowVisibleIndex > -1) { ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox partyName = pageControl.FindControl("txt_PartyName") as ASPxTextBox; ASPxTextBox whName = pageControl.FindControl("txt_WhName") as ASPxTextBox; ASPxDateEdit txt_Date = pageControl.FindControl("txt_Date") as ASPxDateEdit; txt_Date.Enabled = false; partyName.Text = EzshipHelper.GetPartyName(this.grid.GetRowValues(this.grid.EditingRowVisibleIndex, new string[] { "PartyId" })); whName.Text = EzshipHelper.GetWarehouse(this.grid.GetRowValues(this.grid.EditingRowVisibleIndex, new string[] { "WhCode" })); string oid = SafeValue.SafeString(this.grid.GetRowValues(this.grid.EditingRowVisibleIndex, new string[] { "Id" })); if (oid.Length > 0) { string sql = string.Format("select StatusCode from wh_Contract where Id='{0}'", oid); string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");// ASPxButton btn = this.grid.FindEditFormTemplateControl("btn_CloseJob") as ASPxButton; ASPxButton btn_VoidMaster = this.grid.FindEditFormTemplateControl("btn_Void") as ASPxButton; if (closeInd == "CLS") { btn.Text = "Open Job"; } if (closeInd == "CNL") { btn_VoidMaster.Text = "Unvoid"; } else { btn.Text = "Close"; } } } }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxComboBox).Enabled = false; //处理ASPxCheckBox string a = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString(); if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString() != "") { (ASPxGridView1.FindEditFormTemplateControl("chValidFlag") as ASPxCheckBox).Checked = true; } else { (ASPxGridView1.FindEditFormTemplateControl("chValidFlag") as ASPxCheckBox).Checked = false; } if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQBEGIN").ToString() != "") { theBeginDate = Convert.ToDateTime(ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQBEGIN").ToString()); } if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString() != "") { theEndDate = Convert.ToDateTime(ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString()); } } }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { //创建EditForm前 //string Sql = "select a.pline_code,a.pline_code||' '||a.pline_name as showtext from code_product_line a "; string Sql = "select DISTINCT A.PLINE_CODE,A.PLINE_CODE||' '||a.pline_name AS SHOWTEXT FROM CODE_PRODUCT_LINE A where pline_code in( select pline_code from vw_user_role_program where USER_ID='" + theUserId + "' and program_code='" + theProgramCode + "' ) "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[1].ToString(); uPCode.ValueField = dt.Columns[0].ToString(); uPCode.SelectedIndex = uPCode.Items.Count >= 0 ? 0 : -1; string Sql2 = "select ROUNTING_REMARK,ROUNTING_REMARK as showtext from DATA_ROUNTING_REMARK "; DataTable dt2 = dc.GetTable(Sql2); ASPxComboBox uROUNT = ASPxGridView1.FindEditFormTemplateControl("comboxROUNT") as ASPxComboBox; uROUNT.DataSource = dt2; uROUNT.TextField = dt2.Columns[1].ToString(); uROUNT.ValueField = dt2.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("comboxROUNT") as ASPxComboBox).Enabled = false; } else { //uTcode.SelectedIndex = 0; } }
protected void gridDistributorsManage_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!SessionManager.IsEditFormCreated) { if (!gridDistributorsManage.IsNewRowEditing) { // initialize distributor type combo box ASPxComboBox combo = (ASPxComboBox)gridDistributorsManage.FindEditFormTemplateControl("cboType"); if (combo != null) { object value = gridDistributorsManage.GetRowValues(gridDistributorsManage.EditingRowVisibleIndex, "IDDistributorType"); foreach (ListEditItem lei in combo.Items) { if (lei.Value.ToString() == value.ToString()) { combo.SelectedItem = lei; } } } } SessionManager.IsEditFormCreated = true; } }
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; //} }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { (ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtGCode") as ASPxTextBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtLocation") as ASPxComboBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox).Enabled = false; } if (ASPxGridView1.IsNewRowEditing) { (ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox).Enabled = false; } 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 + "' "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[1].ToString(); uPCode.ValueField = dt.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { (ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox).Enabled = false; } }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { // txtPCode.value = 'E'; string Sql = " select distinct a.pline_code,b.pline_name 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 + "' "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[1].ToString(); uPCode.ValueField = dt.Columns[0].ToString(); uPCode.SelectedIndex = uPCode.Items.Count >= 0 ? 0 : -1; if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 string strIflag = ASPxGridView1.GetRowValues(ASPxGridView1.EditingRowVisibleIndex, new string[] { "INCREASE_FLAG" }).ToString(); char chr = Convert.ToChar(strIflag); (ASPxGridView1.FindEditFormTemplateControl("ASPxComboBox1") as ASPxComboBox).Enabled = false; if (chr == 'A') { (ASPxGridView1.FindEditFormTemplateControl("txtSinitial") as ASPxTextBox).Enabled = false; } else { (ASPxGridView1.FindEditFormTemplateControl("txtSmax") as ASPxTextBox).Enabled = false; } } else { //uTcode.SelectedIndex = 0; } }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtVendorCode") as ASPxTextBox).Enabled = false; } }
protected void ASPxGridView2_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView2.IsNewRowEditing && ASPxGridView2.IsEditing) { ///主键不可以修改 (ASPxGridView2.FindEditFormTemplateControl("txtSO2") as ASPxGridLookup).ClientEnabled = false; (ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxTextBox).Enabled = false; } }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { ////创建Editform,对其中某些字段进行属性设置 //if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) //{ // ///主键不可以修改 // (ASPxGridView1.FindEditFormTemplateControl("txtDeptCode") as ASPxTextBox).Enabled = false; //} }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { //主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("pro") as ASPxTextBox).Enabled = false; //按照之前开发的样子,生产线也不可以修改 //(ASPxGridView1.FindEditFormTemplateControl("ASPxComboBox1") as ASPxComboBox).Enabled = false; } }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup; gridLookupUser.GridView.Width = 250; ASPxGridLookup gridLookupTeam = ASPxGridView1.FindEditFormTemplateControl("gridLookupTeam") as ASPxGridLookup; gridLookupTeam.GridView.Width = 250; }
protected void ASPxGridView2_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string PSql = "select PLINE_CODE,PLINE_NAME from CODE_PRODUCT_LINE where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')"; DataTable Pdt = dc.GetTable(PSql); ASPxComboBox uPcode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPcode.DataSource = Pdt; uPcode.TextField = Pdt.Columns[1].ToString(); uPcode.ValueField = Pdt.Columns[0].ToString(); }
//修改 //创建EDITFORM前 protected void ASPxGridView2_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql = "select distinct ljlb as showtext from dmfjbzb"; DataTable dt = dc.GetTable(Sql); ASPxComboBox uPCode = ASPxGridView2.FindEditFormTemplateControl("ComboLJLB") as ASPxComboBox; uPCode.DataSource = dt; uPCode.TextField = dt.Columns[0].ToString(); }
//创建EDITFORM前 //初始化入出库类型combobox protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string sql = "SELECT LXMC FROM DP_RKLX ORDER BY LXDM "; DataTable dt = dc.GetTable(sql); ASPxComboBox cb_Rklx = ASPxGridView1.FindEditFormTemplateControl("txtRklx") as ASPxComboBox; cb_Rklx.DataSource = dt; cb_Rklx.TextField = dt.Columns[0].ToString(); cb_Rklx.ValueField = dt.Columns[0].ToString(); }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false; } else { //uTcode.SelectedIndex = 0; } }
protected void grid_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { Control wc = grid.FindEditFormTemplateControl("ASPxButtonEdit1"); //grid.fin //if (wc != null) //{ // ASPxButtonEdit templateEdit = wc as ASPxButtonEdit; // // // // Initialize the editor as required // // // templateEdit.ForeColor = System.Drawing.Color.Blue; //} }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (Session["isEditForCreated"] == null) { ASPxComboBox currentBox = ((ASPxGridView)sender).FindEditFormTemplateControl("descrBox") as ASPxComboBox; int index = ((ASPxGridView)sender).EditingRowVisibleIndex; int currentKey = Convert.ToInt32(((ASPxGridView)sender).GetRowValues(index, "CategoryID")); for (int i = 1; i <= 9; i++) { currentBox.Items.Add("Description" + i.ToString()); } currentBox.SelectedIndex = currentKey - 1; } Session["isEditForCreated"] = true; }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("WorkUnit") as ASPxComboBox; ASPxComboBox WorkShop = ASPxGridView1.FindEditFormTemplateControl("WorkShop") as ASPxComboBox; //ASPxTextBox routingCode = ASPxGridView1.FindEditFormTemplateControl("txtRoutingCode") as ASPxTextBox; if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { workUnit.Enabled = false; WorkShop.Enabled = true; //routingCode.Enabled = false; } }
protected void ASPxGridView2_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql = "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 dt = dc.GetTable(Sql); ASPxComboBox Ugxdm = ASPxGridView2.FindEditFormTemplateControl("txtGxdm") as ASPxComboBox; Ugxdm.DataSource = dt; Ugxdm.TextField = dt.Columns[0].ToString(); Ugxdm.ValueField = dt.Columns[0].ToString(); //Ugxdm.SelectedIndex = Ugxdm.Items.Count >= 0 ? 0 : -1; if (!ASPxGridView2.IsNewRowEditing && ASPxGridView2.IsEditing) { ///主键不可以修改 (ASPxGridView2.FindEditFormTemplateControl("txtGxdm") as ASPxComboBox).Enabled = false; } }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { ASPxComboBox uTcode = ASPxGridView1.FindEditFormTemplateControl("dropStaionType") as ASPxComboBox; ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox; //ASPxComboBox uScode = ASPxGridView1.FindEditFormTemplateControl("dropStaionArea") as ASPxComboBox; string Sql4 = "SELECT STATION_TYPE_CODE,STATION_TYPE_CODE||' '||STATION_TYPE_NAME AS SHOWTEXT FROM CODE_STATION_TYPE"; DataTable dt4 = dc.GetTable(Sql4); uTcode.DataSource = dt4; uTcode.TextField = dt4.Columns[1].ToString(); uTcode.ValueField = dt4.Columns[0].ToString(); string Sql2 = "select RMES_ID,pline_code||' '||pline_name as showtext from CODE_PRODUCT_LINE"; DataTable dt2 = dc.GetTable(Sql2); uPcode.DataSource = dt2; uPcode.TextField = dt2.Columns[1].ToString(); uPcode.ValueField = dt2.Columns[0].ToString(); //string Sql3 = "SELECT STATION_AREA_CODE,STATION_AREA_CODE||' '||STATION_AREA_NAME AS SHOWTEXT FROM CODE_STATION_AREA"; //DataTable dt3 = dc.GetTable(Sql3); //uScode.DataSource = dt3; //uScode.TextField = dt3.Columns[1].ToString(); //uScode.ValueField = dt3.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtStationCode") as ASPxTextBox).Enabled = false; } else { //uTcode.SelectedIndex = 0; //uPcode.SelectedIndex = 0; //uScode.SelectedIndex = 0; } }
//创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql = "select STATION_TYPE_CODE,STATION_TYPE_CODE||' '||STATION_TYPE_NAME as showtext from CODE_STATION_TYPE"; DataTable dt = dc.GetTable(Sql); ASPxComboBox uSType = ASPxGridView1.FindEditFormTemplateControl("txtSType") as ASPxComboBox; uSType.DataSource = dt; uSType.TextField = dt.Columns[1].ToString(); uSType.ValueField = dt.Columns[0].ToString(); string PSql = "select RMES_ID PLINE_CODE,PLINE_NAME,PLINE_CODE from CODE_PRODUCT_LINE where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')"; DataTable Pdt = dc.GetTable(PSql); ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; uPcode.DataSource = Pdt; uPcode.TextField = Pdt.Columns[1].ToString(); uPcode.ValueField = Pdt.Columns[0].ToString(); //uPcode.SelectedIndex = uPcode.Items.Count >= 0 ? 0 : -1; string ASql = "select distinct AREA_CODE,AREA_CODE||' '||AREA_NAME as showtext from CODE_STATION_AREA 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 case AREA_CODE when 'A' then 1 when 'T' then 2 when 'P' then 3 when 'U' then 4 end"; DataTable Adt = dc.GetTable(ASql); ASPxComboBox uSArea = ASPxGridView1.FindEditFormTemplateControl("txtSArea") as ASPxComboBox; uSArea.DataSource = Adt; uSArea.TextField = Adt.Columns[1].ToString(); uSArea.ValueField = Adt.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("txtSCode") as ASPxTextBox).Enabled = false; (ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false; } else { uPcode.SelectedIndex = uPcode.Items.Count >= 0 ? 0 : -1; //uTcode.SelectedIndex = 0; } }
//修改 //创建EDITFORM前 protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { string Sql = "select ljlb||'--'||ljjc as showtext from dmfjbzb order by ljlb,ljjc "; DataTable dt = dc.GetTable(Sql); ASPxComboBox uFJB = ASPxGridView1.FindEditFormTemplateControl("ComboFJB") as ASPxComboBox; uFJB.DataSource = dt; // uFJB.TextField = dt.Columns[1].ToString(); uFJB.TextField = dt.Columns[0].ToString(); if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing) { ///主键不可以修改 (ASPxGridView1.FindEditFormTemplateControl("TextSO") as ASPxTextBox).Enabled = false; } else { //uTcode.SelectedIndex = 0; } }