private void gridView1_CellMerge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e) { if (e.Column.FieldName == "ParameterName" || e.Column.FieldName == "Point" || e.Column.FieldName == "DelInfBtnStr") { e.Merge = false; e.Handled = true; } else { if (e.Column.FieldName == "ExpresstionText") { //ExpressionId DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView; string expressionId1 = view.GetRowCellValue(e.RowHandle1, view.Columns["ExpressionId"]).ToString(); string expressionId2 = view.GetRowCellValue(e.RowHandle2, view.Columns["ExpressionId"]).ToString(); e.Merge = expressionId1 == expressionId2; e.Handled = true; } else { e.Merge = true; e.Handled = false; } } }
private void grdUser_DoubleClick(object sender, System.EventArgs e) { int row; int intUser = 0; int intContact = 0; row = gvwUser.FocusedRowHandle; if (gvwUser.FocusedRowHandle < 0) { Scheduler.BusinessLayer.Message.MsgInformation("No record exists."); return; } intUser = Convert.ToInt32(gvwUser.GetRowCellValue(gvwUser.FocusedRowHandle, gcolUserID)); intContact = Convert.ToInt32(gvwUser.GetRowCellValue(gvwUser.FocusedRowHandle, gcolContactID)); frmUserDlg fUserDlg = new frmUserDlg(); fUserDlg.UserID = intUser; fUserDlg.ContactID = intContact; fUserDlg.Mode = "Edit"; fUserDlg.LoadData(); if (fUserDlg.ShowDialog() == DialogResult.OK) { LoadUser(); } fUserDlg.Close(); fUserDlg.Dispose(); fUserDlg = null; gvwUser.FocusedRowHandle = row; }
public static List <structColumn> GetListColumnsVisible(DevExpress.XtraGrid.Views.Grid.GridView _GridView) { List <structColumn> ListColumns = new List <structColumn>(); try { if (_GridView != null) { for (int i = 0; i < _GridView.Columns.Count; i++) { if (_GridView.Columns[i].Visible && _GridView.Columns[i].GroupIndex < 0) { structColumn _structColumn = new structColumn(); _structColumn.Caption = _GridView.Columns[i].Caption; _structColumn.FieldName = _GridView.Columns[i].Name + "_" + _GridView.Columns[i].FieldName; _structColumn.VisibleIndex = _GridView.Columns[i].VisibleIndex; _structColumn.IsNumber = false; if (!Object.Equals(_GridView.GetRowCellValue(0, _GridView.Columns[i]), null)) { if (SHARED.Libraries.StringHelper.IsNumber(_GridView.GetRowCellValue(0, _GridView.Columns[i]).ToString())) { _structColumn.IsNumber = true; } } ListColumns.Add(_structColumn); } } ListColumns = ListColumns.OrderBy(item => item.VisibleIndex).ToList(); } } catch { } return(ListColumns); }
private void DoRowDoubleClick(DevExpress.XtraGrid.Views.Grid.GridView view, Point pt) { try { DevExpress.XtraGrid.Views.Grid.ViewInfo.GridHitInfo info = view.CalcHitInfo(pt); if (info.InRow || info.InRowCell) { if (info.Column == null) { } else { if (view.GetRowCellValue(info.RowHandle, "ID") == DBNull.Value) { return; } string sheet = view.GetRowCellValue(info.RowHandle, "ID").ToString(); GetDetils(sheet); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void grdProgram_DoubleClick(object sender, System.EventArgs e) { int row = 0; int intProg = 0; row = gvwProgram.FocusedRowHandle; if (gvwProgram.FocusedRowHandle < 0) { Scheduler.BusinessLayer.Message.MsgInformation("No record exists."); return; } intProg = Convert.ToInt32(gvwProgram.GetRowCellValue(gvwProgram.FocusedRowHandle, gcolProgID)); frmProgramDlg fProgDlg = new frmProgramDlg(); fProgDlg.ProgramID = intProg; fProgDlg.Mode = "Edit"; fProgDlg.LoadData(); if (fProgDlg.ShowDialog() == DialogResult.OK) { LoadProgram(); } fProgDlg.Close(); fProgDlg.Dispose(); fProgDlg = null; gvwProgram.FocusedRowHandle = row; }
private void gridView1_Click(object sender, EventArgs e) { DevExpress.XtraGrid.Views.Grid.GridView gv = sender as DevExpress.XtraGrid.Views.Grid.GridView; int rowhandle = gv.FocusedRowHandle; DevExpress.XtraGrid.Columns.GridColumn col = gv.FocusedColumn; if (col.Caption == "诊室") { ClincId = ""; ClincName = ""; DoctorSrtting obj = gv.GetRow(rowhandle) as DoctorSrtting; if (obj == null) { return; } bool OneFirst = false; if (DeptName != obj.deptName) { DeptName = obj.deptName; GetClinicList(AppContext.Session.hospitalId, obj.deptId); } DoctorsOfficeSettingFrm dosf = new DoctorsOfficeSettingFrm(obj, OneFirst); dosf.ShowDialog(); if (ClincId == "") { if (obj.clinicId == null || obj.clinicId == "") { gv.SetRowCellValue(rowhandle, gv.Columns["clinicId"], ClincId); } } else { gv.SetRowCellValue(rowhandle, gv.Columns["clinicId"], ClincId); } if (ClincName == "") { if (obj.clinicName == null || obj.clinicName == "") { gv.SetRowCellValue(rowhandle, gv.Columns["clinicName"], ClincName); } } else { gv.SetRowCellValue(rowhandle, gv.Columns["clinicName"], ClincName); listhelpers = new List <SoltHelper>(); for (int i = 0; i < this.gridView1.RowCount; i++) { if (gv.GetRowCellValue(i, gv.Columns["clinicId"]).ToString() != "" && gv.GetRowCellValue(i, gv.Columns["clinicName"]).ToString() != "") { SoltHelper sh = new SoltHelper(); sh.ClincNames = gv.GetRowCellValue(i, gv.Columns["clinicName"]).ToString(); sh.Prioxs = gv.GetRowCellValue(i, gv.Columns["period"]).ToString(); sh.Times = gv.GetRowCellValue(i, gv.Columns["workDate"]).ToString(); sh.depetIds = gv.GetRowCellValue(i, gv.Columns["deptId"]).ToString(); listhelpers.Add(sh); } } } } }
/// <summary> /// /// </summary> private void InitializeApplyList(DevExpress.XtraGrid.Views.Grid.GridView dbGridView) { try { m_listObject.Clear(); int[] rows = dbGridView.GetSelectedRows(); for (int i = 0; i < rows.Length; i++) { CApplyObject m_applyObject = new CApplyObject(); m_applyObject.Clear(); m_applyObject.m_sNoOfInpat = dbGridView.GetRowCellValue(rows[i], "NOOFINPAT").ToString(); m_applyObject.m_sName = dbGridView.GetRowCellValue(rows[i], "NAME").ToString(); m_applyObject.m_sDepartmentName = dbGridView.GetRowCellValue(rows[i], "CYKS").ToString(); m_applyObject.m_iApplyTimes = int.Parse(dbGridView.GetRowCellValue(rows[i], "APPLYTIMES").ToString()); m_applyObject.m_sApplyContent = dbGridView.GetRowCellValue(rows[i], "APPLYCONTENT").ToString(); m_applyObject.m_sApply = dbGridView.GetRowCellValue(rows[i], "ID").ToString(); m_applyObject.m_sApplyDocId = this.m_sUser; m_applyObject.m_sApproveContent = dbGridView.GetRowCellValue(rows[i], "APPROVECONTENT").ToString(); m_applyObject.m_sApproveDate = dbGridView.GetRowCellValue(rows[i], "APPROVEDATE").ToString(); m_applyObject.m_sApproveDocId = dbGridView.GetRowCellValue(rows[i], "APPROVEDOCID").ToString(); m_applyObject.m_sPatid = dbGridView.GetRowCellValue(rows[i], "PATID").ToString(); m_listObject.Add(m_applyObject); } } catch (Exception) { throw; } }
/// <summary> /// 显示病历信息方法 /// </summary> private void ShowEmrMessage() { try { foreach (RecordModel re in listAll) { if (re.Index == this.tabControl.SelectedTabPageIndex) { MedicalRecordBrowse mf = re.MyControl; DevExpress.XtraGrid.Views.Grid.GridView dbGridView = mf.dbGridView; if (dbGridView.RowCount > 0) { int[] list = dbGridView.GetSelectedRows(); if (list.Length > 0) { string status = dbGridView.GetRowCellValue(list[0], "STATUS").ToString(); //调用病历查看窗口,进行病历的查询 if (status.Equals("2")) { string noofinpat = dbGridView.GetRowCellValue(list[0], "NOOFINPAT").ToString(); LoadEmrContent(noofinpat); } } } break; } } } catch (Exception ex) { throw ex; } }
private void SpeedSearch() { int iRowPos = gvwDept.FocusedRowHandle; string strGridValue = ""; foreach (DevExpress.XtraGrid.Columns.GridColumn col in gvwDept.Columns) { if (col.SortIndex >= 0) { for (int intCtr = 0; intCtr < gvwDept.RowCount; intCtr++) { if (col.VisibleIndex > -1) { if (gvwDept.GetRowCellValue(intCtr, col) != System.DBNull.Value) { strGridValue = gvwDept.GetRowCellValue(intCtr, col).ToString(); if (strGridValue.ToUpper().Trim().StartsWith(txt_SpeedSearch.Text.Trim().ToUpper())) { gvwDept.FocusedRowHandle = intCtr; break; } } } } } } }
/// <summary> /// 显示病历信息方法 /// </summary> private void ShowEmrMessage() { try { foreach (RecordWriteUpModel re in listAll) { if (re.Index == this.tabControl.SelectedTabPageIndex) { MedicalRecordWriteUp mf = re.MyControl; DevExpress.XtraGrid.Views.Grid.GridView dbGridView = mf.dbGridView; if (dbGridView.RowCount > 0) { int[] list = dbGridView.GetSelectedRows(); if (list.Length > 0) { string status = dbGridView.GetRowCellValue(list[0], "STATUS").ToString(); //调用病历查看窗口,进行病历的查询 if (status.Equals("2")) { string noofinpat = dbGridView.GetRowCellValue(list[0], "NOOFINPAT").ToString(); // LoadEmrContent(noofinpat); decimal syxh = decimal.Parse(noofinpat); if (syxh < 0) { return; } if (syxh < 0) { return; } if (HasBaby(noofinpat)) { ChoosePatOrBaby choosepat = new ChoosePatOrBaby(SqlUtil.App, noofinpat); choosepat.StartPosition = FormStartPosition.CenterParent; if (choosepat.ShowDialog() == System.Windows.Forms.DialogResult.OK) { SqlUtil.App.ChoosePatient(decimal.Parse(choosepat.NOOfINPAT)); SqlUtil.App.LoadPlugIn("DrectSoft.Core.MainEmrPad.dll", DS_BaseService.GetUCEmrInputPath()); } } else { SqlUtil.App.ChoosePatient(syxh); SqlUtil.App.LoadPlugIn("DrectSoft.Core.MainEmrPad.dll", DS_BaseService.GetUCEmrInputPath()); } } } } break; } } } catch (Exception ex) { throw ex; } }
private void simpleButton1_Click(object sender, System.EventArgs e) { bool isSave = false; bool isError = false; DevExpress.XtraGrid.Columns.GridColumn col1 = gridView1.Columns.ColumnByFieldName("strItemCode"); DevExpress.XtraGrid.Columns.GridColumn col2 = gridView1.Columns.ColumnByFieldName("strPromotionCode"); DevExpress.XtraGrid.Columns.GridColumn col3 = gridView1.Columns.ColumnByFieldName("OutStock"); SqlConnection sqlcon = new SqlConnection(SqlHelperUtils.connectionString); sqlcon.Open(); SqlTransaction tran = sqlcon.BeginTransaction(); ACMSLogic.Promotion.Promotion promotion = new ACMSLogic.Promotion.Promotion(); //promotion.DeleteAdjustmentPromotion(tran,this.textEdit2.Text,this.textEdit1.Text); for (int i = 0; i < this.gridView1.DataRowCount; i++) { object cellValue1 = gridView1.GetRowCellValue(i, col1); object cellValue3 = gridView1.GetRowCellValue(i, col3); if (cellValue3 != null) { if (Convert.ToBoolean(cellValue3.ToString())) { if (promotion.UpdateAdjustmentPromotion(tran, this.textEdit2.Text, cellValue1.ToString(), this.textEdit1.Text, strBranchCode, Convert.ToInt32(nEntryID), panel)) { isSave = true; } else { isError = false; } } } } if (isError) { Utils.UI.ShowMessage(this, "Some of the record cannot be saved into database. Please contact System Administrator!"); } else { if (isSave) { Utils.UI.ShowMessage(this, "Record Has Been Updated"); } tran.Commit(); } this.DialogResult = DialogResult.OK; this.Close(); }
public static DataSet FillDatasetFromGrid(DevExpress.XtraGrid.Views.Grid.GridView _GridView) { DataSet _DataSet = new DataSet(); DataTable _DataTable = new DataTable(); if (!Object.Equals(_GridView, null)) { foreach (GridColumn _GridColumn in _GridView.Columns) { _DataTable.Columns.Add(_GridColumn.Name + "_" + _GridColumn.FieldName, Nullable.GetUnderlyingType(_GridColumn.ColumnType) ?? _GridColumn.ColumnType); if (!(_GridColumn.Visible && _GridColumn.GroupIndex < 0)) { if (Object.Equals(_GridColumn.ColumnType, typeof(Int32)) || Object.Equals(_GridColumn.ColumnType, typeof(float)) || Object.Equals(_GridColumn.ColumnType, typeof(DateTime))) { _DataTable.Columns.Add(_GridColumn.Name + "_" + _GridColumn.FieldName + "_STRING", typeof(String)); } } } for (int i = 0; i < _GridView.DataRowCount; i++) { DataRow _DataRow = _DataTable.NewRow(); foreach (GridColumn _GridColumn in _GridView.Columns) { var Value = _GridView.GetRowCellValue(i, _GridColumn); if (Object.Equals(Value, null)) { _DataRow[_GridColumn.Name + "_" + _GridColumn.FieldName] = DBNull.Value; } else { _DataRow[_GridColumn.Name + "_" + _GridColumn.FieldName] = _GridView.GetRowCellValue(i, _GridColumn); } if (!(_GridColumn.Visible && _GridColumn.GroupIndex < 0)) { if (Object.Equals(_GridColumn.ColumnType, typeof(Int32)) || Object.Equals(_GridColumn.ColumnType, typeof(float)) || Object.Equals(_GridColumn.ColumnType, typeof(DateTime))) { var Value_String = _GridView.GetRowCellValue(i, _GridColumn); if (Object.Equals(Value_String, null)) { _DataRow[_GridColumn.Name + "_" + _GridColumn.FieldName + "_STRING"] = ""; } else { _DataRow[_GridColumn.Name + "_" + _GridColumn.FieldName + "_STRING"] = _GridView.GetRowCellValue(i, _GridColumn); } } } } _DataTable.Rows.Add(_DataRow); } } _DataSet.Tables.Add(_DataTable); return(_DataSet); }
private void GridViewLocker_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.Name == "dtExpiry") { GridViewLocker.RefreshRow(e.RowHandle); CurrentLockerRowFocus = GridViewLocker.FocusedRowHandle; if (this.GridViewLocker.RowCount > 0) { if (employee.HasRight("AB_CHANGE_LOCKER_EXPIRYDATE")) { int output; output = 0; SqlHelper.ExecuteNonQuery(connection, "Up_TblLockerExpiryDate", new SqlParameter("@retval", output), new SqlParameter("@dtExpiry", GridViewLocker.GetRowCellValue(e.RowHandle, "dtExpiry").ToString()), new SqlParameter("@strRemarks", GridViewLocker.GetRowCellValue(e.RowHandle, "strRemarks").ToString()), new SqlParameter("@LockerNo", GridViewLocker.GetRowCellValue(e.RowHandle, "nLockerNo").ToString()), new SqlParameter("@BranchCode", oUser.StrBranchCode()), new SqlParameter("@strMembershipID", GridViewLocker.GetRowCellValue(e.RowHandle, "strMembershipID").ToString()), new SqlParameter("@nEmployeeID", oUser.NEmployeeID()) ); } else { UI.ShowErrorMessage(this, "You don't have right to change locker expiry date.", "Error"); } LockerRowFocus = this.GridViewLocker.FocusedRowHandle; this.GridViewLocker.FocusedRowHandle = CurrentLockerRowFocus; } } if (e.Column.Name == "strRemarks") { CurrentLockerRowFocus = GridViewLocker.FocusedRowHandle; if (this.GridViewLocker.RowCount > 0) { int output; output = 0; SqlHelper.ExecuteNonQuery(connection, "Up_TblLockerRemark", new SqlParameter("@retval", output), new SqlParameter("@strRemarks", GridViewLocker.GetRowCellValue(e.RowHandle, "strRemarks").ToString()), new SqlParameter("@LockerNo", GridViewLocker.GetRowCellValue(e.RowHandle, "nLockerNo").ToString()), new SqlParameter("@BranchCode", oUser.StrBranchCode()) ); LockerRowFocus = this.GridViewLocker.FocusedRowHandle; this.GridViewLocker.FocusedRowHandle = CurrentLockerRowFocus; } } }
private void gridViewMd_ItemPromotion_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.FieldName == "nCategoryTypeID") { BindCode(e.Value.ToString(), gridViewMd_ItemPromotion.GetRowCellValue(e.RowHandle, gridViewMd_ItemPromotion.Columns[2]).ToString()); } else if (e.Column.FieldName == "nGroupID") { BindCode(gridViewMd_ItemPromotion.GetRowCellValue(e.RowHandle, gridViewMd_ItemPromotion.Columns["nCategoryTypeID"]).ToString(), e.Value.ToString()); } }
public void GridViewCheck(DevExpress.XtraGrid.Views.Grid.GridView gridView, string p, int id) { if (p == "user") { List <Users> listRelated = new List <Users>(); listRelated = WcfServiceLocator.Create <IUsersManage>().FindRelatedUsersForUserGroup(id); //找出和指定用户组关联的用户 for (int i = 0; i < gridView.RowCount; i++) { var check = listRelated.Exists(delegate(Users user) { if (user.id == (int)gridView.GetRowCellValue(i, "id")) { return(true); } return(false); }); gridView.SetRowCellValue(i, "isChecked", check); } } if (p == "role") { List <Users> listRelated = new List <Users>(); listRelated = WcfServiceLocator.Create <IRoleManage>().findRelatedUser(id); //找出和指定角色关联的用户 for (int i = 0; i < gridView.RowCount; i++) { var check = listRelated.Exists(delegate(Users user) { if (user.id == (int)gridView.GetRowCellValue(i, "id")) { return(true); } return(false); }); gridView.SetRowCellValue(i, "isChecked", check); } } if (p == "rolewithgroup") { List <Group> listRelated = new List <Group>(); listRelated = WcfServiceLocator.Create <IRoleManage>().findRelatedGroup(id); //找出和指定角色关联的用户 for (int i = 0; i < gridView.RowCount; i++) { var check = listRelated.Exists(delegate(Group group) { if (group.Id == (int)gridView.GetRowCellValue(i, "Id")) { return(true); } return(false); }); gridView.SetRowCellValue(i, "isChecked", check); } } }
public void Xuat(DevExpress.XtraGrid.Views.Grid.GridView gridView3) { string filename = ""; using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "Excel Workbook|*.xls" }) { if (sfd.ShowDialog() == DialogResult.OK) { filename = sfd.FileName; } } Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; //xlApp = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); string data = ""; for (int i = 0; i <= gridView3.RowCount - 1; i++) { for (int j = 1; j <= gridView3.Columns.Count; j++) { if (j != 4) { data = gridView3.GetRowCellValue(i, "F" + j.ToString()).ToString(); } else { data = gridView3.GetRowCellValue(i, "BẢNG PHÂN CÔNG GIẢNG DẠY").ToString(); } xlWorkSheet.Cells[i + 1, j] = data; } } xlWorkBook.SaveAs(filename, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); MessageBox.Show(filename); }
public void tsbtdeletebranch(DevExpress.XtraGrid.Views.Grid.GridView view, Form1 F) { try { string name = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(); if (MessageBox.Show("Bạn có chắc muốn xóa đơn vị " + view.GetRowCellValue(view.FocusedRowHandle, "Mã đơn vị").ToString() + "?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { gen.ExcuteNonquery("delete from Branch where BranchID='" + name + "'"); view.DeleteRow(view.FocusedRowHandle); } } catch { MessageBox.Show("Vui lòng chọn đơn vị trước khi xóa."); } }
public static void fGrid현재값검색(DevExpress.XtraGrid.Views.Grid.GridView gridView1) { try { String fiName = Convert.ToString(gridView1.FocusedColumn.FieldName); String fiText = Convert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[fiName])); gridView1.Columns[fiName].FilterInfo = new ColumnFilterInfo(null, gridView1.GetRowCellValue(gridView1.FocusedRowHandle, fiName), fiText); } catch (Exception ex) { MessageBox.Show("그룹으로 묶인필드는 검색할 수 없습니다. → " + ex.Message); } }
//xóa user khỏi hệ thống public void tstbdeleteuser(DevExpress.XtraGrid.Views.Grid.GridView view, Form1 F) { try { string name = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(); if (MessageBox.Show("Bạn có chắc muốn xóa " + view.GetRowCellValue(view.FocusedRowHandle, "Họ và tên").ToString() + "?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { gen.ExcuteNonquery("delete from MSC_User where UserID='" + name + "'"); gen.ExcuteNonquery("delete from MSC_UserJoinRole where UserID='" + name + "'"); view.DeleteRow(view.FocusedRowHandle); } } catch { MessageBox.Show("Vui lòng chọn user trước khi xóa."); } }
public void tsbtdeletenhanvien(DevExpress.XtraGrid.Views.Grid.GridView view, Form1 F) { try { string name = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(); if (MessageBox.Show("Bạn có chắc muốn xóa nhân viên " + view.GetRowCellValue(view.FocusedRowHandle, "Mã nhân viên").ToString() + "?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { gen.ExcuteNonquery("delete from AccountingObject where AccountingObjectID='" + name + "'"); //F.refreshnhanvien(); view.DeleteRow(view.FocusedRowHandle); } } catch { MessageBox.Show("Vui lòng chọn nhân viên trước khi xóa."); } }
public void FiyatYukselt() { MiktarGirisi.textEdit1.EditValue = 0; MiktarGirisi.labelControl1.Text = "Yazılan Yüzde kadar Fiyatı Yükseltir."; if (DialogResult.Yes == MiktarGirisi.ShowDialog()) { for (int i = 0; i < _gvFaturaHareket.RowCount; i++) { decimal EskiFiyat = (decimal)_gvFaturaHareket.GetRowCellValue(i, "AnaBirimFiyat"); decimal YeniFiyat = EskiFiyat + (EskiFiyat * Convert.ToDecimal(MiktarGirisi.textEdit1.EditValue) / 100); _gvFaturaHareket.SetRowCellValue(i, "AnaBirimFiyat", YeniFiyat); } } }
private void updateWarehouse() { GridView gridView = grcWarehouse.FocusedView as GridView; // WarehouseDTO warehouse = new WarehouseDTO(); warehouse.iMaKho = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iMaKho"); warehouse.iTenKho = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iTenKho"); warehouse.iLienHe = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iGhiChu"); warehouse.iDiaChi = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDiaChi"); warehouse.iDienThoai = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDienThoai"); warehouse.iKyHieu = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iKyHieu"); warehouse.iGhiChu = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iGhiChu"); warehouse.iActive = (bool)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iActive"); frmUpdateWarehouse fUpdateWarehouse = new frmUpdateWarehouse(warehouse); fUpdateWarehouse.ShowDialog(); if (statusAction == 1) { loadWarehouse(); statusAction = 0; } else { } }
public void tsbtdeleteprovince(DevExpress.XtraGrid.Views.Grid.GridView view, Form1 F) { try { string name = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(); if (MessageBox.Show("Bạn có chắc muốn xóa Tỉnh/Thành " + view.GetRowCellValue(view.FocusedRowHandle, "Mã Tỉnh/Thành").ToString() + "?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { gen.ExcuteNonquery("delete from Province where ProvinceID='" + name + "'"); gen.ExcuteNonquery("delete from Distrist where ProvinceID='" + name + "'"); //F.refreshprovince(); view.DeleteRow(view.FocusedRowHandle); } } catch { MessageBox.Show("Vui lòng chọn Tỉnh/Thành trước khi xóa."); } }
//chức năng xóa public void tstbdelete(DevExpress.XtraGrid.Views.Grid.GridView view, Form1 F) { try { string name = view.GetRowCellValue(view.FocusedRowHandle, "ID").ToString(); if (MessageBox.Show("Bạn có chắc muốn xóa " + view.GetRowCellValue(view.FocusedRowHandle, "Mã vai trò").ToString() + "?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { gen.ExcuteNonquery("delete from MSC_Role where RoleID='" + name + "'"); gen.ExcuteNonquery("delete from MSC_RolePermissionMaping where RoleID='" + name + "'"); //F.refreshmsc(); view.DeleteRow(view.FocusedRowHandle); } } catch { MessageBox.Show("Vui lòng chọn nhóm trước khi xóa."); } }
public void AddRow(DevExpress.XtraGrid.Views.Grid.GridView View) { int currentRow; currentRow = View.FocusedRowHandle; if (currentRow < 0) { currentRow = View.GetDataRowHandleByGroupRowHandle(currentRow); } //if (View.GroupedColumns.Count == 0) // return; //string grp = View.GetRowCellValue(currentRow, colGRP).ToString(); //GenelDataSet.XGTRow xgtRow = this.genelDataSet.XGT.FindByGRPID(grp, "+"); View.AddNewRow(); View.SetRowCellValue(View.FocusedRowHandle, colTUR, View.GetRowCellValue(currentRow, colTUR)); //View.UpdateCurrentRow(); View.MakeRowVisible(View.FocusedRowHandle, true); View.FocusedColumn = colTOP; View.ShowEditor(); }
public void ExportExcel(DevExpress.XtraGrid.Views.Grid.GridView grid, string path, string name) { GUI.PhanMem.Waiting wait = new GUI.PhanMem.Waiting(); wait.Show(); app obj = new app(); obj.Application.Workbooks.Add(Type.Missing); obj.Columns.ColumnWidth = 20; for (int i = 1; i < grid.Columns.Count + 1; i++) { obj.Cells[1, i] = grid.Columns[i - 1].GetCaption(); } for (int i = 0; i < grid.RowCount; i++) { for (int j = 0; j < grid.Columns.Count; j++) { string value = ""; var ob = grid.GetRowCellValue(i, grid.Columns[j].FieldName); if (ob != null) { value = ob.ToString(); } obj.Cells[i + 2, j + 1] = value; } } obj.ActiveWorkbook.SaveCopyAs(path + name + ".xlsx"); obj.ActiveWorkbook.Saved = true; wait.Close(); }
private void SbtnXuatPDF_TheKho_Click(object sender, EventArgs e) { #region Thong Tin dua vao string tenHang = cboThucPham_TheKho.Text; #region Don Vi Tinh DevExpress.XtraGrid.Views.Grid.GridView view = cboThucPham_TheKho.Properties.View as DevExpress.XtraGrid.Views.Grid.GridView; string donvitinh = "kg"; try { donvitinh = view.GetRowCellValue(view.FocusedRowHandle, "Don vi tinh").ToString(); } catch { } #endregion string CaAn = cboCaAn_TheKho.Text; #region ngay string nam = cboNamHoc_TheKho.Text; string thang = cboThang_TheKho.Text; thang = Convert.ToInt16(thang) >= 10 ? thang : "0" + thang; string ngay = thang + '/' + "01" + '/' + nam; #endregion #region Thong tin Mau hon Dictionary <string, string> thongTin = new Dictionary <string, string>(); thongTin["tenHang"] = tenHang; thongTin["DonViTinh"] = donvitinh; thongTin["ngay"] = ngay; thongTin["CaAn"] = CaAn; #endregion #endregion ExportPDF.UC_TheKho(thongTin, gcTheKho_TheKho); }
private void simpleButton1_Click(object sender, System.EventArgs e) { object unboundValue = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Unbound1"); unboundValue = !(bool)unboundValue; gridView1.SetRowCellValue(gridView1.FocusedRowHandle, "Unbound1", unboundValue); }
public void GridRowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e) { DevExpress.XtraGrid.Views.Grid.GridView _view = (DevExpress.XtraGrid.Views.Grid.GridView)sender; if (Convert.ToBoolean(_view.GetRowCellValue(e.RowHandle, "Edited"))) { e.Appearance.BackColor = UtilColor.EditedColor; } }
public void cell_merge(object sender, DevExpress.XtraGrid.Views.Grid.CellMergeEventArgs e) { DevExpress.XtraGrid.Views.Grid.GridView gridView = sender as DevExpress.XtraGrid.Views.Grid.GridView; object val1 = gridView.GetRowCellValue(e.RowHandle1, e.Column); object val2 = gridView.GetRowCellValue(e.RowHandle2, e.Column); if (e.Column.FieldName == "image") { Image img1 = (Image)val1; Image img2 = (Image)val2; e.Merge = img1.Tag.Equals(img2.Tag); } else { e.Merge = val1.Equals(val2); } e.Handled = true; }
public static void InitGridView(DevExpress.XtraGrid.GridControl _GridControl, Boolean CreatSUM) { //BandedGridView DevExpress.XtraGrid.Views.BandedGrid.BandedGridView _BandedGridView = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridView(); Boolean isBandedGridView = true; try { _BandedGridView = _GridControl.MainView as DevExpress.XtraGrid.Views.BandedGrid.BandedGridView; } catch { isBandedGridView = false; } if (isBandedGridView) { if (!Object.Equals(_BandedGridView, null)) { SetTheme(_BandedGridView); if (CreatSUM) { _BandedGridView.GroupSummary.Clear(); for (int i = 0; i < _BandedGridView.Columns.Count; i++) { if (_BandedGridView.Columns[i].Visible && _BandedGridView.Columns[i].GroupIndex < 0) { if (!Object.Equals(_BandedGridView.GetRowCellValue(0, _BandedGridView.Columns[i]), null)) { if (SHARED.Libraries.StringHelper.IsNumber(_BandedGridView.GetRowCellValue(0, _BandedGridView.Columns[i]).ToString())) { _BandedGridView.Columns[i].SummaryItem.Collection.Clear(); _BandedGridView.Columns[i].Summary.Add(DevExpress.Data.SummaryItemType.Sum, _BandedGridView.Columns[i].FieldName, "{0}"); GridGroupSummaryItem itemTop = new GridGroupSummaryItem(); itemTop.FieldName = _BandedGridView.Columns[i].FieldName; itemTop.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemTop.DisplayFormat = "(" + _BandedGridView.Columns[i].Caption + ": {0})"; _BandedGridView.GroupSummary.Add(itemTop); GridGroupSummaryItem itemDown = new GridGroupSummaryItem(); itemDown.FieldName = _BandedGridView.Columns[i].FieldName; itemDown.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemDown.DisplayFormat = "{0}"; itemDown.ShowInGroupColumnFooter = _BandedGridView.Columns[i]; _BandedGridView.GroupSummary.Add(itemDown); } } } } } } } //GridView if (_GridControl.ViewCollection.Count > 0) { DevExpress.XtraGrid.Views.Grid.GridView _GridView = new DevExpress.XtraGrid.Views.Grid.GridView(); _GridView = _GridControl.ViewCollection[0] as DevExpress.XtraGrid.Views.Grid.GridView; SetTheme(_GridView); if (CreatSUM) { _GridView.GroupSummary.Clear(); for (int i = 0; i < _GridView.Columns.Count; i++) { if (_GridView.Columns[i].Visible && _GridView.Columns[i].GroupIndex < 0) { if (!Object.Equals(_GridView.GetRowCellValue(0, _GridView.Columns[i]), null)) { if (SHARED.Libraries.StringHelper.IsNumber(_GridView.GetRowCellValue(0, _GridView.Columns[i]).ToString())) { _GridView.Columns[i].SummaryItem.Collection.Clear(); _GridView.Columns[i].Summary.Add(DevExpress.Data.SummaryItemType.Sum, _GridView.Columns[i].FieldName, "{0}"); GridGroupSummaryItem itemTop = new GridGroupSummaryItem(); itemTop.FieldName = _GridView.Columns[i].FieldName; itemTop.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemTop.DisplayFormat = "(" + _GridView.Columns[i].Caption + ": {0})"; _GridView.GroupSummary.Add(itemTop); GridGroupSummaryItem itemDown = new GridGroupSummaryItem(); itemDown.FieldName = _GridView.Columns[i].FieldName; itemDown.SummaryType = DevExpress.Data.SummaryItemType.Sum; itemDown.DisplayFormat = "{0}"; itemDown.ShowInGroupColumnFooter = _GridView.Columns[i]; _GridView.GroupSummary.Add(itemDown); } } } } } } }