private void button1_Click(object sender, EventArgs e)
{
try
{
if (txtpwd.Text.Trim()==""||comboBox1.Text=="")
{
MessageBox.Show("�û��������벻��Ϊ�գ�", "��ʾ",//������Ϣ�Ի���
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;//�˳��¼�
}
else
{
string name = comboBox1.Text;//��ȡ�û���
string pwd = txtpwd.Text.Trim();//��ȡ����
SqlConnection conn = DBConnection.MyConnection();//�������ݿ����Ӷ���
conn.Open();//�����ݿ�����
SqlCommand cmd = new SqlCommand(//�������ݿ��������
"select * from HPES_user where name='" + name + "' and password='******'", conn);
SqlDataReader sdr = cmd.ExecuteReader();//�������ݶ�ȡ��
sdr.Read();//��ȡ����
if (sdr.HasRows)//�ж��Ƿ�������
{
string time = DateTime.Now.ToString();//�õ�ʱ����Ϣ
string sql = //����SQL�ַ���
"update HPES_user set logintime='" + time + "' where name='" + name + "'";
operate.OperateData(sql);//�������ݿ���Ϣ
this.MdiParent.Close();//�رո�����
conn.Close();//�ر�����
frmMain Main = new frmMain();//�������������
//Main.loginuser.Text = name;//Ϊ�ֶθ�ֵ
//Main.Logintime.Text = time;//Ϊ�ֶθ�ֵ
Main.Show();//��ʾ������
}
else
{
txtpwd.Text = "";//����ı�����
comboBox1.Text = "";//����ı�����
MessageBox.Show("�û������������", "��ʾ",//������Ϣ�Ի���
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)//�����쳣
{
MessageBox.Show(ex.Message);//������Ϣ�Ի���
}
}
private void btnCalcAll_Click(object sender, EventArgs e)
{
frm = (frmMain)this.ParentForm;
frm.lblSysMessage.Text = "正在检查各系统输入信息...";
if (this.edtHISServerIP.Text == "" || this.edtHISPassword.Text == "" || this.edtHISUserName.Text == "") {
MessageBox.Show("请先输入军卫一号系统数据库连接信息后再执行本操作。", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
frm.lblSysMessage.Text = "系统已就绪。";
return;
}
/*if (this.edtFISServerIP.Text == "" || this.edtFISDBName.Text == "" || this.edtFISUserName.Text == "")
{
MessageBox.Show("请先输入军财一号系统数据库连接信息后再执行本操作。", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
frm.lblSysMessage.Text = "系统已就绪。";
return;
}
*/
try
{
frm.lblSysMessage.Text = "正在尝试连接军卫一号系统数据库...";
frm.StatusBar1.Refresh();
Console.WriteLine("正在尝试连接军卫一号系统数据库...");
//oleconnhis.ConnectionString = "Provider=MSDAORA.Oracle;Data Source=" + this.edtHISServerIP.Text + ";Initial Catalog=" + this.edtHISDBName.Text + ";User Id=" + this.edtHISUserName.Text + ";Password="******";";
oleconnhis.ConnectionString = "Provider=MSDAORA.Oracle;Data Source=" + this.edtHISServerIP.Text + ";User Id=" + this.edtHISUserName.Text + ";Password="******";";
oleconnhis.Open();
}
catch (Exception exec)
{
MessageBox.Show("连接军卫一号系统数据库时出现错误，请检查您输入的连接信息或网络连接。\n错误代码：" + exec.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
frm.lblSysMessage.Text = "系统已就绪。";
////return;
}
/*
try
{
frm.lblSysMessage.Text = "正在尝试连接军财一号系统数据库...";
Console.WriteLine("正在尝试连接军财一号系统数据库...");
oleconnfis.ConnectionString = "Provider=sqloledb;Data Source=" + this.edtFISServerIP.Text + ";Initial Catalog=" + this.edtFISDBName.Text + ";User Id=" + this.edtFISUserName.Text + ";Password="******";";
oleconnfis.Open();
}
catch (Exception exec)
{
MessageBox.Show("连接军财一号系统数据库时出现错误，请检查您输入的连接信息或网络。\n" + exec.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
frm.lblSysMessage.Text = "系统已就绪。";
return;
}
*/
frm.lblSysMessage.Text = "各系统数据库连接就绪，正在准备查询...";
frm.StatusBar1.Refresh();
Console.WriteLine("各系统数据库连接就绪，正在准备查询...");
this.hpes_standard_pointTableAdapter.Fill(this.dsPoint.hpes_standard_point);
DataTable dt= this.dsPoint.hpes_standard_point;
//int oid, tid, pid;
string sName = "";
string sSQL;
string sParameters;
string[] aParameters;
string sBEGINDATE, sENDDATE;
string sFields = "";
string sQID;
OleDbCommand command;
OleDbDataReader reader;
OleDbCommand UpdateCommand = new OleDbCommand();
UpdateCommand.Connection = this.hpes_standard_pointTableAdapter.Connection;
command = new OleDbCommand();
command.Connection = this.hpes_standard_pointTableAdapter.Connection;
if (command.Connection.State == ConnectionState.Closed) command.Connection.Open();
GridEXRow[] rows;
rows = gridEX1.GetRows();
foreach (GridEXRow row in rows)
{
row.GridEX.MoveToRowIndex(row.Position);
sQID = row.Cells[1].Value.ToString();
sName = row.Cells[3].Value.ToString();
sSQL = row.Cells[4].Value.ToString();
sBEGINDATE = row.Cells[6].Value.ToString().Replace("-", "");
sENDDATE = row.Cells[7].Value.ToString().Replace("-", "");
sFields = row.Cells[8].Value.ToString();
//MessageBox.Show(row.Children.ToString());
//GridEXRow childrow = childrows.First();
String[] aFields = sFields.Split(';');
sParameters = row.Cells[5].Value.ToString();
aParameters = sParameters.Split(';');
foreach (String sParameter in aParameters) {
switch (sParameter){
case "BEGINDATE":
sSQL = sSQL.Replace("BEGINDATE", sBEGINDATE);
break;
case "ENDDATE":
sSQL = sSQL.Replace("ENDDATE", sENDDATE);
break;
default:
Console.WriteLine("无法识别的查询参数： {0}", sParameter);
break;
}
}
frm.lblSysMessage.Text="即将执行查询: "+ sName;
Console.WriteLine("即将执行查询: {0}\n查询语句: {1}", sName, sSQL);
try
{
command = new OleDbCommand(sSQL, oleconnhis);
reader = command.ExecuteReader();
if (reader.HasRows)
{
frm.lblSysMessage.Text = "找到数据，准备插入数据库...";
Console.WriteLine("找到数据，准备插入数据库。");
while (reader.Read())
{
string sTemp = "";
for (int i = 0; i < aFields.Length; i++)
{
sTemp += aFields[i] + ": " + reader[i].ToString();
}
frm.lblSysMessage.Text = sTemp;
sSQL = @"INSERT INTO hpes_query_data (HID, YID, QID, " + sFields + ") VALUES (" + hid.ToString() + ", " + yid.ToString() + ", " + sQID + ", ";
for (int i = 0; i < reader.FieldCount; i++)
{
sSQL += reader[i].ToString() + ", ";
}
sSQL += ")";
Console.WriteLine(reader[0].ToString());
UpdateCommand.CommandText = sSQL;
UpdateCommand.ExecuteNonQuery();
}
}
else
{
Console.WriteLine("没有找到符合条件的数据。");
}
reader.Close();
if (row.Position <= gridEX1.RecordCount)
{
frm.uiProgressBar1.Value = (row.Position) * 100 / gridEX1.RecordCount;
}
else
frm.uiProgressBar1.Value = frm.uiProgressBar1.Maximum;
}
catch (Exception exec) {
MessageBox.Show("执行查询时出现错误，请检查数据库连接或查询语句。\n错误代码：" + exec.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
//frm.lblSysMessage.Text = "系统已就绪。";
}
}
frm.lblSysMessage.Text = "系统已就绪，请继续使用。";
}
private void frmSubjectEval_Load(object sender, EventArgs e)
{
frm = (frmMain)this.ParentForm;
if (frm.cboHospital.ComboBox.SelectedValue == null || frm.cboYear.ComboBox.SelectedValue == null)
{
MessageBox.Show("请先选择要考评的医院和考评年度。", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
hid = int.Parse(frm.cboHospital.ComboBox.SelectedValue.ToString());
yid = int.Parse(frm.cboYear.ComboBox.SelectedValue.ToString());
// TODO: 这行代码将数据加载到表“dsQuery.hpes_query”中。您可以根据需要移动或移除它。
this.hpes_queryTableAdapter.Fill(this.dsQuery.hpes_query);
this.hpes_query_dataTableAdapter.Fill(this.dsQuery.hpes_query_data, hid, yid);
OleDbCommand command = new OleDbCommand();
OleDbDataReader reader;
command.Connection = this.hpes_standard_pointTableAdapter.Connection;
if (command.Connection.State == ConnectionState.Closed) command.Connection.Open();
command.CommandText = "SELECT StartDate, endDate FROM hpes_time WHERE YID = " + yid.ToString();
reader = command.ExecuteReader();
reader.Read();
DateTime dBEGINDATE = Convert.ToDateTime(reader[0].ToString());
DateTime dENDDDATE = Convert.ToDateTime(reader[1].ToString());
string sBEGINDATE = dBEGINDATE.ToString("yyyy-MM-dd");
string sENDDATE = dENDDDATE.ToString("yyyy-MM-dd");
GridEXRow[] rows;
rows = gridEX1.GetRows();
foreach (GridEXRow row in rows)
{
row.BeginEdit();
row.Cells[6].Value = sBEGINDATE;
row.Cells[7].Value = sENDDATE;
row.EndEdit();
}
}
private void frmSubjectEval_Activated(object sender, EventArgs e)
{
frm = (frmMain)this.ParentForm;
if (frm.cboHospital.ComboBox.SelectedValue!=null) {
this.dsHospitalTableAdapter1.Fill(this.dsHospital1._dsHospital);
this.dsHospital1._dsHospital.DefaultView.RowFilter = "ID = " + frm.cboHospital.ComboBox.SelectedValue.ToString();
if (this.dsHospital1._dsHospital.Rows[0]["HISServer"] != null)
{
this.edtHISServerIP.Text = this.dsHospital1._dsHospital.Rows[0]["HISServer"].ToString();
this.edtHISUserName.Text = this.dsHospital1._dsHospital.Rows[0]["HISUserName"].ToString();
this.edtHISPassword.Text = this.dsHospital1._dsHospital.Rows[0]["HISPassword"].ToString();
}
if (this.dsHospital1._dsHospital.Rows[0]["FISServer"] != null)
{
this.edtFISServerIP.Text = this.dsHospital1._dsHospital.Rows[0]["FISServer"].ToString();
this.edtFISDBName.Text = this.dsHospital1._dsHospital.Rows[0]["FISDBName"].ToString();
this.edtFISUserName.Text = this.dsHospital1._dsHospital.Rows[0]["FISUserName"].ToString();
this.edtFISPassword.Text = this.dsHospital1._dsHospital.Rows[0]["FISPassword"].ToString();
}
}
}
private void uiButton1_Click(object sender, EventArgs e)
{
if (nameTxt.Text == "" || pwdTxt.Text == "")//判断用户名和密码是否为空
{
MessageBox.Show("用户名或密码不能为空！",//弹出消息对话框
"提示", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;//退出事件
}
else
{
string name = nameTxt.Text.Trim();//移除用户名前部和后部的空格
string pwd = pwdTxt.Text.Trim();//移除密码前部和后部的空格
SqlConnection conn = DBClass.DBConnection.MyConnection();//创建数据库连接对象
conn.Open();//连接到SQL数据库
//SqlCommand cmd = new SqlCommand(//创建数据库命令对象
// "select * from HPES_user where name='" +
// name + "' and password='******'", conn);
SqlCommand cmd = new SqlCommand("select * from HPES_user where name='" + name + "' and password='******'", conn);
SqlDataReader sdr = cmd.ExecuteReader();//得到数据读取器对象
sdr.Read();//读取一条记录
if (sdr.HasRows)//判断是否包含数据
{
string time = DateTime.Now.ToString();//得到系统时间字符串
string sql = "update HPES_user set logintime='" //设置更新数据库的SQL语句
+ time + "' where name='" + name + "'";
operate.OperateData(sql);//更新数据库内容
conn.Close();//关闭数据库连接
//this.Hide();//隐藏窗体
//FrmMain main = new FrmMain();//创建主窗体对象
////main.loginuser.Text = name;//为主窗体字段赋值
////main.Logintime.Text = time;//为主窗体字段赋值
//main.Show();//显示主窗体
frmMain frmMain = new frmMain();
frmMain.Show();
this.Hide();
}
else
{
nameTxt.Text = "";//清空用户名
pwdTxt.Text = "";//清空密码
MessageBox.Show("用户名或密码错误！", "提示",//弹出消息对话框
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
