public static bool Delete(int index)
{
CardInfo info = CardInfos[index];
int count = Dal_CardInfo.Delete(info.CardNumber);
if (count > 0)
{
CardInfos.RemoveAt(index);
}
return(count > 0);
}
public static CardInfo GetCardInfo(string cardNumber)
{
string strWhere = " and CardNumber = @CardNumber ";
object param = new { CardNumber = cardNumber };
List <CardInfo> list = Dal_CardInfo.GetCardInfos(strWhere, param);
if (list.Count > 0)
{
return(list[0]);
}
return(null);
}
public static CardInfo GetLicensePlateInfo(string strNumber)
{
string strWhere = $" and CardType == -1 and CardNumber = @Number ";
object objs = new { Number = strNumber };
List <CardInfo> infos = Dal_CardInfo.GetCardInfos(strWhere, objs);
if (infos.Count > 0)
{
return(infos[0]);
}
return(null);
}
public static List <CardInfo> GetCardInfos(string searchContent, int page, int count)
{
StringBuilder strWhere = new StringBuilder(" and CardType != -1 ");
object param = null;
if (!string.IsNullOrEmpty(searchContent))
{
strWhere.Append(" and CardNumber like @content ");
param = new { content = $"%{searchContent}%" };
}
strWhere.Append($" order by Cid desc limit {count} offset {page * count} ");
CardInfos = Dal_CardInfo.GetCardInfos(strWhere.ToString(), param);
return(CardInfos);
}
public static CardInfo GetCardInfo(int index)
{
CardInfo info = CardInfos[index];
if (info.Id > 0 && info.ViceCardInfos == null)
{
string strWhere = " and Cid in (select Vid from BundledInfo where HostCardNumber = @Number ) ";
object param = new { Number = info.CardNumber };
List <CardInfo> viceCards = Dal_CardInfo.GetCardInfos(strWhere, param);
if (viceCards.Count > 0)
{
info.ViceCardInfos = viceCards;
}
}
return(info);
}
public static List <CardInfo> GetViceCards(string[] strNumbers)
{
StringBuilder strWhere = new StringBuilder(" and CardType = 3 ");
StringBuilder sb = new StringBuilder();
int count = 1;
foreach (string item in strNumbers)
{
sb.Append($"'{item}'");
if (count < strNumbers.Length)
{
sb.Append(",");
}
count += 1;
strWhere.Append($" and CardNumber in ({sb}) ");
}
return(Dal_CardInfo.GetCardInfos(strWhere.ToString(), null));
}
public static List <CardInfo> GetViceCards(int index)
{
StringBuilder strWhere = new StringBuilder(" and CardType = 3 ");
List <CardInfo> viceInfos = CardInfos[index].ViceCardInfos;
if (viceInfos != null && viceInfos.Count > 0)
{
StringBuilder sb = new StringBuilder();
int count = 1;
foreach (CardInfo item in viceInfos)
{
sb.Append($"'{item.CardNumber}'");
if (count < viceInfos.Count)
{
sb.Append(",");
}
count += 1;
}
strWhere.Append($" and CardNumber not in ({sb}) ");
}
List <CardInfo> viceNumbers = new List <CardInfo>();
foreach (CardInfo item in CardInfos)
{
if (item.Id == 0 && item.CardType == 3)
{
viceNumbers.Add(item);
}
}
List <CardInfo> list = Dal_CardInfo.GetCardInfos(strWhere.ToString(), null);
if (list != null && list.Count > 0)
{
viceNumbers.AddRange(list);
}
return(viceNumbers);
}
public static List <CardInfo> GetCardInfos(string numbers)
{
string where = $" and CardNumber in ({numbers})";
return(Dal_CardInfo.GetCardInfos(where, null));
}
public static List <CardInfo> GetCardInfos(int state)
{
string where = $" and CardReportLoss = {state} and CardType >= 0 and CardType <= 2 ";
return(Dal_CardInfo.GetCardInfos(where, null));
}
public static int GetCount(string searchContent)
{
return(Dal_CardInfo.GetCardCount(searchContent));
}
public static bool Delete()
{
int count = Dal_CardInfo.Delete();
return(count > 0);
}
public static int Insert(CardInfo[] infos)
{
return(Dal_CardInfo.Insert(infos));
}
public static int Insert(CardInfo info)
{
return(Dal_CardInfo.Insert(info));
}
public static void Update(CardInfo[] infos)
{
Dal_CardInfo.Update(infos);
}
