public bool initialCon()
{
try
{
string strSql = "select wellNo,depName,gprsNo from tbWell";
CDBConnection.getDataTable(ref CDBConnection.m_dtWellInfo, strSql, "tbWell");
//报警下限
strSql = String.Format("select val from tbInfo where des='报警下限'");
string strWarnLevel = CDBConnection.ExecuteScalar(strSql);
CDBConnection.m_iWarnLevel = Convert.ToInt32(strWarnLevel);
//初始化售水表
this.iniSalDt(ref CDBConnection.m_dtSal);
//初始化指令集
this.iniCmds(ref CDBConnection.m_htCmds);
XmlDocument xDoc = new XmlDocument();
xDoc.Load("Info.xml");
string strServerType = xDoc.DocumentElement.SelectSingleNode("./tcpServer").Attributes.GetNamedItem("name").Value.ToString().Trim();
if (strServerType == "server")
{
CDBConnection.m_bServer = true;
}
else
{
if (strServerType == "client")
{
CDBConnection.m_bClient = true;
}
}
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
}
private void frmWaterSys_Load(object sender, System.EventArgs e)
{
try
{
string strSql=string.Format("select softName,userName,version,image from tbAdInfo where userid='{0}'",BengZhan.CDBConnection.m_strUserID);
DataTable dtAdInfo=new DataTable();
BengZhan.CDBConnection.getDataTable(ref dtAdInfo,strSql,"dt");
XmlDocument xDocInfo=new XmlDocument();
xDocInfo.Load(@"ini/sysIni.xml");
xDocInfo.DocumentElement.SelectSingleNode("./abort/softName").Attributes.GetNamedItem("val").Value=dtAdInfo.Rows[0]["softName"].ToString().Trim();
xDocInfo.DocumentElement.SelectSingleNode("./abort/version").Attributes.GetNamedItem("val").Value=dtAdInfo.Rows[0]["version"].ToString().Trim();
xDocInfo.DocumentElement.SelectSingleNode("./abort/user").Attributes.GetNamedItem("val").Value=dtAdInfo.Rows[0]["userName"].ToString().Trim();
xDocInfo.Save(@"ini/sysIni.xml");
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmWaterSys));
// if(dtAdInfo.Rows[0]["image"].ToString().Trim()=="frm1")
// {
//
// BengZhan.frm1 frm=new frm1();
// System.Drawing.Image im=frm.BackgroundImage;
// this.BackgroundImage=im;
//
// }
//
// if(dtAdInfo.Rows[0]["image"].ToString().Trim()=="frmWaterSys1")
// {
// BengZhan.frm2 frm=new frm2();
// System.Drawing.Image im=frm.BackgroundImage;
// this.BackgroundImage=im;
// }
//
// if(dtAdInfo.Rows[0]["image"].ToString().Trim()=="th")
// {
// this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
// }
//System.Drawing.Image im=frm.BackgroundImage;
// string strSql=string.Format("delete from tbcmd insert into tbCmd values('start')");
// BengZhan.CDBConnection.ExecuteSql(strSql);
// this.pictureBox1.Location=new Point((this.toolBar1.Location.Y+this.toolBar1.Height),this.toolBar1.Location.X);
// this.pictureBox1.Height=this.Height-this.pictureBox1.Location.Y;
// this.pictureBox1.Width=this.Width;
//this.pictureBox1.Image=((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
//this.errorProvider2.SetError(this.toolBar1.b,"warn");
//��ʼһ����ͼ
iniWellAmount();
CInsertMenu cInsertM=new CInsertMenu();
cInsertM.EnableMenu(this.mainMenu1);
cInsertM.enableToolbar(this.toolBar1,this.mainMenu1);
//this.enableToolBar();
this.iniFrm();
//*******************************ϵͳ��ʼ��**********************************************
//New.laidianDisplay.GDBConnection GDBC=new New.laidianDisplay.GDBConnection();
//GDBC.initialCDB();
BengZhan.CDBConnection cdb=new CDBConnection();
cdb.initialCon();
//��ʼ��remotingϵͳ��
GprsSoft.serverMonitor.CServer csObj=new GprsSoft.serverMonitor.CServer();
csObj.InitialCServer();
CDBConnection.refreshHis();
//***************************************************************************************
if(BengZhan.CDBConnection.m_bClient==true)
{
this.Text=this.Text+"[�ͻ���]";
}
if(BengZhan.CDBConnection.m_bServer==true)
{
this.Text=this.Text+"[������]";
}
if(m_softName!=null)
{
if(m_softName.Trim()!="")
{
this.Text=m_softName;
//this.Text=m_softName+string.Format(" [��ǰ�û���{0}]",CDBConnection.m_strUserName);
}
}
//this.BackgroundImage=null;
//�Զ��������ݿ�
//this.startFrm();
autoBackup();
this.startTimer();
this.regCom();
this.disToolBar();
this.BackColor=Color.White;
this.Text=this.Text+"[�°�]";
this.Text="��������ϵͳ";
XmlDocument xDoc=new XmlDocument();
xDoc.Load("Server.xml");
string strTitle=xDoc.DocumentElement.SelectSingleNode("./abort/softName").Attributes.GetNamedItem("val").Value.Trim();
this.Text=strTitle;
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void EnableMenu(MainMenu mMenu)
{
try
{
SqlConnection sCon = new SqlConnection(BengZhan.CDBConnection.m_strCon);
sCon.Open();
string strUserID = CDBConnection.m_strUserID;
string strSql = String.Format("select parentManager from tbUsers where userID='{0}'", strUserID);
string strParentManager = CDBConnection.ExecuteScalar(strSql);
if (strParentManager.Trim() != "")
{
strSql = String.Format("select userID from tbUsers where userName='******'", strParentManager.Trim());
string strUID = CDBConnection.ExecuteScalar(strSql).Trim();
strUserID = strUID;
}
strSql = String.Format("select menuName from userMenu where UserID='{0}'", strUserID);
SqlCommand sCmd = new SqlCommand();
sCmd.Connection = sCon;
sCmd.CommandText = strSql;
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = sCmd;
sda.Fill(ds, "userMenu");
DataTable dtUserMenu = ds.Tables["userMenu"];
for (int i = 0; i < mMenu.MenuItems.Count; i++)
{
mMenu.MenuItems[i].Enabled = false;
mMenu.MenuItems[i].Visible = false;
string strParent = mMenu.MenuItems[i].Text.Trim();
for (int x = 0; x < dtUserMenu.Rows.Count; x++)
{
if (strParent == dtUserMenu.Rows[x][0].ToString().Trim())
{
mMenu.MenuItems[i].Enabled = true;
mMenu.MenuItems[i].Visible = true;
break;
}
}
for (int j = 0; j < mMenu.MenuItems[i].MenuItems.Count; j++)
{
mMenu.MenuItems[i].MenuItems[j].Visible = false;
mMenu.MenuItems[i].MenuItems[j].Enabled = false;
for (int y = 0; y < dtUserMenu.Rows.Count; y++)
{
string strChild = mMenu.MenuItems[i].MenuItems[j].Text.Trim();
if (strChild == dtUserMenu.Rows[y][0].ToString().Trim())
{
mMenu.MenuItems[i].MenuItems[j].Visible = true;
mMenu.MenuItems[i].MenuItems[j].Enabled = true;
break;
}
}
}
}
// for(int i=0;i<mMenu.MenuItems.Count;i++)
// {
// mMenu.MenuItems[i].Enabled=true;
// mMenu.MenuItems[i].Visible=true;
//
// }
sCon.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button1_Click(object sender, System.EventArgs e)
{
try
{
if (this.m_frm != null)
{
this.m_frm.Close();
}
XmlDocument xDoc = new XmlDocument();
xDoc.Load("Server.xml");
string strCon = xDoc.DocumentElement.SelectSingleNode("./strCon").InnerText.Trim();
SqlConnection sCon = new SqlConnection(strCon);
try
{
sCon.Open();
BengZhan.CDBConnection.m_strCon = strCon;
}
catch (Exception ex)
{
MessageBox.Show("连接失败，请测试连接！");
return;
}
CDBConnection.m_sCon = sCon;
string strSql = String.Format("select count(*) from tbUsers where userID='{0}' and userPwd='{1}'", this.txtUserName.Text.Trim(), this.txtPwd.Text.Trim());
sCon = new SqlConnection(BengZhan.CDBConnection.m_strCon);
sCon.Open();
SqlCommand sCmd = new SqlCommand();
sCmd.Connection = sCon;
sCmd.CommandText = strSql;
string strCount = sCmd.ExecuteScalar().ToString();
sCon.Close();
int iCount = Convert.ToInt32(strCount);
if (iCount <= 0)
{
MessageBox.Show("用户ID或密码有误！");
return;
}
CDBConnection.m_strUserID = this.txtUserName.Text.Trim();
strSql = String.Format("select userName from tbUsers where userID='{0}'", CDBConnection.m_strUserID);
CDBConnection.m_strUserName = CDBConnection.ExecuteScalar(strSql);
xDoc = new XmlDocument();
xDoc.Load("Server.xml");
xDoc.DocumentElement.SelectSingleNode("./load").Attributes.GetNamedItem("name").Value = CDBConnection.m_strUserID;
xDoc.Save("Server.xml");
if (BengZhan.tools.DBConnection.m_App != null)
{
this.Close();
return;
}
BengZhan.tools.DBConnection.m_App = this;
this.Hide();
this.Visible = false;
frmWaterSys frmWaterSysObj = new frmWaterSys();
frmWaterSysObj.WindowState = System.Windows.Forms.FormWindowState.Maximized;
frmWaterSysObj.Show();
if (xDoc.DocumentElement.SelectSingleNode("./app") == null)
{
return;
}
string strFile = xDoc.DocumentElement.SelectSingleNode("./app").Attributes.GetNamedItem("val").Value.Trim();
System.Diagnostics.Process p = new System.Diagnostics.Process();
p.StartInfo.WorkingDirectory = strFile;
p.StartInfo.FileName = "bengzhan.exe";
//Info.WorkingDirectory
p.Start();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
