protected void Grid_Costing_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView g = sender as ASPxGridView; string sql = "select JobNo from JobOrder where SequenceId='" + SafeValue.SafeString(g.GetMasterRowKeyValue(), "0") + "'"; this.dsCosting.FilterExpression = "RefNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql)) + "'"; }
protected void grid_PayrollDet_RowDeleted(object sender, DevExpress.Web.Data.ASPxDataDeletedEventArgs e) { ASPxGridView grd = sender as ASPxGridView; UpdateMaster(SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0)); }
protected void grdGeneralJournal_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e) { ASPxGridView grid = sender as ASPxGridView; Guid transactionId = (Guid)grid.GetMasterRowKeyValue(); Guid accountId = (Guid)e.NewValues["AccountId!Key"]; //Validate duuplicate account in transaction //Insert mode if (grid.IsNewRowEditing) { bool isExist = TransactionBO.isExistAccountInTransaction(transactionId, accountId); if (isExist) { Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["AccountId!Key"], String.Format("Tài khoản này đã được chọn")); } } //Edit mode else { Guid oldAccountId = (Guid)e.OldValues["AccountId!Key"]; if (!oldAccountId.Equals(accountId)) { bool isExist = TransactionBO.isExistAccountInTransaction(transactionId, accountId); if (isExist) { Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["AccountId!Key"], String.Format("Tài khoản này đã được chọn")); } } } //Check negative if (e.NewValues["Credit"] != null && (double)e.NewValues["Credit"] < 0) { Utility.Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Credit"], "Không thể nhập số âm"); } if (e.NewValues["Debit"] != null && (double)e.NewValues["Debit"] < 0) { Utility.Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Debit"], "Không thể nhập số âm"); } //Check input both credit and debit if ((e.NewValues["Credit"] != null //&& e.NewValues["Credit"].ToString().Length > 0 && ((double)e.NewValues["Credit"]) > 0) && (e.NewValues["Debit"] != null //&& e.NewValues["Debit"].ToString().Length > 0 && ((double)e.NewValues["Debit"]) > 0)) { Utility.Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Credit"], "Chỉ cho phép nhập Nợ hoặc nhập Có"); Utility.Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Debit"], "Chỉ cho phép nhập Nợ hoặc nhập Có"); } //Check leave blank both credit and debit else if ((e.NewValues["Credit"] == null //|| e.NewValues["Credit"].ToString().Length > 0 || ((double)e.NewValues["Credit"]) == 0) && (e.NewValues["Debit"] == null //|| e.NewValues["Debit"].ToString().Length > 0 || ((double)e.NewValues["Debit"]) == 0)) { Utility.Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Credit"], "Chưa nhập Nợ hoặc nhập Có"); Utility.Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Debit"], "Chưa nhập Nợ hoặc nhập Có"); } }
protected void gvPayments_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView gv = (ASPxGridView)sender; if (cmbProgram.Value != null) { gv.DataSource = new FeesPaymentService().GetAllFeesPayment(int.Parse(cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "ClassID").ToString()), new StudentFeesService().GetStudentFeesById(int.Parse(gv.GetMasterRowKeyValue().ToString()), new SessionManager().GetUserId(this.Session)).UserId, new SessionManager().GetUserId(Session)); } }
protected void Grid_ExchangeRate_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { e.Cancel = true; session.BeginTransaction(); ASPxGridView grid = sender as ASPxGridView; ExchangeRate exchangeid = new ExchangeRate(session); object keyvalue = grid.GetMasterRowKeyValue(); CurrencyType currencyTypeid = session.GetObjectByKey <CurrencyType>(Guid.Parse(keyvalue.ToString())); NAS.DAL.Accounting.Currency.Currency currencyid = BO.get_Currency_true_master(session, currencyTypeid.CurrencyTypeId.ToString(), true, Utility.Constant.ROWSTATUS_ACTIVE); //NAS.DAL.Accounting.Currency.Currency NumeratorCurrencyId = BO.get_CurrencyId_currencyId(session, currencyid.CurrencyId.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); //NAS.DAL.Accounting.Currency.Currency DenomiratorCurrencyId = BO.get_CurrencyId_currencyId(session, Currency_Id.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); //if (BO.check_ExchangeRate_BankId( // session, // NumeratorCurrencyId.CurrencyId.ToString(), // DenomiratorCurrencyId.CurrencyId.ToString(), // bankid.BankId.ToString(), // Utility.Constant.ROWSTATUS_ACTIVE // )) //{ // throw new Exception(String.Format("Ngân Hàng {0} Trùng, Yêu Cầu Nhập Lại Ngân Hàng", bankid.Code)); //} exchangeid.AffectedDate = DateTime.Parse(e.NewValues["AffectedDate"].ToString()); if (e.NewValues["BankId!Key"] != null) { Bank bankid = session.GetObjectByKey <Bank>(Guid.Parse(e.NewValues["BankId!Key"].ToString())); if (bankid != null) { exchangeid.BankId = bankid; exchangeid.Name = bankid.Code; } } exchangeid.Rate = float.Parse(e.NewValues["Rate"].ToString()); if (e.NewValues["Description"] != null) { exchangeid.Description = e.NewValues["Description"].ToString(); } exchangeid.NumeratorCurrencyId = BO.get_CurrencyId_currencyId(session, currencyid.CurrencyId.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); exchangeid.DenomiratorCurrencyId = BO.get_CurrencyId_currencyId(session, Currency_Id.ToString(), Utility.Constant.ROWSTATUS_ACTIVE); exchangeid.Status = short.Parse(e.NewValues["Status"].ToString()); exchangeid.RowCreationTimeStamp = DateTime.Now; exchangeid.RowStatus = Utility.Constant.ROWSTATUS_ACTIVE; exchangeid.Save(); session.CommitTransaction(); grid.CancelEdit(); grid.DataBind(); } catch (Exception) { session.RollbackTransaction(); throw; } }
protected void grid_DoIn_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql = "select DoNo from Wh_Trans where Id='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; string doNo = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), ""); sql = string.Format(@"select * from Wh_Do d left join (select sum(Qty1) as TotalQty,DoNo from Wh_TransDet group by DoNo) as det on d.DoNo=det.DoNo left join Wh_Trans mast on d.PoNo=mast.DoNo and d.DoType='IN' where BlanketNo='{0}'", doNo); DataTable tab = ConnectSql.GetTab(sql); grd.DataSource = tab; }
protected void grid_InvDet_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { e.Values["Id"] = SafeValue.SafeString(e.Values["Id"]); ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql_detCnt = "select ExportInd from jnl_doc where Id='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; string exportInd = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql_detCnt), "N"); if (exportInd == "Y") { throw new Exception("Have Posted, can't delete item"); } }
protected void gvUsersInRole_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView gridview = sender as ASPxGridView; sdsUsersInRole.SelectParameters["rolename"].DefaultValue = gridview.GetMasterRowKeyValue().ToString(); }
protected void ASPxGridView2_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grdTransactionDetail = (ASPxGridView)sender; Session["TransactionId"] = grdTransactionDetail.GetMasterRowKeyValue(); }
protected void detailGrid_DataSelect(object sender, EventArgs e) { ASPxGridView detailGrid = sender as ASPxGridView; detailGrid.DataSource = DataProvider.GetItems((int)detailGrid.GetMasterRowKeyValue()); }
protected void gridviewBankBranch_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e) { ASPxGridView grid = sender as ASPxGridView; if (e.NewValues["Code"] == null) { throw new Exception("Mã số chi nhánh không được để trống."); } else { XPCollection <BankBranch> b = new XPCollection <BankBranch>(session, CriteriaOperator.Parse("Code = '" + e.NewValues["Code"].ToString() + "' AND BankId='" + grid.GetMasterRowKeyValue() + "'")); if (e.IsNewRow) { if (b.Count > 0) { throw new Exception("Mã số chi nhánh đã tồn tại."); } } else { if (e.NewValues["Code"].ToString() != e.OldValues["Code"].ToString()) { if (b.Count > 0) { throw new Exception("Mã số chi nhánh đã tồn tại."); } } } } Regex regex = new Regex(@"^[-+]?[0-9]*\.?[0-9]+$"); if (e.NewValues["PhoneFax"] == null) { return; } if (!regex.IsMatch(e.NewValues["PhoneFax"].ToString())) { throw new Exception("Điện thoại/Fax phải là dạng số."); } }
protected void Grid_Invoice_Import_DataSelect(object sender, EventArgs e) { ASPxGridView grd = sender as ASPxGridView; string sql = "select RefNo from SeaExportRef where sequenceId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), -1) + "'"; this.dsInvoice.FilterExpression = "MastType='SE' and MastRefNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "0") + "'"; }
protected void Grid_RefCont_DataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql = "select RefNo from SeaExportRef where sequenceId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; this.dsExpRefCont.FilterExpression = "StatusCode='USE' and MkgType='Cont' and RefNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "") + "'"; }
protected void gvAuditDetails_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView gridview = sender as ASPxGridView; sdsAuditDetails.SelectParameters["audit_id"].DefaultValue = gridview.GetMasterRowKeyValue().ToString(); }
protected void grid_SubSo_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql = "select DoNo from Wh_Trans where Id=" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + ""; string blanketNo = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "-1"); sql = string.Format(@"select mast.DoNo,DoDate,PartyName,TotalQty,DoStatus from Wh_Trans mast left join (select sum(Qty1) as TotalQty,DoNo from Wh_TransDet group by DoNo) as tab on tab.DoNo=mast.DoNo where BlanketNo='{0}' and DoType='PO'", blanketNo); DataTable tab = ConnectSql.GetTab(sql); grd.DataSource = tab; }
protected void dgMMateriales_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e) { ASPxGridView dg = (ASPxGridView)sender; try { using (var db = new UnidadDeTrabajo()) { foreach (var item in e.InsertValues) { db.MarcaMaterial.InsertarValoresMarcaMaterial(item.NewValues, int.Parse(dg.GetMasterRowKeyValue().ToString())); } foreach (var item in e.UpdateValues) { db.MarcaMaterial.ActualizarMarcaMaterial(item.Keys, item.NewValues); } foreach (var item in e.DeleteValues) { db.MarcaMaterial.EliminarMarcaMaterial(item.Keys); } } dg.JSProperties["cpOperacionesGrid"] = "Operación realizada con éxito"; } catch (Exception ex) { dg.JSProperties["cpOperacionesGrid"] = "Error: " + ex.Message; } e.Handled = true; }
protected void grid_SoInv_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql = "select DoNo from Wh_Trans where Id='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; string doNo = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), ""); sql = string.Format(@"select * from XAArInvoice inv left join Wh_Trans mast on inv.MastRefNo=mast.DoNo and mast.DoType='PO' where BlanketNo='{0}'", doNo); DataTable tab = ConnectSql.GetTab(sql); grd.DataSource = tab; }
protected void gridDetail_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView gridViewProducts = (ASPxGridView)sender; Session["SessionCategoryID"] = gridViewProducts.GetMasterRowKeyValue(); }
protected void gridRecruitmentDet_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; this.dsPerson.FilterExpression = string.Format("CHARINDEX('<'+cast({0} as nvarchar(10))+'>',RecruitId)>0", SafeValue.SafeString(grd.GetMasterRowKeyValue(), "0")); }
protected void Grid_Payable_Import_DataSelect(object sender, EventArgs e) { ASPxGridView grd = sender as ASPxGridView; string sql = "select ReleaseNo from wh_SORelease where Id=" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + ""; this.dsVoucher.FilterExpression = "MastType='SOR' and MastRefNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "-1") + "'"; }
protected void grdServiceConfig_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView gridSC = sender as ASPxGridView; e.NewValues["ServiceID"] = gridSC.GetMasterRowKeyValue(); }
protected void Grid_Payable_Import_DataSelect(object sender, EventArgs e) { ASPxGridView grd = sender as ASPxGridView; string sql = "select JobNo from Tpt_Job where Id='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), -1) + "'"; string refNo = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql)); this.dsVoucher.FilterExpression = string.Format("MastRefNo='{0}' and MastType='TPT'", refNo); }
protected void grid_InvDet_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = sender as ASPxGridView; this.dsQuotationDet.FilterExpression = "QuoteId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), -1) + "'"; }
protected void grid_TripLog_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql = "select JobNo from tpt_Job where Id='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; this.dsTripLog.FilterExpression = " JobNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "") + "' and JobType='Local'"; }
protected void grid_PayrollDet_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = sender as ASPxGridView; this.dsPayrollDet.FilterExpression = "PayrollId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; }
protected void gv_activity_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; string sql = "select JobNo from TPT_Job where Id='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; string JobNo = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql)); dsActivity.FilterExpression = "JobNo='" + JobNo + "'"; }
protected void detailGrid_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grid = sender as ASPxGridView; Session["CategoryID"] = grid.GetMasterRowKeyValue(); }
protected void grid_det_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; this.dsWhInventoryDet.FilterExpression = " LineINo='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; }
protected void grid_InvDet_BeforePerformDataSelect(object sender, EventArgs e) { ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView; this.dsApPayableDet.FilterExpression = "DocId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; }
protected void grid_Mkgs_DataSelect(object sender, EventArgs e) { ASPxGridView g = sender as ASPxGridView; string sql = "select JobNo from JobOrder where SequenceId='" + SafeValue.SafeString(g.GetMasterRowKeyValue(), "0") + "'"; this.dsMarking.FilterExpression = "RefNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql)) + "'"; //ASPxGridView grd = sender as ASPxGridView; //string sql = "select JobNo from SeaExport where sequenceId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; //string jobNo = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), ""); //string sql_jobType = "select mast.jobtype from seaexport job inner join SeaExportRef mast on job.RefNo=mast.Refno where job.sequenceId='" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0) + "'"; //string jobType = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql_jobType), ""); //if (jobType == "FCL") // this.dsMarking.FilterExpression = "JobNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "") + "' and MkgType='Cont'"; //else // this.dsMarking.FilterExpression = "JobNo='" + SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "") + "' and MkgType='Bl'"; }