public HandlingResult Update(SnModel model) { HandlingResult result = new HandlingResult(); String sql = String.Format("UPDATE BPSYS_STORESN SET NAME='{0}',CODE='{1}' WHERE ID='{2}'", model.Name, model.Code, model.Id); String querysql = String.Format("SELECT ID FROM BPSYS_STORESN WHERE CODE='{0}'", model.Code); using (DataBaseProcess process = new DataBaseProcess()) { DataTable dt = process.Query(querysql); if (dt != null && dt.Rows.Count > 0) { Guid id = Guid.Parse(dt.Rows[0]["ID"].ToString()); if (id != model.Id) { result.MsgNumber = 0; result.Message = String.Format("SN[{0}]已经存在", model.Code); } else { result.MsgNumber = process.Exec(sql); } } } result.Successed = result.MsgNumber > 0; result.Message = result.Message.Length > 0 ? result.Message : result.Successed ? "更新成功" : "更新失败"; return(result); }
public HandlingResult Add(SnModel model) { HandlingResult result = new HandlingResult(); String querysql = String.Format("SELECT COUNT(1) AS CNT FROM BPSYS_STORESN WHERE CODE='{0}'", model.Code); String sql = "INSERT INTO BPSYS_STORESN(ID, STOREID, NAME, CODE, STATUS, CREATOR, CREATORID, CREATEDTIME) VALUES ('{0}', '{1}', '{2}', '{3}', {4}, '{5}', '{6}', '{7}')"; sql = String.Format(sql, model.Id, model.StoreId, model.Name, model.Code, 1, UserInformationContext.LoginName, UserInformationContext.ID, DateTime.Now.ToString(ConfigImformationContext.TIME_FORMAT_FULL)); using (DataBaseProcess process = new DataBaseProcess()) { DataTable dt = process.Query(querysql); if (dt != null && dt.Rows.Count > 0) { result.MsgNumber = Int32.Parse(dt.Rows[0]["CNT"].ToString()); if (result.MsgNumber == 0) { result.MsgNumber = process.Exec(sql); } else { result.MsgNumber = 0; result.Message = String.Format("SN[{0}]已经存在", model.Code); } } } result.Successed = result.MsgNumber > 0; result.Message = result.Successed ? "新增成功" : "新增失败"; return(result); }
private HandlingResult ValidateSNSave() { HandlingResult result = new HandlingResult(); SnModel model = new SnModel(); model.Name = textBoxSnName.Text.TrimStart().TrimEnd(); model.Code = textBoxSnCode.Text.TrimStart().TrimEnd(); model.StoreId = _selStoreId; if (String.IsNullOrEmpty(model.Name)) { result.Successed = false; result.Message += "\r\n请填写SN别名"; } if (String.IsNullOrEmpty(model.Code)) { result.Successed = false; result.Message += "\r\n请填写SN"; } if (model.StoreId == null || model.StoreId.Equals(Guid.Empty)) { result.Successed = false; result.Message += "\r\n请选择门店"; } model.Id = Guid.NewGuid(); result.Result = model; return(result); }
public CustomJsonResult Run() { CustomJsonResult result = new CustomJsonResult(); var merchantPosMachines = CurrentDb.MerchantPosMachine.Where(m => m.ExpiryTime < DateTime.Now).ToList(); Log.InfoFormat("到期的机器数量有:{0}", merchantPosMachines.Count); foreach (var merchantPosMachine in merchantPosMachines) { merchantPosMachine.Status = Enumeration.MerchantPosMachineStatus.Expiry; var orderToServiceFee = CurrentDb.OrderToServiceFee.Where(m => m.Status == Enumeration.OrderStatus.WaitPay && m.Type == Entity.Enumeration.OrderType.PosMachineServiceFee && m.UserId == merchantPosMachine.UserId && m.MerchantId == merchantPosMachine.MerchantId && m.PosMachineId == merchantPosMachine.PosMachineId).FirstOrDefault(); if (orderToServiceFee == null) { CalculateServiceFee calculateServiceFee = new CalculateServiceFee(); orderToServiceFee = new OrderToServiceFee(); orderToServiceFee.MerchantId = merchantPosMachine.MerchantId; orderToServiceFee.PosMachineId = merchantPosMachine.PosMachineId; orderToServiceFee.UserId = merchantPosMachine.UserId; orderToServiceFee.SubmitTime = this.DateTime; orderToServiceFee.Type = Enumeration.OrderType.PosMachineServiceFee; orderToServiceFee.TypeName = Enumeration.OrderType.PosMachineServiceFee.GetCnName(); orderToServiceFee.Deposit = 0; orderToServiceFee.MobileTrafficFee = calculateServiceFee.MobileTrafficFee; orderToServiceFee.PriceVersion = calculateServiceFee.Version; orderToServiceFee.Price = calculateServiceFee.MobileTrafficFee; orderToServiceFee.Status = Enumeration.OrderStatus.WaitPay; orderToServiceFee.CreateTime = this.DateTime; orderToServiceFee.Creator = 0; CurrentDb.OrderToServiceFee.Add(orderToServiceFee); CurrentDb.SaveChanges(); SnModel snModel = Sn.Build(SnType.OrderToServiceFee, orderToServiceFee.Id); orderToServiceFee.Sn = snModel.Sn; orderToServiceFee.TradeSnByWechat = snModel.TradeSnByWechat; orderToServiceFee.TradeSnByAlipay = snModel.TradeSnByAlipay; Log.InfoFormat("生成待支付订单号:{0}", orderToServiceFee.Sn); } SysFactory.SysItemCacheUpdateTime.UpdateUser(orderToServiceFee.UserId); CurrentDb.SaveChanges(); } return(result); }
private void AddSN() { HandlingResult result = ValidateSNSave(); if (result.Successed) { SnModel model = (SnModel)result.Result; SNAction action = new SNAction(); result = action.Add(model); if (result.Successed) { MessageHelper.ShowInformationNotify(this, result.Message); } else { MessageHelper.ShowErrorNotify(this, result.Message); } } else { MessageHelper.ShowErrorNotify(this, result.Message); } }