/// <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; } }
internal int EditMemberCardActivity(Member_Card_Activity model) { var cmd = sqlHelper.PrepareStoredSqlCommand(SQLInsertOrUpdate); cmd.AddParam("@Id", model.Id); cmd.AddParam("@CardID", model.CardID); cmd.AddParam("@ACTID", model.ACTID); cmd.AddParam("@Actnum", model.Actnum); cmd.AddParam("@USEstate", model.USEstate); cmd.AddParam("@USEsubdate", model.USEsubdate); var parm = cmd.AddReturnValueParameter("ReturnValue"); cmd.ExecuteNonQuery(); return((int)parm.Value); }