/// <summary> /// 用username/ygbh获取信息 /// </summary> /// <param name="sbbh">username/ygbh</param> /// <returns>bool</returns> public SYS.Model.YGB getXXbyuserName(string userName) { string sql = "select * from YGB where YGBH=@userName or User_Name=@userName"; SqlParameter[] spr = { new SqlParameter("@userName", userName) }; try { SYS.Model.YGB sb = new SYS.Model.YGB(); DataTable dt = new DataTable(); dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { sb.YGBH = dt.Rows[0]["YGBH"].ToString(); sb.YGXM = dt.Rows[0]["YGXM"].ToString(); sb.DHHM = dt.Rows[0]["DHHM"].ToString(); sb.YGZWBH = int.Parse(dt.Rows[0]["YGZWBH"].ToString()); sb.YGSFZ = dt.Rows[0]["YGSFZ"].ToString(); sb.YGZT = dt.Rows[0]["YGZT"].ToString(); sb.User_Name = dt.Rows[0]["User_Name"].ToString(); sb.Password = dt.Rows[0]["Password"].ToString(); } return(sb); } catch (Exception) { throw; } }
/// <summary> /// 用username和password检测是否存在 /// </summary> /// <param name="sbbh">设备编号</param> /// <returns>bool</returns> public bool checkYgbhIsAlive(string ygbh) { string sql = "select * from YGB where YGBH=@ygbh"; SqlParameter[] spr = { new SqlParameter("@ygbh", ygbh) }; try { SYS.Model.YGB sb = new SYS.Model.YGB(); DataTable dt = new DataTable(); dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception) { return(false); } }
/// <summary> /// 用username和password检测是否存在 /// </summary> /// <param name="sbbh">设备编号</param> /// <returns>bool</returns> public bool checkIsRight(string userName, string password) { string sql = "select * from YGB where (YGBH=@userName or User_Name=@userName) and Password=@password"; SqlParameter[] spr = { new SqlParameter("@userName", userName), new SqlParameter("@password", password) }; try { SYS.Model.YGB sb = new SYS.Model.YGB(); DataTable dt = new DataTable(); dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception) { return(false); } }
public bool Update(SYS.Model.YGB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ygb set "); strSql.Append("YGBH=@YGBH,"); //=@PZLX,"); strSql.Append("YGXM=@YGXM,"); //=@JCCLPH,"); strSql.Append("DHHM=@DHHM,"); //=@CLXHBH,"); strSql.Append("YGZWBH=@YGZWBH,"); //=@JCCS,"); strSql.Append("YGSFZ=@YGSFZ,"); //=@CCRQ,"); strSql.Append("YGZT=@YGZT,"); //=@DJRQ,"); strSql.Append("User_Name=@User_Name,"); //=@FDJH,"); strSql.Append("Password=@Password "); //=@CJH,"); strSql.Append("where ygbh=@YGBH or User_Name=@User_Name"); SqlParameter[] parameters = { new SqlParameter("@YGBH", SqlDbType.VarChar, 32), new SqlParameter("@YGXM", SqlDbType.VarChar, 32), new SqlParameter("@DHHM", SqlDbType.VarChar, 32), new SqlParameter("@YGZWBH", SqlDbType.Int, 4), new SqlParameter("@YGSFZ", SqlDbType.VarChar, 32), new SqlParameter("@YGZT", SqlDbType.VarChar, 32), new SqlParameter("@User_Name", SqlDbType.VarChar, 32), new SqlParameter("@Password", SqlDbType.VarChar, 32) }; parameters[0].Value = model.YGBH; parameters[1].Value = model.YGXM; parameters[2].Value = model.DHHM; parameters[3].Value = model.YGZWBH; parameters[4].Value = model.YGSFZ; parameters[5].Value = model.YGZT; parameters[6].Value = model.User_Name; parameters[7].Value = model.Password; try { int rows = DBHelperSQL.Execute(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
public bool AddNewUser(SYS.Model.YGB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ygb ("); strSql.Append("YGBH,"); //=@PZLX,"); strSql.Append("YGXM,"); //=@JCCLPH,"); strSql.Append("DHHM,"); //=@CLXHBH,"); strSql.Append("YGZWBH,"); //=@JCCS,"); strSql.Append("YGSFZ,"); //=@CCRQ,"); strSql.Append("YGZT,"); //=@DJRQ,"); strSql.Append("User_Name,"); //=@FDJH,"); strSql.Append("Password)"); //=@CJH,"); strSql.Append("values (@YGBH,@YGXM,@DHHM,@YGZWBH,@YGSFZ,@YGZT,@User_Name,@Password)"); SqlParameter[] parameters = { new SqlParameter("@YGBH", SqlDbType.VarChar, 32), new SqlParameter("@YGXM", SqlDbType.VarChar, 32), new SqlParameter("@DHHM", SqlDbType.VarChar, 32), new SqlParameter("@YGZWBH", SqlDbType.Int, 4), new SqlParameter("@YGSFZ", SqlDbType.VarChar, 32), new SqlParameter("@YGZT", SqlDbType.VarChar, 32), new SqlParameter("@User_Name", SqlDbType.VarChar, 32), new SqlParameter("@Password", SqlDbType.VarChar, 32) }; parameters[0].Value = model.YGBH; parameters[1].Value = model.YGXM; parameters[2].Value = model.DHHM; parameters[3].Value = model.YGZWBH; parameters[4].Value = model.YGSFZ; parameters[5].Value = model.YGZT; parameters[6].Value = model.User_Name; parameters[7].Value = model.Password; try { if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }