protected void ASPxGridView1_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e) { AccountingPeriod currentEdit = session.GetObjectByKey <AccountingPeriod>(Guid.Parse(e.EditingKeyValue.ToString())); Guid accountingPeriodId = Guid.Parse(e.EditingKeyValue.ToString()); if (AccountingPeriodBO.IsChildOfAnother(session, accountingPeriodId)) { e.Cancel = true; (sender as ASPxGridView).CancelEdit(); throw new Exception("Chu kì kế toán này đang là chu kì trực thuộc của một chu kì khác! Không thể chỉnh sửa"); } Session["AccountingPeriodId_cr"] = currentEdit.AccountingPeriodId; ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup; if (currentEdit.AccountingPeriodTypeId.IsDefault == true) { XPOAccountingPeriodLookup.Criteria = "[RowStatus] > 0s And [IsActive] = True And [IsActive] <> True And [Code] <> 'NAAN_DEFAULT' And [AccountingPeriodTypeId.IsDefault] = True"; grid.Enabled = false; } else { XPOAccountingPeriodLookup.Criteria = "[RowStatus] > 0s And [IsActive] = True And [Code] <> 'NAAN_DEFAULT' And [AccountingPeriodTypeId.IsDefault] = True"; grid.Enabled = true; } }
//新增 protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox pLine = ASPxGridView1.FindEditFormTemplateControl("comboPLine") as ASPxComboBox; ASPxComboBox zdmc = ASPxGridView1.FindEditFormTemplateControl("comboStationCode") as ASPxComboBox; ASPxTextBox zddm = ASPxGridView1.FindEditFormTemplateControl("txtStationName") as ASPxTextBox; ASPxGridLookup gridlookup = ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxGridLookup; ASPxComboBox part_ABC = ASPxGridView1.FindEditFormTemplateControl("comboLJLB") as ASPxComboBox; string ljdm = gridlookup.Value.ToString(); string ljmc = gridlookup.Text.Trim(); string Sql = "INSERT INTO ATPUZDLJMLB (GZDD,ZDDM,ZDMC,LJDM,LJMC,INPUT_PERSON,INPUT_TIME,PART_ABC) " + "VALUES( '" + pLine.Value.ToString() + "','" + zddm.Text.Trim() + "','" + zdmc.Value.ToString() + "','" + ljdm + "','" + ljmc + "','" + theUserId + "',SYSDATE,'" + part_ABC.Value.ToString() + "')"; dc.ExeSql(Sql); //插入到日志表161103 try { string Sql2 = "INSERT INTO ATPUZDLJMLB_LOG (GZDD,ZDDM,ZDMC,LJDM,LJMC,user_code,flag,rqsj,PART_ABC)" + " SELECT GZDD,ZDDM,ZDMC,LJDM,LJMC,'" + theUserCode + "' , 'ADD', SYSDATE,PART_ABC FROM ATPUZDLJMLB WHERE GZDD = '" + pLine.Value.ToString() + "' and ZDMC = '" + zdmc.Value.ToString() + "' and LJDM = '" + ljdm + "'"; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected override System.Web.UI.WebControls.WebControl CreateEditModeControlCore() { ASPxGridLookup lookupEdit = new ASPxGridLookup(); lookupEdit.ID = PropertyName + "_CheckedComboBox"; lookupEdit.Width = Unit.Percentage(100); lookupEdit.SelectionMode = GridLookupSelectionMode.Multiple; lookupEdit.TextChanged += EditValueChangedHandler; lookupEdit.KeyFieldName = LookupValueColumnName; lookupEdit.MultiTextSeparator = ", "; lookupEdit.AllowUserInput = false; // Set the drop-down editor width. lookupEdit.GridView.Width = 500; // OR //string setSizeScript = "function(s, e){s.GetGridView().SetWidth(s.GetWidth()); }"; //lookupEdit.ClientSideEvents.Init = lookupEdit.ClientSideEvents.DropDown = setSizeScript; lookupEdit.GridViewProperties.Settings.ShowColumnHeaders = false; lookupEdit.GridViewProperties.Settings.GridLines = GridLines.None; lookupEdit.GridViewStyles.SelectedRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#00fbfbfb"); lookupEdit.GridViewStyles.FocusedRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#00fbfbfb"); GridViewCommandColumn selectionColumn = new GridViewCommandColumn(); selectionColumn.ShowSelectCheckbox = true; lookupEdit.Columns.Add(selectionColumn); GridViewDataColumn valueColumn = new GridViewDataColumn(LookupValueColumnName); lookupEdit.Columns.Add(valueColumn); lookupEdit.DataSource = GetLookupData(); return(lookupEdit); }
// 主表修改 protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { //ASPxLabel billId = ASPxGridView1.FindEditFormTemplateControl("LabBillId") as ASPxLabel; ASPxTextBox assetcode = ASPxGridView1.FindEditFormTemplateControl("txtAssetCode") as ASPxTextBox; ASPxTextBox srlno = ASPxGridView1.FindEditFormTemplateControl("txtSrlNo") as ASPxTextBox; ASPxGridLookup lkpVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup; ASPxGridLookup lkpManuf = ASPxGridView1.FindEditFormTemplateControl("GridLookupManuf") as ASPxGridLookup; ASPxGridLookup lkpDept = ASPxGridView1.FindEditFormTemplateControl("GridLookupDept") as ASPxGridLookup; ASPxDateEdit dtePurchDate = ASPxGridView1.FindEditFormTemplateControl("CalPCDate") as ASPxDateEdit; ASPxTextBox txtPurchCost = ASPxGridView1.FindEditFormTemplateControl("txtPrice") as ASPxTextBox; ASPxDateEdit wrtStartDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTStartDate") as ASPxDateEdit; ASPxDateEdit wrtEndDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTEndDate") as ASPxDateEdit; ASPxTextBox txtAssetColor = ASPxGridView1.FindEditFormTemplateControl("txtColor") as ASPxTextBox; ASPxTextBox txtBarCode = ASPxGridView1.FindEditFormTemplateControl("txtBarCode") as ASPxTextBox; ASPxGridLookup lkpRspPerson = ASPxGridView1.FindEditFormTemplateControl("lkpResponsePerson") as ASPxGridLookup; ASPxCheckBox chkActiveFlag = ASPxGridView1.FindEditFormTemplateControl("chkActiveFlag") as ASPxCheckBox; ASPxMemo assetRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo; string deptCode = "", vendorCode = "", manufCode = "", rspPerson = ""; ASPxGridLookup gridLookupVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup; ASPxTextBox txtSVendor = ASPxGridView1.FindEditFormTemplateControl("txtSVendor") as ASPxTextBox; if (lkpDept.Value != null) { deptCode = lkpDept.Value.ToString(); } if (lkpManuf.Value != null) { manufCode = lkpManuf.Value.ToString(); } if (lkpVendor.Value != null) { vendorCode = lkpVendor.Value.ToString(); } if (lkpRspPerson.Value != null) { rspPerson = lkpRspPerson.Value.ToString(); } string activeflag = chkActiveFlag.Checked ? "Y":"N"; string upSql = "UPDATE data_asset_detail SET vendor_code='" + vendorCode + "',manufacturer_code='" + lkpManuf.Value + "'," + "response_dept_code='" + deptCode + "',purchase_date=to_date('" + dtePurchDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),purchase_cost=" + txtPurchCost.Text + "," + "warranty_start_date=to_date('" + wrtStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),warranty_end_date=to_date('" + wrtEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss')," + "response_person_code='" + lkpRspPerson.Value.ToString() + "',asset_color='" + txtAssetColor.Text + "',asset_remark='" + assetRemark.Text + "',active_flag='" + activeflag + "' " + " WHERE COMPANY_CODE = '" + theCompanyCode + "' AND serial_number='" + srlno.Text + "'"; theDc.ExeSql(upSql); e.Cancel = true; ASPxGridView1.CancelEdit(); queryFunction(); }
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(); }
public override void InitGridLookup(ASPxGridLookup gridlookup) { gridlookup.KeyFieldName = "OrganizationId"; gridlookup.TextFormatString = "{0} - {1}"; gridlookup.Columns.Clear(); GridViewColumn selectionColumn = new GridViewCommandColumn() { ShowSelectCheckbox = true, VisibleIndex = 0 }; GridViewColumn codeColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Code", Caption = "Mã khách hàng", VisibleIndex = 1 }; GridViewColumn nameColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Name", Caption = "Tên khách hàng", VisibleIndex = 2 }; gridlookup.Columns.Add(selectionColumn); gridlookup.Columns.Add(codeColumn); gridlookup.Columns.Add(nameColumn); }
protected void gridLkupSubj_OnDataBound(object sender, EventArgs e) { Debug.Print("gridLkupSubj_OnDataBound " + System.DateTime.Now.ToString()); bool loadvars = false; if (Request.QueryString["subjset_pk"] != null) { ASPxGridLookup x = (ASPxGridLookup)sender; ASPxGridView grid = (ASPxGridView)x.GridView; var nrow = (int)grid.VisibleRowCount; //var nrow = 33; for (int i = 0; i < numsubj; i++) { if (selected_subjlist.Contains(grid.GetRowValues(i, "subjID").ToString())) { if (grid.Selection.IsRowSelected(i) == false) { loadvars = true; grid.Selection.SelectRow(i); } } } } RefreshSelectedSubj(); }
protected void gridLookup_Init(object sender, EventArgs e) { ASPxGridLookup gl = (ASPxGridLookup)sender; gl.DataSource = CreateDataSource(); gl.DataBind(); }
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e) { //判断为空 ASPxGridLookup gridLookupTeam = ASPxGridView1.FindEditFormTemplateControl("GridLookupTeam") as ASPxGridLookup; if (gridLookupTeam.Value == null) { e.RowError = "班组代码不能为空!"; } ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup; if (gridLookupUser.Value == null) { e.RowError = "用户代码不能为空!"; } else { //判断同一个用户只能分配一个班组 List <object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID"); List <object> UsersName = gridLookupUser.GridView.GetSelectedFieldValues("USER_NAME"); for (int indexUser = 0; indexUser < Users.Count; indexUser++) { string chSql = "SELECT COMPANY_CODE,PLINE_CODE,TEAM_CODE,USER_ID FROM REL_TEAM_USER WHERE COMPANY_CODE='" + theCompanyCode + "' AND PLINE_CODE='" + thePlCode + "' AND USER_ID='" + Users[indexUser].ToString() + "'"; DataTable dt = theDc.GetTable(chSql); if (dt.Rows.Count >= 1) { e.RowError = UsersName[indexUser].ToString() + "已经被分配过班组!"; } } } }
protected void SpecifyJSProperties(ASPxGridLookup gl) { if (gl.GridView.Selection.Count == gl.GridView.VisibleRowCount) { gl.GridView.JSProperties["cp_selected"] = true; } }
public override void InitGridLookup(ASPxGridLookup gridlookup) { gridlookup.KeyFieldName = "BillId"; gridlookup.TextFormatString = "{0}"; gridlookup.Columns.Clear(); GridViewColumn selectionColumn = new GridViewCommandColumn() { ShowSelectCheckbox = true, VisibleIndex = 0 }; GridViewColumn codeColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Code", Caption = "Số phiếu bán", VisibleIndex = 1 }; GridViewColumn nameColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "IssuedDate", Caption = "Ngày", VisibleIndex = 2 }; gridlookup.Columns.Add(selectionColumn); gridlookup.Columns.Add(codeColumn); gridlookup.Columns.Add(nameColumn); }
protected void gridLookup_Init(object sender, EventArgs e) { ASPxGridLookup gl = (ASPxGridLookup)sender; gl.GridView.Width = Unit.Pixel(165); gl.DataSource = CreateDataIEnumerableSourceFromEnum(typeof(CustomEnum)); gl.DataBind(); }
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup; gridLookupUser.GridView.Width = 250; ASPxGridLookup gridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup; gridLookupRole.GridView.Width = 250; }
public override void BreakLinksToControl(bool unwireEventsOnly) { ASPxGridLookup lookupEdit = Editor as ASPxGridLookup; if (lookupEdit != null) { lookupEdit.TextChanged -= EditValueChangedHandler; } base.BreakLinksToControl(unwireEventsOnly); }
protected void glProducts_Init(object sender, EventArgs e) { ASPxGridLookup gridLookup = sender as ASPxGridLookup; gridLookup.GridView.CustomCallback += new ASPxGridViewCustomCallbackEventHandler(gridView_CustomCallback); if (Session["FilterExpression"] != null) { gridLookup.GridView.DataSource = adsProducts; adsProducts.FilterExpression = Session["FilterExpression"].ToString(); } }
protected override System.Web.UI.WebControls.WebControl CreateEditModeControlCore() { lookup = new ASPxGridLookup(); lookup.ValueChanged += ExtendedEditValueChangedHandler; lookup.GridView.SettingsBehavior.AllowSelectByRowClick = true; lookup.GridView.SettingsBehavior.AllowSelectSingleRowOnly = true; lookup.GridView.AutoGenerateColumns = true; lookup.IncrementalFilteringMode = DevExpress.Web.ASPxEditors.IncrementalFilteringMode.Contains; lookup.SelectionMode = GridLookupSelectionMode.Single; lookup.GridView.KeyFieldName = "Oid"; return(lookup); }
protected object GetGridLookupValue(ASPxGridLookup lookup) { try { return(lookup.Value); } catch (Exception ex) { CommonMethods.LogThis(ex.Message + "\r\n" + ex.Source + "\r\n" + ex.StackTrace); return(null); } }
public override List <NASCustomFieldPredefinitionData> GetSelectedPredefinitionDataFromList(object source) { List <NASCustomFieldPredefinitionData> ret = null; Session session = null; try { session = XpoHelper.GetNewSession(); ASPxGridLookup gridlookup = source as ASPxGridLookup; var selectedIds = gridlookup.GridView .GetSelectedFieldValues("OrganizationId") .Select(r => Guid.Parse(r.ToString())); if (selectedIds != null) { ret = new List <NASCustomFieldPredefinitionData>(); foreach (var Id in selectedIds) { Organization organization = session.GetObjectByKey <Organization>(Id); if (organization != null) { NASCustomFieldPredefinitionData retItem = new NASCustomFieldPredefinitionData() { Code = organization.Code, Description = organization.Description, Name = organization.Name, PredefinitionType = Enum.GetName(typeof(MultiSelectionBuiltInTypeEnum), MultiSelectionBuiltInTypeEnum.MULTI_CHOICE_LIST_SUPPLIER), RefId = organization.OrganizationId }; ret.Add(retItem); } } } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
public override List <NASCustomFieldPredefinitionData> GetSelectedPredefinitionDataFromList(object source) { List <NASCustomFieldPredefinitionData> ret = null; Session session = null; try { session = XpoHelper.GetNewSession(); ASPxGridLookup gridlookup = source as ASPxGridLookup; var selectedIds = gridlookup.GridView .GetSelectedFieldValues("BillId") .Select(r => Guid.Parse(r.ToString())); if (selectedIds != null) { ret = new List <NASCustomFieldPredefinitionData>(); foreach (var Id in selectedIds) { PurchaseInvoice purchaseInvoice = session.GetObjectByKey <PurchaseInvoice>(Id); if (purchaseInvoice != null) { NASCustomFieldPredefinitionData retItem = new NASCustomFieldPredefinitionData() { Code = purchaseInvoice.Code, Description = String.Empty, Name = String.Empty, PredefinitionType = Enum.GetName(typeof(MultiSelectionBuiltInTypeEnum), MultiSelectionBuiltInTypeEnum.MULTI_CHOICE_LIST_INVOICE_PURCHASE), RefId = purchaseInvoice.BillId }; ret.Add(retItem); } } } return(ret); } catch (Exception) { throw; } finally { if (session != null) { session.Dispose(); } } }
//修改 protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { //ASPxTextBox uCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxTextBox; //ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtPName") as ASPxTextBox; ASPxGridLookup uSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxGridLookup; ASPxTextBox uJX = ASPxGridView1.FindEditFormTemplateControl("txtJX") as ASPxTextBox; ASPxTextBox uPQBAK = ASPxGridView1.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox; ASPxTextBox uREMARK = ASPxGridView1.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox; string strSO = uSO.Value.ToString(); string strJX = uJX.Text.Trim(); string strPQBAK = uPQBAK.Text.Trim(); string strREMARK = uREMARK.Text.Trim(); //插入到日志表 try { string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)" + " SELECT SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM PAINT_SO WHERE SO = '" + strSO + "'"; dc.ExeSql(Sql2); } catch { return; } string Sql = "UPDATE PAINT_SO SET TYPE_PQ='" + strPQBAK + "',TYPE_PQBAK='" + strPQBAK + "',REMARK='" + strREMARK + "',input_person='" + theUserId + "',input_time=sysdate" + " WHERE SO = '" + strSO + "' "; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)" + " SELECT SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM PAINT_SO WHERE SO = '" + strSO + "'"; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { //新增 int indexUser, indexRole; ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup; ASPxGridLookup gridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup; List <object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID"); List <object> Roles = gridLookupRole.GridView.GetSelectedFieldValues("ROLE_CODE"); for (indexUser = 0; indexUser < Users.Count; indexUser++) { for (indexRole = 0; indexRole < Roles.Count; indexRole++) { MW_MODIFY_USER_ROLE sp = new MW_MODIFY_USER_ROLE() { THEFUNCTION1 = "ADD", THECOMPANYCODE1 = theCompanyCode, THEUSERID1 = Users[indexUser].ToString(), THEROLECODE1 = Roles[indexRole].ToString() }; Rmes.DA.Base.Procedure.run(sp); //dataConn theDataConn = new dataConn(); //theDataConn.theComd.CommandType = CommandType.StoredProcedure; //theDataConn.theComd.CommandText = "MW_MODIFY_USER_ROLE"; //theDataConn.theComd.Parameters.Add("THEFUNCTION1", OracleDbType.Varchar2).Value = "ADD"; //theDataConn.theComd.Parameters.Add("THEFUNCTION1", OracleDbType.Varchar2).Direction = ParameterDirection.Input; //theDataConn.theComd.Parameters.Add("THECOMPANYCODE1", OracleDbType.Varchar2).Value = theCompanyCode; //theDataConn.theComd.Parameters.Add("THECOMPANYCODE1", OracleDbType.Varchar2).Direction = ParameterDirection.Input; //theDataConn.theComd.Parameters.Add("THEUSERID1", OracleDbType.Varchar2).Value = Users[indexUser].ToString(); //theDataConn.theComd.Parameters.Add("THEUSERID1", OracleDbType.Varchar2).Direction = ParameterDirection.Input; //theDataConn.theComd.Parameters.Add("THEROLECODE1", OracleDbType.Varchar2).Value = Roles[indexRole].ToString(); //theDataConn.theComd.Parameters.Add("THEROLECODE1", OracleDbType.Varchar2).Direction = ParameterDirection.Input; //theDataConn.OpenConn(); //theDataConn.theComd.ExecuteNonQuery(); //theDataConn.CloseConn(); } } setCondition(); e.Cancel = true; ASPxGridView1.CancelEdit(); }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxCheckBox chkQAD = ASPxGridView1.FindEditFormTemplateControl("chkQAD") as ASPxCheckBox; ASPxComboBox PCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; //ASPxComboBox uPNum = ASPxGridView1.FindEditFormTemplateControl("txtPNum") as ASPxComboBox; ASPxGridLookup Bgy = ASPxGridView1.FindEditFormTemplateControl("txtBgy") as ASPxGridLookup; ASPxGridLookup Part = ASPxGridView1.FindEditFormTemplateControl("txtPart") as ASPxGridLookup; ASPxTextBox Pname = ASPxGridView1.FindEditFormTemplateControl("txtPname") as ASPxTextBox; //ASPxDateEdit uOnlinetime = ASPxGridView1.FindEditFormTemplateControl("DateOnlinetime") as ASPxDateEdit; string vFlag = ""; if (chkQAD.Checked == true) { vFlag = "Y"; } else { vFlag = "N"; } string strPCode = PCode.Value.ToString(); string strPname = ""; string strBgy = Bgy.Value.ToString(); string strPart = Part.Value.ToString(); string Gsql = "select pt_desc2 from copy_pt_mstr where upper(pt_part)='" + strPart.ToUpper() + "'"; DataTable Gdt = dc.GetTable(Gsql); if (Gdt.Rows.Count > 0) { strPname = Gdt.Rows[0][0].ToString(); } // string strOnlinetime = uOnlinetime.Text.Trim(); if (vFlag == "N") { string Sql = "insert into atpubkflpart(part,gzdd,part_type,part_desc,edit_name,edit_date) " + "VALUES('" + strPart + "','" + strPCode + "','0','" + strPname + "','" + theUserName + "',sysdate)"; dc.ExeSql(Sql); } else { string Sql = "insert into atpubkflpart(part,gzdd,part_type,part_desc,edit_name,edit_date,bgy) " + "VALUES('" + strPart + "','" + strPCode + "','1','" + strPname + "','" + theUserName + "',sysdate,'" + strBgy + "')"; dc.ExeSql(Sql); } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
// 主表新增 protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxTextBox txtSrlNo = ASPxGridView1.FindEditFormTemplateControl("txtSrlNo") as ASPxTextBox; ASPxGridLookup lkpMntType = ASPxGridView1.FindEditFormTemplateControl("lkpMaintType") as ASPxGridLookup; ASPxComboBox txtMntItem = ASPxGridView1.FindEditFormTemplateControl("cmbMntItem") as ASPxComboBox; ASPxTextBox txtSrvUnit = ASPxGridView1.FindEditFormTemplateControl("txtSrvUnit") as ASPxTextBox; ASPxTextBox txtSrvPerson = ASPxGridView1.FindEditFormTemplateControl("txtSrvPerson") as ASPxTextBox; ASPxTextBox txtMntResult = ASPxGridView1.FindEditFormTemplateControl("txtMntResult") as ASPxTextBox; ASPxTextBox txtMntCost = ASPxGridView1.FindEditFormTemplateControl("txtMntCost") as ASPxTextBox; ASPxDateEdit calMntStartDate = ASPxGridView1.FindEditFormTemplateControl("calMntStartDate") as ASPxDateEdit; ASPxDateEdit calMntEndDate = ASPxGridView1.FindEditFormTemplateControl("calMntEndDate") as ASPxDateEdit; ASPxMemo mntRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo; ASPxMemo faultScript = ASPxGridView1.FindEditFormTemplateControl("txtFault") as ASPxMemo; string mntType = ""; string mntItem = e.NewValues["MAINT_ITEM"].ToString(); //string mntItem = txtMntItem == null ? "" : txtMntItem.SelectedItem.Value.ToString(); string mntCost = txtMntCost == null ? "0" : txtMntCost.Text; if (lkpMntType.Value != null) { mntType = lkpMntType.Value.ToString(); } string inSql = "insert into DATA_ASSET_MAINTAIN(company_code,SERIAL_NUMBER,maint_type,maint_item,maint_service_unit," + "maint_service_person,maint_result,maint_cost,maint_start_date,maint_end_date,maint_remark,fault_script) " + "values('" + theCompanyCode + "','" + txtSrlNo.Text + "','" + mntType + "','" + mntItem + "','" + txtSrvUnit.Text + "','" + txtSrvPerson.Text + "','" + txtMntResult.Text + "'," + mntCost + "," + "to_date('" + calMntStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),to_date('" + calMntEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),'" + mntRemark.Text + "','" + faultScript.Text + "')"; dataConn inDc = new dataConn(); inDc.ExeSql(inSql); e.Cancel = true; ASPxGridView1.CancelEdit(); queryFunction(); }
public override void BreakLinksToControl(bool unwireEventsOnly) { if (Editor != null) { ASPxGridLookup control = (ASPxGridLookup)Editor; if (control != null) { control.ValueChanged -= EditValueChangedHandler; control.GridView.CustomCallback -= GridView_CustomCallback; control.Init -= control_Init; control.PreRender -= control_PreRender; } } base.BreakLinksToControl(unwireEventsOnly); }
private void AddButtons(ASPxGridLookup control) { EditButton clearButton = new EditButton(); clearButton.ToolTip = CaptionHelper.GetLocalizedText("DialogButtons", "Clear"); ASPxImageHelper.SetImageProperties(clearButton.Image, "Editor_Clear"); control.Buttons.Add(clearButton); if (newObjectViewController.NewObjectAction.Items.Count > 0) { EditButton addButton = new EditButton(); addButton.ToolTip = CaptionHelper.GetLocalizedText("DialogButtons", "Add"); ASPxImageHelper.SetImageProperties(addButton.Image, "Editor_Add"); control.Buttons.Add(addButton); } }
public void LoadManufacurer(ASPxGridLookup searchlookupedit) { try { ds = this.GetPatient(); searchlookupedit.KeyFieldName = "PatientId"; searchlookupedit.DataSource = ds.Tables["PatientsDetails"]; searchlookupedit.DataBind(); } catch (Exception ex) { Security secs = new Security(); secs.ErrorDesscription = ex.Message; secs.ErrorModule = "Select all permit types"; secs.SaveError(); } }
public void LoadDepartments(ASPxGridLookup searchlookupedit) { try { ds = this.GetDepartment(); searchlookupedit.KeyFieldName = "DeptCode"; searchlookupedit.DataSource = ds.Tables["Departments"]; searchlookupedit.DataBind(); } catch (Exception ex) { Security secs = new Security(); secs.ErrorDesscription = ex.Message; secs.ErrorModule = "Select all permit types"; secs.SaveError(); } }
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxTextBox uLJJ = ASPxGridView1.FindEditFormTemplateControl("txtLJJ") as ASPxTextBox; ASPxTextBox uCYCLE = ASPxGridView1.FindEditFormTemplateControl("txtCYCLE") as ASPxTextBox; ASPxTextBox uXH = ASPxGridView1.FindEditFormTemplateControl("txtXH") as ASPxTextBox; ASPxGridLookup GridLookupCode = ASPxGridView1.FindEditFormTemplateControl("GridLookupCode") as ASPxGridLookup; ASPxTextBox uBZ = ASPxGridView1.FindEditFormTemplateControl("txtBZ") as ASPxTextBox; string code = GridLookupCode.Text.Trim(); //插入到日志表 try { string Sql2 = "INSERT INTO ATPUFLGJTHZQB_LOG (XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,user_code,flag,rqsj)" + " SELECT XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM ATPUFLGJTHZQB WHERE XH = '" + uXH.Text.Trim() + "' "; dc.ExeSql(Sql2); } catch { return; } string Sql = "UPDATE ATPUFLGJTHZQB SET LOCATION_CODE='" + code + "', LOCATION_NAME='" + code + "',LJJ='" + uLJJ.Text.Trim() + "',CYCLE='" + uCYCLE.Text.Trim() + "',BZ='" + uBZ.Text.Trim() + "',INPUT_PERSON='" + theUserId + "',INPUT_TIME=SYSDATE " + " WHERE XH = '" + uXH.Text.Trim() + "'"; dc.ExeSql(Sql); //插入到日志表 try { string Sql2 = "INSERT INTO ATPUFLGJTHZQB_LOG (XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,user_code,flag,rqsj)" + " SELECT XH,LOCATION_CODE,LOCATION_NAME,LJJ,CYCLE,BZ,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM ATPUFLGJTHZQB WHERE XH = '" + uXH.Text.Trim() + "' "; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { if (e.NewValues["IsActive"] == null) { e.NewValues["IsActive"] = false; } if (Util.isExistXpoObject <AccountingPeriod>("Code", (string)e.NewValues["Code"])) { e.Cancel = true; throw (new Exception("Trùng mã chu kì")); return; } if (e.NewValues["AccountingPeriodTypeId!Key"] == null) { e.Cancel = true; throw (new Exception("Chưa chọn thể loại")); return; } AccountingPeriod accountingPeriod = new AccountingPeriod(session); accountingPeriod.Description = (string)e.NewValues["Description"]; accountingPeriod.Code = (string)e.NewValues["Code"]; accountingPeriod.AccountingPeriodTypeId = session.GetObjectByKey <AccountingPeriodType>(Guid.Parse(e.NewValues["AccountingPeriodTypeId!Key"].ToString())); accountingPeriod.FromDateTime = (DateTime)e.NewValues["FromDateTime"]; accountingPeriod.ToDateTime = (DateTime)e.NewValues["ToDateTime"]; accountingPeriod.RowStatus = Constant.ROWSTATUS_ACTIVE; accountingPeriod.IsActive = (bool)e.NewValues["IsActive"]; if (accountingPeriod.Code != null) { accountingPeriod.Save(); } ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup; List <object> selectedRows = grid.GridView.GetSelectedFieldValues("AccountingPeriodId"); if (!accountingPeriod.AccountingPeriodTypeId.IsDefault) { foreach (var o in selectedRows) { AccountingPeriodBO.CreatAccountingPeriodComposite(session, accountingPeriod.AccountingPeriodId, Guid.Parse(o.ToString())); } } e.Cancel = true; ASPxGridView1.CancelEdit(); }
public override void InitGridLookup(ASPxGridLookup gridlookup) { gridlookup.KeyFieldName = "OrganizationId"; gridlookup.TextFormatString = "{0} - {1}"; gridlookup.Columns.Clear(); GridViewColumn selectionColumn = new GridViewCommandColumn() { ShowSelectCheckbox = true, VisibleIndex = 0 }; GridViewColumn codeColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Code", Caption = "Mã tổ chức", VisibleIndex = 1, Width = 120 }; GridViewColumn nameColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "Name", Caption = "Tên tổ chức", VisibleIndex = 2, Width = 200 }; GridViewColumn parentOrgColumn = new GridViewDataTextColumn() { ShowInCustomizationForm = true, FieldName = "ParentOrganizationId.Name", Caption = "Trực thuộc tổ chức", VisibleIndex = 3, }; gridlookup.Columns.Add(selectionColumn); gridlookup.Columns.Add(codeColumn); gridlookup.Columns.Add(nameColumn); gridlookup.Columns.Add(parentOrgColumn); }
private void buildAddBtn(ASPxGridLookup cmb, string popupCode, int moduleID, int width, int height, string title, string param) { EditButton btnAdd = new EditButton(); btnAdd.Image.IconID = "actions_add_16x16"; btnAdd.Image.Height = Unit.Pixel(16); btnAdd.ToolTip = "Thêm mới"; cmb.Buttons.Add(btnAdd); string cmbClientName = cmb.ClientInstanceName; cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{btnCmbAdd('{0}','{1}',{2},{3},{4},'{5}','{6}');}}", popupCode, cmbClientName, moduleID, width, height, title, param); cmb.ClientSideEvents.KeyPress = string.Format("function(s,e){{if(event.ctrlKey && event.keyCode==13)btnCmbAdd('{0}','{1}',{2},{3},{4},'{5}','{6}');}}", popupCode, cmbClientName, moduleID, width, height, title, param); }
public List<HtmlTableCell> BuildGridLookup(string fieldtext, string id, string tablename, string alias, string helptext, string SkinID, int length, string datasource, bool isReadOnly, string controlValue) { List<HtmlTableCell> c = new List<HtmlTableCell>(); try { HtmlTableCell cell = new HtmlTableCell(); cell.Attributes.Add("class", "tblFormViewtdLabel"); cell.Style.Add("Width", "20%"); ASPxLabel lb = new ASPxLabel() { Text = fieldtext }; cell.Controls.Add(lb); HtmlTableCell celledit = new HtmlTableCell(); celledit.Attributes.Add("class", "tblFormViewtdValue"); celledit.Style.Add("Width", "30%"); //json attribute DataTable dtvalues = JsonConvert.DeserializeObject<DataTable>(datasource); string textformat = dtvalues.Rows[0]["textformat"].ToString(); string tablequery = dtvalues.Rows[0]["tablequery"].ToString(); string type = dtvalues.Rows[0]["type"].ToString(); string colSetting = dtvalues.Rows[0]["colSetting"].ToString(); string datavalue = dtvalues.Rows[0]["datavalue"].ToString(); string wherecondition = dtvalues.Rows[0]["wherecondition"].ToString(); SqlDataSource sqldata = new SqlDataSource() { ConnectionString = DataServices.ConnectString }; ASPxGridLookup gl = new ASPxGridLookup(); switch (type) { #region table case "table": { string select = string.Format("SELECT * FROM {0}", tablequery); string querysql = ProccessquerySql(select, wherecondition); proccessCreateColumnGridLookup(type,"",colSetting, gl); sqldata.SelectCommandType = SqlDataSourceCommandType.Text; sqldata.SelectCommand = querysql; gl.DataSource = sqldata; gl.KeyFieldName = datavalue; } break; #endregion #region query case "query": { string select = tablequery; string querysql = ProccessquerySql(select, wherecondition); proccessCreateColumnGridLookup(type,"", colSetting, gl); sqldata.SelectCommandType = SqlDataSourceCommandType.Text; sqldata.SelectCommand = querysql; gl.DataSource = sqldata; gl.KeyFieldName = select.IndexOf('*') >= 0 ? datavalue : datavalue.ToLower(); } break; #endregion #region query case "sp": { proccessCreateColumnGridLookup(type, "", colSetting, gl); sqldata.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sqldata.SelectCommand = tablequery; ProccessAddparamForStore(wherecondition, sqldata); gl.DataSource = sqldata; gl.KeyFieldName = datavalue; } break; #endregion } gl.ID = id; gl.GridViewProperties.Settings.ShowFilterRow = true; gl.SkinID = SkinID; gl.GridView.Width = Unit.Pixel((gl.GridView.Columns.Count > 0 ? gl.GridView.Columns.Count : 1) * (gl.GridView.Columns.Count > 0 ? int.Parse(gl.GridView.Columns[0].Width.Value.ToString()) : 1)); gl.Width = Unit.Percentage(99); gl.Theme = "DevEx"; gl.AutoPostBack = false; gl.TextFormatString = textformat; gl.DataBind(); gl.Value = controlValue; gl.ReadOnly = isReadOnly; celledit.Controls.Add(gl); c.Add(cell); c.Add(celledit); cot += 2; } catch (Exception ex) { LogAction(0, ex.ToString()); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "<script> alert('BuildGridLookup fieldname" + id + "'); </script>", false); } return c; }
private void proccessCreateColumnGridLookup(string type,string select ,string colSetting, ASPxGridLookup gl) { if (type == "query" && select.IndexOf('*')<0) colSetting = colSetting.ToLower(); DataTable dtLiscolSetting = JsonConvert.DeserializeObject<DataTable>(colSetting); for (int i = 0; i < dtLiscolSetting.Rows.Count; i++) { string colname = dtLiscolSetting.Rows[i]["colname"].ToString(); string caption = string.Format("{0}{1}", dtLiscolSetting.Rows[i]["caption"].ToString().Substring(0, 1).ToUpper(), dtLiscolSetting.Rows[i]["caption"].ToString().Remove(0, 1)); GridViewDataTextColumn cl = new GridViewDataTextColumn(); cl.Caption = string.Format("<Center>{0}<Center>", caption); cl.FieldName = colname; cl.VisibleIndex = i; cl.Width = 150; cl.Settings.AutoFilterCondition = AutoFilterCondition.Contains; gl.Columns.Add(cl); } }
/// <summary> /// Tao nut add/fav/refresh /// </summary> /// <param name="cmb">Truyen vao control combobox</param> /// <param name="type">Truyen vao loai nut. 0 : Fav; 1:Fav+Add;2:Fav+Add+Refresh;3:Only Refresh;4:Only Add;5: Fav+Refresh</param> public void buildcmbButton(ASPxGridLookup cmb, int type, string popupCode = "") { int modulePage = -1; try { Int32.TryParse(CU.getCurrentModuleID().ToString(), out modulePage); } catch (System.NullReferenceException) { } int width = 500; int height = 500; string title = "Error load Page!!!"; string param = ""; DataTable dtPopupWindow = new DataTable(); dtPopupWindow = SY_GetModuleID_for_PopUpcontrol(popupCode); if (dtPopupWindow.Rows.Count > 0) { SiAuto.Main.LogDataTable(dtPopupWindow); int.TryParse(dtPopupWindow.Rows[0]["moduleID"].ToString(), out moduleID); int.TryParse(dtPopupWindow.Rows[0]["width"].ToString(), out width); int.TryParse(dtPopupWindow.Rows[0]["height"].ToString(), out height); title = dtPopupWindow.Rows[0]["title"].ToString(); param = dtPopupWindow.Rows[0]["paramArray"].ToString(); } else return; //get Module by popupCode here...... switch (type) { case 0: buildFavBtn(cmb, modulePage); break; case 1: if (checkPermissionBtn(moduleID)) buildFavAddBtn(cmb, popupCode, modulePage, moduleID, width, height, title, param); else buildFavBtn(cmb, modulePage); break; case 2: if (checkPermissionBtn(moduleID)) buildAllBtn(cmb, popupCode, modulePage, moduleID, width, height, title, param); else buildFavRefresh(cmb, modulePage); break; case 3: buildRefreshBtn(cmb); break; case 4: if (checkPermissionBtn(moduleID)) buildAddBtn(cmb, popupCode, moduleID, width, height, title, param); break; case 5: buildFavRefresh(cmb, modulePage); break; default: break; } }
private void buildFavAddBtn(ASPxGridLookup cmb, string popupCode, int ModulePage, int moduleID, int width, int height, string title, string param) { EditButton btnAdd = new EditButton(); btnAdd.Image.IconID = "actions_add_16x16"; btnAdd.Image.Height = Unit.Pixel(16); btnAdd.ToolTip = "Thêm mới"; cmb.Buttons.Add(btnAdd); string cmbClientName = cmb.ClientInstanceName; string cmbClientID = cmb.ClientID + "_B1Img"; EditButton btnFav = new EditButton(); btnFav.Image.Url = "~/img/nonstar.png"; btnFav.Image.Height = Unit.Pixel(16); btnFav.ToolTip = "Chọn làm giá trị mặc định"; cmb.Buttons.Add(btnFav); cmb.ClientSideEvents.Init = string.Format("function(s,e){{cmbFavAddInit(s,'{0}','{1}',{2});}}", cmbClientName, cmbClientID, ModulePage); cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{cmbFavAddClick(s,e,'{0}','{1}','{2}',{3},{4},{5},{6},'{7}','{8}');}}", popupCode, cmbClientName, cmbClientID, ModulePage, moduleID, width, height, title, param); cmb.ClientSideEvents.KeyPress = string.Format("function(s,e){{if(event.ctrlKey && event.keyCode==13)btnCmbAdd('{0}','{1}',{2},{3},{4},'{5}','{6}');}}", popupCode, cmbClientName, moduleID, width, height, title, param); }
public static void SetLookupValue(ASPxGridLookup cbb, object objects) { try { if (objects != null) cbb.Value = objects; } catch (Exception ex) { SiAuto.Main.LogString("Lỗi SetLookupValue :", ex.ToString()); } }
public static string GetLookupValue(ASPxGridLookup cbb) { string result = "-1"; try { result = cbb.Value.ToString(); } catch (Exception ex) { SiAuto.Main.LogString("Lỗi GetLookupValue :", ex.ToString()); } return result; }
public static void BindData(ASPxGridLookup gvlookup, DevExpress.Xpo.Session s, string objectname, string filter = "", params object[] parameter) { try { DynamicDataTableClassInfo classInfo = dynamicClasses[objectname]; if (classInfo != null) { XPServerCollectionSource ds = new XPServerCollectionSource(s, dynamicClasses[objectname], CriteriaOperator.Parse(filter, parameter)); gvlookup.DataSource = ds; //gvlookup.KeyFieldName = classInfo.KeyProperty.DisplayName; } else throw new Exception(string.Format("Đối tượng {0} không tìm thấy trong database. Nếu không có dữ liệu hiển thị thì XPOProfiles để xem điều kiện lọc đúng chưa", objectname)); } catch (Exception ex) { SiAuto.Main.LogColored(Color.Red, "Loi BindData:" + ex.ToString()); throw ex; } }
private void buildRefreshBtn(ASPxGridLookup cmb) { string cmbClientName = cmb.ClientInstanceName; EditButton btnRefresh = new EditButton(); btnRefresh.Image.IconID = "actions_refresh_16x16"; btnRefresh.Image.Height = Unit.Pixel(16); btnRefresh.ToolTip = "Load lại dữ liệu"; cmb.Buttons.Add(btnRefresh); cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{cmbRefreshClick('{0}');}}", cmbClientName); }
private void buildFavRefresh(ASPxGridLookup cmb, int ModulePage) { EditButton btnFav = new EditButton(); btnFav.Image.Url = "~/img/nonstar.png"; btnFav.Image.Height = Unit.Pixel(16); btnFav.ToolTip = "Chọn làm giá trị mặc định"; cmb.Buttons.Add(btnFav); EditButton btnRefresh = new EditButton(); btnRefresh.Image.IconID = "actions_refresh_16x16"; btnRefresh.Image.Height = Unit.Pixel(16); btnRefresh.ToolTip = "Load lại dữ liệu"; cmb.Buttons.Add(btnRefresh); string cmbClientName = cmb.ClientInstanceName; string cmbClientID = cmb.ClientID + "_B0Img"; cmb.ClientSideEvents.Init = string.Format("function(s,e){{cmbFavInit(s,'{0}','{1}',{2});}}", cmbClientName, cmbClientID, ModulePage); cmb.ClientSideEvents.ButtonClick = string.Format("function(s,e){{cmbFavRefClick(s,e,'{0}','{1}',{2});}}", cmbClientName, cmbClientID, ModulePage); }