/// <summary>
/// 获取新增信息数
/// </summary>
/// <param name="shopId">门店ID</param>
/// <param name="userIdentity">0总后台 1总店，2分店</param>
/// <param name="today">默认今天，否则昨天</param>
/// <returns>System.Int32.</returns>
public int GetNewMessageCount(int shopId, int userIdentity, bool today = true)
{
string strSql = "select COUNT(1) from BM_MessageManage M where CONVERT(nvarchar(10),M.CreateTime,121)=@Date and M.IsDel = 0 and IsSend=1 ";
if (userIdentity != 0)
{
strSql = @"select COUNT(1) from BM_MessageManage M
inner join BM_MessageSendTarget T on T.MessageId = M.ID
where CONVERT(nvarchar(10),M.CreateTime,121)=@Date and M.IsDel = 0 and IsSend=1 ";
strSql += " and T.SendTargetShopId=@ShopId";
}
else
{
strSql += " and M.IsSendBelongShopId=1 ";
}
DateTime dtnow = DateTime.Now;
if (!today)
{
dtnow = DateTime.Now.AddDays(-1);
}
var param = new[] {
new SqlParameter("@ShopId", shopId),
new SqlParameter("@Date", dtnow.ToString("yyyy-MM-dd"))
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 添加客户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertCustomerInfo(CustomerModel model)
{
string strSql = "insert into BM_CustomerManage (BelongOne,BelongTwo,Status,Name,Mobile,Addr,Remark,ShopId,InShop,BelongOneShopId,isSave,DataImg) values(@BelongOne,@BelongTwo,@Status,@Name,@Mobile,@Addr,@Remark,@ShopId,@InShop,@BelongOneShopId,@isSave,@DataImg);select @@IDENTITY;";
var param = new[] {
new SqlParameter("@BelongOne", model.BelongOne),
new SqlParameter("@BelongTwo", model.BelongTwo),
new SqlParameter("@Status", model.Status),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@Addr", model.Addr),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@ShopId", model.ShopId),
new SqlParameter("@InShop", model.InShop),
new SqlParameter("@BelongOneShopId", model.BelongOneShopId),
new SqlParameter("@isSave", model.isSave),
new SqlParameter("@DataImg", model.DataImg)
};
object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
return(0);
}
/// <summary>
/// 添加等级
/// 作者：郭孟稳
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertLevel(MallUserLevelModel model)
{
string strsql = @"insert into Mall_UserLevel (UL_Level,UL_LevelName,UL_Type,UL_CustomerID,UL_Description,UL_DefaultLevel,UL_Integral
,UL_MemberNum,UL_DirectTeamNum,UL_IndirectTeamNum,UL_Money,UL_OpenLevel_One,UL_BelongOne_Content,UL_OpenLevel_Two,UL_BelongTwo_Content,UL_GuidetLevel,UL_Gold)
values (@UL_Level,@UL_LevelName,@UL_Type,@UL_CustomerID,@UL_Description,@UL_DefaultLevel,@UL_Integral
,@UL_MemberNum,@UL_DirectTeamNum,@UL_IndirectTeamNum,@UL_Money,@UL_OpenLevel_One,@UL_BelongOne_Content,@UL_OpenLevel_Two,@UL_BelongTwo_Content,@UL_GuidetLevel,@UL_Gold)
select @@IDENTITY";
SqlParameter[] parm =
{
new SqlParameter("@UL_Level", model.UL_Level),
new SqlParameter("@UL_LevelName", model.UL_LevelName),
new SqlParameter("@UL_Type", model.UL_Type),
new SqlParameter("@UL_CustomerID", model.UL_CustomerID),
new SqlParameter("@UL_Description", model.UL_Description),
new SqlParameter("@UL_DefaultLevel", model.UL_DefaultLevel),
new SqlParameter("@UL_Integral", model.UL_Integral),
new SqlParameter("@UL_MemberNum", model.UL_MemberNum),
new SqlParameter("@UL_DirectTeamNum", model.UL_DirectTeamNum),
new SqlParameter("@UL_IndirectTeamNum", model.UL_IndirectTeamNum),
new SqlParameter("@UL_Money", model.UL_Money),
new SqlParameter("@UL_OpenLevel_One", model.UL_OpenLevel_One),
new SqlParameter("@UL_BelongOne_Content", model.UL_BelongOne_Content),
new SqlParameter("@UL_OpenLevel_Two", model.UL_OpenLevel_Two),
new SqlParameter("@UL_BelongTwo_Content", model.UL_BelongTwo_Content),
new SqlParameter("@UL_GuidetLevel", model.UL_GuidetLevel),
new SqlParameter("@UL_Gold", model.UL_Gold)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strsql, parm)));
}
/// <summary>
/// 获取新增审核资讯数(此方法只有总后台调用)
/// </summary>
/// <param name="shopId">门店ID</param>
/// <param name="userIdentity">0总后台 1总店，2分店</param>
/// <param name="today">默认今天，否则昨天</param>
/// <returns>System.Int32.</returns>
public int GetNewArticleCount(int shopId, int userIdentity, bool today = true)
{
string strSql = "select COUNT(1) from BM_ArticleList where CONVERT(nvarchar(10),CreateTime,121)=@Date and IsDel=0 ";
if (userIdentity != 0)
{
strSql += " and AuthorId=@ShopId and AuthorIdentity=@AuthorIdentity";
}
else
{
strSql += " and AuthorIdentity in (1,2)";
}
DateTime dtnow = DateTime.Now;
if (!today)
{
dtnow = DateTime.Now.AddDays(-1);
}
var param = new[] {
new SqlParameter("@ShopId", shopId),
new SqlParameter("@AuthorIdentity", userIdentity),
new SqlParameter("@Date", dtnow.ToString("yyyy-MM-dd"))
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 根据多个门店ID，获取门店名称，并拼接在一起
/// </summary>
/// <param name="ids">The ids.</param>
/// <returns>System.String.</returns>
private string GetMessageShopName(string ids)
{
var arr = ids.Split(',');
string strSql = string.Format("select stuff((select '/'+ShopName from BM_ShopManage where ShopID in ({0}) for xml path('')),1,1,'')", string.Join(",", arr));
return(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql).ToString());
}
/// <summary>
/// 添加站内信息
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public int AddMailInfo(MailModel model)
{
string strSql = @"insert into BM_Mail(AuthorId,AuthorName,SendType,Title,BodyContent,CoverUrl,ReplyUserId,ReplyPid,PhoneModel) values(@AuthorId,@AuthorName,@SendType,@Title,@BodyContent,@CoverUrl,@ReplyUserId,@ReplyPid,@PhoneModel);select @@IDENTITY";
var param = new[] {
new SqlParameter("@AuthorId", model.AuthorId),
new SqlParameter("@AuthorName", model.AuthorName),
new SqlParameter("@SendType", model.SendType),
new SqlParameter("@Title", model.Title),
new SqlParameter("@BodyContent", model.BodyContent),
new SqlParameter("@CoverUrl", model.CoverUrl),
new SqlParameter("@ReplyUserId", model.ReplyUserId),
new SqlParameter("@ReplyPid", model.ReplyPid),
new SqlParameter("@PhoneModel", model.PhoneModel)
};
object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql.ToString(), param);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 获取新增盟友数
/// </summary>
/// <param name="shopId">门店ID</param>
/// <param name="userIdentity">0总后台 1总店，2分店</param>
/// <param name="today">默认今天，否则昨天</param>
/// <returns>System.Int32.</returns>
public int GetNewAllyCount(int shopId, int userIdentity, bool today = true)
{
string strSql = "select count(1) from BM_User_extend where CONVERT(nvarchar(10),CreateTime,121)=@Date and UserIdentity=0 ";
if (shopId > 0)
{
if (userIdentity == 1)
{
strSql += " and BelongShopId=@ShopId";
}
else if (userIdentity == 2)
{
strSql += " and ShopId=@ShopId";
}
}
DateTime dtnow = DateTime.Now;
if (!today)
{
dtnow = DateTime.Now.AddDays(-1);
}
var param = new[] {
new SqlParameter("@ShopId", shopId),
new SqlParameter("@Date", dtnow.ToString("yyyy-MM-dd"))
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
//public int GetNotReadMessageCount(int userId)
//{
// string strSql = @"select COUNT(1) from BM_MailReadLog r
// left join BM_Mail a on a.ID=r.MailId
// where a.SendType<>2 and r.IsRead=0 and r.UserId=@UserId";
// var param = new[] {
// new SqlParameter("@UserId",userId)
// };
// return Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param));
//}
/// <summary>
/// 获取未读消息数量
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="sendType">0我发的消息 1 我接收的消息，2我的留言</param>
/// <returns>System.Int32.</returns>
public int GetNotReadMessageCount(int userId, int sendType)
{
string strSql = @"select COUNT(1) from BM_MailReadLog r
left join BM_Mail a on a.ID=r.MailId
where r.IsRead=0 and r.UserId=@UserId";
if (sendType == 2)
{
strSql += " and a.SendType=@SendType ";
}
else
{
strSql += " and a.SendType<>2 ";
}
if (sendType == 0 || sendType == 2)
{
strSql += " and a.AuthorId=@UserId ";
}
else
{
strSql += " and A.AuthorId<>@UserId ";
}
var param = new[] {
new SqlParameter("@UserId", userId),
new SqlParameter("@SendType", sendType)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 获取分页数据集合
/// </summary>
/// <typeparam name="T"></typeparam>
///<param name="PageSize"></param>
///<param name="PageIndex"></param>
/// <param name="strSql"></param>
///<param name="orderbyField">排序字段</param>
/// <param name="commandParameters"></param>
/// <param name="callback">回调处理函数</param>
/// <returns></returns>
public ResultPageModel getPageData <T>(int PageSize, int PageIndex, string strSql, string orderbyField, SqlParameter[] commandParameters, Action <List <T> > callback, bool orderby = false) where T : new()
{
string querySql = DbHelperSQLP.buildPageSql(PageIndex, PageSize, strSql, orderbyField, orderby);
string recordCountSql = DbHelperSQLP.buildRecordCountSql(strSql);
ResultPageModel result = new ResultPageModel();
int recordCount = Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, recordCountSql, commandParameters));
List <T> lst = new List <T>();
using (SqlDataReader dr = DbHelperSQLP.ExecuteReader(WebConfig.getConnectionString(), CommandType.Text, querySql, commandParameters))
{
lst = DbHelperSQLP.GetEntityList <T>(dr);
callback?.Invoke(lst);
}
int pageCount = recordCount / PageSize;
if (recordCount % PageSize != 0)
{
++pageCount;
}
result.PageIndex = PageIndex;
result.PageSize = PageSize;
result.Total = recordCount;
result.PageCount = pageCount;
result.Rows = lst;
return(result);
}
/// <summary>
/// 判断用户名是否存在
/// </summary>
/// <param name="loginName">Name of the login.</param>
/// <returns>true if the specified login name is exist; otherwise, false.</returns>
public bool IsExist(string loginName)
{
string strSql = "select COUNT(1) from BM_ShopManage where LoginName=@LoginName";
var param = new[] {
new SqlParameter("@LoginName", loginName)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 根据总店ID，判断其所有分店是否全部冻结
/// </summary>
/// <param name="shopId">The shop identifier.</param>
/// <returns>true if [is all disable by shop identifier] [the specified shop identifier]; otherwise, false.</returns>
public bool IsAllDisableByShopID(int shopId)
{
string strSql = "select COUNT(1) from BM_ShopManage where ShopBelongId=@ShopID and IsActive=1 and IsDel=0";
var param = new[] {
new SqlParameter("@ShopID", shopId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) == 0);
}
/// <summary>
/// 根据门店ID，获取门店名称
/// </summary>
/// <param name="shopId">The shop identifier.</param>
/// <returns>System.String.</returns>
private string GetMessageShopName(int shopId)
{
string strSql = "select ShopName from BM_ShopManage where ShopID=@ShopID";
var parms = new[] {
new SqlParameter("@ShopID", shopId)
};
return(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, parms).ToString());
}
/// <summary>
/// 我的现金券数量
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <returns>System.Int32.</returns>
public int GetMyCashCouponCount(int userId)
{
string strSql = "select COUNT(1) from BM_GetCashCouponLog where UserId=@UserId and IsGet=0 ";
var param = new[] {
new SqlParameter("@UserId", userId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 计算订单数
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public int CountOrders(int userId)
{
string strSql = "select count(*) from BM_Orders where UserId=@UserId";
var param = new[] {
new SqlParameter("@UserId", userId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 判断是否存在
/// </summary>
/// <param name="mobile"></param>
/// <param name="addr"></param>
/// <returns></returns>
public bool IsExist(string mobile, string addr)
{
string strSql = "select COUNT(1) from BM_CustomerManage where IsDel=0 and Status<>2 and Mobile =@Mobile or Addr =@Addr";
var param = new[] {
new SqlParameter("@Mobile", mobile),
new SqlParameter("@Addr", addr)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 判断用户是否存在
/// </summary>
/// <param name="mobile"></param>
/// <param name="storeId"></param>
/// <returns></returns>
private bool UserExist(string mobile, int storeId)
{
string strSql = "select COUNT(1) from Hot_UserBaseInfo with(nolock) where UB_UserLoginName=@LoginName and UB_CustomerID=@CustomerID";
var param = new[] {
new SqlParameter("@LoginName", mobile),
new SqlParameter("@CustomerID", storeId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 根据用户ID判断当前资讯是否已阅读
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="articleId">The article identifier.</param>
/// <returns>true if the specified user identifier is read; otherwise, false.</returns>
public bool IsRead(int userId, int articleId)
{
string strSql = "select COUNT(1) from BM_ReadLog where ArticleId=@ArticleId and UserId=@UserId";
var param = new[] {
new SqlParameter("@ArticleId", articleId),
new SqlParameter("@UserId", userId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
///判断用户是否已转发
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="couponId">The coupon identifier.</param>
/// <returns>true if [is send coupon by user identifier] [the specified user identifier]; otherwise, false.</returns>
public bool IsSendCouponByUserId(int userId, int couponId)
{
string strSql = "select COUNT(1) from BM_CouponSend where UserId=@UserId and CouponId=@CouponId";
var parm = new[] {
new SqlParameter("@UserId", userId),
new SqlParameter("@CouponId", couponId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql.ToString(), parm)) > 0);
}
/// <summary>
/// 判断授权token是否存在
/// </summary>
/// <param name="UserId">The user identifier.</param>
/// <returns>true if [is authentication token exist] [the specified user identifier]; otherwise, false.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public bool IsAuthTokenExist(int UserId)
{
string strSql = "select COUNT(1) from BM_AuthToken where UserId=@UserId";
SqlParameter[] parm =
{
new SqlParameter("@UserId", UserId),
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, parm)) > 0);
}
public bool IsExist(string loginName)
{
string strSql = "select COUNT(1) from Hot_UserBaseInfo U with(nolock) where U.UB_UserLoginName=@UB_UserLoginName and U.UB_CustomerID=@UB_CustomerID";
var param = new[] {
new SqlParameter("@UB_UserLoginName", loginName),
new SqlParameter("@UB_CustomerID", ConstConfig.storeId),
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 更新用户阅读状态
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="articleId">The article identifier.</param>
/// <returns>true if XXXX, false otherwise.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public bool UpdateReadStatus(int userId, int articleId)
{
string strSql = "update BM_ReadLog set IsRead=1 where UserId=@UserId and ArticleId=@ArticleId";
var param = new[] {
new SqlParameter("@ArticleId", articleId),
new SqlParameter("@UserId", userId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 判断是否通过验证
/// </summary>
/// <param name="verifyCode"></param>
/// <returns></returns>
public bool IsPassVerify(string verifyCode, string phone)
{
string strSql = "select count(1) from Swt_SmsVerification where SSV_Verification=@SSV_Verification and SSV_IsInvalid=0 and SSV_Phone=@SSV_Phone and DATEDIFF(SECOND,SSV_AddTime,GETDATE()) < 600 ";
var parameters = new[] {
new SqlParameter("@SSV_Verification", verifyCode),
new SqlParameter("@SSV_Phone", phone)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, parameters)) > 0);
}
/// <summary>
///添加工作汇报内容
/// </summary>
/// <param name="title">The title.</param>
/// <returns>System.Int32.</returns>
public int AddWorkReport(string title)
{
string strSql = "insert into BM_WorkReport(WorkTitle) values(@WorkTitle);select @@IDENTITY";
var param = new[] {
new SqlParameter("@WorkTitle", title),
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 判断当前盟主的盟友奖励是否存在
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <returns>true if [is rewar exist] [the specified user identifier]; otherwise, false.</returns>
public bool IsRewarExist(int userId)
{
string strSql = "select COUNT(1) from BM_RewardsSetting where UserId=@UserId";
SqlParameter[] param =
{
new SqlParameter("@UserId", userId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 根据盟友ID，获取盟友的订单数量
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="orderStatus">0 未成交 1 已成交 2退单</param>
/// <returns>System.Int32.</returns>
public int CountOrdersByAllyUserId(int userId, int orderStatus)
{
string strSql = "select count(*) from BM_Orders where Ct_BelongId=@UserId and OrderStatus=@OrderStatus";
var param = new[] {
new SqlParameter("@UserId", userId),
new SqlParameter("@OrderStatus", orderStatus)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)));
}
/// <summary>
/// 根据条件，修改阅读状态为未读
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="mailId">The mail identifier.</param>
/// <returns>true if XXXX, false otherwise.</returns>
public bool UpdateMailNotReadStatus(int userId, int mailId)
{
string strSql = "update BM_MailReadLog set IsRead=0 where UserId<>@UserId and MailId=@MailId and IsRead=1";
var param = new[] {
new SqlParameter("@MailId", mailId),
new SqlParameter("@UserId", userId)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param)) > 0);
}
/// <summary>
/// 获取当前发送次数
/// </summary>
/// <param name="phone">The phone.</param>
/// <param name="customerid">The customerid.</param>
/// <returns>System.Int32.</returns>
public int TodaySendCount(string phone, int customerid)
{
string sql = "SELECT COUNT(1) FROM Swt_SmsVerification WHERE SSV_Phone=@Mobile AND SSV_CustomerId=@StoreId and CONVERT(nvarchar(10),SSV_AddTime,121)=CONVERT(nvarchar(10),GETDATE(),121)";
var parameters = new[] {
new SqlParameter("@Mobile", phone),
new SqlParameter("@StoreId", customerid)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, sql, parameters)));
}
/// <summary>
/// 获取商户的等级数量
/// 作者：郭孟稳
/// </summary>
/// <param name="storeId"></param>
/// <returns></returns>
public int GetLevelCount(int storeId, int type)
{
string strSql = "select COUNT(*) from Mall_UserLevel where UL_CustomerID=@UL_CustomerID and UL_Type=@UL_Type";
SqlParameter[] parm =
{
new SqlParameter("@UL_CustomerID", storeId),
new SqlParameter("@UL_Type", type)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, parm)));
}
/// <summary>
/// 获取当前最大等级级别
/// 作者：郭孟稳
/// </summary>
/// <param name="storeId"></param>
/// <returns></returns>
public int GetMaxLevel(int storeId, int type)
{
string strSql = "select top 1 UL_Level from Mall_UserLevel where UL_CustomerID=@UL_CustomerID and UL_Type=@UL_Type order by UL_Level desc";
SqlParameter[] parm =
{
new SqlParameter("@UL_CustomerID", storeId),
new SqlParameter("@UL_Type", type)
};
object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, parm);
return(obj == null ? 0 : Convert.ToInt32(obj));
}
public bool Exists(string verifyCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Swt_SmsVerification");
strSql.Append(" where ");
strSql.Append(" SSV_Verification = @SSV_Verification and SSV_IsInvalid=0");
var parameters = new[] {
new SqlParameter("@SSV_Verification", verifyCode)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql.ToString(), parameters)) > 0);
}