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);
}
}
}
}
}
}
}
