//public static readonly InterfaceEventLogRepository LogRepository = new EventLogRepository();
/// <summary>
/// 得到正在发行的产品
/// </summary>
/// <returns></returns>
//public OPM GetAllProducts()
//{
// OPM opm111 = new OPM();
// List<OptionsProductModel> lopm = new List<OptionsProductModel>();
// IEnumerable<OptionsProduct> iop = OptionsProductRepository.FindAll().Where(p => p.Status == 1);
// if (iop != null && iop.Count() != 0)
// {
// foreach (var item in iop)
// {
// OptionsProductModel opm = new OptionsProductModel();
// opm.addDate = Convert.ToDateTime(item.AddDate).ToString("yyyy-MM-dd HH:mm:ss");
// opm.beginDate = Convert.ToDateTime(item.BeginDate).ToString("yyyy-MM-dd HH:mm:ss");
// opm.charge = item.Charge;
// opm.chargeType = item.ChargeType;
// opm.deadline = item.Deadline;
// opm.endDate = string.Empty;
// opm.callPriceType = item.CallPriceType;
// //opm.Margin = item.Margin;
// //opm.MarginType = item.MarginType;
// opm.maxNum = item.MaxNum;
// opm.optionsProductID = item.OptionsProductID;
// opm.optionType = item.OptionType;
// opm.partnerName = item.PartnerName;
// opm.price = item.Price;
// opm.priceType = item.PriceType;
// opm.amountType = item.AmountType;
// opm.productName = item.ProductName;
// opm.status = item.Status;
// opm.unit = item.Unit;
// opm.productDesc = item.ProductDesc;
// opm.productDtlDesc = item.ProductDtlDesc;
// opm.formula = item.Formula;
// opm.productUrl = item.ProductUrl;
// opm.contract = item.Contract;
// opm.contractChs = item.ContractChs;
// List<FallRoleModel> lfrm = new List<FallRoleModel>();
// List<FallRole> lfr = FallRoleRepository.FindList(f => f.OptionsProductID == item.OptionsProductID, string.Empty, false).ToList();
// if (lfr != null && lfr.Count() != 0)
// {
// foreach (var fall in lfr)
// {
// FallRoleModel frm = new FallRoleModel();
// frm.compensateNum = fall.CompensateNum;
// frm.compensateType = fall.CompensateType;
// frm.createDate = Convert.ToDateTime(fall.CreateDate).ToString("yyyy-MM-dd HH:mm:ss");
// frm.down = fall.Down;
// frm.fallRoleID = fall.FallRoleID;
// frm.fallRoleName = fall.FallRoleName;
// frm.optionsProductID = fall.OptionsProductID;
// frm.partType = fall.PartType;
// frm.topCompensateNum = fall.TopCompensateNum;
// frm.topCompensateType = fall.TopCompensateType;
// frm.up = fall.Up;
// frm.upDownType = fall.UpDownType;
// lfrm.Add(frm);
// }
// }
// opm.fallRole = lfrm;
// List<RiseRoleModel> lrrm = new List<RiseRoleModel>();
// List<RiseRole> lrr = RiseRoleRepository.FindList(r => r.OptionsProductID == item.OptionsProductID, string.Empty, false).ToList();
// if (lrr != null && lrr.Count() != 0)
// {
// foreach (var rise in lrr)
// {
// RiseRoleModel rrm = new RiseRoleModel();
// rrm.createDate = Convert.ToDateTime(rise.CreateDate).ToString("yyyy-MM-dd HH:mm:ss");
// rrm.dividendNum = rise.DividendNum;
// rrm.dividendType = rise.DividendType;
// rrm.down = rise.Down;
// rrm.optionsProductID = rise.OptionsProductID;
// rrm.partType = rise.PartType;
// rrm.riseRoleID = rise.RiseRoleID;
// rrm.riseRoleName = rise.RiseRoleName;
// rrm.topDividendNum = rise.TopDividendNum;
// rrm.topDividendType = rise.TopDividendType;
// rrm.up = rise.Up;
// rrm.upDownType = rise.UpDownType;
// lrrm.Add(rrm);
// }
// }
// opm.riseRole = lrrm;
// lopm.Add(opm);
// }
// opm111.products = lopm;
// }
// return opm111;
//}
//private static object o = new object();
/// <summary>
/// 第三方取得期货价格
/// 异步操作
/// </summary>
/// <returns></returns>
public async Task <HttpResponseMessage> PostFuturePriceByDate(HttpRequestMessage request)
{
try
{
string loginjson = request.Content.ReadAsStringAsync().Result;
if (!string.IsNullOrEmpty(loginjson))
{
return(await Task.Run(async() =>
{
RequestFuturePriceModel json = JsonConvert.DeserializeObject <RequestFuturePriceModel>(DESEncrypt.DesDecrypt(loginjson));
ReturnFuturePriceModel RFPM = new ReturnFuturePriceModel();
List <RFuturePrice> LFP = new List <RFuturePrice>();
List <DateTime> alldays = GetAllDays(Convert.ToDateTime(json.StartDate), Convert.ToDateTime(json.EndDate));
foreach (DateTime day in alldays)
{
//string sday = day.ToString("yyyy-MM-dd");
FuturePrice price = await FuturePriceRepository.FindAsync(p => p.TradeCode == json.Contract && p.Date == day);
if (price != null)
{
LFP.Add(new RFuturePrice {
date = day.ToString("yyyy-MM-dd"), price = price.Price
});
}
}
RFPM.datas = LFP;
RFPM.result = "1";
RFPM.message = string.Empty;
string str = DESEncrypt.DesEncrypt(JsonConvert.SerializeObject(RFPM));
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json")
};
return result;
}));
}
else
{
string str = DESEncrypt.DesEncrypt("{\"result\":\"0\",\"message\":\"json为空\"}");
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
}
catch (Exception ex)
{
string str = DESEncrypt.DesEncrypt("{\"result\":\"0\",\"message\":\"" + ex.Message + "\"}");
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json")
};
LogRepository.Add(new EventLog()
{
Name = "第三方", Date = DateTime.Now.ToLocalTime(), Event = "取得期货价格失败" + ex.Message
});
return(result);
}
}
public void LogEvent(string eventTypeCode, ApplicationUser appUser)
{
var eventLog = new EventLog
{
EventTypeCode = eventTypeCode,
UserCreatedID = appUser.Id,
UserCreatedName = appUser.UserName,
DataValues = "User=" + appUser.ToString(),
DateTimeCreated = DateTime.Now
};
_eventLogRepository.Add(eventLog);
}
public async Task AddDomainEvent(EventLog eventLog)
{
try
{
await _eventLogRepository.Add(eventLog);
}
catch (Exception exception)
{
_logger.Error(exception, "Unable to save domain event into repository for correlation {CorrelationId}", eventLog.CorrelationId);
_logger.Error("Event Log {EventLog} with correlation {CorrelationId}", eventLog, eventLog.CorrelationId);
throw;
}
}
private async Task <IEnumerable <Domain.Entities.Thermostat> > Parse(object json)
{
if (_settings.StoreResponse)
{
await _eventLogRepository.Add(new EventLog(
"Ecobee", _settings.ThermostatUri, "ResponseBody", DateTime.UtcNow, _request.CorrelationId, entityObject : json));
}
return(ThermostatListParser.Parse(json));
}
private async Task <EcobeeResponsesModel> Parse(object json)
{
if (_settings.StoreResponse)
{
await _eventLogRepository.Add(new EventLog(
"Ecobee", _settings.ThermostatUri, "ResponseBody", DateTime.UtcNow, _correlationId, entityObject : json));
}
var response = EcobeeResponseParser.Parse(json);
if (response.Code != 0)
{
var exception = new HqvException("Ecobee responded not sucessful");
exception.Data["response"] = response;
}
return(response);
}
public ActionResult AddUser(User user)
{
try
{
if (user != null)
{
user.Date = DateTime.Now.ToLocalTime().ToString();
user.UserPassword = EncryptUtils.Base64Encrypt(user.UserPassword);
if (UserRepository.Add(user) != null)
{
LogRepository.Add(new EventLog()
{
Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "新增用户成功"
});
return(Json(new
{
Success = true,
Msg = "用户添加成功。"
}));
}
}
return(Json(new
{
Success = false,
Msg = "添加失败，请重新提交。"
}));
}
catch (Exception ex)
{
LogRepository.Add(new EventLog()
{
Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "新增用户失败" + ex.Message
});
return(Json(new
{
Success = false,
Msg = "添加失败，" + ex.Message
}));
}
}
public async Task <ActionResult> UploadMonitorCondition(string monitordate, string id, HttpPostedFileBase uploadedFile)
{
try
{
if (uploadedFile != null && uploadedFile.ContentLength > 0)
{
Guid MonitorID = new Guid(id);
DateTime MonitorDate = Convert.ToDateTime(monitordate);
string fileExtenSion = Path.GetExtension(uploadedFile.FileName);
string path = System.IO.Path.Combine(Server.MapPath("~/FileUpLoad/"), System.IO.Path.GetFileName(uploadedFile.FileName));
string justName = Path.GetFileNameWithoutExtension(uploadedFile.FileName);
uploadedFile.SaveAs(path);//将文件保存到本地
DataTable dt = await ExcelReader.ReadExcel(fileExtenSion, path);
if (dt.Rows.Count == 0 || dt == null)
{
return(Json(new
{
statusCode = 400,
status = "数据数量为空，请重新检查文件。"
}));
}
if (dt.Columns.Count < 2)
{
return(Json(new
{
statusCode = 400,
status = "数据列数量有误，请重新检查数据是否合格。"
}));
}
int count = 0;
List <MonitorCondition> lmc = new List <MonitorCondition>();
foreach (DataRow item in dt.Rows)
{
MonitorCondition mc = new MonitorCondition();
mc.MonitorID = MonitorID;
mc.Contract = justName;
mc.MainPosition = Convert.ToInt32(item[0]);
mc.MinPosition = Convert.ToInt32(item[1]);
mc.MaxPosition = Convert.ToInt32(item[2]);
mc.MinPrice = Convert.ToInt32(item[3]);
mc.MaxPrice = Convert.ToInt32(item[4]);
mc.MonitorDate = MonitorDate;
lmc.Add(mc);
}
count = MonitorConditionRepository.AddRange(lmc);
LogRepository.Add(new EventLog()
{
Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "上传监控指标数据" + count.ToString() + "条数据。"
});
return(Json(new
{
statusCode = 200,
status = "已经上传" + count.ToString() + "条数据。"
}));
}
else
{
return(Json(new
{
statusCode = 400,
status = "文件传输有误，请重新上传。"
}));
}
}
catch (Exception ex)
{
return(Json(new
{
statusCode = 400,
status = "文件上传发生异常," + ex.Message
}));
}
}
public ActionResult AddGoodsPurchase(GoodsPurchase purchase)
{
try
{
if (purchase != null)
{
purchase.TotalPrice = purchase.UnitPrice * purchase.ContractNum;
purchase.AwaitPickdingNum = purchase.ContractNum - purchase.AlreadyPickingNum;
purchase.TonCost = purchase.UnitPrice + purchase.LogisticsCost;
purchase.AllCost = purchase.TonCost * purchase.ContractNum;
purchase.GoodsPurchaseID = new GoodsPurchase().GoodsPurchaseID;
purchase.Noter = Session["LoginedUser"].ToString();
purchase.RecordTime = DateTime.Now;
if (GoodsPurchaseRepository.Add(purchase) != null)
{
return(Json(new { Success = true }));
}
}
return(Json(new { Success = false,
Message = "参数有误。" }));
}
catch (Exception ex)
{
LogRepository.Add(new EventLog()
{
Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "新增现货采购合同失败" + ex.Message
});
return(Json(new
{
Success = false,
Message = ex.Message
}));
}
}
public ActionResult AddTemplateAction(Brochure model)
{
try
{
if (model != null)
{
model.TempDate = DateTime.Now.ToLocalTime();
model.IsTemp = true;
if (BrochureRepository.Add(model) != null)
{
LogRepository.Add(new EventLog()
{
Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "新增宣传册模板事件成功"
});
return(Json(new
{
Success = true
}));
}
}
return(Json(new
{
Success = false
}));
}
catch (Exception ex)
{
LogRepository.Add(new EventLog()
{
Name = Session["LoginedUser"].ToString(), Date = DateTime.Now.ToLocalTime(), Event = "新增宣传册模板事件失败" + ex.Message
});
return(Json(new
{
Success = false
}));
}
}
public int Add(EventLogs eventLog)
{
return(_eventLogRepository.Add(eventLog));
}
