protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { int totCnt = SafeValue.SafeInt(System.Configuration.ConfigurationManager.AppSettings["License"], 0); int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar("SELECT COUNT(SequenceId) FROM [User]"), 0); if (cnt - 1 >= totCnt) { throw new Exception("Error, pls contact your IT"); } else { ASPxGridView grd = sender as ASPxGridView; ASPxTextBox pwd = grd.FindEditFormTemplateControl("txtPwd") as ASPxTextBox; if (pwd.Text == "") { e.Cancel = true; throw new Exception("Please enter the password ."); } else { ASPxTextBox userId = grd.FindEditFormTemplateControl("txtCode") as ASPxTextBox; Encryption.EncryptClass encrypt = new Encryption.EncryptClass(); e.NewValues["Pwd"] = encrypt.DESEnCode(userId.Text, pwd.Text); } e.NewValues["IsActive"] = true; } }
private Dictionary <string, object> ExtractValuesFromEditForm(ASPxGridView grid) { Dictionary <string, object> pairs = new Dictionary <string, object>(); // EmployeeID pairs.Add("EmployeeID", null); string employeeIDStr = ((ASPxLabel)grid.FindEditFormTemplateControl("lblEmployeeID")).Text; if (!string.IsNullOrEmpty(employeeIDStr)) { pairs["EmployeeID"] = Int32.Parse(employeeIDStr); } // PageControl ASPxPageControl pageControl = (ASPxPageControl)grid.FindEditFormTemplateControl("pgcEditForm"); /// First page TabPage firstPage = pageControl.TabPages[0]; pairs.Add("FirstName", ((ASPxTextBox)firstPage.FindControl("tbFirstName")).Text); pairs.Add("LastName", ((ASPxTextBox)firstPage.FindControl("tbLastName")).Text); pairs.Add("BirthDate", ((ASPxDateEdit)firstPage.FindControl("deBirthDate")).Date); /// Second page TabPage secondPage = pageControl.TabPages[1]; pairs.Add("City", ((ASPxTextBox)secondPage.FindControl("tbCity")).Text); pairs.Add("Country", ((ASPxTextBox)secondPage.FindControl("tbCountry")).Text); /// Third page pairs.Add("Notes", ((ASPxMemo)pageControl.TabPages[2].FindControl("txtNotes")).Text); /// Fourth page TabPage fourthPage = pageControl.TabPages[3]; pairs.Add("OccupationID", ((ASPxComboBox)fourthPage.FindControl("cbOccupation")).Value); pairs.Add("Subscriber", ((ASPxCheckBox)fourthPage.FindControl("chbSubscriber")).Checked); return(pairs); }
protected void gridInterviewDet_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grd = sender as ASPxGridView; ASPxTextBox name = grd.FindEditFormTemplateControl("txt_Name") as ASPxTextBox; if (SafeValue.SafeString(name.Text).Length < 1) { throw new Exception("Name not be null !!!"); return; } e.NewValues["Status"] = "CANDIDATE"; e.NewValues["InterviewId"] = SafeValue.SafeString(e.NewValues["InterviewId"], ""); e.NewValues["RecruitId"] = SafeValue.SafeString(e.NewValues["RecruitId"], ""); ASPxCheckBox married = grd.FindEditFormTemplateControl("ckb_Married") as ASPxCheckBox; if (married.Checked) { e.NewValues["Married"] = "Y"; } else { e.NewValues["Married"] = "N"; } e.NewValues["CreateBy"] = HttpContext.Current.User.Identity.Name; e.NewValues["CreateDateTime"] = DateTime.Now; }
protected void GRID_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; ASPxTextBox txtNombre = (ASPxTextBox)grid.FindEditFormTemplateControl("ASPxNombre"); ASPxListBox cmbMateriales = (ASPxListBox)grid.FindEditFormTemplateControl("ASPxListBox"); MATERIAL newKit = new MATERIAL(); newKit.M_NOMBRE = txtNombre.Text; newKit.M_TIPO = "Kit"; newKit.M_MEDIDA_COMPRA = 1; newKit.M_MEDIDA_DISTRIBUCION = 1; newKit.M_STOCK_BAJO = 1; newKit.M_STOCK_IDEAL = 100; newKit.M_STOCK_REAL = 0; CRUD_Material.Create(newKit); int kit_id = CRUD_Material.Read(newKit.M_NOMBRE); foreach (ListEditItem item in cmbMateriales.Items) { MATERIAL_KIT mat = new MATERIAL_KIT(); mat.M_ID = kit_id; mat.MAT_M_ID = CRUD_Material.Read(item.Value.ToString()); mat.MK_CANTIDAD = 1; CRUD_Kit.Create(mat); } e.Cancel = true; grid.CancelEdit(); }
protected void grid_Event_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView g = this.grid_Transport; ASPxGridView gEvent = g.FindEditFormTemplateControl("grid_Event") as ASPxGridView; ASPxDropDownEdit contNo = gEvent.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit; ASPxComboBox contType = gEvent.FindEditFormTemplateControl("cmb_ContainerType") as ASPxComboBox; if (checkCont_NO_Type(contNo.Text, contType.Text)) { throw new Exception("Container No and Type are not match"); } e.NewValues["EventDateTime"] = DateTime.Now; ASPxTextBox docNo = g.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; e.NewValues["DocNo"] = docNo.Text; ASPxTextBox docType = g.FindEditFormTemplateControl("txt_DocType") as ASPxTextBox; e.NewValues["DocType"] = docType.Text; ASPxTextBox jobNo = g.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox; e.NewValues["JobNo"] = jobNo.Text; ASPxButtonEdit shipPol = g.FindEditFormTemplateControl("btn_ShipPol") as ASPxButtonEdit; e.NewValues["Pol"] = shipPol.Text; ASPxButtonEdit shipPod = g.FindEditFormTemplateControl("btn_ShipPod") as ASPxButtonEdit; e.NewValues["Pod"] = shipPod.Text; //string Name = EzshipHelper.GetUserName(); //string Port = System.Configuration.ConfigurationManager.AppSettings["LocalPort"]; e.NewValues["EventPort"] = btn_Port.Text; }
public void Effect_Inserting(object sender, ASPxDataInsertingEventArgs e) { ASPxGridView detailGridView = (ASPxGridView)sender; ASPxGridView editform_gv = (ASPxGridView)detailGridView.FindEditFormTemplateControl("cnr").FindControl("gv1"); ASPxFormLayout fl = (ASPxFormLayout)detailGridView.FindEditFormTemplateControl("cnr").FindControl("Effect_Layout_Form"); for (int i = 0; i < editform_gv.Selection.Count; i++) { SqlCommand cmd; string effect_obid = editform_gv.GetSelectedFieldValues("OBID")[i].ToString(); string detector_obid = detailGridView.GetMasterRowKeyValue().ToString(); string load_qry = "insert into TB_DE_LINK(OBID, LEFTREL, RIGHTREL, N1CREATIONDATE, N1CREATIONSESID) "; load_qry = load_qry + "VALUES (NEWID(), '" + detector_obid + "', '" + effect_obid + "', "; load_qry = load_qry + "REPLACE(REPLACE(CONVERT(varchar(23), GETDATE(), 121), '-','/'),' ', '-') , '" + SessionInfo.UserName + "') "; cmd = new SqlCommand(load_qry, fgm_moduler.func_Class.conn); cmd.ExecuteNonQuery(); } e.Cancel = true; Detector_Grid.CancelEdit(); //makeDetectorGridView(); //makeEffectGridView(); //Session["Dataset"] = DetectorVoting; //Detector_Grid.DataSource = DetectorVoting; //Detector_Grid.DataBind(); }
protected void gvw_car_no_OnRowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; var cbb_car_area = grid.FindEditFormTemplateControl("cbb_car_area") as DevExpress.Web.ASPxEditors.ASPxComboBox; var txt_car_no = grid.FindEditFormTemplateControl("txt_car_no") as DevExpress.Web.ASPxEditors.ASPxTextBox; e.NewValues["car_no"] = cbb_car_area.Text + txt_car_no.Text; }
private LogFile CollectDataForLogFile(string Mode, DataRow LogFileRow) { try { LogFile LogFileObject = new LogFile(); ContentPlaceHolder cph = (ContentPlaceHolder)Master.FindControl("ContentPlaceHolder1"); ASPxGridView gv = (ASPxGridView)cph.FindControl("LogFileGridView"); //cph.FindControl("LogFileGridView"); ASPxTextBox txtKeyword = (ASPxTextBox)gv.FindEditFormTemplateControl("LogFileTextBox"); ASPxTextBox txtNotRequiredKeyword = (ASPxTextBox)gv.FindEditFormTemplateControl("NotLogFileTextBox"); ASPxCheckBox LogFileCheckBox = (ASPxCheckBox)gv.FindEditFormTemplateControl("LogFileCheckBox"); ASPxCheckBox logCheckBox = (ASPxCheckBox)gv.FindEditFormTemplateControl("logCheckBox"); ASPxCheckBox AgentlogCheckBox = (ASPxCheckBox)gv.FindEditFormTemplateControl("AgentlogCheckBox"); LogFileObject.Keyword = txtKeyword.Text; LogFileObject.NotRequiredKeyword = txtNotRequiredKeyword.Text; //LogFileRow["Keyword"].ToString(); if (LogFileCheckBox.Checked == true) { LogFileObject.RepeatOnce = true; } else { LogFileObject.RepeatOnce = false; } if (logCheckBox.Checked == true) { LogFileObject.Log = true; } else { LogFileObject.Log = false; } if (AgentlogCheckBox.Checked == true) { LogFileObject.AgentLog = true; } else { LogFileObject.AgentLog = false; } //bool.Parse(LogFileRow["RepeatOnce"].ToString()); if (Mode == "Update") { LogFileObject.ID = int.Parse(LogFileRow["ID"].ToString()); } return(LogFileObject); } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } }
private int GetBalQty(ASPxGridView grd) { ASPxButtonEdit txt_det_Product = grd.FindEditFormTemplateControl("txt_det_Product") as ASPxButtonEdit; ASPxSpinEdit spin_det_Price = grd.FindEditFormTemplateControl("spin_det_Price") as ASPxSpinEdit; string product = SafeValue.SafeString(txt_det_Product.Text); decimal price = SafeValue.SafeDecimal(spin_det_Price.Value, 0); string sql = string.Format("select (select SUM(Qty) from wh_POReceiptDet where Price={1} and Product='{0}')-isnull((select sum(Qty) from wh_SoReleaseDet where Price={1} and Product='{0}'),0)", product, price); return(SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0)); }
protected void gvUser_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e) { ASPxGridView gridView = sender as ASPxGridView; ASPxRadioButtonList ASPxRadioButtonList2 = gridView.FindEditFormTemplateControl("ASPxRadioButtonList2") as ASPxRadioButtonList; ASPxRadioButtonList ASPxRadioButtonList1 = gridView.FindEditFormTemplateControl("ASPxRadioButtonList1") as ASPxRadioButtonList; ASPxRadioButtonList1.Value = 1; ASPxRadioButtonList1.SelectedIndex = 0; ASPxRadioButtonList2.Value = 2; ASPxRadioButtonList2.SelectedIndex = 0; }
protected void grid_Event_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView g = this.grid_Transport; ASPxGridView gEvent = g.FindEditFormTemplateControl("grid_Event") as ASPxGridView; ASPxDropDownEdit contNo = gEvent.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit; ASPxComboBox contType = gEvent.FindEditFormTemplateControl("cmb_ContainerType") as ASPxComboBox; if (checkCont_NO_Type(contNo.Text, contType.Text)) { throw new Exception("Container No and Type are not match"); } }
protected void SaveJob() { try { ASPxGridView g = this.grid_Marking; ASPxTextBox houseId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; int Id = SafeValue.SafeInt(houseId.Text, 0); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(SeaExportMkg), "SequenceId='" + Id + "'"); SeaExportMkg mkg = C2.Manager.ORManager.GetObject(query) as SeaExportMkg; bool isNew = false; if (Id == 0) { isNew = true; mkg = new SeaExportMkg(); } ASPxDateEdit polEta = g.FindEditFormTemplateControl("date_PolEta") as ASPxDateEdit; mkg.PolEta = polEta.Date; ASPxDateEdit polClearDate = g.FindEditFormTemplateControl("date_PolClearDate") as ASPxDateEdit; mkg.PolClearDate = polClearDate.Date; ASPxDateEdit polReturnDate = g.FindEditFormTemplateControl("date_PolReturnDate") as ASPxDateEdit; mkg.PolReturnDate = polReturnDate.Date; ASPxDateEdit podEta = g.FindEditFormTemplateControl("date_PodEta") as ASPxDateEdit; mkg.PodEta = podEta.Date; ASPxDateEdit podClearDate = g.FindEditFormTemplateControl("date_PodClearDate") as ASPxDateEdit; mkg.PodClearDate = podClearDate.Date; ASPxDateEdit podReturnDate = g.FindEditFormTemplateControl("date_PodReturnDate") as ASPxDateEdit; mkg.PodReturnDate = podReturnDate.Date; ASPxMemo polRemark = g.FindEditFormTemplateControl("memo_PolRemark") as ASPxMemo; mkg.PolRemark = polRemark.Text; ASPxMemo podRemark = g.FindEditFormTemplateControl("memo_PodRemark") as ASPxMemo; mkg.PodRemark = podRemark.Text; if (isNew) { C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(mkg); houseId.Text = mkg.SequenceId.ToString(); //this.txt_JobNo.Text = tpt1.JobNo; Session["TptWhere"] = "SequenceId='" + mkg.SequenceId + "'"; this.dsMarking.FilterExpression = Session["TptWhere"].ToString(); if (this.grid_Marking.GetRow(0) != null) { this.grid_Marking.StartEdit(0); } } else { C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(mkg); } } catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); } }
protected void UserProfileDataSource_Inserting(object sender, SqlDataSourceCommandEventArgs e) { int visibleindex = MainGridView.FocusedRowIndex; ASPxGridView sousgrid = MainGridView.FindDetailRowTemplateControl(visibleindex, "ThemeGridSite") as ASPxGridView; ASPxCheckBoxList listTiers = sousgrid.FindEditFormTemplateControl("chkListTiers") as ASPxCheckBoxList; string ListTiers = ""; foreach (string val in listTiers.SelectedValues) { ListTiers += val + ";"; } ASPxCheckBoxList listJour = sousgrid.FindEditFormTemplateControl("chkListJourn") as ASPxCheckBoxList; string ListJour = ""; foreach (string val in listJour.SelectedValues) { ListJour += val + ";"; } ASPxCheckBoxList listaffichmontant = sousgrid.FindEditFormTemplateControl("ASPxCheckAfficherMontant") as ASPxCheckBoxList; string affichmontant = "0"; foreach (string val in listaffichmontant.SelectedValues) { affichmontant = val; } ASPxCheckBoxList listaccederdate = sousgrid.FindEditFormTemplateControl("ASPxCheckAccederDate") as ASPxCheckBoxList; string accederdate = "0"; foreach (string val in listaccederdate.SelectedValues) { accederdate = val; } //ASPxCheckBoxList listDoc = sousgrid.FindEditFormTemplateControl("chkListDoc") as ASPxCheckBoxList; //string ListDoc = ""; //foreach (string val in listDoc.SelectedValues) //{ // ListDoc += val + ";"; //} e.Command.Parameters[2].Value = ListJour; e.Command.Parameters[3].Value = ListTiers; e.Command.Parameters[5].Value = affichmontant; e.Command.Parameters[6].Value = accederdate; //e.Command.Parameters[4].Value = ListDoc; }
protected void grid_Transport_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e) { if (e.Parameters.Equals("save")) { gridView_save(sender, e); } if (e.Parameters.Equals("borrow")) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; ASPxLabel txt_Id = grd.FindEditFormTemplateControl("lb_Id") as ASPxLabel; C2.CtmMastData data = C2.Manager.ORManager.GetObject <C2.CtmMastData>(SafeValue.SafeInt(txt_Id.Text, 0)); if (data != null) { C2.CtmMastDataLog.addBorrow(data); e.Result = "success"; } } if (e.Parameters.Equals("return")) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; ASPxLabel txt_Id = grd.FindEditFormTemplateControl("lb_Id") as ASPxLabel; C2.CtmMastData data = C2.Manager.ORManager.GetObject <C2.CtmMastData>(SafeValue.SafeInt(txt_Id.Text, 0)); if (data != null) { C2.CtmMastDataLog.addReturn(data); e.Result = "success"; } } }
protected void grid_Transport_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e) { string s = e.Parameters; ASPxGridView g = sender as ASPxGridView; ASPxTextBox masterId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; string userId = HttpContext.Current.User.Identity.Name; }
public DateTime controlKoniecZawieszeniafromWUC(ASPxGridView grid) { ASPxPageControl pageControl = grid.FindEditFormTemplateControl("ASPxPageControl1") as ASPxPageControl; zawieszenia txt = pageControl.FindControl("zawieszenia1") as zawieszenia; return(txt.koniec.Date); }
protected void ASPxGridView1_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; DataType dataType = (DataType)grid.GetRowValuesByKeyValue(e.Keys[0], "Type"); string editorID = string.Empty; switch (dataType) { case DataType.Text: editorID = "txt"; break; case DataType.DateTime: editorID = "date"; break; case DataType.Dictionary1: editorID = "dict"; break; case DataType.Dictionary2: editorID = "dict"; break; } ASPxEdit editor = (ASPxEdit)grid.FindEditFormTemplateControl(editorID); e.NewValues["DataValue"] = editor.Value.ToString(); }
protected void ASPxGridView1_CustomDataCallback1(object sender, ASPxGridViewCustomDataCallbackEventArgs e) { string s = e.Parameters; if (s == "Delete") { ASPxGridView grd = sender as ASPxGridView; ASPxTextBox oid = grd.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox; string sql = string.Format("Delete from XAGlEntryDet where GlNo='{0}'", oid.Text); int res = Manager.ORManager.ExecuteCommand(sql); if (res > -1) { sql = string.Format("Delete from XAGlEntry where SequenceId='{0}'", oid.Text); res = Manager.ORManager.ExecuteCommand(sql); if (res > -1) { e.Result = "CS";//cancel success } else { e.Result = "CF"; } } else { } } }
protected void grid_ref_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { string refN = e.Parameters; ASPxGridView grd = sender as ASPxGridView; if (refN == "Photo") { if (this.dsJobPhoto.FilterExpression == "1=0") { ASPxPageControl pageControl = grd.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox refNo = pageControl.FindControl("txt_RefN") as ASPxTextBox; this.dsJobPhoto.FilterExpression = "JobClass='E' and RefNo='" + refNo.Text + "'";// } } else if (refN == "Save") { Save(); } else if (refN == "Delete") { // ASPxCheckBox cb_de =(ASPxCheckBox)grid_ref.FindControl //if (cb_Delete.Checked == true) // { // string sql = "delete from SeaAttachment where SequenceId="+SafeValue.SafeInt(txt_ID.Text,0); // } } }
/// <summary> /// GridView的直接子控件的显示情况(GridView.Column可填Caption/FieldName) /// </summary> /// <param name="gv"></param> /// <param name="Status"></param> /// <param name="where"></param> public static void Bind_Authority(ASPxGridView gv, string Status, string where) { string Role = EzshipHelper.GetUseRole(); string Path = GetFrame(); string sql_part = ""; if (Status.Length > 0) { sql_part = " and [Status]='" + Status + "'"; } sql_part += where; string sql = string.Format(@"select Control,ControlType,IsHid from Helper_Authority where Frame='{0}' and Role='{1}' {2}", Path, Role, sql_part); DataTable dt = ConnectSql.GetTab(sql); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; string name = SafeValue.SafeString(dr["Control"]); string type = SafeValue.SafeString(dr["ControlType"]); string IsHid = SafeValue.SafeString(dr["IsHid"].ToString()); if (type.Equals("Column")) { Bind_Column(gv, name, IsHid); } else { Control c = gv.FindEditFormTemplateControl(name); if (c != null) { Bind_Control(c, type, IsHid); } } } }
public bool controlCheckbox(string control, ASPxGridView grid) { ASPxPageControl pageControl = grid.FindEditFormTemplateControl("ASPxPageControl1") as ASPxPageControl; ASPxCheckBox txt = pageControl.FindControl(control) as ASPxCheckBox; return(txt.Checked); }
public static T EditForm <T>(this ASPxGridView source, string path, string pathSeparator) where T : Control { var controlIds = path.Split(new[] { pathSeparator }, StringSplitOptions.RemoveEmptyEntries); var elementsEnumerator = controlIds.GetEnumerator(); var result = source.FindEditFormTemplateControl(elementsEnumerator.FetchNext().As <string>()); if (result == null) { throw new ElementNotFoundException(); } while (elementsEnumerator.MoveNext()) { result = result.FindControl(elementsEnumerator.Current.As <string>()); if (result == null) { throw new ElementNotFoundException(); } } return((T)result); }
protected void grid_Export_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) { string s = e.Parameters; if (s == "Photo") { if (this.dsJobPhoto.FilterExpression == "1=0") { ASPxGridView grd = sender as ASPxGridView; ASPxPageControl pageControl = grd.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl; ASPxTextBox HNo = pageControl.FindControl("txtHouseId") as ASPxTextBox; //this.dsJobPhoto.FilterExpression = "JobClass='I' and RefNo='" + refNo.Text + "'"; string sql = "select RefNo,JobNo from air_job where Id='" + HNo.Text + "'"; DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0]; if (tab.Rows.Count > 0) { string refNo = tab.Rows[0]["RefNo"].ToString(); string jobNo = tab.Rows[0]["JobNo"].ToString(); this.dsJobPhoto.FilterExpression = string.Format("JobType='AE' and RefNo='{0}' and JobNo='{1}'", refNo, jobNo); } } } if (s == "Save") { SaveJob(); } }
protected void grid_Cost_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e) { ASPxGridView grd = sender as ASPxGridView; ASPxTextBox vendorName = grd.FindEditFormTemplateControl("txt_CostVendorName") as ASPxTextBox; vendorName.Text = EzshipHelper.GetPartyName(grd.GetRowValues(grd.EditingRowVisibleIndex, new string[] { "VendorId" })); }
protected void grid_Transport_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e) { //throw new Exception("AA"); try { if (this.grid_Transport.EditingRowVisibleIndex > -1) { ASPxGridView g = this.grid_Transport; //ASPxTextBox custName = g.FindEditFormTemplateControl("txt_Tpt_CustomerName") as ASPxTextBox; //ASPxTextBox haulierName = g.FindEditFormTemplateControl("txt_Tpt_HaulierName") as ASPxTextBox; //custName.Text = EzshipHelper.GetPartyName(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "CustomerId" })); //haulierName.Text = EzshipHelper.GetPartyName(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "HaulierId" })); string oid = SafeValue.SafeString(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "Id" })); //PayTab(SafeValue.SafeInt(oid, 0)); string sql = "select isnull(StatusCode,'USE') from cont_asset where Id=" + oid; string StatusCode = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE"); switch (StatusCode) { case "CLS": ASPxButton btnCLS = g.FindEditFormTemplateControl("btn_Close") as ASPxButton; btnCLS.Text = "Open"; break; case "CNL": ASPxButton btnCNL = g.FindEditFormTemplateControl("btn_Void") as ASPxButton; btnCNL.Text = "UnVoid"; break; default: break; } } } catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); } //if (Request.QueryString["JobNo"] != null) //{ // string jobType = EzshipHelper.GetJobType("SE", Request.QueryString["JobNo"].ToString()); //} //else //{ // string refNo = SafeValue.SafeString(this.grid_Transport.GetRowValues(this.grid_Transport.EditingRowVisibleIndex, new string[] { "RefNo" })); //} }
protected void gvUser_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView gridView = sender as ASPxGridView; ASPxCallbackPanel cbPanel = gridView.FindEditFormTemplateControl("ASPxCallbackOffice") as ASPxCallbackPanel; ASPxTextBox txtofficeid = (ASPxTextBox)cbPanel.FindControl("txtofficeid"); e.NewValues["OfficeLocID"] = txtofficeid.Value; }
protected void grid_Event_DataSelect(object sender, EventArgs e) { ASPxGridView g = this.grid_Transport; ASPxTextBox docNo = g.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; ASPxGridView grd = sender as ASPxGridView; this.dsEvent.FilterExpression = "DocNo='" + SafeValue.SafeString(docNo.Text, "-1") + "'"; }
protected void BUDeptListGrid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxPageControl pageControl = grid.FindEditFormTemplateControl("BUHeadPageControl") as ASPxPageControl; ASPxDateEdit effectDate = pageControl.FindControl("EffectDate") as ASPxDateEdit; ASPxComboBox entCode = pageControl.FindControl("EntityCode") as ASPxComboBox; ASPxCallbackPanel callBackPanel = pageControl.FindControl("BUCallBackPanel") as ASPxCallbackPanel; ASPxComboBox buCode = callBackPanel.FindControl("BUCode") as ASPxComboBox; ASPxComboBox buHead = pageControl.FindControl("BUHead") as ASPxComboBox; ASPxComboBox buHeadStatus = pageControl.FindControl("BUHeadStatus") as ASPxComboBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string sCtrlNum = GlobalClass.GetControl_DocNum("BU_Dept_Head", Convert.ToDateTime(effectDate.Value.ToString())); string sLastModified = DateTime.Now.ToString(); string sbuCode = ""; if (buCode.Value != null) { sbuCode = buCode.Value.ToString(); } string insert = "INSERT INTO tbl_System_BUDeptHead ([Ctrl], [EffectDate], [EntityCode], [BUDeptCode], [UserKey], [StatusKey], [LastModified]) VALUES (@Ctrl, @EffectDate, @EntityCode, @BUDeptCode, @UserKey, @StatusKey, @LastModified)"; SqlCommand cmd = new SqlCommand(insert, conn); cmd.Parameters.AddWithValue("@Ctrl", sCtrlNum); cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString()); cmd.Parameters.AddWithValue("@EntityCode", entCode.Value.ToString()); cmd.Parameters.AddWithValue("@BUDeptCode", sbuCode.ToString()); cmd.Parameters.AddWithValue("@UserKey", buHead.Value.ToString()); cmd.Parameters.AddWithValue("@StatusKey", buHeadStatus.Value.ToString()); cmd.Parameters.AddWithValue("@LastModified", sLastModified); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); e.Cancel = true; grid.CancelEdit(); BindUserList(); int pk_latest = 0; string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_BUDeptHead ORDER BY [PK] DESC"; SqlCommand comm = new SqlCommand(query_pk, conn); SqlDataReader r = comm.ExecuteReader(); while (r.Read()) { pk_latest = Convert.ToInt32(r[0].ToString()); } conn.Close(); if (pk_latest > 0) { FocusThisRowGrid(grid, pk_latest); } }
protected void grid_bkg_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e) { ASPxGridView grd = sender as ASPxGridView; if (grd.EditingRowVisibleIndex > -1) { string houseId = SafeValue.SafeString(grd.GetRowValues(grd.EditingRowVisibleIndex, new string[] { "SequenceId" })); string sql = string.Format("select top(1) mkg.Sequenceid,Mkg.Qty,Mkg.PackageType,Mkg.Weight,mkg.Volume,mkg.Marking,mkg.Description from seaexportmkg mkg inner join seaexport job on mkg.RefNo=job.RefNo and mkg.JobNo=job.JobNo where job.SequenceId='{0}'", houseId); DataTable tab = ConnectSql.GetTab(sql); if (tab.Rows.Count == 1) { ASPxTextBox mkgId = grd.FindEditFormTemplateControl("txtMkgId") as ASPxTextBox; ASPxSpinEdit wt = grd.FindEditFormTemplateControl("spin_wt2") as ASPxSpinEdit; ASPxSpinEdit m3 = grd.FindEditFormTemplateControl("spin_m4") as ASPxSpinEdit; ASPxSpinEdit qty = grd.FindEditFormTemplateControl("spin_pkg2") as ASPxSpinEdit; ASPxButtonEdit pkgType = grd.FindEditFormTemplateControl("txt_pkgType2") as ASPxButtonEdit; ASPxMemo mkg = grd.FindEditFormTemplateControl("txt_mkg2") as ASPxMemo; ASPxMemo des = grd.FindEditFormTemplateControl("txt_des2") as ASPxMemo; mkgId.Text = SafeValue.SafeString(tab.Rows[0]["SequenceId"]); wt.Value = SafeValue.SafeDecimal(tab.Rows[0]["Weight"], 0); m3.Value = SafeValue.SafeDecimal(tab.Rows[0]["Volume"], 0); qty.Value = SafeValue.SafeInt(tab.Rows[0]["Qty"], 0); pkgType.Text = SafeValue.SafeString(tab.Rows[0]["PackageType"]); mkg.Text = SafeValue.SafeString(tab.Rows[0]["Marking"]); des.Text = SafeValue.SafeString(tab.Rows[0]["Description"]); } } }
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grd = sender as ASPxGridView; ASPxTextBox pwd = grd.FindEditFormTemplateControl("txtPwd") as ASPxTextBox; if (pwd.Text == "") { //e.Cancel = true; //throw new Exception("Please enter the password ."); } else { ASPxTextBox userId = grd.FindEditFormTemplateControl("txtCode") as ASPxTextBox; Encryption.EncryptClass encrypt = new Encryption.EncryptClass(); e.NewValues["Pwd"] = encrypt.DESEnCode(userId.Text, pwd.Text); } }
/// <summary> /// Searchs for combo by FindEditFormTemplateControl and returns selected value /// </summary> /// <param name="grid"></param> /// <param name="controlName"></param> /// <returns></returns> public static object GetEditFormComboValue(ASPxGridView grid, string controlName) { ASPxComboBox cbo = (ASPxComboBox)grid.FindEditFormTemplateControl(controlName); if (cbo != null) if (cbo.SelectedItem == null) return null; else return cbo.SelectedItem.Value; return null; }
protected object GetValueFromControlGeneric(string idName, ASPxGridView grid, string pageControlID) { ASPxPageControl pageControl = grid.FindEditFormTemplateControl(pageControlID) as ASPxPageControl; if (pageControl == null) return null; object control = pageControl.FindControl(idName); if (control is ASPxTextBox) { ASPxTextBox t = control as ASPxTextBox; return t.Text; } else if (control is ASPxSpinEdit) { ASPxSpinEdit t = control as ASPxSpinEdit; return t.Value; } else if (control is ASPxDateEdit) { ASPxDateEdit t = control as ASPxDateEdit; return t.Date; } else if (control is ASPxComboBox) { ASPxComboBox t = control as ASPxComboBox; return t.Value; } else if (control is ASPxMemo) { ASPxMemo t = control as ASPxMemo; return t.Text; } else if (control is ASPxCheckBox) { ASPxCheckBox t = control as ASPxCheckBox; return t.Checked; } else if (control is DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor) { DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor t = control as DevExpress.Web.ASPxHtmlEditor.ASPxHtmlEditor; return t.Html; } return ""; }
/// <summary> /// Legge valori di ct_stato_civile e ct_titolo dai controlli (combobox) e li /// scrive in recPaziente /// </summary> /// <param name="recPaziente"></param> /// <param name="grdSender"></param> private void readComboBox(DALRuntime.TRecPaziente recPaziente, ASPxGridView grdSender) { ASPxComboBox cbxStatoCivile = (ASPxComboBox)grdSender.FindEditFormTemplateControl("cbxStatoCivile"); if (cbxStatoCivile != null && cbxStatoCivile.Value != null) recPaziente.CtStatoCivile = Convert.ToInt32(cbxStatoCivile.Value.ToString()); ASPxComboBox cbxTitolo = (ASPxComboBox)grdSender.FindEditFormTemplateControl("cbxTitoloStudio"); if (cbxTitolo != null && cbxTitolo.Value != null) recPaziente.CtTitolo = Convert.ToInt32(cbxTitolo.Value.ToString()); ASPxComboBox cbxSesso = (ASPxComboBox)grdSender.FindEditFormTemplateControl("cbxSesso"); if (cbxSesso != null && cbxSesso.Value != null) recPaziente.Sesso = cbxSesso.Value.ToString(); }