📄 form1.cs
字号:
//无对应收费点情况
if (ret == 1)
{
MessageBox.Show(this, "此工作站不是一个通用收费点工作站！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Application.Exit();
return;
}
//本机是某收费点的工作站的情况
if(ret==0)
{
//判断本收费点是否可用
OracleConnection myConn = Connection.DBConnection;
if (myConn == null)
{
return;
}
int state=0;//收费点状态，0：停用；1：可用
string mySql = "";
mySql ="select State from Charge_Site_Info where SiteID="+m_nSiteID;
OracleCommand dbCommand = new OracleCommand(mySql, myConn);
try
{
OracleDataReader myReader = dbCommand.ExecuteReader();
while (myReader.Read())
{
state=myReader.GetInt32(0);
}
myReader.Close();
myConn.Close();
}
catch
{
E.ShowMessage(ErrorCode.E_8_DBUnknownError_Code);
return;
}
if(state==0)
{
if (m_nAdminRight != 0)
{
E.ShowMessage(8);
this.Close();
return;
}
else //交费管理菜单不可用
{
MessageBox.Show(this, "本收费点已被禁用！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
mnNewCharge.Enabled=false;
}
}
}
}
/// <summary>
/// 获取当前登录的管理员用户ID、权限
/// </summary>
/// <returns>0：成功；1：失败；</returns>
private int AcquireCurrentAdminInfo()
{
OracleConnection myConn = Connection.DBConnection;
string mySql="select t1.userid,t1.right,t1.name "+
"from charge_admin_info t1,charge_ws_info t2 "+
"where t1.username='"+m_sAdminName+"' and "+
"t2.IPAddr='"+CCommonForCharge.getIPAddress() + "'";
OracleCommand dbCommand = new OracleCommand(mySql, myConn);
try
{
OracleDataReader myReader = dbCommand.ExecuteReader();
if (myReader.Read())
{
m_sAdminID = myReader.GetString(0);
m_nAdminRight = myReader.GetInt32(1);
//根据权限设置窗口菜单的可用性,一般管理员则只有“系统”和“交费管理”菜单项可用
if (m_nAdminRight != 0)
{
mnPlatf.Enabled=false;
mnSite.Enabled=false;
mnItemMain.Enabled=false;
}
if(m_nAdminRight == 0)
{
}
}
else
{
E.ShowMessage(8);
return 1;
}
}
catch
{
E.ShowMessage(ErrorCode.E_8_DBUnknownError_Code);
return 1;
}
return 0;
}
/// <summary>
/// 由本机IP地址获取收费点编号和收费点名称
/// </summary>
/// <returns>0：成功；1：无对应收费点；-1：其他情况</returns>
private int AcquireSiteInfo()
{
OracleConnection myConn = Connection.DBConnection;
string mySql = "select t1.SiteID, t1.SiteName " +
"from Charge_Site_Info t1, Charge_R_Site_Ws t2, charge_Ws_Info t3 " +
"where t1.SiteID = t2.SiteID and " +
"t2.WsID = t3.WsID and " +
"t3.IPAddr='" + CCommonForCharge.getIPAddress() + "'";
OracleCommand dbCommand = new OracleCommand(mySql, myConn);
try
{
OracleDataReader dbReader = dbCommand.ExecuteReader();
if (dbReader.Read())
{
m_nSiteID = dbReader.GetInt32(0);
m_sSiteName = dbReader.GetString(1);
}
else //如果该工作站不在任何一个收费点，则返回
{
dbReader.Close();
return 1;
}
dbReader.Close();
}
catch
{
E.ShowMessage(ErrorCode.E_8_DBUnknownError_Code);
return -1;
}
return 0;
}
private void menuItem1_Click(object sender, System.EventArgs e)
{
}
//重新登录
private void mnRelogin_Click(object sender, System.EventArgs e)
{
CfrmLogin frmLogin = new CfrmLogin();
if (frmLogin.ShowDialog(this) == DialogResult.OK)
{
//登录完成，获取登录管理员用户名
m_sAdminName = Connection.LoginUser;
statusBarPanel1.Text = "当前管理员 " + m_sAdminName;
AcquireCurrentAdminInfo();
}
}
//退出通用收费系统
private void mnExit_Click(object sender, System.EventArgs e)
{
this.Close();
}
//修改口令
private void mnPwdSet_Click(object sender, System.EventArgs e)
{
CdlgPwdSet dlgPwdSet = new CdlgPwdSet(m_sAdminName);
dlgPwdSet.ShowDialog(this);
}
//创建项目
private void mnCreateItem_Click(object sender, System.EventArgs e)
{
/*CDefineItem DefineItem=new CDefineItem();
DefineItem.ShowDialog(this);*/
}
//学生交费
private void menuItem3_Click(object sender, System.EventArgs e)
{
}
private void mnCHandIn_Click(object sender, System.EventArgs e)
{
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
/*CdlgSMoneyModify dlgSMoneyModify=new CdlgSMoneyModify();
dlgSMoneyModify.ShowDialog(this);*/
}
private void mnTModify_Click(object sender, System.EventArgs e)
{
/*CdlgTMoneyModify dlgTMoneyModify=new CdlgTMoneyModify();
dlgTMoneyModify.ShowDialog(this);*/
}
private void mnMaintain_Click(object sender, System.EventArgs e)
{
CdlgMaintainForCharge dlgMaintain=new CdlgMaintainForCharge();
dlgMaintain.ShowDialog(this);
}
//开通收费项目
private void menuItem2_Click_1(object sender, System.EventArgs e)
{
COpenChargeItem OpenChargeItem=new COpenChargeItem();
OpenChargeItem.ShowDialog(this);
}
//停止收费项目
private void menuItem4_Click(object sender, System.EventArgs e)
{
CdlgStopChargeItem dlgStopChargeItem=new CdlgStopChargeItem();
dlgStopChargeItem.ShowDialog(this);
}
private void menuItem11_Click(object sender, System.EventArgs e)
{
CdlgItemInfoView dlgItemInfoView=new CdlgItemInfoView();
dlgItemInfoView.ShowDialog(this);
}
private void menuItem13_Click(object sender, System.EventArgs e)
{
ProcessStartInfo StartHelpInfo = null;
StartHelpInfo = new ProcessStartInfo("charge.chm","");
try
{
System.Diagnostics.Process.Start(StartHelpInfo);
}
catch(Exception E)
{
MessageBox.Show(E.Message);
}
}
private void mnQuery_Click(object sender, System.EventArgs e)
{
}
private void menuItem16_Click(object sender, System.EventArgs e)
{
}
private void menuItem16_Click_1(object sender, System.EventArgs e)
{
COffItem offitem=new COffItem();
offitem.ShowDialog(this);
}
private void mnstart_Click(object sender, System.EventArgs e)
{
COpenChargeItem OpenChargeItem=new COpenChargeItem();
OpenChargeItem.ShowDialog(this);
}
private void linkLabel6_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
{
}
private void linkLabel16_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
{
}
private void mnChargeItemView_Click(object sender, System.EventArgs e)
{
CdlgItemInfoView dlgItemInfoView=new CdlgItemInfoView();
dlgItemInfoView.ShowDialog(this);
}
private void mnSchool_Click(object sender, System.EventArgs e)
{
CfrmPlatFOrg frmPlatFOrg = new CfrmPlatFOrg();
frmPlatFOrg.ShowDialog();
}
//部门管理
private void menuItem17_Click(object sender, System.EventArgs e)
{
CfrmPlatFDept frmPlatFDept = new CfrmPlatFDept();
frmPlatFDept.ShowDialog();
}
private void menuItem16_Click_2(object sender, System.EventArgs e)
{
CfrmPlatFMajor frmPlatFMajor = new CfrmPlatFMajor();
frmPlatFMajor.ShowDialog();
}
private void menuItem17_Click_1(object sender, System.EventArgs e)
{
CfrmPlatFClass frmPlatFClass = new CfrmPlatFClass();
frmPlatFClass.ShowDialog();
}
private void menuItem18_Click(object sender, System.EventArgs e)
{
CfrmPlatFStuTree frmPlatFStuTree = new CfrmPlatFStuTree();
frmPlatFStuTree.ShowDialog();
}
private void menuItem22_Click(object sender, System.EventArgs e)
{
CdlgMaintainForCharge dlgMaintain=new CdlgMaintainForCharge();
dlgMaintain.ShowDialog(this);
}
private void menuItem23_Click(object sender, System.EventArgs e)
{
CdlgPwdSet dlgPwdSet = new CdlgPwdSet(m_sAdminName);
dlgPwdSet.ShowDialog(this);
}
private void mnSetItem_Click(object sender, System.EventArgs e)
{
CdlgCreateItem dlg=new CdlgCreateItem();
dlg.ShowDialog();
}
private void mnItemStart_Click(object sender, System.EventArgs e)
{
COpenChargeItem OpenChargeItem=new COpenChargeItem();
OpenChargeItem.ShowDialog(this);
}
private void mnItemStop_Click(object sender, System.EventArgs e)
{
COffItem offitem=new COffItem();
offitem.ShowDialog(this);
}
private void mnItemTask_Click(object sender, System.EventArgs e)
{
CdlgItwmMaintain dlgItwmMaintain=new CdlgItwmMaintain();
dlgItwmMaintain.ShowDialog();
}
private void mnItemView_Click(object sender, System.EventArgs e)
{
CdlgItemInfoView dlgItemInfoView=new CdlgItemInfoView();
dlgItemInfoView.ShowDialog(this);
}
private void menuItem25_Click(object sender, System.EventArgs e)
{
CdlgStat dlgStat=new CdlgStat();
dlgStat.ShowDialog();
}
private void menuItem24_Click(object sender, System.EventArgs e)
{
CdlgPay dlgPay=new CdlgPay();
dlgPay.ShowDialog();
}
private void statusBar1_PanelClick(object sender, System.Windows.Forms.StatusBarPanelClickEventArgs e)
{
}
private void menuItem2_Click_2(object sender, System.EventArgs e)
{
CdlgItwmMaintain dlgItwmMaintain=new CdlgItwmMaintain();
dlgItwmMaintain.ShowDialog();
}
private void menuItem3_Click_1(object sender, System.EventArgs e)
{
CdlgPay dlgPay=new CdlgPay();
dlgPay.ShowDialog();
}
private void menuItem3_Click_2(object sender, System.EventArgs e)
{
CdlgStat dlgStat=new CdlgStat();
dlgStat.ShowDialog();
}
private void menuItem21_Click(object sender, System.EventArgs e)
{
CdlgWs dlgWs=new CdlgWs();
dlgWs.ShowDialog();
}
private void menuItem19_Click(object sender, System.EventArgs e)
{
CfrmPlatFTeaTree frmPlatFTeaTree = new CfrmPlatFTeaTree();
frmPlatFTeaTree.ShowDialog();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -