public void DelRow()
{
if (gridView == null || gridView.GridControl == null)
{
return;
}
int[] rowIndexes = gridView.GetSelectedRows(); // 선택된 Row 모두 가져옴
if (rowIndexes == null)
{
return;
}
IList <T> delList = new List <T>();
foreach (int index in rowIndexes)
{
T entity = (T)gridView.GetRow(index);
if (entity == null)
{
continue;
}
delList.Add(entity);
gridView.DeleteRow(index); // Delete selectrows from view
}
//gridView.DeleteSelectedRows(); // 한번에 선택된 Row 모두 삭제
this.Delete(delList);
}
private void btnClass_Del_Click(object sender, System.EventArgs e)
{
DataRow row = this.gridViewMd_Class.GetDataRow(gridViewMd_Class.FocusedRowHandle);
if (row != null)
{
if (AddNew)
{
AddNew = false;
gridViewMd_Class.DeleteRow(gridViewMd_Class.FocusedRowHandle);
}
else
{
DialogResult result = MessageBox.Show(this, "Do you really want to delete record with Class Code = " + row["strClassCode"].ToString(),
"Delete?", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
try
{
SqlHelper.ExecuteNonQuery(connection, "del_tblClass",
new SqlParameter("@strClassCode", row["strClassCode"].ToString())
);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Delete Process Failed");
return;
}
MessageBox.Show("Record Deleted Successfully", "Message");
}
mdClassTypeInit();
mdClassInit();
}
}
}
private void btn_Del_Click(object sender, System.EventArgs e)
{
DataRow row = this.gridView1.GetDataRow(gridView1.FocusedRowHandle);
if (row != null)
{
if (AddNew)
{
AddNew = false;
gridView1.DeleteRow(gridView1.FocusedRowHandle);
}
else
{
DialogResult result = MessageBox.Show(this, "Do you really want to delete record with Department Id = " + row["nDepartmentID"].ToString(),
"Delete?", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
try
{
SqlHelper.ExecuteNonQuery(connection, "del_TblDepartment",
new SqlParameter("@departmentID", row["nDepartmentID"].ToString())
);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Delete Process Failed");
return;
}
MessageBox.Show("Record Deleted Successfully", "Message");
BindGrid();
}
}
}
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle)
{
if (view == null)
{
return;
}
view.DeleteRow(view.GetRowHandle(rowhandle));
view.RefreshData();
}
/// <summary>
/// 删除指定控件中有焦点的数据行。
/// </summary>
/// <param name="ctrGrid"></param>
public void DeleteFocusedRow(DevExpress.XtraGrid.GridControl xtraGrid)
{
DevExpress.XtraGrid.Views.Grid.GridView gridView = xtraGrid.MainView as DevExpress.XtraGrid.Views.Grid.GridView;
if (gridView.FocusedRowHandle < 0)
{
return;
}
gridView.DeleteRow(gridView.FocusedRowHandle);
xtraGrid.RefreshDataSource();
}
public void DeleteMain(DevExpress.XtraGrid.Views.Grid.GridView gv, string classname) //删除主表信息
{
string deleteIndex = gv.GetFocusedRowCellDisplayText(gv.Columns["StorageNumber"]);
if (MessageBox.Show("是否删除此消息？", "删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
deleteMain(deleteIndex, classname);
gv.DeleteRow(gv.FocusedRowHandle);
}
else
{
}
}
/// <summary>
/// 单表删除
/// </summary>
/// <param name="gv">锁定gridview</param>
public void DeleteData(DevExpress.XtraGrid.Views.Grid.GridView gv) //删除单一表一行内容
{
string deleteIndex = gv.GetFocusedRowCellDisplayText(gv.Columns["ID"]);
if (MessageBox.Show("是否删除此消息？", "删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
deleteData(deleteIndex);
gv.DeleteRow(gv.FocusedRowHandle);
}
else
{
}
}
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 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."); }
}
//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."); }
}
//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 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."); }
}
private void DeleteFocusedRows(DevExpress.XtraGrid.Views.Grid.GridView view)
{
if (view.RowCount > 0 && view.IsValidRowHandle(view.FocusedRowHandle) && !view.IsNewItemRow(view.FocusedRowHandle))
{
view.BeginSort();
try
{
view.DeleteRow(view.FocusedRowHandle);
}
catch (Exception)
{
}
view.EndSort();
}
}
private void simpleButton2_Click(object sender, System.EventArgs e)
{
if (gridView2.RowCount == 0)
{
MessageBox.Show("请先选定一个要删除的学生号码.", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int smsInfo_id = Convert.ToInt32(gridView2.GetDataRow(gridView2.GetSelectedRows()[0])["smsInfo_id"]);
if (new SMSInfoSystem().DeleteSMSPhoneNum(smsInfo_id) > 0)
{
gridView2.DeleteRow(gridView2.GetSelectedRows()[0]);
MessageBox.Show("删除成功.", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void tsbtdeleteiic(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 loại vật tư hàng hóa, công cụ dụng cụ " + view.GetRowCellValue(view.FocusedRowHandle, "Mã loại vật tư hàng hóa, công cụ dụng cụ").ToString() + "?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
gen.ExcuteNonquery("delete from InventoryItemCategory where InventoryCategoryID='" + name + "'");
gen_ta.ExcuteNonquery("delete from InventoryItemCategory where InventoryCategoryID='" + name + "'");
gen_tn.ExcuteNonquery("delete from InventoryItemCategory where InventoryCategoryID='" + name + "'");
gen_chk_tp.ExcuteNonquery("delete from InventoryItemCategory where InventoryCategoryID='" + name + "'");
gen_chk_vt.ExcuteNonquery("delete from InventoryItemCategory where InventoryCategoryID='" + name + "'");
//F.refreshiic();
view.DeleteRow(view.FocusedRowHandle);
}
}
catch { MessageBox.Show("Vui lòng chọn loại vật tư hàng hóa, công cụ dụng cụ trước khi xóa."); }
}
void EliminarLineasVacias(DevExpress.XtraGrid.Views.Grid.GridView View)
{
try
{
for (int i = 0; i < View.RowCount; i++)
{
var Item = (in_Producto_Info)View.GetRow(i);
if (Item != null)
{
if (Item.IdProducto == 0)
{
View.DeleteRow(i);
}
}
}
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
}
}
private void DeleteSelectedRows(DevExpress.XtraGrid.Views.Grid.GridView view, int rowhandle)
{
if (view == null)
{
return;
}
view.DeleteRow(view.GetRowHandle(rowhandle));
////int[] rows = gridView1.GetSelectedRows();
//int[] g = view.GetSelectedRows();
//DataRow[] rows = new DataRow[view.SelectedRowsCount];
//for (int i = 0; i < view.SelectedRowsCount; i++)
// rows[i] = view.GetDataRow(view.GetSelectedRows()[i]);
//view.BeginSort();
//try
//{
// foreach (DataRow row in rows)
// row.Delete();
//}
//finally
//{
// view.EndSort();
//}
view.RefreshData();
}
//delete
private void simpleButton5_Click(object sender, System.EventArgs e)
{
if (gridView1.RowCount <= 1)
{
MessageBox.Show("至少应该保证有一台门口机处于工作状态，删除失败！");
return;
}
if (DialogResult.Yes != MessageBox.Show("确定删除?", "系统信息!",
MessageBoxButtons.YesNo, MessageBoxIcon.Information))
{
return;
}
// if(gridView1.GetDataRow(gridView1.GetSelectedRows()[0])["machine_state"].ToString().Equals("待分配")
// ||gridView1.GetDataRow(gridView1.GetSelectedRows()[0])["machine_state"].ToString().Equals("待修改"))
// {
// MessageBox.Show("只有状态不为待修改和待分配的记录才能进行删除,请选择正确的行记录.","系统信息!",
// MessageBoxButtons.OK,MessageBoxIcon.Information);
//
// return;
// }
int machineAddr = Convert.ToInt32(gridView1.GetDataRow(gridView1.GetSelectedRows()[0])["machine_address"]);
int rowsAffected = new MachineSystem().DeleteMachine(machineAddr);
gridView1.DeleteRow(gridView1.GetSelectedRows()[0]);
// if(rowsAffected>0)
// {
// gridView1.DeleteRow(gridView1.GetSelectedRows()[0]);
// }
// else
// {
// MessageBox.Show("删除失败,请重试.","系统信息!",
// MessageBoxButtons.OK,MessageBoxIcon.Information);
// }
}
private void simpleButton_DeleteSms_Click(object sender, System.EventArgs e)
{
if (gridView2.RowCount == 0)
{
MessageBox.Show("请先选择要删除的回复!", "出错了!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int replyID = Convert.ToInt32(gridView2.GetDataRow(gridView2.GetSelectedRows()[0])["replyContent_id"]);
if (new SMSInfoSystem().DeleteSMSReply(replyID) > 0)
{
gridView2.DeleteRow(gridView2.GetSelectedRows()[0]);
MessageBox.Show("删除成功!", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除失败!", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void simpleButton_DeleteTemp_Click(object sender, System.EventArgs e)
{
if (gridView1.RowCount == 0)
{
MessageBox.Show("请先选择要删除的模板.", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int tempID = Convert.ToInt32(gridView1.GetDataRow(gridView1.GetSelectedRows()[0])["templet_id"]);
if (new SMSInfoSystem().DeleteSMSTemp(tempID) > 0)
{
gridView1.DeleteRow(gridView1.GetSelectedRows()[0]);
MessageBox.Show("模板删除成功.", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("模板删除失败,请重试.", "系统信息!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
///
/// </summary>
/// <param name="flag"></param>
private void OpenCommandDialog(int flag)
{
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 refresh = 0;
int tabIndex = 0;
int StatusCount = 0;
if (flag < 0)
{
MedicalRecordApply medicalRecordApply = new MedicalRecordApply();
medicalRecordApply.ShowDialog();
refresh = medicalRecordApply.m_iCommandFlag;
tabIndex = medicalRecordApply.m_iTabIndex;
//2是提交，0是草稿
}
else
{
InitializeApplyList(dbGridView);
if (this.m_listObject.Count > 0)
{
CApplyObject obj = (CApplyObject)m_listObject[0];
MedicalRecordEditAndDelay medicalRecordApply = new MedicalRecordEditAndDelay(obj, flag);
medicalRecordApply.ShowDialog();
refresh = medicalRecordApply.m_iCommandFlag;
tabIndex = medicalRecordApply.m_iTabIndex;
}
}
//刷新数据
if (refresh > 0)
{
if (tabIndex == 2)
{
int[] list = dbGridView.GetSelectedRows();
dbGridView.DeleteRow(list[0]);
StatusCount++;
}
switch (flag)
{
case -1: //申请
foreach (RecordModel rd in listAll)
{
if (rd.Index == 2)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
}
break;
case 0: //编辑
foreach (RecordModel rd in listAll)
{
if (rd.Index == 2)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
}
break;
case 1:
foreach (RecordModel rd in listAll)
{
if (rd.Index == 0)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
else if (rd.Index == 3)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
}
break; //申请延期事件
}
re.MyControl.GetInitDB(true);
re.Count = re.Count - StatusCount;
re.MyControl.dbGridView = dbGridView;
RefreshInformation(re.Index, re.Count);
break;
}
}
break;
}
}
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="status"></param>
/// <param name="info"></param>
private void ExecuteCommand(int status, string info)
{
try
{
foreach (RecordModel re in listAll)
{
if (re.Index == this.tabControl.SelectedTabPageIndex)
{
DevExpress.XtraGrid.Views.Grid.GridView dbGridView = re.MyControl.dbGridView;
if (dbGridView.RowCount > 0)
{
if (dbGridView.SelectedRowsCount > 0)
{
/*
* string name = dbGridView.GetRowCellValue(dbGridView.GetSelectedRows()[0], "NAME").ToString();
* string number = dbGridView.GetRowCellValue(dbGridView.GetSelectedRows()[0], "NOOFINPAT").ToString();
* info = info + " 病历：" + name + "(" + number + ")";
*/
DialogResult dR = DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("您确认要" + info + "吗？", "信息提示", MyMessageBoxButtons.OkCancel);
if (dR == System.Windows.Forms.DialogResult.OK)
{
int[] list = dbGridView.GetSelectedRows();
int StatusCount = 0;
for (int i = 0; i < list.Length; i++)
{
string id = dbGridView.GetRowCellValue(list[i], "ID").ToString();
if (status > 0)
{
dbGridView.SetRowCellValue(list[i], "STATUSDES", status);
CApplyObject.UpdateStatus(id, status);
dbGridView.DeleteRow(list[i]);
StatusCount++;
}
else
{
dbGridView.DeleteRow(list[i]);
CApplyObject.Delete(id);
StatusCount++;
}
}
switch (status)
{
case 1:
foreach (RecordModel rd in listAll)
{
if (rd.Index == 2)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
}
break; //提交申请
case -1: break; //删除申请
case 5:
foreach (RecordModel rd in listAll)
{
if (rd.Index == 4)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
}
break; //归还病历
case 4:
foreach (RecordModel rd in listAll)
{
if (rd.Index == 5)
{
if (rd.MyControl == null)
{
UserControlDB(rd.Index);
}
rd.MyControl.GetInitDB(true);
rd.MyDataTable = rd.MyControl.User_Table;
rd.Count = rd.MyControl.User_Table.Rows.Count;
RefreshInformation(rd.Index, rd.Count);
}
}
break; //撤销申请
}
re.Count = re.Count - StatusCount;
re.MyControl.dbGridView = dbGridView;
RefreshInformation(re.Index, re.Count);
break;
}
}
else
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(info + "请选择需要操作的记录", "信息提示");
}
}
}
}
//提交m_Apply
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
