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;
}
}
}
