public bool SaveBillItemAndUserCard(PatiInBillItemEntity billItem, UserCardEntity cardEntity)
{
using (TransactionScope trans = new TransactionScope())
{
try
{
bool ok1 = access.Save(billItem);
if (ok1 == false)
{
return(false);
}
ok1 = cardAccess.Update(cardEntity);
if (ok1 == false)
{
return(false);
}
trans.Complete();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public ActionResult GetUserSelect(string input)
{
string Condition = " and 1=1";
if (!string.IsNullOrEmpty(input))
{
Condition += " and ( (UserName like '%" + input + "%') or ( UserId like '%" + input + "%')) ";
}
else
{
Condition += "and 1=2";
}
IList <UserInfoEntity> userList = userLogic.LoadAll(Condition, 10, 1, "CreateDate", "desc");
IList <UserAndCardEntity> usercardList = new List <UserAndCardEntity>();
foreach (UserInfoEntity item in userList)
{
UserCardEntity card = usercardLogic.Load(item.CardId);
UserAndCardEntity uscardentity = new UserAndCardEntity();
uscardentity.UserName = item.UserName;
uscardentity.UserId = item.UserId;
uscardentity.CardId = item.CardId;
uscardentity.PreAmount = card.PreAmount;
uscardentity.FeeAmount = card.FeeAmount;
uscardentity.AgeName = (DateTime.Now.Year - item.BirthDate.Year).ToString();
uscardentity.SexName = (item.Sex == "0" ? "男" : "女");
usercardList.Add(uscardentity);
}
return(Json(usercardList, JsonRequestBehavior.AllowGet));
}
public bool SavePayList(PatiPayListEntity newPayment, UserCardEntity usercard)
{
using (TransactionScope trans = new TransactionScope())
{
try
{
bool isTrue = access.Save(newPayment);
if (isTrue == false)
{
return(false);
}
isTrue = cardAccess.Update(usercard);
if (isTrue == false)
{
return(false);
}
trans.Complete();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public bool Update(UserCardEntity obj)
{
try
{
Update("UserCardMap.Update", obj);
return(true);
}
catch
{
return(false);
}
}
public UserCardEntity Load(string code)
{
try
{
UserCardEntity uarcard = QueryForObject <UserCardEntity>("UserCardMap.Load", code);
return(uarcard);
}
catch (Exception ex)
{
throw;
}
}
public ActionResult SavePatiPayList(PatiPayListEntity payInfo)
{
string CreateUser = HttpContext.ApplicationInstance.Context.Request.Cookies["UserId"].Value;
payInfo.PayId = CreateUser + DateTime.Now.ToString("yyMMddHHmmssff");
payInfo.Direction = 1;
payInfo.CreateDate = DateTime.Now;
payInfo.CreateUser = CreateUser;
UserCardEntity cardEnty = usercardLogic.Load(payInfo.CardId);
cardEnty.PreAmount = cardEnty.PreAmount + payInfo.PayAmount;
bool isok = payLogic.SavePayList(payInfo, cardEnty);
return(Json(isok, JsonRequestBehavior.AllowGet));
}
public JsonResult Save(UserInfoEntity newObj)
{
JsonResult result = new JsonResult();
try
{
string strUserId = HttpContext.ApplicationInstance.Context.Request.Cookies["UserId"].Value;
newObj.UserId = GetMaxUserId();
Random rad = new Random();
string numString = rad.Next(100, 999).ToString();
string CardId = newObj.UserId + numString;
newObj.CardId = CardId;
newObj.LoginName = newObj.UserId;
newObj.Flag = 0;
newObj.Password = StringCipherCls.EncryptDES("654321", StringCipherCls.keyIn);
newObj.CreateDate = DateTime.Now;
newObj.CreateUser = strUserId;
newObj.DepId = newObj.DepId;
newObj.RoleType = "";
newObj.UpdateDate = DateTime.Now;
newObj.RoleType = "0";
newObj.CreateDate = DateTime.Now;
newObj.CreateUser = strUserId;
newObj.UpdateDate = DateTime.Now;
newObj.UpdateUser = strUserId;
// 生成卡号。
UserCardEntity cardEntity = new UserCardEntity();
cardEntity.CardId = CardId;
cardEntity.Flag = "0";
cardEntity.UserId = newObj.UserId;
cardEntity.CreateDate = DateTime.Now;
cardEntity.CreateUser = strUserId;
cardEntity.UpdateDate = DateTime.Now;
cardEntity.UpdateUser = strUserId;
bool isOK = usLogic.SaveUserCard(newObj, cardEntity);
return(Json(isOK));
}
catch
{
return(Json(false));
}
}
public bool SaveUserCard(UserInfoEntity user, UserCardEntity cardInfo)
{
try
{
SqlMapClientTemplate.mapper.BeginTransaction();
Insert("UserInfoMap.Save", user); // 员工保存
Insert("UserCardMap.Insert", cardInfo); // 员工账号保存
SqlMapClientTemplate.mapper.CommitTransaction();
return(true);
}
catch (Exception ex)
{
SqlMapClientTemplate.mapper.RollBackTransaction();
return(false);
}
}
public ActionResult GetUserByCardCode(string carid)
{
JsonResult result = new JsonResult();
try
{
UserCardEntity cardInfo = cardlogic.Load(carid);
UserInfoEntity userinfo = usLogic.Load(cardInfo.UserId);
if (userinfo == null)
{
result.Data = new { status = 200, msg = "无此用户" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
result.Data = new { status = 100, msg = "success", userData = userinfo };
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
result.Data = new { status = 200, msg = ex.Message };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult getRemainSum(string userid)
{
JsonResult result = new JsonResult();
UserInfoEntity user = userLogic.Load(userid);
if (user == null)
{
result.Data = new { status = 200, msg = "用户不存在" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
UserCardEntity cardEnty = usercardLogic.Load(user.CardId);
if (cardEnty == null)
{
result.Data = new { status = 200, msg = "用户卡号不存在" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
decimal leaveAmount = cardEnty.PreAmount - cardEnty.FeeAmount;
result.Data = new { status = 100, msg = "success", remainSum = leaveAmount };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult SavePatiBillItem(string userid, string cardid, decimal amount)
{
string CreateUser = HttpContext.ApplicationInstance.Context.Request.Cookies["UserId"].Value;
PatiInBillItemEntity billitem = new PatiInBillItemEntity();
billitem.BillItemId = CreateUser + DateTime.Now.ToString("yyMMddHHmmssfff");
billitem.UserId = userid;
billitem.Amount = amount;
billitem.IsUnusual = "0";
billitem.OrdId = "";
if (DateTime.Now.Hour < 10)
{
billitem.TypeCode = "01";
}
else if (DateTime.Now.Hour > 10 && DateTime.Now.Hour < 15)
{
billitem.TypeCode = "02";
}
else if (DateTime.Now.Hour > 15 && DateTime.Now.Hour < 22)
{
billitem.TypeCode = "03";
}
billitem.BillDate = DateTime.Now;
billitem.CreateDate = DateTime.Now;
billitem.CreateUser = CreateUser;
UserCardEntity cardEnty = this.usercardLogic.Load(cardid);
cardEnty.FeeAmount += amount;
cardEnty.UpdateDate = DateTime.Now;
cardEnty.UpdateUser = CreateUser;
bool isok = billitemLogic.SaveBillItemAndUserCard(billitem, cardEnty);
return(Json(isok, JsonRequestBehavior.AllowGet));
}
public bool Update(UserCardEntity entity)
{
return(access.Update(entity));
}
public bool Save(UserCardEntity obj)
{
throw new NotImplementedException();
}
public bool SaveUserCard(UserInfoEntity user, UserCardEntity cardInfo)
{
return(useraccess.SaveUserCard(user, cardInfo));
}
public bool BackUserFee(string applyId, string backUserId)
{
using (TransactionScope trans = new TransactionScope())
{
try
{
bool isok = true;
RefundsApplyEntity entity = access.Load(applyId);
entity.BackUserId = backUserId;
entity.BackDate = DateTime.Now;
entity.IsBack = "1";
isok = access.Update(entity);
if (isok == false)
{
return(false);
}
UserInfoEntity user = userAccess.Load(entity.UserId);
if (user != null)
{
UserCardEntity cardEnty = usercardAccess.Load(user.CardId);
cardEnty.PreAmount = cardEnty.PreAmount - entity.Amount;
cardEnty.UpdateDate = DateTime.Now;
cardEnty.UpdateUser = backUserId;
isok = usercardAccess.Update(cardEnty);
if (isok == false)
{
return(false);
}
}
PatiPayListEntity payInfo = new PatiPayListEntity();
payInfo.PayId = backUserId + DateTime.Now.ToString("yyMMddHHmmssff");
payInfo.UserId = entity.UserId;
payInfo.CardId = user.CardId;
payInfo.Direction = -1;
payInfo.CreateDate = DateTime.Now;
payInfo.CreateUser = backUserId;
payInfo.PayAmount = entity.Amount;
isok = paylistLogic.Save(payInfo); // 保存数据。
if (isok == true)
{
trans.Complete();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
}
public ActionResult GetUserByCardCode(string carid)
{
JsonResult result = new JsonResult();
try
{
UserCardEntity cardInfo = cardlogic.Load(carid);
if (cardInfo == null)
{
result.Data = new { status = 200, msg = "无此用户" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
UserInfoEntity userinfo = userLogic.Load(cardInfo.UserId);
if (userinfo.Flag == -1)
{
result.Data = new { status = 200, msg = "此用户已经停用，不能扫码收费！" };
return(Json(result, JsonRequestBehavior.AllowGet));
}
//if (userinfo.Flag == 0)
//{
// result.Data = new { status = 200, msg = "此用户未审核，不能扫码收费！" };
// return Json(result, JsonRequestBehavior.AllowGet);
//}
string TypeCode = "";
string typeCodeName = "";
if (DateTime.Now.Hour < 10)
{
TypeCode = "01";
typeCodeName = "早餐";
}
else if (DateTime.Now.Hour > 10 && DateTime.Now.Hour < 15)
{
TypeCode = "02";
typeCodeName = "午餐";
}
else if (DateTime.Now.Hour > 15 && DateTime.Now.Hour < 22)
{
TypeCode = "03";
typeCodeName = "晚餐";
}
IList <OrderDinnerEntity> dinners = dinnerlogic.LoadAll(" and TypeCode='" + TypeCode + "' and OrderDate between '" + DateTime.Now.ToString("yyyy-MM-dd 00:00:00") + "' and '" + DateTime.Now.ToString("yyyy-MM-dd 23:59:59") + "' and (CancUser is null or CancUser='') and UserId = '" + userinfo.UserId + "'", 99, 1, "OrderDate desc");
if (dinners != null && dinners.Count > 0)
{
int quantity = dinners[0].Quantity;
string ShowMsg = userinfo.UserName + "--" + dinners[0].OrderDate.ToString("yyyy-MM-dd") + "--预定[" + typeCodeName + "]--[" + quantity.ToString() + "份]";
result.Data = new { status = 100, msg = ShowMsg, userData = userinfo };
}
else
{
result.Data = new { status = 100, msg = userinfo.UserName + "-没有预定午餐", userData = userinfo };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
result.Data = new { status = 200, msg = ex.Message };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
