/// <summary> /// 存储过程 登录 /// </summary> /// <param name="phone">电话号码</param> /// <param name="pwd">密码</param> /// <returns>0-账号不存在 1-密码错误 2-登录成功</returns> public static int LoginUserInfo(string phone, string pwd, string work) { SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@phone", phone), new SqlParameter("@password", pwd), new SqlParameter("@num", SqlDbType.Int), new SqlParameter("@work", work) }; paras[2].Direction = ParameterDirection.Output; DBHelper.GetDataTableByProcedure("LoginSales", paras); return((int)paras[2].Value); }
/// <summary> /// 获取商品列表的分页数据 /// </summary> /// <param name="pageSize">每页行数</param> /// <param name="pageIndex">第几页</param> /// <param name="ClassID">商品分类</param> /// <returns>商品数据集</returns> public static List <DatailsMode1> SelectProductByPaging(int pageSize, int pageIndex) { SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@pagesize", pageSize), new SqlParameter("@pageindex", pageIndex), }; DataTable dt = DBHelper.GetDataTableByProcedure("chaxun", paras); List <DatailsMode1> list = new List <DatailsMode1>(); if (dt != null && dt.Rows.Count >= 1) { foreach (DataRow item in dt.Rows) { DatailsMode1 DM = new DatailsMode1(); //点赞数 DM.Like_number = int.Parse(item["Like_number"].ToString()); //封面路径 DM.Project_cover = item["Project_cover"].ToString(); //项目名称 DM.Project_Name = item["Project_Name"].ToString(); //目标筹集天数 DM.Raise_day = int.Parse(item["Raise_day"].ToString()); //预计筹集金额 DM.Project_Money = double.Parse(item["Project_Money"].ToString()); //筹集进度 DM.Financing_state = item["Financing_state"].ToString(); //已获得经资 DM.Raised_amount = double.Parse(item["Raised_amount"].ToString()); //项目ID DM.ProjectID = int.Parse(item["ProjectID"].ToString()); //筹集百分比 double nu = DM.Raised_amount / DM.Project_Money * 100; DM.chouji = double.Parse(nu.ToString("F2")); //DM.chouji = (int)DM.Raised_amount / (int)DM.Project_Money * 100; //结束日期 DM.Closing_date = DateTime.Parse(item["Closing_date"].ToString()); //DM.Release_date = DateTime.Parse(item["Release_date"].ToString()); //剩余天数 DM.shengyutime = DM.Closing_date.DayOfYear - DateTime.Now.DayOfYear; if (DM.Closing_date <= DateTime.Now) { DM.shengyutime = 0; if (DM.Project_Money == DM.Raised_amount) { DM.Financing_state = "已完成"; } else { DM.Financing_state = "已结束"; } } list.Add(DM); } return(list); } else { return(null); } }