private void gridViewShift_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Name").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Start").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "End").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên ca làm việc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Start").ToString())) { MessageBox.Show("Vui lòng chọn thời gian bắt đầu ca làm việc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "End").ToString())) { MessageBox.Show("Vui lòng chọn thời gian kết thúc ca làm việc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_Shift(); obj.Id = Id; obj.Name = gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Name").ToString(); obj.Start = DateTime.Parse(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Start").ToString()); obj.End = DateTime.Parse(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "End").ToString()); obj.Note = gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Note") != null?gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Note").ToString() : ""; if (obj.Id == 0) { int result = BLLShift.Instance.Insert(connect, obj); if (result == 0) { MessageBox.Show("Tên ca làm việc này đã tồn tại. Xin chọn lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } } else { bool result = BLLShift.Instance.Update(connect, obj); if (result == false) { MessageBox.Show("Tên ca làm việc này đã tồn tại. Xin chọn lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } } GetGridShift(); } } catch (Exception ex) { } End: { } }
private void gridViewAdd_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { gridViewAdd.UpdateCurrentRow(); ShowTotal(); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { //表格数据发生变化 RefreshChart(); }
private void gridViewEquipment_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int n = 0; int.TryParse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Id").ToString(), out Id); bool isNumber = int.TryParse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString(), out n); if (Id == 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Name").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString())) { goto End; } else if (Id == 0 && (string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString()) || gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString() == "0")) { goto End; } else if (Id == 0 && (string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString()) || gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString() == "0")) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên thiết bị.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString())) { MessageBox.Show("Vui lòng nhập mã thiết bị.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && isNumber == false) { MessageBox.Show("Mã thiết bị phải là dạng chữ số. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && n <= 0) { MessageBox.Show("Mã thiết bị phải là dạng chữ số lớn hơn 0. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString()) == 0) { MessageBox.Show("Vui lòng chọn quầy.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString()) == 0) { MessageBox.Show("Vui lòng chọn trạng thái.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_Equipment(); obj.Id = Id; obj.Name = gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Name").ToString(); obj.Code = int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString()); obj.EquipTypeId = equipTypeId; obj.CounterId = int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString()); obj.StatusId = int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString()); obj.Position = gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Position") != null?gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Position").ToString() : ""; //DateTime? et = (DateTime)gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "EndTime"); //obj.EndTime = et != null ? et : null; obj.Note = gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Note") != null?gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Note").ToString() : ""; if (obj.Id == 0) { int result = BLLEquipment.Instance.Insert(connect, obj); if (result == 0) { MessageBox.Show("Tên thiết bị đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } } else { bool result = BLLEquipment.Instance.Update(connect, obj); if (result == false) { MessageBox.Show("Tên thiết bị đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } } GetGridEquipment(); frmMain.lib_Equipments = BLLEquipment.Instance.Gets(connect, (int)eEquipType.Counter); } } catch (Exception ex) { } End: { } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { lblNetCost.Text = String.Format("{0:n2}", TotalSales()); }
private void gridViewService_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int start = 0; int end = 0; bool isNumber1 = int.TryParse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString(), out start); bool isNumber2 = int.TryParse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString(), out end); int.TryParse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Name").ToString())) { goto End; } else if (Id == 0 && (string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString()) || isNumber1 == false || start <= 0)) { goto End; } else if (Id == 0 && (string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString()) || isNumber2 == false || end <= 0 || end < start)) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "TimeProcess").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên dịch vụ.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString())) { MessageBox.Show("Vui lòng nhập số phiếu bắt đầu.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && isNumber1 == false) { MessageBox.Show("Số phiếu bắt đầu phải là chữ số. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && start <= 0) { MessageBox.Show("Số phiếu bắt đầu có giá trị không hợp lệ. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString())) { MessageBox.Show("Vui lòng nhập số phiếu kết thúc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && isNumber2 == false) { MessageBox.Show("Số phiếu kết thúc phải là chữ số. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && (end <= 0 || end < start)) { MessageBox.Show("Số phiếu kết thúc có giá trị không hợp lệ. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "TimeProcess").ToString())) { MessageBox.Show("Vui lòng nhập thời gian xử lý.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_Service(); obj.Id = Id; obj.Name = gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Name").ToString(); obj.StartNumber = int.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString()); obj.EndNumber = int.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString()); obj.TimeProcess = DateTime.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "TimeProcess").ToString()); obj.IsActived = bool.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "IsActived").ToString()); obj.Note = gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Note") != null?gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Note").ToString() : ""; obj.Code = gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Code") != null?gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Code").ToString() : ""; if (obj.Id == 0) { int result = BLLService.Instance.Insert(connect, obj); if (result == 0) { MessageBox.Show("Tên dịch vụ đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } } else { bool result = BLLService.Instance.Update(connect, obj); if (result == false) { MessageBox.Show("Tên dịch vụ đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } } GetGridService(); } } catch (Exception ex) { } End: { } }
private void gridViewModrecordgridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { var modrecordInfo = this.gridViewModrecord.GridView1.GetRow(e.RowHandle) as ModRecordInfo; string idx = string.Empty; this.gridViewModrecord.AddColumnAlias("GUID", "GUID"); this.gridViewModrecord.AddColumnAlias("ModDate", "修改日期"); this.gridViewModrecord.AddColumnAlias("ModVersion", "修改版本"); this.gridViewModrecord.AddColumnAlias("ModOrderId", "修改单号"); this.gridViewModrecord.AddColumnAlias("Proposer", "申请人"); this.gridViewModrecord.AddColumnAlias("Programmer", "修改人"); this.gridViewModrecord.AddColumnAlias("ModContent", "修改内容"); this.gridViewModrecord.AddColumnAlias("ModReason", "修改原因"); this.gridViewModrecord.AddColumnAlias("Remark", "备注"); switch (e.Column.ToString()) { case "GUID": idx = "guid"; break; case "修改日期": idx = "moddate"; break; case "修改版本": idx = "modversion"; break; case "修改单号": idx = "modorderId"; break; case "申请人": idx = "proposer"; break; case "修改人": idx = "programmer"; break; case "修改内容": idx = "modcontent"; break; case "修改原因": idx = "modreason"; break; case "备注": idx = "remark"; break; } if (string.IsNullOrEmpty(idx)) { return; } XmlNodeList xmlNodeLst = xmldicthelper.Read("datatype/histories"); foreach (XmlElement element in xmlNodeLst) { if (string.Equals(element.Attributes["guid"].Value, modrecordInfo.GUID)) { if (string.Equals(e.Column.ColumnType.Name, "DateTime")) { element.Attributes[idx].Value = Convert.ToDateTime(e.Value).ToShortDateString() + " " + DateTimeHelper.GetServerDateTime2().ToLongTimeString(); } else { element.Attributes[idx].Value = e.Value.ToString(); } } } xmldicthelper.Save(false); }
private void GridlerIcin_EditValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { KaydetMedenCikilmasin(true); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { if (e.RowHandle == -1) { return; } if (e.Column.FieldName == "FV") { DataRow dr = this.gridView1.GetDataRow(e.RowHandle); IFieldInfo fi = dr["F"] as IFieldInfo; if (fi != null) { string strobj = e.Value.ToString(); bool bRes = false; switch (fi.FieldType) { case gviFieldType.gviFieldBlob: case gviFieldType.gviFieldGeometry: case gviFieldType.gviFieldUnknown: break; case gviFieldType.gviFieldFloat: float f; bRes = float.TryParse(strobj, out f); if (bRes) { dr["FV"] = strobj; } else { dr["FV"] = null; } break; case gviFieldType.gviFieldDouble: double d; bRes = double.TryParse(strobj, out d); if (bRes) { dr["FV"] = strobj; } else { dr["FV"] = null; } break; case gviFieldType.gviFieldFID: case gviFieldType.gviFieldUUID: case gviFieldType.gviFieldInt16: Int16 i16; bRes = Int16.TryParse(strobj, out i16); if (bRes) { dr["FV"] = strobj; } else { dr["FV"] = null; } break; case gviFieldType.gviFieldInt32: Int32 i32; bRes = Int32.TryParse(strobj, out i32); if (bRes) { dr["FV"] = strobj; } else { dr["FV"] = null; } break; case gviFieldType.gviFieldInt64: Int64 i64; bRes = Int64.TryParse(strobj, out i64); if (bRes) { dr["FV"] = strobj; } else { dr["FV"] = null; } break;; case gviFieldType.gviFieldString: dr["FV"] = strobj; break; case gviFieldType.gviFieldDate: DateTime dt; bRes = DateTime.TryParse(strobj, out dt); if (bRes) { dr["FV"] = strobj; } else { dr["FV"] = null; } break; default: break; } this.gridView1.RefreshRow(e.RowHandle); } } } catch (Exception ex) { } }
private void gridViewCounter_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { try { int Id = 0; int.TryParse(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Id").ToString(), out Id); if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString())) { goto End; } else if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString())) { goto End; } if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString())) { MessageBox.Show("Vui lòng nhập tên quầy.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString())) { MessageBox.Show("Vui lòng nhập tên rút gọn.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString())) { MessageBox.Show("Vui lòng nhập số thứ tự.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var obj = new Q_Counter(); obj.Id = Id; obj.ShortName = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString(); obj.Name = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString(); obj.Index = int.Parse(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString()); obj.Position = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Position") != null?gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Position").ToString() : ""; obj.Acreage = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Acreage") != null?gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Acreage").ToString() : ""; int kq = 0; if (obj.Id == 0) { kq = BLLCounter.Instance.Insert(connect, obj); } else { kq = BLLCounter.Instance.Update(connect, obj); } if (kq == 0) { MessageBox.Show("Tên quầy đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } else { GetGridCounter(); } } } catch (Exception ex) { } End : { } }
private void grvGioGiang_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { drGioGiang = grvGioGiang.GetDataRow(grvGioGiang.FocusedRowHandle); TinhGioChuan(drGioGiang); }
void ViewFieldConfig_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { isNeedSave = true; }
void gvDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { GridView gv = sender as GridView; if (e.Column.FieldName.ToUpper().Equals("MAVT")) { //khach hang TextEdit txtKh = data.FrmMain.Controls.Find("MaKH", true)[0] as TextEdit; //vat tu string vt = gv.GetFocusedRowCellValue(e.Column).ToString(); //ngayCT DateEdit dtp = data.FrmMain.Controls.Find("ngayCT", true)[0] as DateEdit; string sql = "select * from ChinhSachGia CSG INNER JOIN GiaVT VT on VT.CSGID=CSG.CSGID " + "LEFT JOIN GiaKH KH on KH.CSGID=CSG.CSGID WHERE VT.MaVT='" + vt + "'"; DataTable dt = db.GetDataTable(sql); DataView dvGiaVT = new DataView(dt); DataView dvKH; string nhomkh = ""; sql = "select Nhom1 from dmkh where makh ='" + txtKh.Text + "'"; DataTable dtNhom = db.GetDataTable(sql); if (dtNhom.Rows.Count > 0) { nhomkh = dtNhom.Rows[0]["Nhom1"].ToString(); } dvGiaVT.RowFilter = "TuNgay is null and DenNgay is null"; //nhóm có, mã có //nhóm không, mã có //nhóm có, mã không //nhóm không , mã không if (dvGiaVT.Count > 0) { dvKH = new DataView(dvGiaVT.ToTable()); dvKH.RowFilter = "MaKH is null and NhomKH is null"; if (dvKH.Count == 0) { if (nhomkh != "") { dvKH.RowFilter = "MaKH is null and NhomKH = '" + nhomkh + "'"; } } if (dvKH.Count == 0) { dvKH.RowFilter = "MaKH='" + txtKh.Text + "'"; } if (dvKH.Count == 0)//kt trường hợp vattu có chính sách giá trong khoảng thời gian hay ko? { dvGiaVT.RowFilter = "TuNgay <= '" + dtp.DateTime + "' and DenNgay >= '" + dtp.DateTime + "'"; dvKH = new DataView(dvGiaVT.ToTable()); dvKH.RowFilter = "MaKH is null and NhomKH is null"; if (dvKH.Count == 0) { if (nhomkh != "") { dvKH.RowFilter = "MaKH is null and NhomKH = '" + nhomkh + "'"; } } if (dvKH.Count == 0) { dvKH.RowFilter = "MaKH='" + txtKh.Text + "'"; } } } else { dvGiaVT.RowFilter = "TuNgay <= '" + dtp.DateTime + "' and DenNgay >= '" + dtp.DateTime + "'"; dvKH = new DataView(dvGiaVT.ToTable()); dvKH.RowFilter = "MaKH is null and NhomKH is null"; if (dvKH.Count == 0) { if (nhomkh != "") { dvKH.RowFilter = "MaKH is null and NhomKH = '" + nhomkh + "'"; } } if (dvKH.Count == 0) { dvKH.RowFilter = "MaKH='" + txtKh.Text + "'"; } } setPrice(dvKH, gv); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Kaydet_Vazgec_Sil_Enable(true); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { //this.dgrex_Dm_Loai_Hopdong.EmbeddedNavigator.Buttons.EndEdit.DoClick(); this.DoClickEndEdit(dgrex_Dm_Loai_Hopdong); }
private void _gdMAIN_VIEW_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { _gdMAIN_VIEW.CellValueChanged -= _gdMAIN_VIEW_CellValueChanged; ChangeValues(sender, e); _gdMAIN_VIEW.CellValueChanged += _gdMAIN_VIEW_CellValueChanged; }
private void gVCambio_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Caulcular(); }
private void grvDynamic_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DirtyData = true; }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { }
private void gridViewAddVehicle_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == colAddVehicleId || e.Column == colAddVehicleWorkerUnitPrice) { return; } TenderMaterialListEquipmentModel currentItem = new TenderMaterialListEquipmentModel(); int currentId = Convert.ToInt32(gridViewAddVehicle.GetFocusedRowCellValue("Id")); if (currentId <= 0) { //if (e.Value == null) //{ // return; //} currentItem = new TenderMaterialListEquipmentModel(); TenderEquipment equipment = new TenderEquipment(); equipment.IsWorker = false; equipment.TenderId = UICurrentManager.Instance.CurrentTender.Id; if (e.Column == colAddVehicleVehicle) { //System.Data.DataRow row = gridViewAddVehicle.GetDataRow(gridViewAddVehicle.FocusedRowHandle); //string cellValue = row[0].ToString(); //object a = gridViewAddVehicle.GetSelectedRow("SelectedVehicle"); object b = gridViewAddVehicle.ActiveEditor.EditValue; equipment.WorkerVehicleId = (int)b; } OperationResult result = TenderEquipmentProvider.Instance.Save(equipment); if (result.Success) { TenderMaterialListEquipment tenderMaterialListEquipment = new TenderMaterialListEquipment(); tenderMaterialListEquipment.EquipmentId = equipment.Id; tenderMaterialListEquipment.MaterialListId = this.SelectedMaterial.Id.Value; tenderMaterialListEquipment.TenderId = UICurrentManager.Instance.CurrentTender.Id; tenderMaterialListEquipment.Equipment = equipment; OperationResult result1 = TenderMaterialListEquipmentProvider.Instance.Save(tenderMaterialListEquipment); if (result1.Success) { currentItem = new TenderMaterialListEquipmentModel(tenderMaterialListEquipment); currentItem.Equipment = equipment; gridViewAddVehicle.SetFocusedRowCellValue(colAddVehicleId, currentItem.Id); LoadWorkerMateriallistGrid(); return; } } } else { List <TenderMaterialListEquipmentModel> items = ((IEnumerable <TenderMaterialListEquipmentModel>)bindingSourceAddVehicle.DataSource).ToList(); foreach (TenderMaterialListEquipmentModel item in items) { if (item.Id == currentId) { currentItem = item; break; } } } if (e.Column == colAddVehicleQuantity) { currentItem.Quantity = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <double>(e.Value); } else if (e.Column == colAddVehicleUnitTime) { currentItem.UnitTime = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <int>(e.Value); } else if (e.Column == colAddVehicleUnitTimeType) { currentItem.UnitTimeType = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <UnitTimeTypesEnum>(e.Value); } else if (e.Column == colAddVehicleVehicle) { currentItem.Equipment.WorkerVehicleId = (int)e.Value; TenderEquipmentProvider.Instance.Save(currentItem.Equipment); currentItem.Equipment = null; } currentItem.Save(); grdAddVehicle.Refresh(); }
private void gridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.FieldName == "SOLUONG") { } }
private void gvHoliday_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { }
private void GridViewCellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { treeList.Refresh(); }
public void grdGrid_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { #region Barcode if (e.Column.ToString() == "Barkod") { string barcode = e.Value.ToString(); string oldBarcode, state = ""; int miktar = 0; db.AddParameterValue("@barcode", barcode); DataTable dtSearch = db.GetDataTable(@"SELECT stStockCard.Ref, stStockCard.code AS [Kart Kodu], stStockCard.name AS [Kart Adı], StStockCardBarcodes.size AS Beden, StStockCardBarcodes.color AS Renk, StStockCardBarcodes.barcode AS Barcode, StStockCardUnits.unitRef as [Birim Ref], StStockCardUnits.unitCode as [Birim Kodu] FROM stStockCard LEFT JOIN StStockCardBarcodes ON stStockCard.Ref = StStockCardBarcodes.cardRef LEFT JOIN StStockCardUnits ON stStockCard.Ref = StStockCardUnits.Ref WHERE (stStockCard.active = 1) and barcode = @barcode"); if (dtSearch.Rows.Count > 0) { if (grdGrid.RowCount - 1 > 0) { for (int i = 0; i < grdGrid.RowCount - 1; i++) { oldBarcode = grdGrid.GetRowCellValue(i, "Barkod").ToString(); if (barcode == oldBarcode) { grdGrid.DeleteRow(grdGrid.FocusedRowHandle); miktar = int.Parse(grdGrid.GetRowCellValue(i, "Miktar").ToString()); miktar++; grdGrid.SetRowCellValue(i, "Miktar", miktar); state = "true"; break; } else { state = "false"; } } if (state == "false") { DataRow row = dtBox.NewRow(); row["Kart Ref"] = int.Parse(dtSearch.Rows[0]["Ref"].ToString()); row["Kart Kodu"] = dtSearch.Rows[0]["Kart Kodu"].ToString(); row["Kart Adı"] = dtSearch.Rows[0]["Kart Adı"].ToString(); row["Renk"] = dtSearch.Rows[0]["Renk"].ToString(); row["Beden"] = dtSearch.Rows[0]["Beden"].ToString(); row["Barkod"] = barcode; row["Birim Kodu"] = "Adet"; row["Miktar"] = 1; db.AddParameterValue("@barcode", barcode); db.AddParameterValue("@branchRef", ledBranch.GetValue()); string price = db.GetScalarValue("select dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString(); row["Birim Fiyat"] = price; decimal total = decimal.Parse(row["Miktar"].ToString()) * decimal.Parse(price); row["Toplam Tutar"] = total; grdGrid.DeleteRow(grdGrid.FocusedRowHandle); dtBox.Rows.Add(row); grdGrid.RefreshData(); } } else { grdGrid.DeleteRow(grdGrid.FocusedRowHandle); DataRow row = dtBox.NewRow(); row["Kart Ref"] = int.Parse(dtSearch.Rows[0]["Ref"].ToString()); row["Kart Kodu"] = dtSearch.Rows[0]["Kart Kodu"].ToString(); row["Kart Adı"] = dtSearch.Rows[0]["Kart Adı"].ToString(); row["Renk"] = dtSearch.Rows[0]["Renk"].ToString(); row["Beden"] = dtSearch.Rows[0]["Beden"].ToString(); row["Barkod"] = barcode; row["Birim Kodu"] = "Adet"; row["Miktar"] = 1; db.AddParameterValue("@barcode", barcode); db.AddParameterValue("@branchRef", ledBranch.GetValue()); string price = db.GetScalarValue("select dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString(); row["Birim Fiyat"] = price; decimal total = decimal.Parse(row["Miktar"].ToString()) * decimal.Parse(price); row["Toplam Tutar"] = total; dtBox.Rows.Add(row); grdGrid.RefreshData(); } } else { grdGrid.DeleteRow(grdGrid.FocusedRowHandle); } } #endregion if (e.Column.ToString() == "Miktar" || e.Column.ToString() == "Birim Fiyat") { Calculate(); } }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { ischange = true; gridView1.SelectRow(e.RowHandle); }
private void gridViewLancsBaixa_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { refreshTotal(); }
private void gridStokHareket_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Toplamlar(); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { _haveChange = true; RaiseDataChanged(); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { this.dgware_Dm_Nhom_Hanghoa_Ban.EmbeddedNavigator.Buttons.DoClick(dgware_Dm_Nhom_Hanghoa_Ban.EmbeddedNavigator.Buttons.EndEdit); }
private void GridViewSampleNotes_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { gridViewSampleNotes.PostEditor(); gridViewSampleNotes.UpdateCurrentRow(); }