/// <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]));
}
