void ICedts_CardRepository.UpdateCard(CEDTS_Card card)
{
int id = card.ID;
var b_card = db.CEDTS_Card.Where(p => p.ID == id).FirstOrDefault();
db.ApplyCurrentValues(b_card.EntityKey.EntitySetName, card);
db.SaveChanges();
}
public ActionResult Create(FormCollection form, CEDTS_Card card)
{
System.Data.DataTable dt = new System.Data.DataTable();//为excel创建表格
dt.Columns.Add("SerialNumber", System.Type.GetType("System.String"));
dt.Columns.Add("PassWord", System.Type.GetType("System.String"));
int CardCount = int.Parse(form["num"]);
card.CreateTime = DateTime.Now;
card.ActivationState = 0;
switch (card.CardType)
{
case 0: card.EffectiveTime = "一年"; break;
case 1: card.EffectiveTime = "一月"; break;
case 2: card.EffectiveTime = "30次"; break;
default: break;
}
card.CreateUser = _card.GetUserIDbyAccount(User.Identity.Name);
for (int i = 0; i < CardCount; i++)
{
DataRow dr = dt.NewRow();
var SerialNumberList = _card.SelectAllCard(null, 4, 4, 4, 0, "").Select(p => p.SerialNumber).ToList();
string txt = Guid.NewGuid().ToString().Replace("-", "").Substring(0, 16).ToUpper();
card.SerialNumber = txt;
if (SerialNumberList.Contains(card.SerialNumber))
{
i--;
continue;
}
string pwd = Guid.NewGuid().ToString().Replace("-", "").Substring(0, 8).ToUpper();
card.PassWord = _card.HashPassword(pwd);
CEDTS_Card c = new CEDTS_Card();
c.ActivationState = card.ActivationState;
c.ActivationTime = card.ActivationTime;
c.ActivationUser = card.ActivationUser;
c.CardKind = 1;
c.CardType = card.CardType;
c.CreateTime = card.CreateTime;
c.CreateUser = card.CreateUser;
c.Discount = 1;
c.EffectiveTime = card.EffectiveTime;
c.Money = card.Money;
c.OverdueTime = card.OverdueTime;
c.PartnerID = card.PartnerID;
c.PassWord = card.PassWord;
c.SerialNumber = card.SerialNumber;
_card.CreateCard(c);
dr[0] = txt;
dr[1] = pwd;
dt.Rows.Add(dr);
}
string[] listname = { "序列号", "密码" };
string[] cols = { "SerialNumber", "PassWord" };
ToExcel.tableToExcel(dt, listname, cols);
DoExcel();
return(RedirectToAction("Index"));
}
void ICedts_CardRepository.CreateCard(CEDTS_Card card)
{
db.AddToCEDTS_Card(card);
db.SaveChanges();
}
