private void btnSave1_Click(object sender, EventArgs e)
{
string ConnStr = null;
//ConnStr = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", txtAccess.Text);
ConnStr = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True;Jet OLEDB:Database Password=meiyoumima2011", txtAccess.Text);
try
{
Configuration config = ConfigurationManager.OpenExeConfiguration("PubClasses.dll");
config.ConnectionStrings.ConnectionStrings.Remove("PubClasses.Properties.Settings.Setting_ConnStr");
config.ConnectionStrings.ConnectionStrings.Add(new ConnectionStringSettings("PubClasses.Properties.Settings.Setting_ConnStr", ConnStr, "System.Data.OleDb"));
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("ConnectionStrings");
// My.Settings.ConnectionString = config.ConnectionStrings.ConnectionStrings("一卡通.Properties.Settings.Default.ConnectionString").ToString
//MsgBox(My.Settings.ConnectionString)
Dlg.ShowOKInfo("保存成功,程序将重新启动");
Application.Exit();
System.Diagnostics.Process.Start(Application.ExecutablePath.ToString());
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message.ToString());
}
}
private void btnAudit_Click(object sender, EventArgs e)
{
if (DialogResult.Yes == MessageBox.Show("确认复核通过？", "提示", MessageBoxButtons.YesNo))
{
int ret = 0;
string auditString = "";
foreach (DataGridViewRow mRow in dgvNoTicketAudit.Rows)
{
if (Convert.ToBoolean(mRow.Cells["ColumnChecked"].Value) == true)
{
auditString += mRow.Cells["idDataGridViewTextBoxColumn"].Value + ",";
}
}
auditString = auditString.TrimEnd(',');
if (auditString == "")
{
Dlg.ShowErrorInfoAndHelp("没有选择要复核的记录");
return;
}
string mSql = string.Format("UPDATE T_NoTicket SET P2 = '{0}',P3 = '{1}', AuditDate = GETDATE() WHERE Id IN ({2})", "复核已通过", Classes.PubClass.UserId, auditString);
ret = SqlHelper.ExecuteNonQuery(mSql);
if (ret > 0)
{
Dlg.ShowOKInfo("保存成功");
//刷新页面
refresh();
}
else
{
Dlg.ShowErrorInfo("保存失败");
}
}
}
public static bool ConnectDB(string connStr)
{
try
{
using (OleDbConnection mConn = new OleDbConnection(connStr))
{
mConn.Open();
if (mConn.Provider.IndexOf("SQLOLEDB") != -1)
{
CommonClass.SttDb.iDBType = 1;
}
else if (mConn.Provider.IndexOf("Jet") != -1)
{
CommonClass.SttDb.iDBType = 0;
}
else
{
CommonClass.SttDb.iDBType = -2;
}
CommonClass.SttDb.sDbInfo = string.Format("{0}({1})", mConn.DataSource, mConn.Database);
CommonClass.SttDb.sDataSource = mConn.DataSource;
mConn.Close();
return(false);
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
return(true);
}
}
private void tsbModify_Click(object sender, EventArgs e)
{
if (tvRYZ.SelectedNode == null)
{
Dlg.ShowErrorInfo("未选择要修改的角色！");
return;
}
if (tvRYZ.SelectedNode.Text == "管理员")
{
Dlg.ShowErrorInfo("管理员角色不允许修改！");
return;
}
using (FrmInput mForm = new FrmInput())
{
mForm.txtInput.Text = tvRYZ.SelectedNode.Text;
int zbh = Convert.ToInt32(tvRYZ.SelectedNode.Tag);
if (mForm.ShowDialog() == DialogResult.OK)
{
string sSql = string.Format("select count(*) from ptryz where zmc='{0}'", mForm.txtInput.Text.Trim());
int iRet = (int)SqlHelper.ExecuteScalar(sSql);
if (iRet == -1)
{
return;
}
if (iRet != 0)
{
Dlg.ShowErrorInfoAndHelp(string.Format("输入的新角色名称“{0}”已存在，不能修改！", mForm.txtInput.Text.Trim()));
return;
}
sSql = string.Format("update ptryz set zmc='{0}' where zbh={1}", mForm.txtInput.Text.Trim(), zbh);
int ret = SqlHelper.ExecuteNonQuery(sSql);
InitRYZ();
}
}
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
if (tvRYZ.SelectedNode == null)
{
Dlg.ShowErrorInfoAndHelp("请选择用户的角色以分配权限！");
return;
}
if (tvRYZ.SelectedNode.Text == "管理员")
{
Dlg.ShowErrorInfoAndHelp("管理员角色不允许修改权限！");
return;
}
int ryzbh = Convert.ToInt32(tvRYZ.SelectedNode.Tag);
List <string> mSqls = new List <string>();
mSqls.Add(string.Format("delete from ptzqx where ryzbh={0} and MKBH in (select MKBH from PTcd where MKBH <> '0000' and (cardtype in (-1,-2) or cardtype ={1}))", ryzbh, CommonClass.SttIC.iCardType));
foreach (TreeNode tn in tvRight.Nodes)
{
AddSqlStr(ref mSqls, tn, ryzbh);
}
int ret = SqlHelper.ExecuteSqls(mSqls.ToArray());
if (ret == 0)
{
Dlg.ShowOKInfo("保存成功");
return;
}
else
{
Dlg.ShowErrorInfo("保存失败");
return;
}
}
public static void Restore(string PFileName)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Title = "数据库恢复";
openFileDialog1.InitialDirectory = Application.StartupPath;
openFileDialog1.Filter = "备份文件(*.mdb)|*.mdb";
openFileDialog1.ShowDialog();
string strOldFile = openFileDialog1.FileName;
if (strOldFile == PFileName)
{
Dlg.ShowErrorInfo("文件已存在！");
return;
}
try
{
FileInfo fileInfo1 = new FileInfo(strOldFile);
fileInfo1.CopyTo(PFileName, true);
Dlg.ShowOKInfo("数据库恢复成功！");
return;
}
catch
{
throw;
}
}
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("重置失败!");
}
}
}
}
/// <summary>
/// 执行SQL语句返回DataTable
/// </summary>
/// <param name="mSql">要执行Sql的语句</param>
/// <returns></returns>
public static DataTable GetData(string mSql, bool _blFlag = true)
{
DataTable mTable = new DataTable();
try
{
using (OleDbConnection mConn = new OleDbConnection(CommonClass.ConnStr))
{
mConn.Open();
using (OleDbDataAdapter adapter = new OleDbDataAdapter(mSql, mConn))
{
adapter.Fill(mTable);
}
mConn.Close();
}
}
catch (Exception ex)
{
if (_blFlag)
{
Dlg.ShowErrorInfo(ex.Message);
}
else
{
throw ex;
}
}
return(mTable);
}
private object addControl(string senderName, string _sTitle = "")
{
try
{
Control mCT = null;
if (PnlClient.Controls.Find(senderName, false).Length > 0) //该页面已存在
{
mCT = PnlClient.Controls.Find(senderName, false)[0];
}
else
{
Assembly myAs = Assembly.GetExecutingAssembly();
Type mType = myAs.GetType(senderName);
if (mType == null)
{
Dlg.ShowErrorInfoAndHelp("没有找到窗体");
return(1);
}
if (mType.BaseType.Name == "UserControl" || mType.BaseType.Name == "UserControlBase")
{
mCT = (Control)Activator.CreateInstance(mType);
mCT.Name = senderName;
}
SetDoubleBuffered(mCT);
PnlClient.Controls.Add(mCT);
// mCT.Parent = panel1;
//将控件加载到标签页上
}
if (mCT != null)
{
mCT.Dock = System.Windows.Forms.DockStyle.Fill;
mCT.BringToFront();
mCT.Select();
}
if (string.IsNullOrEmpty(_sTitle))
{
LblTip.Text = senderName;
}
else
{
LblTip.Text = _sTitle;
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(string.Format("异常：\n{0}", ex.Message));
return(1);
}
return(0);
//0成功
}
/// <summary>
/// 执行所有Sql语句
/// </summary>
/// <param name="mSqls">要执行所有Sql语句</param>
/// <returns></returns>
public static int ExecuteSqls(string[] mSqls)
{
try
{
using (OleDbConnection mConn = new OleDbConnection(CommonClass.ConnStr))
{
mConn.Open();
using (OleDbTransaction mTrans = mConn.BeginTransaction())
{
try
{
using (OleDbCommand mComm = new OleDbCommand())
{
mComm.Connection = mConn;
mComm.Transaction = mTrans;
int ret = 0;
foreach (string mSql in mSqls)
{
mComm.CommandText = mSql;
ret = mComm.ExecuteNonQuery();
if (ret < 1 && mSql.ToUpper().Contains("insert".ToUpper()) == true)
{
mTrans.Rollback();
return(1);
}
}
}
}
catch (Exception ex)
{
mTrans.Rollback();
Dlg.ShowErrorInfo(ex.Message);
return(1);
}
mTrans.Commit();
}
mConn.Close();
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
return(1);
}
return(0);
}
public static void Timing(DateTime _DT)
{
try
{
SystemTime st = new SystemTime();
st.wYear = (ushort)_DT.Year;
st.wMonth = (ushort)_DT.Month;
st.wDay = (ushort)_DT.Day;
st.Whour = (ushort)_DT.Hour;
st.wMinute = (ushort)_DT.Minute;
st.wSecond = (ushort)_DT.Second;
SetLocalTime(st);
}
catch (Exception Ex)
{
Dlg.ShowErrorInfo(string.Format("系统时间设置失败:\n{0}", Ex.Message));
}
}
private void btnAudit2_Click(object sender, EventArgs e)
{
if (DialogResult.Yes == MessageBox.Show("确认审批不通过？", "提示", MessageBoxButtons.YesNo))
{
int ret = 0;
string auditString = "";
foreach (DataGridViewRow mRow in dgvNoTicketAudit.Rows)
{
if (Convert.ToBoolean(mRow.Cells["ColumnChecked"].Value) == true)
{
auditString += mRow.Cells["idDataGridViewTextBoxColumn"].Value + ",";
}
}
auditString = auditString.TrimEnd(',');
if (auditString == "")
{
Dlg.ShowErrorInfoAndHelp("没有选择要审批的记录");
return;
}
string mSql = string.Format("UPDATE T_NoTicket SET Status = '{0}',AuditId = '{1}', AuditDate = GETDATE() WHERE (Id IN ({2}))", "审批未通过", Classes.PubClass.UserId, auditString);
ret = SqlHelper.ExecuteNonQuery(mSql);
if (ret > 0)
{
Dlg.ShowOKInfo("保存成功!");
//修改页面显示2016.9.6
refresh();
//foreach (DataGridViewRow mRow in dgvExAllocation.Rows)
//{
// if (Convert.ToBoolean(mRow.Cells["ColumnChecked"].Value) == true)
// {
// dgvExAllocation.Rows.Remove(mRow);
// }
//}
}
else
{
Dlg.ShowErrorInfo("保存失败");
}
}
}
int CheckLogin(string _sUserID, string _sPass)
{
string mSql;
_sPass = MD5.Md5Encrypt(_sPass);
mSql = string.Format("SELECT mm,xm,jb,sh,zt FROM PTry WHERE gh='{0}' ", _sUserID);
DataTable mTable = SqlHelper.GetData(mSql);
if (mTable == null)
{
Dlg.ShowErrorInfo("获取操作员信息失败！");
return(-1);
}
if (mTable.Rows.Count < 1)
{
Dlg.ShowErrorInfo("工号输入错误！");
return(-1);
}
if (mTable.Rows[0]["zt"].ToString() == "1")
{
Dlg.ShowErrorInfo("该工号已被锁定,请联系管理员！");
return(-1);
}
if (_sPass != mTable.Rows[0]["mm"].ToString())
{
Dlg.ShowErrorInfo("密码输入错误");
return(-1);
}
CommonClass.OperatorID = _sUserID;
try
{
CommonClass.OperatorType = Convert.ToInt32(mTable.Rows[0]["jb"]);
}
catch {}
CommonClass.SttUser.sUserID = _sUserID;
CommonClass.SttUser.sUserName = mTable.Rows[0]["xm"].ToString();
try
{
CommonClass.SttUser.iLevel = Convert.ToInt32(mTable.Rows[0]["jb"]);
}
catch { }
return(0);
}
public static void RefreshSection(string mConnStr)
{
try
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
config.ConnectionStrings.ConnectionStrings.Remove("PubClasses.Properties.Settings.Setting_ConnStr");
config.ConnectionStrings.ConnectionStrings.Add(new ConnectionStringSettings("PubClasses.Properties.Settings.Setting_ConnStr", mConnStr, "System.Data.OleDb"));
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("ConnectionStrings");
Dlg.ShowOKInfo("保存成功,程序将重新启动");
Application.Restart();
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message.ToString());
}
}
private int ChangeCardType(string xmlPath, string cardType)
{
try
{
XmlDocument xmlDoc = new XmlDocument();
if (File.Exists(xmlPath) == false)
{
xmlDoc.AppendChild(xmlDoc.CreateXmlDeclaration("1.0", "gb2312", null));
xmlDoc.AppendChild(xmlDoc.CreateElement("", "Config", ""));
xmlDoc.Save(xmlPath);
}
xmlDoc.Load(xmlPath);
XmlNode mConfigNode = xmlDoc.SelectSingleNode("Config");
if (mConfigNode == null)
{
mConfigNode = xmlDoc.CreateElement("", "Config", "");
xmlDoc.AppendChild(mConfigNode);
}
XmlNode mCardTypeNode = xmlDoc.SelectSingleNode("Config/CardType");
if (mCardTypeNode == null)
{
mCardTypeNode = xmlDoc.CreateElement("CardType");
mConfigNode.AppendChild(mCardTypeNode);
}
XmlAttribute xaType = mCardTypeNode.Attributes["Type"];
if (xaType == null)
{
xaType = xmlDoc.CreateAttribute("Type");
mCardTypeNode.Attributes.Append(xaType);
}
xaType.Value = cardType;
xmlDoc.Save(xmlPath);
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
return(1);
}
return(0);
}
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();
}
}
/// <summary>
/// 测试是否能连接数据库
/// </summary>
/// <returns>0--成功,1--失败</returns>
public static int TestDB()
{
try
{
//if (Common.mDatabaseClass.ConnectDB(PubClasses.Properties.Settings.Default.Setting_ConnStr) == false)
if (ConnectDB(CommonClass.ConnStr) == false)
{
return(0);
}
else
{
return(1);
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
return(1);
}
}
private void btnTest1_Click(object sender, EventArgs e)
{
string ConnStr = null;
ConnStr = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True;Jet OLEDB:Database Password=meiyoumima2011", txtAccess.Text);
//;Persist Security Info=True;Jet OLEDB:Database Password=
OleDbConnection mConn = new OleDbConnection(ConnStr);
try
{
mConn.Open();
mConn.Close();
Dlg.ShowOKInfo("连接成功");
BtnSaveAccess.Enabled = true;
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message.ToString());
BtnSaveAccess.Enabled = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string ConnStr = null;
ConnStr = string.Format("provider=SQLOLEDB;Data Source={0},{1};Password={2};User ID={3};Initial Catalog={4}", txtAddress.Text, txtPort.Text, txtDBPass.Text, txtDBUser.Text, txtDBName.Text);
// //获取appSettings节点
try
{
SqlHelper.RefreshSection(ConnStr);
// My.Settings.ConnectionString = config.ConnectionStrings.ConnectionStrings("一卡通.Properties.Settings.Default.ConnectionString").ToString
//MsgBox(My.Settings.ConnectionString)
//Dlg.ShowOKInfo("保存成功,程序将重新启动");
//Application.Restart();
//Application.Exit()
//Process.Start(Application.ExecutablePath.ToString)
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message.ToString());
}
}
private void btnTest_Click(object sender, EventArgs e)
{
string ConnStr = null;
//Provider=SQLOLEDB;Data Source=.;Integrated Security=SSPI;Initial Catalog=DBMeter
ConnStr = string.Format("Provider=SQLOLEDB;Data Source={0},{1};Password={2};User ID={3};Initial Catalog={4}", txtAddress.Text, txtPort.Text, txtDBPass.Text, txtDBUser.Text, txtDBName.Text);
OleDbConnection mConn = new OleDbConnection(ConnStr);
try
{
mConn.Open();
mConn.Close();
Dlg.ShowOKInfo("连接成功");
BtnSave.Enabled = true;
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message.ToString());
BtnSave.Enabled = false;
}
}
/// <summary>
/// 执行Sql语句返回受影响的行数
/// </summary>
/// <param name="mSql">要执行Sql的语句</param>
/// <returns></returns>
public static int ExecuteNonQuery(string mSql)
{
int ret = 0;
try
{
using (OleDbConnection mConn = new OleDbConnection(CommonClass.ConnStr))
{
mConn.Open();
using (OleDbCommand mComm = new OleDbCommand(mSql, mConn))
{
ret = mComm.ExecuteNonQuery();
}
mConn.Close();
return(ret);
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
return(-1);
}
}
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();
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
System.Diagnostics.Process[] processes = System.Diagnostics.Process.GetProcessesByName("Client");
if (processes.Length > 1)
{
IntPtr hwnd = processes[0].MainWindowHandle;
// NOTE: ensure the first intance handle selected
if (System.Diagnostics.Process.GetCurrentProcess().MainWindowHandle == hwnd)
{
hwnd = processes[1].MainWindowHandle;
}
long style = GetWindowLong(hwnd, GWL_STYLE);
if ((style & WS_MINIMIZE) == WS_MINIMIZE)
{
ShowWindow(hwnd, SW_SHOWNOACTIVATE);
}
SetForegroundWindow(hwnd);
return;
}
try
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
string xmlPath = "DBInfo.xml";
XmlDocument xmlDoc = new XmlDocument();
if (File.Exists(xmlPath) == false)
{
//文件不存在则新建文件
xmlDoc.AppendChild(xmlDoc.CreateXmlDeclaration("1.0", null, null));
//根节点
xmlDoc.AppendChild(xmlDoc.CreateElement("DBInfo"));
xmlDoc.Save(xmlPath);
//应用程序所在目录下级目录用“/”，上级目录用“../”
Common.XmlHelper.Insert(xmlPath, "/DBInfo", "DBType", "", "0");
//XmlHelper.Insert(xmlPath, "/DBInfo", "DBConnStr", "", "Provider=SQLOLEDB;Data Source=192.168.111.115,1433;Persist Security Info=True;Password=sa;User ID=sa;Initial Catalog=DBMeter");
Common.XmlHelper.Insert(xmlPath, "/DBInfo", "DBConnStr", "", "");
}
string sConnStr = Common.XmlHelper.Read(xmlPath, "/DBInfo/DBConnStr", "");
//解密数据库连接参数
sConnStr = Soft.Common.Utils.DecryptRc2(sConnStr);
//公共类的连接字符串赋值，包括类属性 和 项目属性两处
//Common.Properties.Settings.Default.ConnectionString = Common.ConnStr;
CommonClass.SetConnStr(sConnStr);
if (SqlHelper.TestDB() == 0)
{
//PubClasses.SqlHelper.mConnStr = mConnStr;
}
else
{
Dlg.ShowErrorInfo("连接数据库失败,请运行“数据库连接参数配置工具.exe”进行配置！");
return;
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(string.Format("异常：\n{0}", ex.Message));
return;
}
Application.Run(new FrmLogin());
}
private void OK_Click(object sender, EventArgs e)
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
#region MyRegion
//string LoginName, Password;
//LoginName = txtLoginName.Text.Trim();
//Password = txtPassword.Text.Trim();
//var mTable = new T_UsersTableAdapter().GetDataByLoginName(LoginName);
//if (mTable.Rows.Count < 1)
//{
// Dlg.Show("登录名输入错误");
// return;
//}
//else
//{
// var mRow = (SaleManager.DAL.DataSetUsers.T_UsersRow)mTable.Rows[0];
// Password = PubClasses.MD5.Md5Encrypt(Password);
// if (string.Compare(Password, mRow.PassWord) != 0)
// {
// Dlg.Show("密码输入错误");
// txtPassword.Text = "";
// return;
// }
// PubClasses.Common.LoginName = LoginName;
// PubClasses.Common.UserId = mRow.id;
// PubClasses.Common.UserName = mRow.UserName;
// PubClasses.Common.UserRight = mRow.OperRight;
// PubClasses.Common.UserStatus = mRow.UserStatus;
// isLogined = true;
//}
//System.Net.IPAddress[] IPs = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName());
//if (IPs.Length > 0)
//{
// new T_LoginLogTableAdapter().Insert(PubClasses.Common.UserId, IPs[2].ToString());
//}
#endregion
//object[] args = new object[2];
//Assembly myAs;
//myAs = Assembly.LoadFrom("一卡通.dll");
//Type mType = myAs.GetType("一卡通.Classes.Login");
//if (mType != null)
//{
// args[0] = this;
// args[1] = "";
// int ret =-1;
// ret = (int)mType.InvokeMember("Login_Ok", BindingFlags.InvokeMethod, null, mType, args);
// if (ret != 0)
// {
// return;
// }
//}
//else
//{
// Dlg.Show("加载登录模块失败！");
// return;
//}
//判断要加载的界面类型
string UserId = TBUserID.Text.Trim();
string UserPass = TBUserPass.Text.Trim();
CommonClass.SttUser.blSuperUser = false;
if (UserId == "0000")
{
if (UserPass != "OneCardSuperAdmin")
{
Dlg.ShowErrorInfo("密码不正确，重新输入！");
this.TBUserPass.SelectAll();
this.TBUserPass.Focus();
return;
}
CommonClass.SttUser.sUserID = UserId;
CommonClass.SttUser.sUserName = "******";
CommonClass.SttUser.blSuperUser = true;
}
else if (CheckLogin(UserId, UserPass) != 0)
{
return;
}
//Client.Common.OperatorName = mTable.Rows[0]["xm"].ToString();
//Client.Common.NetNo = mTable.Rows[0]["sh"].ToString();
////04规范
////取 区域号，卡类型，只有一条
////DataSet ds1 = new DataSet();
//mSql = "SELECT AreaNo,CardType FROM SZICSysParam";
//mTable = Client.SqlHelper.GetData(mSql);
//if (mTable.Rows.Count == 0)
//{
// Dlg.ShowErrorInfo("请先进行系统参数（区域号，卡类型）设置！");
// return;
//}
//else
//{
// Client.Common.gSysId = mTable.Rows[0]["AreaNo"].ToString().PadLeft(4, '0'); //区域号
// Client.Common.gCardType = mTable.Rows[0]["CardType"].ToString(); //卡类型
//}
////取 读卡器端口号，条件是计算机名
//string portStr = "USB";
//string ComputerName = System.Environment.GetEnvironmentVariable("ComputerName");
//mSql = string.Format("SELECT * FROM SZComputerParam where ComputerName='{0}'", ComputerName);
//mTable = Client.SqlHelper.GetData(mSql);
//if (mTable.Rows.Count == 0)
//{
// Dlg.ShowErrorInfo("请先进行本机参数（读卡器端口号）设置！");
// //return;
//}
//else
//{
// portStr = mTable.Rows[0]["Port"].ToString().Trim();
// object obj = mTable.Rows[0]["T57_flag"];
// if (obj != DBNull.Value)
// {
// Client.Common.gT57_flag = Convert.ToInt16(obj);
// }
//}
//if (portStr == "USB")
//{
// Client.Common.gPortInt = 100;
//}
//else
//{
// Client.Common.gPortInt = System.Convert.ToInt32(portStr.Substring(portStr.Length - 2, 2));
//}
////04规范end
////取加密因子
//mSql = "SELECT * FROM PTSoft_object";
//mTable = PubClasses.SqlHelper.GetData(mSql);
//if (mTable == null)
//{
// Dlg.ShowErrorInfo("获取软件信息失败！");
// return;
//}
//if (mTable.Rows.Count == 0)
//{
// Dlg.ShowErrorInfo("系统因子A不存在！");
// return;
//}
//else
//{
// if (mTable.Rows[0]["JMA"] == DBNull.Value)
// {
// Dlg.ShowErrorInfo("系统因子A为空值！");
// return;
// }
// else
// {
// PubClasses.Common.JMA = mTable.Rows[0]["JMA"].ToString();
// if (PubClasses.Common.JMA.Length != 8)
// {
// Dlg.ShowErrorInfo("系统因子A长度错误！");
// return;
// }
// }
//}
FrmMain mForm = new FrmMain(this);
mForm.LoadModuleListFromDb(CommonClass.OperatorType);
//mForm.tssb用户名.Text = "登录用户名:" + Common.UserName + " | 权限:" + PubClasses.Common.UserRight;
mForm.Show();
this.Hide();
}
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;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtNewPass.Text.Trim() == string.Empty)
{
Dlg.ShowErrorInfo("新密码不能为空");
return;
}
if (txtRePass.Text.Trim() == string.Empty)
{
Dlg.ShowErrorInfo("确认密码不能为空");
return;
}
if (txtNewPass.Text.Trim().Equals(txtRePass.Text.Trim()) == false)
{
Dlg.ShowErrorInfo("新密码与确认密码不符");
return;
}
try
{
//检查旧密码是否正确
string _sPass = txtOldPass.Text.Trim();
string mSql;
//加密
_sPass = MD5.Md5Encrypt(_sPass);
mSql = string.Format("SELECT mm FROM PTry WHERE gh='{0}' ", txtGH.Text.Trim());
DataTable mTable = SqlHelper.GetData(mSql);
if (mTable == null)
{
Dlg.ShowErrorInfo("获取操作员信息失败！");
return;
}
if (mTable.Rows.Count < 1)
{
Dlg.ShowErrorInfo("工号输入错误！");
return;
}
if (_sPass != mTable.Rows[0]["mm"].ToString())
{
Dlg.ShowErrorInfo("原密码输入错误");
return;
}
//修改用户密码
string _NewPass = txtNewPass.Text.Trim();
_NewPass = MD5.Md5Encrypt(_NewPass);
mSql = string.Format("update ptry set mm ='{0}' where gh='{1}'", _NewPass, txtGH.Text.Trim());
int ret = SqlHelper.ExecuteNonQuery(mSql);
if (ret > 0)
{
Dlg.ShowOKInfo("修改成功！");
txtOldPass.Text = "";
txtNewPass.Text = "";
txtRePass.Text = "";
return;
}
else
{
Dlg.ShowOKInfo("修改失败！");
return;
}
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(ex.Message);
return;
}
}
private object addControl(string senderName, ModuleList mModule)
{
try
{
Control mCT = null;
string sCtrlName = mModule.MKHSM;
if (PnlClient.Controls.Find(sCtrlName, false).Length > 0) //该页面已存在
{
mCT = PnlClient.Controls.Find(sCtrlName, false)[0];
}
else
{
Assembly myAs;
string sDllFile = mModule.MKWJM;
if (File.Exists(sDllFile))
{
myAs = Assembly.LoadFrom(sDllFile);
}
else
{
myAs = Assembly.GetExecutingAssembly();
}
if (myAs == null)
{
Dlg.ShowErrorInfoAndHelp(string.Format("未找到程序集({0})", mModule.MKWJM));
return(null);
}
Type mType = myAs.GetType(sCtrlName);
if (mType == null)
{
Dlg.ShowErrorInfoAndHelp(string.Format("没有找到窗体({0})！", sCtrlName));
return(1);
}
mCT = (Control)Activator.CreateInstance(mType);
mCT.Name = sCtrlName;
//if (mType.BaseType.Name != "Form" )
//{
// mCT.BackColor = System.Drawing.Color.Transparent;
//}
SetDoubleBuffered(mCT);
//SetBackColorTransParent(mCT);
mCT.Dock = System.Windows.Forms.DockStyle.Fill;
if (mCT is Form)
{
mCT.Show();
}
else
{
mCT.Tag = mModule;
//PnlClient.Controls.Clear();
foreach (Control ctrl in PnlClient.Controls)
{
ctrl.Dispose();
}
PnlClient.Controls.Add(mCT);
}
// mCT.Parent = panel1;
}
if (mCT != null)
{
//for (int i = 0; i < panel1.Controls.Count; i++)
//{
// panel1.Controls[i].Dispose();
//}
mCT.BringToFront();
mCT.Select();
}
LblTip.Text = senderName;
}
catch (Exception ex)
{
Dlg.ShowErrorInfo(string.Format("异常：\n{0}", ex.Message));
return(1);
}
return(0); //0成功
}
