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);
}
}
