Esempio n. 1
0
        private void btn_ok_Click(object sender, EventArgs e)
        {
            if (rbt_ZG.Checked == true)
            {
                sbjgbh      = ConfigurationManager.AppSettings["sbjgbh_ZGYB"].ToString(); //社保机构编号(职工)
                yybm        = ConfigurationManager.AppSettings["yybm"].ToString();        //医院编码
                UserCode_DW = ConfigurationManager.AppSettings["UserCode_DW"].ToString(); //医保登录用户名
                Password_DW = ConfigurationManager.AppSettings["Password_DW"].ToString(); //医保登录密码
                BXLX        = "职工";
            }
            if (rbt_JM.Checked == true)
            {
                sbjgbh      = ConfigurationManager.AppSettings["sbjgbh_JMYB"].ToString(); //社保机构编号(居民)
                yybm        = ConfigurationManager.AppSettings["yybm"].ToString();        //医院编码
                UserCode_DW = ConfigurationManager.AppSettings["UserCode_DW"].ToString(); //医保登录用户名
                Password_DW = ConfigurationManager.AppSettings["Password_DW"].ToString(); //医保登录密码
                BXLX        = "居民";
            }
            this.Hide();

            FrmsbjgSelect fsbjg = new FrmsbjgSelect();

            fsbjg.ShowDialog();

            sbjgbh = fsbjg.selSbjgBH;
            string networkPatclassID = fsbjg.fglyComtext;

            fsbjg.Close();
            MainForm frm = new MainForm(UserCode, UserName, HOSPITAL_ID, HOSPITAL_NAME, sbjgbh, yybm, UserCode_DW, Password_DW, networkPatclassID);

            frm.ShowDialog();
            this.Close();
            this.Dispose();
        }
Esempio n. 2
0
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            var time = DateTime.Now;

            UserCode      = text_UserCode.Text.ToString().Trim();
            Password      = text_Password.Text.ToString().Trim();
            UserName      = textBox_CzyXm.Text.ToString().Trim();
            HOSPITAL_ID   = cmb_Hos.SelectedValue.ToString();
            HOSPITAL_NAME = cmb_Hos.Text;
            if (UserCode == "" || UserName == "")
            {
                MessageBox.Show("请正确输入用户名回车后再进行登录!");
                this.text_UserCode.Focus();
                return;
            }
            else if (Password == "")
            {
                MessageBox.Show("请输入密码后再进行登录!");
                this.text_Password.Focus();
                return;
            }
            else
            {
                string        PassWord_JM = StringHelper.GetMD5String(Password);
                StringBuilder strSql      = new StringBuilder();
                strSql.Append(" SELECT DISTINCT a.USER_CODE,a.UESR_NAME,a.PASSWORD,a.HOSPITAL_ID,c.HOSPITAL_NAME FROM COMM.COMM.USERINFO_VIEW a ");
                strSql.Append(" LEFT JOIN COMM.COMM.ROLES_VS_SYS b ON b.ROLE_ID = a.ROLE_ID ");
                strSql.Append(" LEFT JOIN COMM.COMM.HOSPITALS c ON c.HOSPITAL_ID = a.HOSPITAL_ID ");
                strSql.Append(" WHERE b.SYS_ID IN ('1','3') AND a.FLAG_SYSINVALID=0 ");
                strSql.Append(" AND USER_CODE= '" + UserCode + "' AND a.HOSPITAL_ID='" + HOSPITAL_ID + "' ");//AND a.PASSWORD='******'

                DataTable dtRe = new DataTable();
                dtRe = SQLHelper.ExecSqlReDs(strSql.ToString()).Tables[0];
                if (dtRe.Rows.Count == 0)
                {
                    MessageBox.Show("用户不存在或无此登陆权限");
                    return;
                }
                else if (dtRe.Rows[0]["PASSWORD"].ToString().Trim() != PassWord_JM) //判断密码
                {
                    MessageBox.Show("密码不正确");
                    this.text_Password.Text = "";
                    text_Password.Focus();
                    return;
                }
                this.Hide();
                StringBuilder strSql2 = new StringBuilder();
                strSql2.Append(" SELECT TOP 1  INSTITUTION_CODE, INSTITUTION_NAME, INSTITUTION_USER_CODE, INSTITUTION_PASSWORD ");
                strSql2.Append(" FROM COMM.DICT.NETWORK_VS_INSTITUTION ");
                strSql2.Append(" WHERE HOSPITAL_ID='" + HOSPITAL_ID + "' ");
                dtRe = new DataTable();
                dtRe = SQLHelper.ExecSqlReDs(strSql2.ToString()).Tables[0];
                if (dtRe.Rows.Count == 0)
                {
                    MessageBox.Show("用户不存在或无此登陆权限");
                    return;
                }
                sbjgbh      = ConfigurationManager.AppSettings["sbjgbh_JMYB"].ToString(); //社保机构编号(居民)
                yybm        = dtRe.Rows[0]["INSTITUTION_CODE"].ToString();                //医院编码
                UserCode_DW = dtRe.Rows[0]["INSTITUTION_USER_CODE"].ToString();           //医保登录用户名
                Password_DW = dtRe.Rows[0]["INSTITUTION_PASSWORD"].ToString();            //医保登录密码


                FrmsbjgSelect fsbjg = new FrmsbjgSelect();
                fsbjg.ShowDialog();

                sbjgbh            = fsbjg.selSbjgBH;
                networkPatclassID = "";//fsbjg.fglyComtext;

                fsbjg.Close();
                //LOGIN.Sel_SBJG frm = new LOGIN.Sel_SBJG(this.text_UserCode.Text.ToString(), this.textBox_CzyXm.Text.ToString(), HOSPITAL_ID, HOSPITAL_NAME);
                MainForm frm = new MainForm(UserCode, UserName, HOSPITAL_ID, HOSPITAL_NAME, sbjgbh, yybm, UserCode_DW, Password_DW, networkPatclassID);
                frm.ShowDialog();
                this.Close();
                this.Dispose();
            }
        }