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; } }
/// <summary> /// 公用录入单卡号方法 result:录入成功返回cardid,错误返回错误原因 /// </summary> /// <returns></returns> public static bool CommonEnterCardNumber(int issueid, decimal cardnumber, int comid, out string result, Member_Issue issue) { Member_Card cardinfo = new MemberCardData().GetCardByCardNumber(cardnumber); //判断卡号是否存在属于此次发行的卡片类型 int cardtype = cardinfo.Crid; int issuecardtype = issue.Crid; if (cardtype != issuecardtype) { result = "输入的卡号所属类型和发行需要的卡号类型不相符"; return(false); } Member_Channel channel = new MemberChannelData().GetChannelDetail(issue.Chid); List <Member_Issue_Activity> actlist = new MemberIssueActivityData().GetIssuePromot(issueid); try { var upMemberCardd = new MemberCardData().UPChannelCardCode(channel.Id, cardnumber, issueid);//更改生成卡号表中卡号所属渠道的id和发行id foreach (Member_Issue_Activity issueact in actlist) { Member_Card_Activity cardactinfo = new MemberCardActivityData().GetCardActInfo(cardinfo.Id, issueact.Acid); //防止一张卡重复录入同一次活动 if (cardactinfo == null) { Member_Card_Activity cardact = new Member_Card_Activity() { Id = 0, ACTID = issueact.Acid, Actnum = 1, CardID = cardinfo.Id, USEstate = (int)MemberCardUserState.NotUse, USEsubdate = DateTime.Parse("1900-01-01") }; var insertcardact = new MemberCardActivityData().EditMemberCardActivity(cardact); } } result = upMemberCardd.ToString(); return(true); } catch (Exception ex) { new SqlHelper().Dispose(); result = "意外错误"; return(false); throw; } }
public static string GetIssuePromot(int issueid) { try { var pro = new MemberIssueActivityData().GetIssuePromot(issueid); return(JsonConvert.SerializeObject(new { type = 100, msg = pro })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new { type = 1, msg = ex.Message })); throw; } }