public int Rechange(int cardId, decimal money, decimal songmoney)
{
try
{
DianDianEntities db = new DianDianEntities();
dd_mem_card card = db.dd_mem_card.Find(cardId);
if (card == null)
{
return(1); //查找不到
}
card.money = card.money + money;
card.songmoney = card.songmoney + songmoney;
db.dd_mem_card.Attach(card);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(card);
stateEntity.SetModifiedProperty("money");
stateEntity.SetModifiedProperty("songmoney");
dd_card_userecord dcu = new dd_card_userecord();
dcu.addtime = DateTime.Now;
dcu.cardid = cardId;
dcu.consume = money;
dcu.shopkey = Properties.Settings.Default.shopkey;
dcu.smoney = songmoney;
dcu.type = 0;
db.dd_card_userecord.Add(dcu);
db.SaveChanges();
return(0);
}
catch (Exception e)
{
log.Error("AddMember error. msg=" + e.Message);
throw;
}
}
public void AddMember(string cardNo, string name, string tel, string birth, int sex, decimal money, decimal songmoney)
{
try {
if (cardNo.Equals(""))
{
// cardNo = "" + Properties.Settings.Default.shopkey + DateTime.Now.ToString("yyyyMMddHHmmssffff");
cardNo = "" + Properties.Settings.Default.shopkey + DateTime.Now.ToString("yyyyMMddHHmmss");
}
dd_mem_card newMember = new dd_mem_card();
DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1));
newMember.addtime = (int)(DateTime.Now - startTime).TotalSeconds;
newMember.birthday = birth;
newMember.cardno = cardNo;
newMember.expirydate = (int)(DateTime.Now.AddYears(1) - startTime).TotalSeconds;
newMember.isdian = true;
newMember.isvalid = 0;
newMember.jifen = 0;
newMember.money = money;
newMember.pintaimoney = 0;
newMember.realname = name;
newMember.sex = sex;
newMember.shopkey = Properties.Settings.Default.shopkey;
newMember.songmoney = songmoney;
newMember.telno = tel;
newMember.yiling = 0;
DianDianEntities db = new DianDianEntities();
db.dd_mem_card.Add(newMember);
db.SaveChanges();
}
catch (Exception e)
{
log.Error("AddMember error. msg=" + e.Message);
throw;
}
}
