public static string EnterCardNumber(int issueid, decimal cardnumber, int comid)
{
string result = "";
Member_Issue issue = new MemberIssueData().GetIssueDetailById(issueid);
Member_Card cardinfo = new MemberCardData().GetCardByCardNumber(cardnumber);
if (cardinfo == null)
{
result = "卡号不存在";
return(JsonConvert.SerializeObject(new { type = 1, msg = result }));
}
else
{
//判断卡号是否已经录入
bool hasentered = new MemberCardData().IsHasEntered(cardnumber);
if (hasentered)
{
result = "卡号已经录入";
return(JsonConvert.SerializeObject(new { type = 1, msg = result }));
}
}
bool isenter = CommonEnterCardNumber(issueid, cardnumber, comid, out result, issue);
if (isenter)
{
return(JsonConvert.SerializeObject(new { type = 100, msg = result }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 1, msg = result }));
}
}
public static string EditIssue(Member_Issue issuemodel, string actchecked)
{
try
{
var issueid = new MemberIssueData().InsertOrUpdate(issuemodel);
var delissueact = new MemberIssueActivityData().DelIssueIdByIssueId(issueid);
string[] actgroup = actchecked.Split(',');
for (int i = 0; i < actgroup.Length; i++)
{
Member_Issue_Activity act = new Member_Issue_Activity()
{
Id = 0,
ISid = issueid,
Acid = int.Parse(actgroup[i])
};
var issueactid = new MemberIssueActivityData().InsertOrUpdate(act);
}
return(JsonConvert.SerializeObject(new { type = 100, msg = issueid }));
}
catch
{
new SqlHelper().Dispose();
throw;
}
}
public static string GetIssueDetailById(int issueid)
{
try
{
var pro = new MemberIssueData().GetIssueDetailById(issueid);
return(JsonConvert.SerializeObject(new { type = 100, msg = pro }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static string GetIssueDetail2(int issueid)
{
try
{
var pro = new MemberIssueData().GetIssueDetailById(issueid);
List <Member_Issue> list = new List <Member_Issue>();
list.Add(pro);
IEnumerable result = "";
if (list != null)
{
result = from prop in list
select new
{
Id = prop.Id,
Com_id = prop.Com_id,
Chid = prop.Chid,
Crid = prop.Crid,
Title = prop.Title,
Num = prop.Num,
Openyes = prop.Openyes,
Openaddress = prop.Openaddress,
ActName = new MemberIssueActivityData().GetIssueActStr(prop.Id),
IssueType = new MemberChannelData().GetChannelDetail(prop.Chid).Issuetype == 0 ? "内部渠道" : "外部渠道",
ChannelUnit = new MemberChannelcompanyData().GetCompanyById(new MemberChannelData().GetChannelDetail(prop.Chid).Companyid).Companyname,
Name = new MemberChannelData().GetChannelDetail(prop.Chid).Name,
EnteredNumber = new MemberCardData().GetEnteredNumber(issueid), //得到此次发行已经录入的卡号数量
CName = new MemberCardData().GetCardCreateByCrid(prop.Crid).Cname,
OpenCardNum = new MemberCardData().GetOpenCardNum(issueid), //得到此次发行已经开卡的数量
}
}
;
return(JsonConvert.SerializeObject(new { type = 100, msg = result }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static string PageList(string comid, int pageindex, int pagesize)
{
var totalcount = 0;
try
{
var prodata = new MemberIssueData();
var list = prodata.PageList(comid, pageindex, pagesize, out totalcount);
IEnumerable result = "";
if (list != null)
{
result = from pro in list
select new
{
Id = pro.Id,
Com_id = pro.Com_id,
Crid = pro.Crid,
Chid = pro.Chid,
Title = pro.Title,
Num = pro.Num,
Openyes = pro.Openyes,
Openaddress = pro.Openaddress,
IsSueType = new MemberChannelData().GetChannelDetail(pro.Chid).Issuetype == 0 ? "内部渠道" : "外部渠道",
UnitName = new MemberChannelcompanyData().GetCompanyById(new MemberChannelData().GetChannelDetail(pro.Chid).Companyid).Companyname,
ISueName = new MemberChannelData().GetChannelDetail(pro.Chid).Name,
//根据issueid 得到录入量和开卡量；
EnteredNum = new MemberCardData().GetEnteredNumber(pro.Id),
OpenCardNum = new MemberCardData().GetOpenCardNum(pro.Id)
}
}
;
return(JsonConvert.SerializeObject(new { type = 100, totalCount = totalcount, msg = result }));
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message }));
throw;
}
}
public static string BatchEnterCardNumber(int issueid, decimal numberbegin, decimal numberend, int comid, bool ignoreentered)
{
//判断卡号区间内的卡号数量 是否大于此次剩余的发行数量；大于返回错误
Member_Issue issue = new MemberIssueData().GetIssueDetailById(issueid);
decimal enterrcount = numberend - numberbegin;
decimal enterrnum = decimal.Parse(issue.Num.ToString());
decimal enterednum = decimal.Parse(new MemberCardData().GetEnteredNumber(issueid).ToString());//这次发行已经录入的数目
if (enterrcount > enterrnum - enterednum)
{
return(JsonConvert.SerializeObject(new { type = 1, msg = "区间范围超过了剩余的发行数量" + (enterrnum - enterednum) }));
}
string result1 = ""; //判断区间内的卡号是否全部符合录入要求；符合，录入；不符合弹出确认框
string result2 = ""; //判断卡片区间内的卡号是否都存在于 卡号生成表(Member_Card)
for (var i = numberbegin; i <= numberend; i++)
{
Member_Card cardinfo = new MemberCardData().GetCardByCardNumber(i);
if (cardinfo == null)
{
result2 += i + ",";
}
else
{
if (cardinfo.IssueCard > 0)
{
result1 += i + ",";
}
}
}
if (result1.Trim() != "")
{
if (!ignoreentered)//不忽视已经录入的
{
return(JsonConvert.SerializeObject(new { type = 10, msg = result1.Substring(0, result1.Length - 1) + "已经录入到数据库" }));
}
}
if (result2.Trim() != "")
{
return(JsonConvert.SerializeObject(new { type = 1, msg = result2.Substring(0, result2.Length - 1) + "卡号表中不存在，请管理员生成" }));
}
//循环向卡号生成表中录入 当前卡号所属渠道的卡号；并且把卡号和所属促销活动 关联起来
string result4 = "";
for (var i = numberbegin; i <= numberend; i++)
{
string result3 = "";//单卡号处理时返回的内容
bool isenter = CommonEnterCardNumber(issueid, i, comid, out result1, issue);
if (isenter == false)
{
result4 += i + result3 + ",";
}
}
if (result4 != "")
{
return(JsonConvert.SerializeObject(new { type = 1, msg = result4.Substring(0, result4.Length - 1) }));
}
else
{
return(JsonConvert.SerializeObject(new { type = 100, msg = numberbegin + "-" + numberend + "卡号录入成功" }));
}
}
