public Member_Card GetMemberCardByOpenId(string openid) { using (var helper = new SqlHelper()) { Member_Card list = new InternalMemberCard(helper).GetMemberCardList(openid); return list; } }
public List<Member_Card> GetMemberCardList(int comid, decimal cardcode, int pageindex, int pagesize, int issueid, int channelid, int actid, int isopencard, out int totalcount) { using (var helper = new SqlHelper()) { var list = new InternalMemberCard(helper).GetMemberCardList(comid, cardcode, pageindex, pagesize, issueid, channelid, actid, isopencard, out totalcount); return list; } }
public int IsHasOutCardcode(int comid, string outcardcode) { using (var helper = new SqlHelper()) { int result = new InternalMemberCard(helper).IsHasOutCardcode(comid, outcardcode); return result; } }
public int UpMemberChennel(string openid, int channelid) { using (var helper = new SqlHelper()) { int result = new InternalMemberCard(helper).UpMemberChennel(openid, channelid); return result; } }
public int InsOutMemberCardcode(string outcardcode, int isused, int comid, int imlogid) { using (var helper = new SqlHelper()) { int result = new InternalMemberCard(helper).InsOutMemberCardcode(outcardcode, isused, comid, imlogid); return result; } }
/// <summary> /// 得到不可用的 外部导入卡号 /// </summary> /// <param name="comid"></param> /// <returns></returns> internal string GetUnusedOutCardcode(int comid) { using (var helper = new SqlHelper()) { string result = new InternalMemberCard(helper).GetUnusedOutCardcode(comid); return result; } }
public int Insoutcardcodeimlog(string initfilename, string relativepath, int imtor, int comid, string imtime) { using (var helper = new SqlHelper()) { int result = new InternalMemberCard(helper).Insoutcardcodeimlog(initfilename, relativepath, imtor, comid, imtime); return result; } }
public List<Member_Card> CardPageList(string comid, int pageindex, int pagesize, out int totalcount) { using (var helper = new SqlHelper()) { var list = new InternalMemberCard(helper).CardPageList(comid, pageindex, pagesize, out totalcount); return list; } }
public static Member_Card GetCardNumber(decimal cardnumber) { using (var sql = new SqlHelper()) { try { var cardinfo = new InternalMemberCard(sql).GetCardByCardNumber(cardnumber); return cardinfo; } catch { throw; } } }
public string SearchCard(string pno, int comid, out int userinfo) { using (var sql = new SqlHelper()) { try { var cardinfo = new InternalMemberCard(sql).SearchCard(pno, comid, out userinfo); return cardinfo; } catch { throw; } } }
public string GetCarValidate(int actid, int cardid, int orderid, string servername, int num_people, int per_capita_money, int menber_return_money, string sales_admin, int comid, string AccountName) { using (var sql = new SqlHelper()) { try { var cardinfo = new InternalMemberCard(sql).GetCarValidate(actid, cardid, orderid, servername, num_people, per_capita_money, menber_return_money, sales_admin, comid, AccountName); return cardinfo; } catch { throw; } } }
public string GetCardInfo(int logid, int pno, int comid) { using (var sql = new SqlHelper()) { try { var cardinfo = new InternalMemberCard(sql).GetCardInfo(logid, pno, comid); return cardinfo; } catch { throw; } } }
public string EconfirmCard(int aid, int actid, int cardid, int comid, out Member_Activity actinfo, out string phone, out string name, out decimal idcard, out decimal agcardcode) { using (var sql = new SqlHelper()) { try { var cardinfo = new InternalMemberCard(sql).EconfirmCard(aid, actid, cardid, comid, out actinfo, out phone, out name, out idcard, out agcardcode); return cardinfo; } catch { throw; } } }
public int EditMemberCard(Member_Card membercard) { using (var sql = new SqlHelper()) { try { int result = new InternalMemberCard(sql).EditMemberCard(membercard); return result; } catch (Exception ex) { throw; } } }
public static int GetRandomCode() { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.GetRandomCode(); return result; } catch { throw; } } }
public int UPChannelCardCode(decimal channelcardcode, decimal cardnumber, int issueid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.UPChannelCardCode(channelcardcode, cardnumber, issueid); return result; } catch { throw; } } }
public static Member_Card GetCardId(int cardid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); Member_Card result = internalData.GetCardId(cardid); return result; } catch { throw; } } }
public int upCardcodeChannel(string cardcode, int channelid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.upCardcodeChannel(cardcode, channelid); return result; } catch { throw; } } }
public int GetOpenCardNum(int issueid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.GetOpenCardNum(issueid); return result; } catch { throw; } } }
public int GetEnteredNumberByChannelId(int channelid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.GetEnteredNumberByChannelId(channelid); return result; } catch { throw; } } }
public static decimal AutoInputMoeny(int uid, int faceobjects, int comid, out int jifen_range) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); var result = internalData.AutoInputMoeny(uid, faceobjects, comid, out jifen_range); return result; } catch { throw; } } }
public static int EditCardInfo(Member_Card info) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.InsertOrUpdate(info); return result; } catch { throw; } } }
public static string CreateECard(int carttype, int comid) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); string result = internalData.CreateECard(carttype, comid); return result; } catch { throw; } } }
public bool IsHasEntered(decimal cardnumber) { using (var sql = new SqlHelper()) { try { var internalData = new InternalMemberCard(sql); int result = internalData.IsHasEntered(cardnumber); if (result > 0) { return true; } else { return false; } } catch { throw; } } }