public List <Pubs> GetAllPubList()
{
try
{
List <Pubs> Pubs = new List <Pubs>();
using (var db = new rftkocsmadbEntities3())
{
Pubs = db.Pubs.ToList();
foreach (Pubs pub in Pubs)
{
pub.customerOverallRatings = PubManager.CalculateOverAllRatingPub(pub.pubID.ToString());
}
db.SaveChanges();
Pubs = db.Pubs.ToList();
return(Pubs);
}
}
catch (Exception e)
{
throw e;
}
}
public HttpResponseMessage CommandEQM(string EqmUID, int Command)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C052_EQMController_CommandEQM";
var msg = "";
try
{
var EqmU = eqm.eqm_EquipmentSugar.GetById(EqmUID);
if (EqmU == null)
{
response.SetContent(HttpStatus.error, "设备不存在", "", ResponseType.josn);
return(response);
}
var project = dict.dict_ProjectListSQLSugar.GetById(EqmU.ProjectCode);
if (project == null)
{
response.SetContent(HttpStatus.error, "项目不存在！", project, ResponseType.josn);
return(response);
}
var sysManager = new ORM.SqlSugar.BLL.sysManager();
var model = sysManager.AliConfigSQLSugar.GetById(1);
PubManager pum = new PubManager(model.AccessKey, model.SecretKey);
var rmsg = "";
var pupstr = "{\"method\":\"thing.service.property.set\",\"id\":\"222857295\",\"params\":{\"Command\":\"" + Command + "_1\"},\"version\":\"1.0.0\"}";
var presut = pum.Pub(project.ProductKey, EqmU.DeviceName, pupstr, out rmsg);
if (presut)
{
response.SetContent(HttpStatus.ok, "指令下发成功", "", ResponseType.josn);
return(response);
}
else
{
response.SetContent(HttpStatus.error, "与硬件通讯失败", rmsg, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public void AddOpinion(customerOpinions OpinionToBeAdded)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
db.customerOpinions.Add(OpinionToBeAdded);
db.Pubs.Find(OpinionToBeAdded.pubID).customerOverallRatings = PubManager.CalculateOverAllRatingPub(OpinionToBeAdded.pubID.ToString());
db.SaveChanges();
}
}
catch (System.Data.Entity.Core.UpdateException e)
{
Debug.WriteLine(e.ToString());
throw e;
}
}
private void getMess(HtmlMessage mess)
{
try
{
IPubManager manager = new PubManager();
if (manager.SavePub(mess))
{
string id = mess.Id;
if (id.PadLeft(0x19, '0').CompareTo(Config.maxMessID.PadLeft(0x19, '0')) > 0)
{
Config.maxMessID = id;
PropertyUtil.SetValue("PUB_MAX_MESS_ID", id);
}
}
new MessageForm(this, mess).ShowDialog();
}
catch (Exception exception)
{
this.log.ErrorFormat("接收公告信息异常：{0}", exception.ToString());
}
}
private void Awake()
{
instance = this;
}
public HttpResponseMessage OpenMaintainEQM(string MemberCode, int Switch, string EqmUID, string MaintainProductCode, bool Discharge)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "A049_EQMController_OpenMaintainEQM";
var msg = "";
try
{
var EqmU = eqm.eqm_EquipmentSugar.GetById(EqmUID);
if (EqmU == null)
{
response.SetContent(HttpStatus.error, "设备不存在", "", ResponseType.josn);
return(response);
}
var exit_model = eqm.eqm_ExchangeListSugar.GetSingle(p => p.EqmUID == EqmUID && p.Status != 3 && p.Status != 9 && p.OverdueTime > DateTime.Now);
if (exit_model != null)
{
response.SetContent(HttpStatus.error, "设备正在使用中，请等待", exit_model.OverdueTime, ResponseType.josn);
return(response);
}
var pd = new pdMannager();
var project = dict.dict_ProjectListSQLSugar.GetById(EqmU.ProjectCode);
if (project == null)
{
response.SetContent(HttpStatus.error, "项目不存在！", project, ResponseType.josn);
return(response);
}
var _switch = eqm.eqm_PartitionSwitchSugar.GetSingle(p => p.EqmUID == EqmUID && p.PartitionWallID == Switch);
if (_switch == null)
{
response.SetContent(HttpStatus.error, "该电池单元不可用！", project, ResponseType.josn);
return(response);
}
if (!string.IsNullOrEmpty(MaintainProductCode))
{
var count = eqm.eqm_PartitionSwitchSugar.Count(p => p.ProductCode == MaintainProductCode);
if (count > 0)
{
response.SetContent(HttpStatus.error, "该电池已在设备中！", project, ResponseType.josn);
return(response);
}
var product = pd.pd_ProductListSugar.GetById(MaintainProductCode);
if (product == null)
{
response.SetContent(HttpStatus.error, "电池不存在！", product, ResponseType.josn);
return(response);
}
if (product.ProductType != _switch.ProductType)
{
response.SetContent(HttpStatus.error, "该单元不能放这个电池！", project, ResponseType.josn);
return(response);
}
var scount = mb.mb_StockLSugar.Count(p => p.Qty > 0 && p.ProductCode == MaintainProductCode);
if (scount > 0)
{
response.SetContent(HttpStatus.error, "这个电池已在会员使用中！", project, ResponseType.josn);
return(response);
}
}
var or_head = new ORM.SqlSugar.Model.eqm.eqm_ExchangeList();
var ExRef = "Exchange" + JVS_ADM.Common.Utils.GetRamCode();
if (Discharge)
{
ExRef = "Discharge" + JVS_ADM.Common.Utils.GetRamCode();
}
or_head.ExRef = ExRef;
or_head.ExTime = DateTime.Now;
or_head.MemberCode = MemberCode;
or_head.OverdueTime = DateTime.Now.AddMinutes(1);
or_head.Status = 0;
or_head.ShopID = EqmU.ShopID;
or_head.EqmUID = EqmU.EqmUID;
or_head.ProductCode = MaintainProductCode;
or_head.OldProductCode = "";
or_head.Switch = Switch;
var result = db.SqlServerClient.Ado.UseTran(() =>
{
var sysManager = new ORM.SqlSugar.BLL.sysManager();
var model = sysManager.AliConfigSQLSugar.GetById(1);
PubManager pum = new PubManager(model.AccessKey, model.SecretKey);
var rmsg = "";
Random rd = new Random();
var pupstr = "{\"method\":\"thing.service.property.set\",\"id\":\"222940092\",\"params\":{\"MaintainLast\":\"" + ExRef + "_" + Switch + "_1\"},\"version\":\"1.0.0\"}";
if (Discharge)
{
pupstr = "{\"method\":\"thing.service.property.set\",\"id\":\"222940092\",\"params\":{\"Discharge\":\"" + ExRef + "_" + Switch + "_1\"},\"version\":\"1.0.0\"}";
}
var presut = pum.Pub(project.ProductKey, EqmU.DeviceName, pupstr, out rmsg);
if (presut)
{
eqm.eqm_ExchangeListSugar.Insert(or_head);
}
else
{
response.SetContent(HttpStatus.error, "与硬件通讯失败", or_head, ResponseType.josn);
}
});
if (result.IsSuccess)
{
response.SetContent(HttpStatus.ok, "操作成功", or_head, ResponseType.josn);
return(response);
}
else
{
response.SetContent(HttpStatus.error, result.ErrorMessage, or_head, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage OpenEQM(string MemberCode, string EqmUID, string OldProductCode, decimal UnitPrice, decimal Qty, decimal PayAmount, decimal DiscountedAmt)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C045_EQMController_OpenEQM";
var msg = "";
try
{
var member = mb.mb_BaseInfoSQLSugar.GetById(MemberCode);
if (member == null || member.ExpirationDate == null || member.ExpirationDate < DateTime.Now)
{
response.SetContent(HttpStatus.error, "您还不是VIP会员！", "chongqian", ResponseType.josn);
return(response);
}
var EqmU = eqm.eqm_EquipmentSugar.GetById(EqmUID);
if (EqmU == null)
{
response.SetContent(HttpStatus.error, "设备不存在", "", ResponseType.josn);
return(response);
}
var exit_model = order.order_HeaderSugar.GetSingle(p => p.EqmUID == EqmUID && p.Status != 3 && p.Status != 9 && p.OverdueTime > DateTime.Now);
if (exit_model != null)
{
response.SetContent(HttpStatus.error, "设备正在使用中，请稍后重试", exit_model.OverdueTime, ResponseType.josn);
return(response);
}
var productOld = pd.pd_ProductListSugar.GetById(OldProductCode);
if (productOld == null)
{
response.SetContent(HttpStatus.error, "电池代码无效！", productOld, ResponseType.josn);
return(response);
}
var project = dict.dict_ProjectListSQLSugar.GetById(EqmU.ProjectCode);
if (project == null)
{
response.SetContent(HttpStatus.error, "项目不存在！", project, ResponseType.josn);
return(response);
}
if (productOld == null)
{
response.SetContent(HttpStatus.error, "电池不存在！", productOld, ResponseType.josn);
return(response);
}
var list = pd.pd_ProductTypeSugar.GetList(p => p.ProjectCode == "cabinet");
var ProductType = pd.GetSaleCardType(list, productOld.ProductType.ToInt32());
var vipCount = mb.mb_Assets.Count(p => p.MemberCode == MemberCode && p.ProductType == ProductType && p.ExpiryDate > DateTime.Now);
if (vipCount <= 0)
{
response.SetContent(HttpStatus.error, "您还没开通VIP会员或是会员已过期！", project, ResponseType.josn);
return(response);
}
var count = eqm.eqm_PartitionSwitchSugar.Count(p => p.EqmUID == EqmUID && p.ProductType == productOld.ProductType && p.Switch == 1);
if (count <= 0)
{
response.SetContent(HttpStatus.error, "没有可用的单元，请稍后重试！", project, ResponseType.josn);
return(response);
}
var or_head = new ORM.SqlSugar.Model.order.order_Header();
var or_List = new ORM.SqlSugar.Model.order.order_List();
var OrderRef = "Battery" + JVS_ADM.Common.Utils.GetRamCode();
or_head.OrderRef = OrderRef;
or_head.OrderTime = DateTime.Now;
or_head.ProjectCode = EqmU.ProjectCode;
or_head.MemberCode = MemberCode;
or_head.TotalAmount = UnitPrice * Qty;
or_head.PayAmount = PayAmount;
or_head.DiscountedAmt = DiscountedAmt;
or_head.mbAddressID = 0;
or_head.OverdueTime = DateTime.Now.AddMinutes(1);
or_head.Status = 0;
or_head.ShopID = EqmU.ShopID;
or_head.EqmUID = EqmU.EqmUID;
or_head.Para1 = 0;
or_head.Msg = productOld.ProductType.ToString() + "类型的电池";
or_List.OrderRef = OrderRef;
or_List.ProductCode = "";
or_List.MemberCode = MemberCode;
or_List.Qty = Qty;
or_List.CreditsNo = 0;
or_List.OldProductCode = OldProductCode;
var Reservelist = order.order_ReservedSugar.GetList(p => p.MemberCode == MemberCode && p.EvaluateTime > DateTime.Now && p.Status == 1);
var result = db.SqlServerClient.Ado.UseTran(() =>
{
var sysManager = new ORM.SqlSugar.BLL.sysManager();
var model = sysManager.AliConfigSQLSugar.GetById(1);
PubManager pum = new PubManager(model.AccessKey, model.SecretKey);
var rmsg = "";
Random rd = new Random();
var pupstr = "{\"method\":\"thing.service.property.set\",\"id\":\"222857295\",\"params\":{\"SwitchLast\":\"" + OrderRef + "_" + productOld.ProductType + "\"},\"version\":\"1.0.0\"}";
var presut = pum.Pub(project.ProductKey, EqmU.DeviceName, pupstr, out rmsg);
if (presut)
{
order.order_HeaderSugar.Insert(or_head);
order.order_ListSugar.Insert(or_List);
foreach (var item in Reservelist)
{
item.Status = 3;
order.order_ReservedSugar.Update(item);
}
}
else
{
response.SetContent(HttpStatus.error, "与硬件通讯失败", or_head, ResponseType.josn);
}
});
if (result.IsSuccess)
{
response.SetContent(HttpStatus.ok, "操作成功", or_head, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, result.ErrorMessage, or_head, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public MainPage()
{
this.InitializeComponent();
Pubs = PubManager.GetPubs();
}
public void DeleteOpinionByID(string opinionID)
{
try
{
using (var db = new rftkocsmadbEntities3())
{
db.customerOpinions.Remove(db.customerOpinions.Find(opinionID));
db.Pubs.Find(db.customerOpinions.Find(opinionID).pubID).customerOverallRatings = PubManager.CalculateOverAllRatingPub(db.customerOpinions.Find(opinionID).pubID.ToString());
db.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
