private void toolStripButton3_Click(object sender, EventArgs e)
{
if (Dlg.ShowConfirmInfo("确认要删除该模块吗?") == DialogResult.Yes)
{
string MKBH;
if (tvRight.SelectedNode == null)
{
Dlg.ShowErrorInfoAndHelp("请选择要删除的模块！");
return;
}
MKBH = ((ModuleList)tvRight.SelectedNode.Tag).MKBH;
List <string> mSqls = new List <string>();
string mSql = string.Format("delete from ptcd where mkbh='{0}'", MKBH);
mSqls.Add(mSql);
mSql = string.Format("delete from ptzqx where mkbh='{0}'", MKBH);
mSqls.Add(mSql);
int ret = SqlHelper.ExecuteSqls(mSqls.ToArray());
if (ret == 0)
{
Dlg.ShowOKInfo("删除成功!");
ClearForm();
InitRight();
}
}
}
private void 注销ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (Dlg.ShowConfirmInfo("是否确定要注销？") == DialogResult.Yes)
{
Logout();
}
}
private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (Dlg.ShowConfirmInfo("是否确定要退出系统？") == DialogResult.Yes)
{
Close();
}
}
private void tsbResetPass_Click(object sender, EventArgs e)
{
//Confirm
if (Dlg.ShowConfirmInfo("确认要重置密码吗？") == DialogResult.No)
{
return;
}
if (dgvRY.SelectedRows.Count < 1)
{
Dlg.ShowErrorInfoAndHelp("请先选择要重置的用户");
return;
}
int gh = Convert.ToInt32(dgvRY.SelectedRows[0].Cells["ColGH"].Value);
using (FrmInput mForm = new FrmInput())
{
if (mForm.ShowDialog() == DialogResult.OK)
{
string strPass = mForm.txtInput.Text.Trim();
strPass = MD5.Md5Encrypt(strPass);
string mSql = string.Format("update ptry set mm='{0}' where gh='{1}'", strPass, gh);
int ret = SqlHelper.ExecuteNonQuery(mSql);
if (ret > 0)
{
Dlg.ShowOKInfo("重置成功!");
}
else
{
Dlg.ShowErrorInfo("重置失败!");
}
}
}
}
private void tsbRYDel_Click(object sender, EventArgs e)
{
if (dgvRY.SelectedRows.Count == 0)
{
return;
}
string loginName = dgvRY.SelectedRows[0].Cells[ColLoginName.Index].Value.ToString();
if (loginName == "admin")
{
Dlg.ShowErrorInfoAndHelp("admin不能进行删除！");
return;
}
//Confirm
if (Dlg.ShowConfirmInfo("确认要删除该用户吗？") == DialogResult.No)
{
return;
}
long id = Convert.ToInt64(dgvRY.SelectedRows[0].Cells[ColID.Index].Value);
string mSql = string.Format("delete from t_users where id='{0}'", id);
int ret = SqlHelper.ExecuteNonQuery(mSql);
if (ret > 0)
{
InitRY();
}
}
private void tsbRYDel_Click(object sender, EventArgs e)
{
if (dgvRY.SelectedRows.Count == 0)
{
return;
}
int gh = Convert.ToInt32(dgvRY.SelectedRows[0].Cells["ColGH"].Value);
if (gh == 1001)
{
Dlg.ShowErrorInfoAndHelp("工号1001不能进行删除！");
return;
}
//检查用户是否过做业务
DbAccess DbAcs = new DbAccess(CommonClass.ConnStr);
DbAcs.m_sSQL = string.Format("select count(*) from XTtradelist where operaterid='{0}'", gh);
DataSet DS = DbAcs.GetDataSet();
if (DS.ExtendedProperties["ReturnFlag"].ToString() != "0")
{
Dlg.ShowErrorInfo(DS.ExtendedProperties["ReturnFlag"].ToString());
return;
}
if (DS.Tables[0].Rows[0][0].ToString() != "0")
{
Dlg.ShowErrorInfo("该用户已经做过业务，不能删除！");
return;
}
//Confirm
if (Dlg.ShowConfirmInfo("确认要删除该用户吗？") == DialogResult.No)
{
return;
}
string mSql = string.Format("delete from ptry where gh='{0}'", gh);
int ret = SqlHelper.ExecuteNonQuery(mSql);
if (ret > 0)
{
InitRY();
}
}
private void tsbDel_Click(object sender, EventArgs e)
{
if (tvRYZ.SelectedNode == null)
{
Dlg.ShowErrorInfo("未选择要删除的角色！");
return;
}
if (tvRYZ.SelectedNode.Text == "管理员")
{
Dlg.ShowErrorInfo("管理员角色不允许删除！");
return;
}
//Check
DbAccess DbAcs = new DbAccess(CommonClass.ConnStr);
DbAcs.m_sSQL = string.Format("SELECT count(*) FROM [PTry] where JB={0}", tvRYZ.SelectedNode.Tag.ToString());
DataSet DS = DbAcs.GetDataSet();
if (DS.ExtendedProperties["ReturnFlag"].ToString() != "0")
{
Dlg.ShowErrorInfo(DS.ExtendedProperties["ReturnFlag"].ToString());
return;
}
if (DS.Tables[0].Rows[0][0].ToString() != "0")
{
Dlg.ShowErrorInfo("该系统角色已经做过分配，不能删除！");
return;
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
if (Dlg.ShowConfirmInfo("确认要删除该角色吗?") == DialogResult.Yes)
{
string mSql = string.Format("delete from ptryz where zbh={0}", Convert.ToInt32(tvRYZ.SelectedNode.Tag));
int ret = SqlHelper.ExecuteNonQuery(mSql);
InitRYZ();
InitRight();
}
}
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
if (blZhuxiao == false)
{
if (Dlg.ShowConfirmInfo("确定退出系统？") == System.Windows.Forms.DialogResult.No)
{
e.Cancel = true;
return;
}
else
{
e.Cancel = false;
//return;
#region 取数据库备份参数
int backupMode;
string backupPath;
string lsql = string.Format("SELECT IntCode,VcParam1 from SysParam where IntType=1");
using (DataTable dt = SqlHelper.GetData(lsql))
{
if (dt.Rows.Count == 0)
{
Dlg.ShowErrorInfoAndHelp("第一次使用，请设置数据库备份参数！");
e.Cancel = true;
return;
}
else
{
backupMode = Utils.StrToIntDef(dt.Rows[0]["IntCode"].ToString(), -1);
backupPath = Convert.ToString(dt.Rows[0]["VcParam1"]).Trim();
}
if ((backupMode < 0) || (backupMode > 2))
{
Dlg.ShowErrorInfo("数据库“备份选项”不正确，请设置！");
e.Cancel = true;
return;
}
if (backupMode != 2)
{
if (string.IsNullOrEmpty(backupPath) == true)
{
if (Dlg.ShowConfirmInfo("数据库备份路径为空，请设置！") == System.Windows.Forms.DialogResult.Yes)
{
e.Cancel = true;
return;
}
}
if ((!Directory.Exists(backupPath)) && CommonClass.SttDb.iDBType == 0)
{
if (Dlg.ShowConfirmInfo("数据库备份路径在本机不存在，请设置！") == System.Windows.Forms.DialogResult.Yes)
{
e.Cancel = true;
return;
}
}
}
}
#endregion
#region 备份
if (CommonClass.SttDb.iDBType == 0)
{
string dbFullName = Application.StartupPath + @"\DbMeter.mdb";
Cursor.Current = Cursors.WaitCursor;
CopyFileClass.Backup(backupMode, dbFullName, backupPath);
Cursor.Current = Cursors.Default;
}
else
{
if (backupMode == 0)
{
if (Dlg.ShowConfirmInfo("是否备份数据库") == System.Windows.Forms.DialogResult.Yes)
{
Cursor.Current = Cursors.WaitCursor;
string dbFullName = backupPath + "\\dbmeter" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".bak";
System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(@"\(.*?\)");
string dbName = regex.Match(CommonClass.SttDb.sDbInfo).ToString().Trim('(', ')');
string mSql = string.Empty;
mSql = string.Format(@"BACKUP DATABASE {0} TO DISK = N'{1}' WITH INIT , NOUNLOAD , NAME = N'{0}备份',NOSKIP , STATS = 10, NOFORMAT", dbName, dbFullName);
SqlHelper.ExecuteNonQuery(mSql);
Cursor.Current = Cursors.Default;
}
}
else if (backupMode == 1)
{
Cursor.Current = Cursors.WaitCursor;
string dbFullName = backupPath + "\\dbmeter" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".bak";
System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(@"\(.*?\)");
string dbName = regex.Match(CommonClass.SttDb.sDbInfo).ToString().Trim('(', ')');
string mSql = string.Empty;
mSql = string.Format(@"BACKUP DATABASE {0} TO DISK = N'{1}' WITH INIT , NOUNLOAD , NAME = N'{0}备份',NOSKIP , STATS = 10, NOFORMAT", dbName, dbFullName);
SqlHelper.ExecuteNonQuery(mSql);
Cursor.Current = Cursors.Default;
}
}
#endregion
//关闭启动窗体
myLogin.Close();
}
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
e.Cancel = true;
return;
}
}