/// <summary> /// kb 验证手机验证码 /// </summary> /// <param name="module">模块</param> /// <param name="Phone">手机号码</param> /// <param name="PhoneCode">验证码</param> /// <returns></returns> public Hi.Model.SYS_PhoneCode GetModel(string module, string Phone, string PhoneCode) { string sqlstr = "select top 1 * from SYS_PhoneCode where DATEDIFF(minute,CreateDate,GETDATE()) between 0 and 30 and ispast=0 and module=@Module and Phone=@Phone and PhoneCode=@PhoneCode order by createdate desc"; SqlParameter[] Sqlparams = { new SqlParameter("@Module", SqlDbType.VarChar, 50), new SqlParameter("@Phone", SqlDbType.VarChar, 11), new SqlParameter("@PhoneCode", SqlDbType.VarChar, 50) }; Sqlparams[0].Value = module; Sqlparams[1].Value = Phone; Sqlparams[2].Value = PhoneCode; DataSet ds = SqlHelper.Query(SqlHelper.LocalSqlServer, sqlstr, Sqlparams); if (ds.Tables[0].Rows.Count > 0) { DataRow r = ds.Tables[0].Rows[0]; return(Common.GetListEntity <Hi.Model.SYS_PhoneCode>(ds.Tables[0])[0]); } else { return(null); } }
/// <summary> /// kb 验证手机验证码 /// </summary> /// <param name="module">模块</param> /// <param name="Phone">手机号码</param> /// <param name="PhoneCode">验证码</param> /// <returns></returns> public List <Hi.Model.SYS_PhoneCode> GetListModel(string module, string Phone) { string sqlstr = "select * from SYS_PhoneCode where DATEDIFF(minute,CreateDate,GETDATE()) between 0 and 60 and ispast=0 and module=@Module and Phone=@Phone order by createdate desc"; SqlParameter[] Sqlparams = new SqlParameter[] { new SqlParameter("@Module", SqlDbType.VarChar, 50), new SqlParameter("@Phone", SqlDbType.VarChar, 11), }; Sqlparams[0].Value = module; Sqlparams[1].Value = Phone; DataSet ds = SqlHelper.Query(SqlHelper.LocalSqlServer, sqlstr, Sqlparams); return(Common.GetListEntity <Hi.Model.SYS_PhoneCode>(ds.Tables[0])); }
public List <Hi.Model.SYS_NewsNotice> QueryGroupNewList(string strWhart) { if (string.IsNullOrEmpty(strWhart)) { strWhart = "*"; } string SqlQuery = @"select " + strWhart + @", row_number() over(order by CreateDate desc ) rowsid from SYS_NewsNotice where dr='0' and (NewsType=1 or NewsType=3) and IsTop='1' and IsEnabled='1' union all select " + strWhart + @", row_number() over(order by CreateDate desc ) rowsid from SYS_NewsNotice where dr='0' and NewsType=2 and IsTop='1' and IsEnabled='1' "; DataSet ds = SqlHelper.Query(SqlHelper.LocalSqlServer, SqlQuery.ToString()); return(Common.GetListEntity <Hi.Model.SYS_NewsNotice>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_Promotion> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_Promotion>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.DIS_Integral> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.DIS_Integral>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_GoodsCustoms> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_GoodsCustoms>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.PAY_FastPayMent> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.PAY_FastPayMent>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.SYS_NewsNotice> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.SYS_NewsNotice>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.PAY_Financing> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.PAY_Financing>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_DisPriceInfo> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_DisPriceInfo>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_TemplateAttrValue> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_TemplateAttrValue>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_RebateDetail> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_RebateDetail>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.DIS_StockChk> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.DIS_StockChk>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.Pay_PaymentSettings> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.Pay_PaymentSettings>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.SYS_RoleUser> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.SYS_RoleUser>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_DefDoc_B> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_DefDoc_B>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.PAY_Withdrawals> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.PAY_Withdrawals>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BF_ZD_PROVINCE> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BF_ZD_PROVINCE>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_Attribute> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_Attribute>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.DIS_Logistics> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.DIS_Logistics>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_CompNews> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_CompNews>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.SYS_SysBusinessLog> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.SYS_SysBusinessLog>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.SYS_UserMessage> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.SYS_UserMessage>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_PrePayment> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_PrePayment>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_DisCollect> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_DisCollect>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_GoodsAttrsInfo> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_GoodsAttrsInfo>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.BD_ShopGoodsList> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.BD_ShopGoodsList>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.SYS_PaymentBank> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.SYS_PaymentBank>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.PAY_RegisterLog> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.PAY_RegisterLog>(ds.Tables[0])); }
/// <summary> /// 由数据集得到泛型数据列表 /// </summary> private IList <Hi.Model.DIS_OrderOut> GetList(DataSet ds) { return(Common.GetListEntity <Hi.Model.DIS_OrderOut>(ds.Tables[0])); }