/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int insert(loginModel model) { //定义添加sql string sql = "insert cc values(@name,@pwd,default)"; //集合存储值 SqlParameter[] sqlpar = new SqlParameter[] { new SqlParameter("@name", model.name), new SqlParameter("@pwd", model.pwd), }; //定义查询sql string sql2 = "select * from cc where name=@name"; //查询所需的参数 SqlParameter[] sqlpar2 = new SqlParameter[] { new SqlParameter("@name", model.name), }; int num = 0; //执行查询判断是否存在相同值 object cx = DBhelp.select(sql2, sqlpar2); if (cx != null) { //返回一个数字(任意数字即可,前台判断所用) return(num = 66); } //执行添加语句 num = DBhelp.Notquery(sql, sqlpar); return(num); }
/// <summary> /// 根据级别进行查询营销额 /// </summary> /// <param name="num"></param> /// <returns></returns> public static object selectListsale(string num) { SqlParameter[] sqlpar = new SqlParameter[] { new SqlParameter("@num", num) }; object sdr = DBhelp.select("Listsale", sqlpar); return(sdr); }
/// <summary> /// 根据用户级别进行查询总人数 /// </summary> /// <param name="num"></param> /// <returns></returns> public static object selectUsergrade(string num) { SqlParameter[] sqlpar = new SqlParameter[] { new SqlParameter("@num", num) }; object sdr = DBhelp.select("selectnumber", sqlpar); return(sdr); }
/// <summary> /// 根据用户名密码查询 /// </summary> /// <param name="Username"></param> /// <param name="Userpassword"></param> /// <returns></returns> public static object Userslogin(string Username, string Userpassword) { SqlParameter[] sqlpar = new SqlParameter[] { new SqlParameter("@Username", Username), new SqlParameter("@Userpassword", Userpassword), }; object obj = DBhelp.select("Userslogin", sqlpar); return(obj); }
/// <summary> /// 分页 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="docount"></param> /// <returns></returns> public static object Userspaging(int pageIndex, int pageSize, out int docount) { docount = 1; SqlParameter[] sqlpar = new SqlParameter[] { new SqlParameter("@pageindex", pageIndex), new SqlParameter("@pagesize", pageSize), new SqlParameter("@docount", docount), }; //sqlpar[2].Direction = ParameterDirection.Output; object dt = DBhelp.select("Userspaging", sqlpar); //docount = Convert.ToInt32(sqlpar[2].Value); return(dt); }
/// <summary> /// 根据账号密码进行查询 /// </summary> /// <param name="name"></param> /// <param name="pwd"></param> /// <returns></returns> public static object selectone(string name, string pwd) { //创建连接字符串 string sql = "select * from cc where name=@name and pow=@pwd"; //创建sqlpar SqlParameter[] sqlpar = new SqlParameter[] { new SqlParameter("@name", name), new SqlParameter("@pwd", pwd) }; //方法调用 object num = DBhelp.select(sql, sqlpar); return(num); }