void gridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { GridView view = sender as GridView; GridView gridView = (GridView)MainView; ManagerTimeKeeperEntities entity = (ManagerTimeKeeperEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity; if (e.RowHandle >= 0) { HRTimeKeeperCompletesInfo objTimeKeeperCompletesInfo = (HRTimeKeeperCompletesInfo)gridView.GetRow(e.RowHandle); ((ManagerTimeKeeperModule)Screen.Module).AddBackupList(objTimeKeeperCompletesInfo); if (e.Column.FieldName == "HRTimeKeeperCompleteTimeCheck") { //1.CheckSameTime ((ManagerTimeKeeperModule)Screen.Module).CheckSameTime(objTimeKeeperCompletesInfo, entity.TimeKeeperCompletesList.ToList()); //2.CheckNotInOverTime ((ManagerTimeKeeperModule)Screen.Module).CheckNotInOverTime(objTimeKeeperCompletesInfo, 60, true); //2.CheckNotInOverTime ((ManagerTimeKeeperModule)Screen.Module).CheckOverTimeAbsence(objTimeKeeperCompletesInfo, 60, true); } if (e.Column.FieldName == "HRTimeKeeperCompleteDate") { ((ManagerTimeKeeperModule)Screen.Module).ChangeCompleteDate(objTimeKeeperCompletesInfo); } } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { this.BaseFocusLabel.Focus(); if (e.Column.FieldName == "GrossQty") { // 净重=毛米长(米)*克重 (千克/米)*门幅(米) 毛重=净重+0.05kg 云虹公式: ColumnView view = sender as ColumnView; decimal grossqty = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "GrossQty")); //毛米长 decimal grossweight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "GrossWeight")); //毛重 decimal netweight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "NetWeight")); //净重 decimal mwidth = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWidth")); //门幅 decimal mweight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWeight")); //克重 if (mwidth > 0 && mwidth < 1000) { decimal mf = mwidth * SysConvert.ToDecimal(0.01); decimal kz = mweight * SysConvert.ToDecimal(0.001); decimal jz = SysConvert.ToDecimal(grossqty * mf * kz, 2); view.SetRowCellValue(view.FocusedRowHandle, "NetWeight", jz); decimal mz = jz + SysConvert.ToDecimal(0.05); view.SetRowCellValue(view.FocusedRowHandle, "GrossWeight", mz); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
private void viewListado_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { ro_nomina_tipo_liqui_orden_Info oFila = new ro_nomina_tipo_liqui_orden_Info(); try { int cont = 0; oFila = (ro_nomina_tipo_liqui_orden_Info)viewListado.GetRow(e.RowHandle); if (oFila != null) { if (e.Column.Name == "colOrden") { cont = (from a in oLstOrdenRubrosNomina_Info where a.Orden == oFila.Orden select a).Count(); if (cont > 1) { MessageBox.Show("El Orden se encuentra repetido, revise por favor", "ATENCION", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); Log_Error_bus.Log_Error(ex.ToString()); } }
/// <summary> /// 主表单元格值变化进行的操作 /// </summary> private void gridViewPSchedule_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { switch (e.Column.FieldName) { case "CodeFileName": string tmpStr = DataTypeConvert.GetString(gridViewPSchedule.GetDataRow(e.RowHandle)["CodeFileName"]); if (tmpStr == "") { gridViewPSchedule.SetRowCellValue(e.RowHandle, "CodeName", ""); } else { DataTable temp = (DataTable)repSearchCodeFileName.DataSource; DataRow[] drs = temp.Select(string.Format("CodeFileName='{0}'", tmpStr)); if (drs.Length > 0) { gridViewPSchedule.SetRowCellValue(e.RowHandle, "CodeName", DataTypeConvert.GetString(drs[0]["CodeName"])); } } break; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--主表单元格值变化进行的操作错误。", ex); } }
void rootgridViewPaymentTerms_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { GridView view = sender as GridView; if (CurrentState == ActionsStates.Edit) { PaymentTerms tmpPaymentTerms = new PaymentTerms(); object idPaymentTerms = view.GetRowCellValue(view.FocusedRowHandle, nameof(PaymentTerms.IdPaymentTerms)); object description = view.GetRowCellValue(view.FocusedRowHandle, nameof(PaymentTerms.Description)); object descriptionZh = view.GetRowCellValue(view.FocusedRowHandle, nameof(PaymentTerms.DescriptionZh)); tmpPaymentTerms.IdPaymentTerms = (idPaymentTerms ?? string.Empty).ToString(); tmpPaymentTerms.Description = (description ?? string.Empty).ToString(); tmpPaymentTerms.DescriptionZh = (descriptionZh ?? string.Empty).ToString(); AddModifiedPaymentTermToList(tmpPaymentTerms); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void GVDanhSachDaCapMa_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { GridView view = sender as GridView; var columnHandle = e.Column.ColumnHandle; var rowHandle = e.RowHandle; var maDonvi = view.GetRowCellValue(rowHandle, this.col_MaDonVi_GCDaCapMau); var maXN = view.GetRowCellValue(rowHandle, this.col_MaXetNghiem_GCDaCapMau); //int sLuong = view.GetRowCellValue(rowHandle, this.col_SoLuong) == null ? 1 : int.Parse(view.GetRowCellValue(rowHandle, this.col_SoLuong).ToString()); //var GtriBatDau = view.GetRowCellValue(rowHandle, this.col_MaBatDau) == null ? string.Empty : view.GetRowCellValue(rowHandle, this.col_MaBatDau).ToString(); //var GtriKetThuc = view.GetRowCellValue(rowHandle, this.col_MaKetThuc) == null ? string.Empty : view.GetRowCellValue(rowHandle, this.col_MaKetThuc).ToString(); if (rowHandle < view.RowCount) { if (columnHandle == this.col_MaXetNghiem_GCDaCapMau.ColumnHandle) { var rs = this.lstDaDanhMaXN.FirstOrDefault(p => p.MaXetNghiem == maXN.ToString()); var valueOld = view.ActiveEditor.OldEditValue; if (rs != null) { if (!string.IsNullOrEmpty(valueOld.ToString())) { for (int i = 0; i < view.RowCount; i++) { if (view.GetRowCellValue(i, this.col_MaXetNghiem_GCDaCapMau).Equals(maXN) && !i.Equals(rowHandle)) { view.SetRowCellValue(i, this.col_MaXetNghiem_GCDaCapMau, valueOld.ToString()); break; } } } } } } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { // xmlhelper.Read("bookstore/book[@ISBN=\"7-111-19149-6\"]") Attributes 的属性 // xmlhelper.Read("bookstore/book[title=\"计算机硬件技术基础\"]") 内部节点 XmlNodeList xmlNodeLst = xmlhelper.Read("datatype/item[@gid=\"" + tmpconstantInfo.Gid + "\"]"); Int32 idx = -1; switch (e.Column.ToString()) { case "名称": idx = 0; break; case "常量值": idx = 1; break; case "说明": idx = 2; break; } if (idx == -1) { return; } xmlNodeLst.Item(idx).InnerText = e.Value.ToString(); xmlhelper.Save(false); tmpconstantInfo = null; }
private void gvPO_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DataRow row = gvPO.GetDataRow(e.RowHandle); if (e.Column == colSupplierCode || e.Column == colSupplierName) { string code = (string)row[e.Column.FieldName]; row[colSupplierCode.FieldName] = code; row[colSupplierName.FieldName] = code; } else if (e.Column == colProjectCode || e.Column == colProjectName) { int projectId = (int)row[e.Column.FieldName]; row[colProjectCode.FieldName] = projectId; row[colProjectName.FieldName] = projectId; row[colBillable.FieldName] = Project.GetProject(projectId)?.Billable ?? false; } if (!gvPO.IsNewItemRow(e.RowHandle)) { if (new GridColumn[] { colPODate, colPONumber, colSupplierCode, colSupplierName, colProjectCode, colProjectName, colBillable }.Contains(e.Column)) { FieldPO.SqlUpdate((int)row[colId.FieldName], (DateTime)row[colPODate.FieldName], Convert.ToString(row[colPONumber.FieldName]), (string)row[colSupplierCode.FieldName], (int)row[colProjectCode.FieldName], (bool)row[colBillable.FieldName]); row[colStatus.FieldName] = Enum.GetName(typeof(EnumSubmitStatus), EnumSubmitStatus.Open); btnSubmit.Enabled = true; } } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!GridViewVouch.IsFilterRow(e.RowHandle)) { modified = true; } }
void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!CellExists(gridView1.GetDataSourceRowIndex(e.RowHandle), e.Column)) { modifiedCells.Add(new GridCell(gridView1.GetDataSourceRowIndex(e.RowHandle), e.Column)); } }
private void gridViewLeaveDayDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == colDayOffType) { CalculateLeaveDays(); } }
void rootgridViewFamiliesHk_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { GridView view = sender as GridView; if (CurrentState == ActionsStates.Edit) { FamilyHK tmpFamilyHK = new FamilyHK(); object idFamilyHk = view.GetRowCellValue(view.FocusedRowHandle, nameof(FamilyHK.IdFamilyHk)); object description = view.GetRowCellValue(view.FocusedRowHandle, nameof(FamilyHK.Description)); tmpFamilyHK.IdFamilyHk = (idFamilyHk ?? string.Empty).ToString(); tmpFamilyHK.Description = (description ?? string.Empty).ToString(); AddModifiedFamilyHkToList(tmpFamilyHK); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void grvData_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { decimal qty = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colQty)); decimal vat = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colVAT)) / 100; decimal priceHD = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceHD)); decimal priceTPA = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceTPA)); decimal priceReal = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceReal)); decimal priceVT = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceDT)); string priceType = TextUtils.ToString(grvData.GetRowCellValue(e.RowHandle, colPriceType)); int costGroupID = TextUtils.ToInt(grvData.GetRowCellValue(e.RowHandle, colCostGroupID)); bool isChange = false; if (e.Column == colQty) { grvData.SetRowCellValue(e.RowHandle, colTotalVT, qty * priceVT); grvData.SetRowCellValue(e.RowHandle, colTotalHD, qty * priceHD); grvData.SetRowCellValue(e.RowHandle, colTotalTPA, qty * priceTPA); grvData.SetRowCellValue(e.RowHandle, colTotalReal, qty * priceReal); isChange = true; } if (e.Column == colVAT) { grvData.SetRowCellValue(e.RowHandle, colPriceHDnoVAT, priceHD * (1 - vat)); grvData.SetRowCellValue(e.RowHandle, colTotalHDnoVat, qty * (priceHD * (1 - vat))); isChange = true; } if (e.Column == colPriceType || e.Column == colPriceDT || e.Column == colCostGroupID) { decimal costSX = GetCostSX(costGroupID, priceVT); decimal costTM = GetCostTM(costGroupID, priceVT); if (priceType.ToUpper() == "SX") { grvData.SetRowCellValue(e.RowHandle, colPriceTPA, costSX); grvData.SetRowCellValue(e.RowHandle, colTotalTPA, qty * costSX); } else { grvData.SetRowCellValue(e.RowHandle, colPriceTPA, costTM); grvData.SetRowCellValue(e.RowHandle, colTotalTPA, qty * costTM); } } if (e.Column == colPriceHD) { grvData.SetRowCellValue(e.RowHandle, colPriceHDnoVAT, priceHD * (1 - vat)); grvData.SetRowCellValue(e.RowHandle, colTotalHDnoVat, qty * (priceHD * (1 - vat))); grvData.SetRowCellValue(e.RowHandle, colTotalHD, qty * priceHD); isChange = true; } if (isChange) { loadRealPrice(); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { //if (e.Column.FieldName == "PorcDesc") //{ // bEditMontoDesc = false; // bEditPorcDesc = true; //} }
void gvMain_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.FieldName == "AdjustQTY") { gvMain.SetFocusedRowCellValue(gvMain.Columns["TotalQTY"], Convert.ToDecimal(e.Value) + Convert.ToDecimal(gvMain.GetFocusedRowCellValue("FinishJobQTY"))); } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { ColumnView view = gridControl1.FocusedView as ColumnView; // if (view.UpdateCurrentRow()) { dataTableAdapter.Update(eJX_DATADataSet.Data); } }
private void advBandedGridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!AdvBandedGridViewDigHdr.IsFilterRow(e.RowHandle)) { modified = true; labelControl7.Text = DateTime.Today.ToShortDateString(); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (string.IsNullOrEmpty((gridView1.GetFocusedRow() as ConstantInfo).Gid) && (gridView1.FocusedRowHandle + 1 == gridView1.RowCount)) { btnAdd_Click(null, null); } tmpconstantInfo = gridView1.GetRow(e.RowHandle) as ConstantInfo; }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (!GridViewBusTable.IsFilterRow(e.RowHandle)) { modified = true; } labelControl1.Text = DateTime.Today.ToShortDateString(); labelControl2.Text = username; }
private void dvgBsDetails_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { //if(e.Column.FieldName== "Amount") //{ // decimal value; // value = Convert.ToDecimal(Amount.SummaryItem.SummaryValue)-Convert.ToDecimal(e.Value.ToString()); //} }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { //DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView; ////MessageBox.Show("" + e.RowHandle + ""); //viethoadon(e.RowHandle); //BandedGridView view = sender as BandedGridView; //decimal a = 1000; //view.Columns["TotalPrice"] }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { // xmlhelper.Read("bookstore/book[@ISBN=\"7-111-19149-6\"]") Attributes 的属性 // xmlhelper.Read("bookstore/book[title=\"计算机硬件技术基础\"]") 内部节点 XmlNodeList xmlNodeLst = xmlhelper.Read("datatype/item[@gid=\"" + tmpdataTypeInfo.Gid + "\"]"); Int32 idx = -1; switch (e.Column.ToString()) { case "类型名": idx = 0; break; case "名称": idx = 1; break; case "Oracle": idx = 2; break; case "Mysql": idx = 3; break; case "DB2": idx = 4; break; case "Sql Server": idx = 5; break; case "Sqlite": idx = 6; break; case "Access": idx = 7; break; case "CShort": idx = 8; break; } if (idx == -1) { return; } xmlNodeLst.Item(idx).InnerText = e.Value.ToString(); xmlhelper.Save(false); tmpdataTypeInfo = null; }
/// <summary> /// 套餐类别变更 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.FieldName == "CB002") //套餐类别 { if (e.Value.ToString() == "1") { (sender as ColumnView).SetRowCellValue(e.RowHandle, "CB005", null); } } }
private void dvgItemDetails_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { List <ItemMasterModel> lstItems = objIMBL.GetItemsByName(e.Value.ToString()); if (e.Column.Caption == "Item") { if (e.Value.ToString() == null) { dvgBsDetails.Focus(); } else { List <string> lstUnits = new List <string>(); foreach (ItemMasterModel objUnits in lstItems) { lstUnits.Add(objUnits.MainUnit); lstUnits.Add(objUnits.AltUnit); } UnitsLookup.DataSource = lstUnits; } } if (e.Column.Caption == "Qty" || e.Column.Caption == "Basic Amt" || e.Column.Caption == "Price(Rs.)") { GridView view = sender as GridView; decimal Qty = Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString()); decimal Price = Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Price"]).ToString() == string.Empty ? "0.00" : view.GetRowCellValue(e.RowHandle, view.Columns["Price"]).ToString()); decimal BasicAmt = Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["BasicAmt"]).ToString() == string.Empty ? "0.00" : view.GetRowCellValue(e.RowHandle, view.Columns["BasicAmt"]).ToString()); decimal TaxSlab = 5; if (view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString() != string.Empty && view.GetRowCellValue(e.RowHandle, view.Columns["Price"]).ToString() != string.Empty) { //if (tbxSaleType.SelectedItem.ToString() == "VAT Incl") //{ // TaxCalculationModel objTax = objSTCal.VATInclusive(Qty, Price, BasicAmt, TaxSlab); // view.SetRowCellValue(e.RowHandle, view.Columns["Amount"], Math.Round(objTax.TotalAmount, 2)); // view.SetRowCellValue(e.RowHandle, view.Columns["BasicAmt"], Math.Round(objTax.BasicAmount, 2)); // view.SetRowCellValue(e.RowHandle, view.Columns["TaxAmount"], Math.Round(objTax.TaxAmount, 2)); // view.SetRowCellValue(e.RowHandle, view.Columns["Price"], Math.Round(objTax.Price, 2)); //} } } //decimal Value; //if (e.Column.Caption == "Basic Amt") //{ // Value = Convert.ToDecimal(e.Value.ToString()) / Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString()); // if (tbxSaleType.SelectedItem.ToString() == "VAT Incl") // { // TaxCalculationModel objTax = objSTCal.VATInclusive(Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString()), Convert.ToDecimal(va), 5); // view.SetRowCellValue(e.RowHandle, view.Columns["BasicAmt"], Math.Round(objTax.BasicAmount, 2)); // view.SetRowCellValue(e.RowHandle, view.Columns["TaxAmount"], Math.Round(objTax.TaxAmount, 2)); // view.SetRowCellValue(e.RowHandle, view.Columns["Amount"], Math.Round(objTax.TotalAmount, 2)); // } //} }
private void gvEquipment_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DataRow row = gvEquipment.GetDataRow(e.RowHandle); if (e.Column == colEqpNum || e.Column == colAssetDescription) { string eqtNum = Convert.ToString(row[e.Column.FieldName]); row[colEqpNum.FieldName] = eqtNum; row[colAssetDescription.FieldName] = eqtNum; var equip = Equipment.GetEquipment(eqtNum); row[colEquipmentClass.FieldName] = EquipmentClass.GetEquipmentClass(equip.ClassCode)?.DisplayName ?? ""; Employee employee = (equip.OwnerType == EnumOwnerType.Employee) ? EquipmentAssignment.GetEmployee(equip.EqpNum, _headerRecord.LogDate) : null; row[colEmpNum.FieldName] = (object)employee?.EmpNum ?? DBNull.Value; row[colEmployeeName.FieldName] = employee?.DisplayName ?? ""; RefreshBillRate(row); } else if (e.Column == colLevel1Code) { row[colLevel2Code.FieldName] = DBNull.Value; row[colLevel3Code.FieldName] = DBNull.Value; row[colLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colLevel2Code) { row[colLevel3Code.FieldName] = DBNull.Value; row[colLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colLevel3Code) { row[colLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colBillCycle) { RefreshBillRate(row); } else if (e.Column == colQuantity) { RefreshBillAmount(row); } if (!gvEquipment.IsNewItemRow(e.RowHandle)) { if (new GridColumn[] { colEqpNum, colAssetDescription, colChangeOrder, colLevel1Code, colLevel2Code, colLevel3Code, colLevel4Code, colBillable, colQuantity, colBillCycle }.Contains(e.Column)) { EquipTimeEntry.SqlUpdate((int)row[colId.FieldName], (string)row[colEqpNum.FieldName], ConvertEx.ToNullable <int>(row[colEmpNum.FieldName]), ConvertEx.ToNullable <int>(row[colChangeOrder.FieldName]), ConvertEx.ToNullable <int>(row[colLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel2Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel4Code.FieldName]), (bool)row[colBillable.FieldName], ConvertEx.ToNullable <decimal>(row[colQuantity.FieldName]) ?? 0, ConvertEx.CharToEnum <EnumBillCycle>(row[colBillCycle.FieldName]), ConvertEx.ToNullable <decimal>(row[colBillAmount.FieldName])); LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open); } } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { GridView view = sender as GridView; int HTV = 0; long a = 0; switch (e.Column.FieldName) { case "GiaHeThong2": case "GiaHeThong": case "GiaYeuCau": view.SetRowCellValue(e.RowHandle, view.Columns["CL1"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaYeuCau"]) - (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong"])); view.SetRowCellValue(e.RowHandle, view.Columns["CL5"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) * 10 / 11); view.SetRowCellValue(e.RowHandle, view.Columns["CL2"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram"]) / 100); if ((long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong2"]) > 0) { view.SetRowCellValue(e.RowHandle, view.Columns["CL3"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaYeuCau"]) - (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong2"])); view.SetRowCellValue(e.RowHandle, view.Columns["CL6"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL3"]) * 10 / 11); view.SetRowCellValue(e.RowHandle, view.Columns["CL4"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL3"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram2"]) / 100); } HTV = (int)view.GetRowCellValue(e.RowHandle, view.Columns["HanhTrinhVe"]); a = (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) / (HTV > 0 ? 2 : 1); if (a > 50000) { view.SetRowCellValue(e.RowHandle, view.Columns["PhanTram"], 10); } a = 0; bandedGridView1.BestFitColumns(); break; case "PhanTram2": case "PhanTram": view.SetRowCellValue(e.RowHandle, view.Columns["CL2"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram"]) / 100); if ((long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong2"]) > 0) { view.SetRowCellValue(e.RowHandle, view.Columns["CL4"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL3"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram2"]) / 100); } break; case "CL1": HTV = (int)view.GetRowCellValue(e.RowHandle, view.Columns["HanhTrinhVe"]); a = (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) / (HTV > 0 ? 2 : 1); if (a > 50000) { view.SetRowCellValue(e.RowHandle, view.Columns["PhanTram"], 10); } a = 0; break; } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Task task = gridView1.GetRow(e.RowHandle) as Task; if (e.Column == colComplete && task != null) { task.Complete = !task.Complete; gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); } }
/// <summary> /// 数据改变事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.FieldName.ToUpper() == "AC116") //出生日期 { if (e.Value != null && !(e.Value is DBNull)) { ChineseDateTime cdt = new ChineseDateTime(Convert.ToDateTime(e.Value)); gridView2.SetRowCellValue(e.RowHandle, "AC117", cdt.ToChineseString()); } } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { //if (e.Column.FieldName == "YM")//修改原码 //{ // int DID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("DID")); // CheckOrderISNRule rule = new CheckOrderISNRule(); // CheckOrderISN entity = new CheckOrderISN(); // entity.ID = DID; // entity.SelectByID(); // if (SysConvert.ToDecimal(gridView1.GetFocusedRowCellValue("YM")) != entity.YM) // { // if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增)) // { // this.ShowMessage("你没有此操作权限"); // return; // } // entity.YM = SysConvert.ToDecimal(gridView1.GetFocusedRowCellValue("YM")); // rule.RUpdate(entity); // } //} //if (e.Column.FieldName == "CheckFlag") //{ // if (SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("CheckFlag")) == 1) // { // int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("ID")); // for (int i = 0; i < gridView1.RowCount; i++) // { // if (SysConvert.ToInt32(gridView1.GetRowCellValue(i, "CheckFlag")) == 1) // { // if (ID != SysConvert.ToInt32(gridView1.GetRowCellValue(i, "ID"))) // { // this.ShowMessage("请勾选同一缸号!"); // gridView1.SetFocusedRowCellValue("CheckFlag", 0); // } // } // } // } //} } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 子表单元格值变化进行的操作 /// </summary> private void gridViewSWWList_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { switch (e.Column.FieldName) { case "CodeFileName": string tmpStr = DataTypeConvert.GetString(gridViewSWWList.GetDataRow(e.RowHandle)["CodeFileName"]); if (tmpStr == "") { gridViewSWWList.SetRowCellValue(e.RowHandle, "CodeName", ""); } else { DataTable temp = (DataTable)repSearchCodeFileName.DataSource; DataRow[] drs = temp.Select(string.Format("CodeFileName='{0}'", tmpStr)); if (drs.Length > 0) { gridViewSWWList.SetRowCellValue(e.RowHandle, "CodeName", DataTypeConvert.GetString(drs[0]["CodeName"])); } } break; case "ProjectName": string projectNameStr = DataTypeConvert.GetString(gridViewSWWList.GetDataRow(e.RowHandle)["ProjectName"]); string projectNoStr = ""; if (projectNameStr == "") { gridViewSWWList.SetRowCellValue(e.RowHandle, "ProjectNo", ""); gridViewSWWList.SetRowCellValue(e.RowHandle, "ProjectName", ""); gridViewSWWList.SetRowCellValue(e.RowHandle, "StnNo", ""); } else { DataTable temp = (DataTable)repSearchProjectNo.DataSource; DataRow[] drs = temp.Select(string.Format("ProjectName='{0}'", projectNameStr)); if (drs.Length > 0) { gridViewSWWList.SetRowCellValue(e.RowHandle, "ProjectNo", DataTypeConvert.GetString(drs[0]["ProjectNo"])); projectNoStr = DataTypeConvert.GetString(drs[0]["ProjectNo"]); } gridViewSWWList.SetRowCellValue(e.RowHandle, "StnNo", ""); } BingStnListComboBox(projectNoStr); break; } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--子表单元格值变化进行的操作错误。", ex); } }
private void gvRate_CellValueChanged(object sender, CellValueChangedEventArgs e) { var rate = gvRate.GetRow(gvRate.FocusedRowHandle) as WorkHourStandartDrawing; if (rate != null) { _controller.SaveRate(rate); } }
private void gvTopView_CellValueChanged(object sender, CellValueChangedEventArgs e) { var doc = (StandartDrawing)gvTopView.GetRow(e.RowHandle); if (doc != null) _controller.Save(doc); }