Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string yhdm = this.textBox1.Text;

            if (yhdm != "") 
            {
                LYC.BLL.User user = new LYC.BLL.User();
                LYC.Model.UserInfo userinfo = new LYC.Model.UserInfo();
                userinfo =  user.getUser(yhdm);
            }
           
        }
Exemplo n.º 2
0
        public IList<UserInfo> GetUsers()
        {
            IList<UserInfo> users = new List<UserInfo>();

            using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.ConnHIS, SQL3))
            {
                while (rdr.Read())
                {
                    UserInfo user = new UserInfo(Convert.ToInt16(rdr["XTSB"]), rdr["YHDM"].ToString(), rdr["YHZM"].ToString(), rdr["YHMC"].ToString(), rdr["YHKL"].ToString());
                    users.Add(user);
                }
             
                return users;

            }
        }
Exemplo n.º 3
0
        private  SqlParameter[] GetParms(UserInfo user)
        {

            SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter(PARM_XTSB,SqlDbType.SmallInt),
                new SqlParameter(PARM_YHDM,SqlDbType.VarChar,4),
                new SqlParameter(PARM_YHZM,SqlDbType.VarChar,20),
                new SqlParameter(PARM_YHMC,SqlDbType.VarChar,10),
                new SqlParameter(PARM_YHKL,SqlDbType.VarChar,10)
            };
            parms[0].Value = user.Xtsb;
            parms[1].Value = user.Yhdm;
            parms[2].Value = user.Yhzm;
            parms[3].Value = user.Yhmc;
            parms[4].Value = user.Yhkl;
            return parms;
        }
Exemplo n.º 4
0
        public UserInfo GetUser(string yhdm)
        {
            UserInfo user = new UserInfo();
            SqlParameter parm = new SqlParameter();
            parm.ParameterName = PARM_YHDM;
            parm.Value = yhdm;
            parm.SqlDbType = SqlDbType.VarChar;
            parm.Size = 4;
            using (SqlDataReader rdr = SQLHelper.ExecuteReaderWithParm(SQLHelper.ConnHIS,SQL1,parm))
            {
                 if (rdr.Read())
                {
                    user = new UserInfo(Convert.ToInt16(rdr["XTSB"]), rdr["YHDM"].ToString(), rdr["YHZM"].ToString(), rdr["YHMC"].ToString(), rdr["YHKL"].ToString());   
                }

            }
            return user;
        }
Exemplo n.º 5
0
 public int AddUser(UserInfo user)
 {
     SqlParameter[] parms = GetParms(user);
     int val = SQLHelper.ExecuteNonQueryWithParms(SQLHelper.ConnHIS, SQL4, parms);
     return val;
 }