/// <summary>
/// 得到会员的分类激活码信息
/// </summary>
/// <param name="model"></param>
/// <param name="totalrowcount"></param>
/// <returns></returns>
public List <MemberActiveCodeModel> GetMemberActiveCodeListForPage(int memberid, int typeid, int pageindex, int pagesize, out int totalrowcount)
{
List <MemberActiveCodeModel> list = new List <MemberActiveCodeModel>();
string columms = @"ID,ActiveCode,AMType,MemberID,MemberPhone,MemberName,AMStatus,Addtime,UseCode,UserTime,CASE AMStatus WHEN 1 THEN '未使用' WHEN 2 THEN '已使用' WHEN 3 THEN '已过期' END AS AMStatusName";
string where = "";
if (memberid > 0)
{
where = " MemberID=" + memberid.ToString() + " AND AMType=" + typeid.ToString();
}
PageProModel page = new PageProModel();
page.colums = columms;
page.orderby = "Addtime";
page.pageindex = pageindex;
page.pagesize = pagesize;
page.tablename = @"dbo.MemberActiveCode";
page.where = where;
DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
MemberActiveCodeModel activecode = new MemberActiveCodeModel();
if (item["ID"].ToString() != "")
{
activecode.ID = int.Parse(item["ID"].ToString());
}
if (item["UserTime"].ToString() != "")
{
activecode.UserTime = DateTime.Parse(item["UserTime"].ToString());
}
activecode.ActiveCode = item["ActiveCode"].ToString();
if (item["AMType"].ToString() != "")
{
activecode.AMType = int.Parse(item["AMType"].ToString());
}
if (item["MemberID"].ToString() != "")
{
activecode.MemberID = int.Parse(item["MemberID"].ToString());
}
activecode.MemberPhone = item["MemberPhone"].ToString();
activecode.MemberName = item["MemberName"].ToString();
if (item["AMStatus"].ToString() != "")
{
activecode.AMStatus = int.Parse(item["AMStatus"].ToString());
}
if (item["Addtime"].ToString() != "")
{
activecode.Addtime = DateTime.Parse(item["Addtime"].ToString());
}
activecode.UseCode = item["UseCode"].ToString();
activecode.AMStatusName = item["AMStatusName"].ToString();
list.Add(activecode);
}
}
return(list);
}
/// <summary>
/// 会员激活码
/// </summary>
/// <param name="memberactive"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult memberactivecode(MemberActiveCodeModel memberactivecode, int page = 1)
{
int totalrowcount = 0;
memberactivecode.PageIndex = page;
memberactivecode.PageSize = PageSize;
List <MemberActiveCodeModel> memberactivecodelist = bll.GetMemberActiveCodeListForPage(memberactivecode, out totalrowcount);
PagedList <MemberActiveCodeModel> pageList = null;
if (memberactivecodelist != null)
{
pageList = new PagedList <MemberActiveCodeModel>(memberactivecodelist, page, PageSize, totalrowcount);
}
this.ViewData["memberactivecode.AMType"] = GetTypeListItem(0);
this.ViewData["memberactivecode.AMStatus"] = GetStatusListItem1(1);
MemberActiveIndexViewModel model = new MemberActiveIndexViewModel();
model.memberactivecodelist = pageList;
model.totalcount = totalrowcount;
model.pagesize = PageSize;
model.currentpage = page;
ViewBag.PageTitle = "会员激活码列表";
return(View(model));
}
public List <MemberActiveCodeModel> GetMemberActiveCodeList(int memberid, int type)
{
List <MemberActiveCodeModel> list = new List <MemberActiveCodeModel>();
string sqltxt = @"SELECT ActiveCode
FROM dbo.MemberActiveCode
WHERE AMType = @type
AND MemberID = @memberid
AND AMStatus = 1";
SqlParameter[] paramter =
{
new SqlParameter("@type", type),
new SqlParameter("@memberid", memberid)
};
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
foreach (DataRow item in dt.Rows)
{
MemberActiveCodeModel model = new MemberActiveCodeModel();
model.ActiveCode = item["ActiveCode"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 得到会员的激活码信息
/// </summary>
/// <param name="model"></param>
/// <param name="totalrowcount"></param>
/// <returns></returns>
public List <MemberActiveCodeModel> GetMemberActiveCodeListForPage(MemberActiveCodeModel model, out int totalrowcount)
{
List <MemberActiveCodeModel> list = new List <MemberActiveCodeModel>();
string columms = @"ID ,ActiveCode ,AMType,CASE AMType WHEN 1 THEN '激活账户' WHEN 2 THEN '排单专用' END AMTypeName ,MemberID ,MemberPhone ,MemberName ,AMStatus ,Addtime,CASE AMStatus WHEN 1 THEN '未使用' WHEN 2 THEN '已使用' WHEN 3 THEN '已过期' END AMStatusName";
string where = "";
if (model != null)
{
if (model.AMStatus > 0)
{
where += " AMStatus= " + model.AMStatus;
}
if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where))
{
where += @" MemberPhone Like '%" + model.MemberPhone + "%'";
}
else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where))
{
where += @" AND MemberPhone Like '%" + model.MemberPhone + "%'";
}
if (!string.IsNullOrWhiteSpace(model.ActiveCode) && string.IsNullOrWhiteSpace(where))
{
where += @" ActiveCode ='" + model.ActiveCode + "'";
}
else if (!string.IsNullOrWhiteSpace(model.ActiveCode) && !string.IsNullOrWhiteSpace(where))
{
where += @" AND ActiveCode ='" + model.ActiveCode + "'";
}
}
PageProModel page = new PageProModel();
page.colums = columms;
page.orderby = "Addtime";
page.pageindex = model.PageIndex;
page.pagesize = model.PageSize;
page.tablename = @"dbo.MemberActiveCode";
page.where = where;
DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
MemberActiveCodeModel memberactive = new MemberActiveCodeModel();
if (item["ID"].ToString() != "")
{
memberactive.ID = int.Parse(item["ID"].ToString());
}
memberactive.ActiveCode = item["ActiveCode"].ToString();
if (item["MemberID"].ToString() != "")
{
memberactive.MemberID = int.Parse(item["MemberID"].ToString());
}
memberactive.MemberPhone = item["MemberPhone"].ToString();
memberactive.MemberName = item["MemberName"].ToString();
if (item["AMStatus"].ToString() != "")
{
memberactive.AMStatus = int.Parse(item["AMStatus"].ToString());
}
if (item["Addtime"].ToString() != "")
{
memberactive.Addtime = DateTime.Parse(item["Addtime"].ToString());
}
memberactive.AMStatusName = item["AMStatusName"].ToString();
memberactive.AMTypeName = item["AMTypeName"].ToString();
list.Add(memberactive);
}
}
return(list);
}
/// <summary>
/// 分配激活码
/// </summary>
/// <param name="codes"></param>
/// <param name="memberphone"></param>
/// <returns></returns>
public int AssignedCode(List <string> codes, string memberphone)
{
int result = 0;
//得到激活码信息
List <ActiveCodeModel> codelist = GetCodeMassage(codes);
//得到被分配会员信息
MemberInfoModel member = GetMember(memberphone);
if (member.MStatus != 2)
{
return(0);
}
//开启事务，分配激活码
try
{
using (TransactionScope scope = new TransactionScope())
{
//更改原表状态
result = UpdateStatus(codelist);
if (result < codelist.Count)
{
throw new Exception("更改激活码原表失败");
}
List <MemberActiveCodeModel> maclist = new List <MemberActiveCodeModel>();
foreach (var item in codelist)
{
MemberActiveCodeModel mac = new MemberActiveCodeModel();
mac.ActiveCode = item.ActivationCode;
mac.MemberID = member.ID;
mac.MemberName = member.TruethName;
mac.MemberPhone = member.MobileNum;
mac.AMType = item.AType;
maclist.Add(mac);
}
result = AddMemberActiveCode(maclist);
if (result < 1)
{
return(0);
}
ActiveCodeLogModel activemodel = new ActiveCodeLogModel();
activemodel.ActiveCode = "";
activemodel.Addtime = DateTime.Now;
activemodel.AID = 0;
activemodel.MemberID = member.ID;
activemodel.MemberName = member.TruethName;
activemodel.MemberPhone = member.MobileNum;
activemodel.Remark = "接收" + codelist.Count + "个" + (codelist[0].AType == 1 ? "激活币" : "排单币");
OperateLogDAL.AddActiveCodeLog(activemodel);
try
{
UserBehaviorLogModel log = new UserBehaviorLogModel();
log.AOrderCode = "";
log.BehaviorSource = 2;
if (codelist[0].AType == 1)
{
log.BehaviorType = 8;
}
else
{
log.BehaviorType = 7;
}
log.HOrderCode = "";
log.MemberID = member.ID;
log.MemberName = member.TruethName;
log.MemberPhone = member.MobileNum;
log.ProcAmount = 0;
log.Remark = "系统派发激活码/排单币" + codelist.Count + "个";
UserBehaviorLogDAL.AddUserBehaviorLog(log);
}
catch { }
scope.Complete();
result = 1;
}
}
catch
{
return(0);
}
return(result);
}
/// <summary>
/// 得到分页数据
/// </summary>
/// <param name="model"></param>
/// <param name="totalrowcount"></param>
/// <returns></returns>
public List <MemberActiveCodeModel> GetMemberActiveCodeListForPage(MemberActiveCodeModel model, out int totalrowcount)
{
return(dal.GetMemberActiveCodeListForPage(model, out totalrowcount));
}