// Warning - will not work - see comment above ProblemFour method invokation in Main()
public static void Main()
{
var mongoHandler = new MongoDbHandler();
var sqlHandler = new SqlServerHandler();
var mySqlHandler = new MySqlHandler();
var pdfHandler = new PdfHandler();
var xmlToSql = new XmlToSqlServerLoader();
var excellHandler = new ExcellHandler();
var mongoToSql = new MongoToSqlServerLoader();
var zipExtractor = new ZipExtractor();
var jsonHandler = new JsonHandler();
var sqliteHandler = new SqliteHandler();
var xmlHandler = new XmlHandler();
if (!Directory.Exists(OutputDirectory))
{
Directory.CreateDirectory(OutputDirectory);
}
//// Mongolab.com credentials - Username: TeamXenon , Passsword: xenon123
ProblemOne(mongoHandler, mongoToSql, zipExtractor, excellHandler);
ProblemTwo(pdfHandler);
ProblemThree(xmlHandler);
//// NOTE!!! - you need to go to CarParts.Data.MySql project and in its App.config file
//// you should change the password in the connectionString tag with which you connect to your localhost instance of the MySQL Workbench server.
ProblemFour(sqlHandler, mySqlHandler, jsonHandler);
ProblemFive(mongoHandler, xmlToSql);
ProblemSix(excellHandler, sqlHandler, sqliteHandler, mySqlHandler);
}
private static void ProblemFour(SqlServerHandler sqlHandler, MySqlHandler mySqlHandler, JsonHandler jsonHandler)
{
var reports = sqlHandler.ReadPartReports();
jsonHandler.GenerateJsonReports(reports);
mySqlHandler.WriteReports(reports);
Console.WriteLine("Successfully added json reports to the file system and to MySQL database.");
}
private HTTPResponseDTO <T> WebExceptionHandler <T>(WebException webex, string referenceNo) where T : class
{
HTTPResponseDTO <T> response = null;
if (webex.Response != null)
{
WebResponse errResp = webex.Response;
HttpWebResponse resp = (HttpWebResponse)webex.Response;
using Stream respStream = errResp.GetResponseStream();
if (resp.StatusCode == HttpStatusCode.BadRequest)
{
string content = new StreamReader(respStream).ReadToEnd();
if (!string.IsNullOrWhiteSpace(content))
{
response = new HTTPResponseDTO <T>()
{
HttpStatusCode = resp.StatusCode,
Body = JsonHandler.Deserialize <T>(content)
};
}
else
{
Logger.WriteLog(logType: CommonEnum.LogLevelEnum.Error, methodBase: System.Reflection.MethodBase.GetCurrentMethod(), referenceNo: referenceNo, exception: webex);
}
}
else
{
Logger.WriteLog(logType: CommonEnum.LogLevelEnum.Error, methodBase: System.Reflection.MethodBase.GetCurrentMethod(), referenceNo: referenceNo, message: new StreamReader(respStream).ReadToEnd(), exception: webex);
}
}
else
{
Logger.WriteLog(logType: CommonEnum.LogLevelEnum.Error, methodBase: System.Reflection.MethodBase.GetCurrentMethod(), referenceNo: referenceNo, exception: webex);
}
return(response);
}
public string GetAllStores()
{
//Store s2 = StoreService.GetStore(2);
//foreach (Stock st in s2.Stocks)
//{
// int i = st.id;
//}
/*
* List<Store> ls = StoreService.GetAllStores();
* //jonathan: i just wrote this for debug
* foreach (Store s in ls)
* {
* foreach (Stock st in s.Stocks)
* {
* int i = st.id;
* }
* }
*/
List <Store> ls = StoreService.GetAllStores();
return(JsonHandler.SerializeObject(ls));
}
public async Task <IActionResult> GetProductorAsync(string id)
{
var productores = await JsonHandler.LoadFileAsync <Productor>(FilePath.Productores)
.ConfigureAwait(false);
var productor = productores.FirstOrDefault(p => p.Identificacion == id);
if (productor == null)
{
return(NotFound());
}
var allCalificaciones = await JsonHandler.LoadFileAsync <Calificacion>(FilePath.Calificacion);
var calificaciones = allCalificaciones.FindAll(c => c.IdProductor == id);
if (calificaciones.Count > 0)
{
productor.Calificaciones = calificaciones.Count;
productor.Calificacion = calificaciones.Sum(c => c.Valor) / calificaciones.Count;
}
return(Ok(productor));
}
public JsonResult Login(string userName, string password, string Code)
{
//验证验证码
if (Session["Code"] == null)
{
return(Json(JsonHandler.CreateMessage(0, "请重新刷新验证码"), JsonRequestBehavior.AllowGet));
}
if (Session["Code"].ToString().ToLower() != Code.ToLower())
{
return(Json(JsonHandler.CreateMessage(0, "验证码错误"), JsonRequestBehavior.AllowGet));
}
//验证用户
SysUser user = accoutBLL.Login(userName, ValueConvert.MD5(password));
if (user == null)
{
return(Json(JsonHandler.CreateMessage(0, "用户名或密码错误"), JsonRequestBehavior.AllowGet));
}
else if (!Convert.ToBoolean(user.State))//被禁用
{
return(Json(JsonHandler.CreateMessage(0, "用户被系统禁用"), JsonRequestBehavior.AllowGet));
}
AccountModel account = new AccountModel();
account.Id = user.Id;
account.TrueName = user.TrueName;
Session["Account"] = account;
//在线用户统计
//OnlineHttpModule.ProcessRequest();
return(Json(JsonHandler.CreateMessage(1, ""), JsonRequestBehavior.AllowGet));
}
public void CheckInReservation(int room, DateTime startDate)
{
Reservation reservation = Context.Reservations
.Include(r => r.Guest).Include(r => r.Transactions)
.Where(r => r.Room.FullRoomNumber == room)
.Where(r => r.StartDate <= startDate)
.Where(r => startDate < r.EndDate)
.FirstOrDefault(r => r.State != State.Canceled);
if (reservation == null)
{
return;
}
Logging.Instance.WriteLine("Edit reservation:");
Logging.Instance.WriteLine($"Old: {reservation}", true);
Reservations[reservation.Id - 1].State = State.CheckedIn;
reservation.LastVersionJson = JsonHandler.SerializeToJson(reservation);
reservation.State = State.CheckedIn;
reservation.DateModified = DateTime.Now;
Logging.Instance.WriteLine($"New: {reservation}", true);
Context.SaveChanges();
UpdateResInfos();
OnReservationsChanged?.Invoke(this, EventArgs.Empty);
}
public ActionResult Delete(long id)
{
WMS_Inventory_HModel entity = m_BLL.GetById(id);
entity.InventoryStatus = "已失效";
if (id != 0)
{
if (m_BLL.Edit(ref errors, entity))
{
LogHandler.WriteServiceLog(GetUserTrueName(), "Id:" + id, "成功", "删除", "WMS_Inventory_H");
return(Json(JsonHandler.CreateMessage(1, Resource.DeleteSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserTrueName(), "Id" + id + "," + ErrorCol, "失败", "删除", "WMS_Inventory_H");
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail)));
}
}
public ActionResult Delete(int headId)
{
int id = headId;
if (id != 0)
{
//if (m_BLL.Delete(ref errors, id))
if (m_BLL.ClearInventoryQty(ref errors, GetUserTrueName(), id))
{
LogHandler.WriteServiceLog(GetUserTrueName(), "Id:" + id, "成功", "删除", "WMS_Inventory_D");
return(Json(JsonHandler.CreateMessage(1, Resource.DeleteSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserTrueName(), "Id" + id + "," + ErrorCol, "失败", "删除", "WMS_Inventory_D");
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail)));
}
}
public async Task <ProjectFileExportJobStatus> GetProjectExportJobStatus(string projectName, string jobId)
{
// prepare api data
var url = string.Format("{0}/{1}/projects/{2}/export/jobs/{3}", _endpointUrl, _customTextAuthoringBaseUrl, projectName, jobId);
var headers = new Dictionary <string, string>
{
["Ocp-Apim-Subscription-Key"] = _serviceKey
};
var parameters = new Dictionary <string, string>
{
["api-version"] = CustomTextAuthoringApiVersion
};
// make network call
var response = await _httpHandler.SendGetRequestAsync(url, headers, parameters);
// handle errors if exists
await _helpers.HandleApiErrorResponse(response);
// parse result
var result = JsonHandler.DeserializeObject <ProjectFileExportJobStatus>(await response.Content.ReadAsStringAsync());
return(result);
}
public JsonResult SaveBefor(string inserted)
{
var personList = JsonHandler.DeserializeJsonToList <Spl_PersonModel>(inserted);
var personResultList = new List <Spl_PersonModel>();
//新加
if (personList != null && personList.Count != 0)
{
foreach (var model in personList)
{
Spl_PersonModel entity = new Spl_PersonModel();
entity.Id = ResultHelper.NewId;
entity.Name = model.Name;
entity.Sex = model.Sex;
entity.Age = model.Age;
entity.IDCard = model.IDCard;
entity.Phone = model.Phone;
entity.Email = model.Email;
entity.Address = model.Address;
entity.CreateTime = ResultHelper.NowTime;
entity.Region = model.Region;
entity.Category = model.Category;
personResultList.Add(entity);
}
}
try
{
m_BLL.SaveImportData(personResultList);
LogHandler.WriteServiceLog(GetUserId(), "导入成功", "成功", "导入", "Spl_Person");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed)));
}
catch (Exception ex) {
LogHandler.WriteServiceLog(GetUserId(), ex.Message, "失败", "导入", "Spl_Person");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ex.Message)));
}
}
public JsonResult Create(DEF_TestJobsDetailStepsModel model)
{
try
{
//新增
model.ItemID = Guid.NewGuid().ToString();
model.StepType = 0;
m_BLL.Create(ref validationErrors, model);
//写日志
if (validationErrors.Count > 0)
{
//错误写入日志
LogHandler.WriteServiceLog(GetUserId(), Resource.InsertFail + "，新增测试步骤ID:" + model.ItemID, "失败", "新增", "测试步骤");
return(Json(JsonHandler.CreateMessage(0, validationErrors.Error)));
}
//成功写入日志
LogHandler.WriteServiceLog(GetUserId(), Resource.InsertSucceed + "，新增测试步骤ID:" + model.ItemID, "成功", "新增", "测试步骤");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed)));
}
catch
{
return(Json(JsonHandler.CreateMessage(1, Resource.InsertFail)));
}
}
public JsonResult Create(MIS_ArticleModel model)
{
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.Creater = GetCurrentUserId();
if (model != null && ModelState.IsValid)
{
if (articleBll.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetCurrentUserId(), "Id" + model.Id + ",ChannelId" + model.ChannelId, "成功", "创建", "IMIS_ArticleRepository");
return(Json(JsonHandler.CreateMessage(1, Suggestion.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetCurrentUserId(), "Id" + model.Id + ",ChannelId" + model.ChannelId + "," + ErrorCol, "失败", "创建", "IMIS_ArticleRepository");
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail)));
}
}
public JsonResult Create(WMS_ReInspectModel model)
{
model.Id = 0;
model.CreateTime = ResultHelper.NowTime;
model.CreatePerson = GetUserTrueName();
if (model != null && ModelState.IsValid)
{
if (m_BLL.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserTrueName(), "Id" + model.Id + ",AIId" + model.AIId, "成功", "创建", "WMS_ReInspect");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserTrueName(), "Id" + model.Id + ",AIId" + model.AIId + "," + ErrorCol, "失败", "创建", "WMS_ReInspect");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail)));
}
}
public JsonResult Delete(string sno)
{
try
{
if (!ModelState.IsValid)
{
return(Json(JsonHandler.CreateMessage(0, "上传参有错误")));
}
if (string.IsNullOrEmpty(sno))
{
return(Json(JsonHandler.CreateMessage(0, "请选择删除记录")));
}
if (m_BLL.DeleteJob(ref validationErrors, sno))
{
//关闭任务
JobsTools.CloseTaskJob(ref validationErrors, sno);
}
//写日志
if (validationErrors.Count > 0)
{
//错误写入日志
LogHandler.WriteServiceLog(GetUserId(), "删除任务管理ID:" + sno, "失败", "删除", "任务管理");
return(Json(JsonHandler.CreateMessage(0, validationErrors.Error)));
}
//成功写入日志
LogHandler.WriteServiceLog(GetUserId(), "删除任务管理ID:" + sno, "成功", "删除", "任务管理");
return(Json(JsonHandler.CreateMessage(1, Resource.DeleteSucceed)));
}
catch
{
return(Json(JsonHandler.CreateMessage(0, Resource.DeleteFail)));
}
}
public async Task <IActionResult> AddClienteAsync(Cliente cliente)
{
cliente.Password = Encryption.Encrypt(cliente.Password);
if (cliente == null || string.IsNullOrWhiteSpace(cliente.Identificacion))
{
return(BadRequest());
}
var exists = await JsonHandler.CheckIfExists(FilePath.Clientes, cliente, (p1, p2) =>
{
return(p1.Identificacion == p2.Identificacion);
});
if (exists)
{
return(Conflict());
}
await JsonHandler.AddToFileAsync(FilePath.Clientes, cliente)
.ConfigureAwait(false);
return(CreatedAtRoute("default", new { id = cliente.Identificacion }, cliente));
}
public override List <Spl_ProductModel> GetList(ref GridPager pager, string queryStr)
{
IQueryable <Spl_Product> queryData = null;
if (!string.IsNullOrWhiteSpace(queryStr))
{
queryData = m_Rep.GetList(
a => a.Id.Contains(queryStr) ||
a.Name.Contains(queryStr) ||
a.Code.Contains(queryStr)
|| a.Color.Contains(queryStr)
|| a.CategoryId.Contains(queryStr)
|| a.CreateBy.Contains(queryStr)
);
}
else
{
queryData = m_Rep.GetList();
}
//启用通用列头过滤
if (!string.IsNullOrWhiteSpace(pager.filterRules))
{
List <DataFilterModel> dataFilterList = JsonHandler.Deserialize <List <DataFilterModel> >(pager.filterRules).Where(f => !string.IsNullOrWhiteSpace(f.value)).ToList();
queryData = LinqHelper.DataFilter <Spl_Product>(queryData, dataFilterList);
}
pager.totalRows = queryData.Count();
//排序
queryData = LinqHelper.SortingAndPaging(queryData, pager.sort, pager.order, pager.page, pager.rows);
return(CreateModelList(ref queryData));
}
public JsonResult Create(SysModuleModel model)
{
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.CreatePerson = GetUserId();
if (model != null && ModelState.IsValid)
{
if (m_BLL.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",Name" + model.Name, "成功", "创建", "SysModule");
return(Json(JsonHandler.CreateMessage(1, Suggestion.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",Name" + model.Name + "," + ErrorCol, "失败", "创建", "SysModule");
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail)));
}
}
public static void Main(string[] args)
{
Share share1 = new Share("vodName", "vod.l");
Share share2 = new Share("ftse", "ftse");
string[] shareNames = new string[2] {
"vodName", "ftseName"
};
string nameBasket = "Basket";
double strikeBasket = 9;
Share[] sharesBasket = { share1, share2 };
Double[] weights = { 0.3, 0.7 };
DateTime maturityBasket = new DateTime(2019, 09, 04);
BasketOption optionBasket = new BasketOption(nameBasket, sharesBasket, weights, maturityBasket, strikeBasket);
BasketOption optionBasket2 = new BasketOption("BASKETTT", sharesBasket, weights, maturityBasket, strikeBasket);
VanillaCall optionVanille = new VanillaCall("Vanille", sharesBasket[0], maturityBasket, strikeBasket);
VanillaCall optionVanille2 = new VanillaCall("Vanille2", sharesBasket[0], maturityBasket, strikeBasket);
JsonHandler jsonHandle = new JsonHandler();
jsonHandle.SaveOption(optionVanille);
jsonHandle.SaveOption(optionVanille);
jsonHandle.SaveOption(optionVanille2);
jsonHandle.SaveOption(optionBasket);
jsonHandle.SaveOption(optionBasket2);
jsonHandle.SaveOption(optionBasket);
jsonHandle.SaveOption(optionBasket);
jsonHandle.LoadOptions();
List <VanillaCall> listOptions = jsonHandle.ListVanillaCalls;
List <BasketOption> listBasket = jsonHandle.ListBasketOptions;
}
public async Task <IActionResult> UpdateCategoriaAsync(int id, Categoria categoria)
{
if (categoria == null || id != categoria.Id)
{
return(BadRequest());
}
var categorias = await JsonHandler.LoadFileAsync <Categoria>(FilePath.Categorias)
.ConfigureAwait(false);
var oldCat = categorias.FirstOrDefault(c => c.Id == id);
if (oldCat == null)
{
return(NotFound());
}
categorias.Remove(oldCat);
categorias.Add(categoria);
await JsonHandler.OvewriteFileAsync(FilePath.Categorias, categorias);
return(NoContent());
}
public async Task <Embed> ListJsons()
{
return(await JsonHandler.ListJsons(JsonFiles));
}
private async void buyShoppingBasketHandler(JObject msgObj, string message)
{
JsonResponse response;
string purchaseInfo = null;
int month = -1, year = -1, ccv = -1, id = -1;
string cardNumber = null, holder = null, name = null, address = null, city = null, country = null, zip = null;
int requestId = (int)msgObj["id"];
//{int cardNumber, int month,int year, string holder, int ccv, int id, string name, string address, string city, string country, string zip}
try
{
cardNumber = (string)msgObj["data"]["cardNumber"];
month = (int)msgObj["data"]["month"];
year = (int)msgObj["data"]["year"];
holder = (string)msgObj["data"]["holder"];
ccv = (int)msgObj["data"]["cvv"];
id = (int)msgObj["data"]["id"];
name = (string)msgObj["data"]["name"];
address = (string)msgObj["data"]["address"];
city = (string)msgObj["data"]["city"];
country = (string)msgObj["data"]["country"];
zip = (string)msgObj["data"]["zip"];
}
catch (WorkShopDbException dbExc)
{
response = JsonResponse.generateActionError(requestId, "DB is down please try again in few minutes\n" + dbExc.Message);
//Console.WriteLine("F 5");
}
catch (Exception e)
{
Logger.Log("error", logLevel.ERROR, "can't parse info from server");
response = JsonResponse.generateActionError(requestId, "can't parse the input please check the legality of your input");
sendMyselfAMessage(JsonHandler.SerializeObject(response));
//Console.WriteLine("F 4" + e.Message);
return;
}
try
{
purchaseInfo = await user.BuyShoppingBasket(cardNumber, month, year, holder, ccv, id, name, address, city, country, zip);
var x = new { data = "purchase succeeded:\n" + purchaseInfo };
response = JsonResponse.generateActionSucces(requestId, JsonHandler.SerializeObject(x));
/*var purchaseInfoNotificaiton = new { type = "notification", info = "message", data = purchaseInfo, requestId = -1 };
* purchaseInfo = JsonHandler.SerializeObject(purchaseInfoNotificaiton);*/
//Console.WriteLine("T");
}
catch (WorkShopDbException dbExc)
{
response = JsonResponse.generateActionError(requestId, "DB is down please try again in few minutes\n" + dbExc.Message);
//Console.WriteLine("F 1");
}
catch (Exception e)
{
response = JsonResponse.generateActionError(requestId, e.Message);
//Console.WriteLine("F 2");
}
sendMyselfAMessage(JsonHandler.SerializeObject(response));
/* for (int i = 0; i < 10_000; i++) ;
* if (purchaseInfo != null)
* sendMyselfAMessage(purchaseInfo);*/
}
public async Task <FileResult> Excel()
{
string userID = OpeCur.AccountNow.Id;
searchNo = userID + "ID";
gidPager = userID + "Pager";
var cacheSearchNo = Core.CacheHelper.GetCache(searchNo);
var cachePager = Core.CacheHelper.GetCache(gidPager);
string queryStr = (string)cacheSearchNo;
GridPager pager = (GridPager)cachePager;
List <QueryViewModel> listView = await FilterData(pager, queryStr);
if (!string.IsNullOrWhiteSpace(pager.filterRules))
{
List <DataFilterModel> dataFilterList = JsonHandler.Deserialize <List <DataFilterModel> >(pager.filterRules).Where(f => !string.IsNullOrWhiteSpace(f.value)).ToList();
listView = LinqHelper.DataFilter <QueryViewModel>((listView.AsEnumerable()).AsQueryable(), dataFilterList).ToList();
}
#region 获取失效日期并转换"yyyy年MM月dd日"
foreach (var item in listView)
{
await Task.Run <QueryViewModel>(() => { return(GetDataOfExpiry(item)); });
}
#endregion
//整合代码
//string title = new { "param":[{"WAREHOUSE":"仓库","ITEM":"编码","ITEM_DESC":"描述","COMPANY":"所属公司","ATTRIBUTE_NUM":"库存数量","ON_HAND_QTY":"处理数量"}] };
//string[] tt = { "WAREHOUSE", "ITEM", "ITEM_DESC", "COMPANY", "ATTRIBUTE_NUM", "ON_HAND_QTY" };
//DataTable tt1 = Commons.DataTableExtensions.ToDataTable<QueryViewModel>(listView, tt);//list数据转为Table类型
//NPOIHelper.WriteToDownLoad("临空" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls", "sheet1", tt1);//写入excel
#region 创建Excel表格
//创建Excel文件的对象
HSSFWorkbook book = new HSSFWorkbook();
//添加一个sheet
ISheet sheet1 = book.CreateSheet("Sheet1");
sheet1.SetColumnWidth(0, 15 * 256);
sheet1.SetColumnWidth(1, 15 * 256);
sheet1.SetColumnWidth(2, 35 * 256);
sheet1.SetColumnWidth(3, 15 * 256);
sheet1.SetColumnWidth(4, 15 * 256);
sheet1.SetColumnWidth(5, 15 * 256);
sheet1.SetColumnWidth(6, 15 * 256);
sheet1.SetColumnWidth(7, 15 * 256);
sheet1.SetColumnWidth(8, 10 * 256);
sheet1.SetColumnWidth(9, 10 * 256);
//给sheet1添加第一行的头部标题
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("仓库");
row1.CreateCell(1).SetCellValue("编号");
row1.CreateCell(2).SetCellValue("描述");
row1.CreateCell(3).SetCellValue("所属公司");
row1.CreateCell(4).SetCellValue("生产日期");
row1.CreateCell(5).SetCellValue("失效日期");
row1.CreateCell(6).SetCellValue("合格");
row1.CreateCell(7).SetCellValue("不合格");
row1.CreateCell(8).SetCellValue("库存数量");
row1.CreateCell(9).SetCellValue("处理数量");
//将数据逐步写入sheet1各个行
for (int i = 0; i < listView.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(listView[i].WAREHOUSE);
rowtemp.CreateCell(1).SetCellValue(listView[i].ITEM);
rowtemp.CreateCell(2).SetCellValue(listView[i].ITEM_DESC);
rowtemp.CreateCell(3).SetCellValue(listView[i].COMPANY);
rowtemp.CreateCell(4).SetCellValue(listView[i].DateOfProduction == null ? null : listView[i].DateOfProduction.ToString());
rowtemp.CreateCell(5).SetCellValue(listView[i].DateOfExpiry == null ? null : (listView[i].DateOfExpiry).ToString());
rowtemp.CreateCell(6).SetCellValue(listView[i].IsQualified.ToString());
rowtemp.CreateCell(7).SetCellValue(listView[i].IsNotQualified.ToString());
rowtemp.CreateCell(8).SetCellValue(listView[i].ATTRIBUTE_NUM.ToString());
rowtemp.CreateCell(9).SetCellValue(listView[i].ON_HAND_QTY.ToString());
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
#endregion
#region Excel 保存路径
// 输出Excel文件
#endregion
return(await Task.Run <FileResult>(() => { return File(ms, "application/vnd.ms-excel", "临空" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls"); }));
}
/// <summary>
/// Gets the Crosswalks from the server
/// </summary>
/// <param name="coordx">current latitude</param>
/// <param name="coordy">current longitude</param>
/// <returns></returns>
IEnumerator GetCrosswalksAround(float coordx, float coordy)
{
//double coordx = -960078.26;
//double coordy = 5035965.30;
//url connection
string getWayUrl = "http://" + localIP + ":8080/find/gis-crosswalks/two/";
//string getWayUrl = "http://127.0.0.1:8080/find/gis-crosswalks/two/";
string request = getWayUrl + coordx.ToString() + "/?coordy=" + coordy.ToString();
//get request
using (UnityWebRequest wayRequest = UnityWebRequest.Get(request))
{
yield return(wayRequest.Send());
//if any error
if (wayRequest.isNetworkError || wayRequest.isHttpError)
{
serverData.text = "Server: Cannot connect to the destination host. Verify your connection, please.";
Debug.Log(wayRequest.error);
}
else
{
if (wayRequest.isDone)
{
//get data to string
string jsonResult = System.Text.Encoding.UTF8.GetString(wayRequest.downloadHandler.data);
// Debug.Log(jsonResult);
if (jsonResult.Equals("null"))
{
Debug.Log("Nothing received (crosswalk)");
}
else
{
//getting json data to object from server
//hack to work with the JsonHelper class
string value = "{\"Items\":" + jsonResult + "}";
//print the received objects
ServerObject[] jsonObject = JsonHandler.FromJson <ServerObject>(value); // string json data to object
foreach (ServerObject element in jsonObject)
{
Debug.Log("Crosswalk ID: " + element.gis_crosswalks_id + " intersection: " + element.gis_crosswalks_intersection_id +
" coordx: " + element.gis_crosswalk_coordinatesX + " coordy: " + element.gis_crosswalk_coordinatesY);
//verifies if already created or not
AddOrNot(element);
//add object to list and create the instance
if (canAdd)
{
element.created = "no";
buildSceneScript.objectList.Add(element);
Debug.Log("Added crosswalk " + element.gis_crosswalks_id + " to the objectList");
}
}
serverData.text = "Server: received something";
}
}
}
}
}
public async Task InvokeAsync(HttpContext context)
{
string requestBody = string.Empty;
try
{
context.Request.EnableBuffering();
using (StreamReader reader = new StreamReader(context.Request.Body))
{
requestBody = await reader.ReadToEndAsync();
context.Request.Body.Position = 0;
await Next(context);
}
}
catch (System.Exception ex)
{
string referenceNo = Guid.NewGuid().ToString();
_logger.WriteLog(logType: CommonEnum.LogLevelEnum.Error, methodBase: System.Reflection.MethodBase.GetCurrentMethod(), referenceNo: referenceNo, exception: ex);
_logger.WriteLog(logType: CommonEnum.LogLevelEnum.Information, methodBase: System.Reflection.MethodBase.GetCurrentMethod(), referenceNo: referenceNo, message: $"Reqeust body: {JsonHandler.Serialize(requestBody)}");
HandleException(context, referenceNo);
}
}
private async Task <List <QueryViewModel> > FilterData(GridPager pager, string queryStr)
{
var Datalist = OpeCur.SCVServiceSession.LOCATION_INVENTORY.GetList().ToList();//获取所有数据
if ((!string.IsNullOrEmpty(queryStr)) && queryStr != "")
{
Datalist = Datalist.Where(t => t.ITEM.ToLower().Contains(queryStr.Trim().ToLower())).ToList();
if (Datalist == null)
{
return(null);
}
}
string userID = OpeCur.AccountNow.Id;
//整合所属商家数据
List <SysUserMerchantCodeModel> companyList = OpeCur.ServiceSession.SysUserMerchantCode.GetList().Where(t => t.UserId == userID).ToList();
#region 整合所属商户的数据
//整合多个公司的数据
List <LOCATION_INVENTORY_MODEL> listSource = new List <LOCATION_INVENTORY_MODEL>();
List <LOCATION_INVENTORY_MODEL> companyItem = new List <LOCATION_INVENTORY_MODEL>();
foreach (var company in companyList)
{
companyItem = Datalist.Where(L => L.COMPANY.ToLower() == company.MerchantCode.ToLower()).ToList();
listSource = listSource.Concat(companyItem).ToList();
}
#endregion
searchNo = userID + "ID";
gidPager = userID + "Pager";
Core.CacheHelper.SetCache(searchNo, queryStr, 1200);//搜索条件置入缓存
Core.CacheHelper.SetCache(gidPager, pager, 1200);
var cacheSearchNo = Core.CacheHelper.GetCache(searchNo);
var cachePager = Core.CacheHelper.GetCache(gidPager);
List <QueryViewModel> queryList = await CacheData(listSource, queryStr);
List <QueryViewModel> GetList = new List <QueryViewModel>();
QueryViewModel modelItem = new QueryViewModel();
if (!string.IsNullOrWhiteSpace(pager.filterRules))
{
List <DataFilterModel> dataFilterList = JsonHandler.Deserialize <List <DataFilterModel> >(pager.filterRules).Where(f => !string.IsNullOrWhiteSpace(f.value)).ToList();
queryList = LinqHelper.DataFilter <QueryViewModel>((queryList.AsEnumerable()).AsQueryable(), dataFilterList).ToList();
}
#region 排序
if (pager.order == "asc")
{
if (pager.sort == "ITEM")
{
queryList = queryList.OrderBy(t => t.ITEM).ToList();
}
else if (pager.sort == "COMPANY")
{
queryList = queryList.OrderBy(t => t.COMPANY).ToList();
}
else if (pager.sort == "ATTRIBUTE_NUM")
{
queryList = queryList.OrderBy(t => t.ATTRIBUTE_NUM).ToList();
}
else if (pager.sort == "ON_HAND_QTY")
{
queryList = queryList.OrderBy(t => t.ON_HAND_QTY).ToList();
}
else if (pager.sort == "IsQualified")
{
queryList = queryList.OrderBy(t => t.IsQualified).ToList();
}
else if (pager.sort == "IsNotQualified")
{
queryList = queryList.OrderBy(t => t.IsNotQualified).ToList();
}
else if (pager.sort == "DaysToExpire")
{
queryList = queryList.OrderBy(t => t.DaysToExpire).ToList();
}
else if (pager.sort == "DateOfProduction")
{
queryList = queryList.OrderBy(t => t.DateOfProduction).ToList();
}
else if (pager.sort == "DateOfExpiry")
{
queryList = queryList.OrderBy(t => t.DateOfExpiry).ToList();
}
}
else
{
if (pager.sort == "ITEM")
{
queryList = queryList.OrderByDescending(t => t.ITEM).ToList();
}
else if (pager.sort == "COMPANY")
{
queryList = queryList.OrderByDescending(t => t.COMPANY).ToList();
}
else if (pager.sort == "ATTRIBUTE_NUM")
{
queryList = queryList.OrderByDescending(t => t.ATTRIBUTE_NUM).ToList();
}
else if (pager.sort == "ON_HAND_QTY")
{
queryList = queryList.OrderByDescending(t => t.ON_HAND_QTY).ToList();
}
else if (pager.sort == "IsQualified")
{
queryList = queryList.OrderByDescending(t => t.IsQualified).ToList();
}
else if (pager.sort == "IsNotQualified")
{
queryList = queryList.OrderByDescending(t => t.IsNotQualified).ToList();
}
else if (pager.sort == "DaysToExpire")
{
queryList = queryList.OrderByDescending(t => t.DaysToExpire).ToList();
}
else if (pager.sort == "DateOfProduction")
{
queryList = queryList.OrderByDescending(t => t.DateOfProduction).ToList();
}
else if (pager.sort == "DateOfExpiry")
{
queryList = queryList.OrderByDescending(t => t.DateOfExpiry).ToList();
}
}
#endregion
return(queryList);
}
public ConnectionHandler()
{
jsonHandler = new JsonAdapter();
}
public Fuzzy_Sets()
{
_walkingRules = JsonHandler <FuzzySets> .GetFromJson("FuzzySets.json");
}
public JsonResult Create(Flow_FormContentModel model)
{
//当前的Form模版
Flow_FormModel formModel = formBLL.GetById(model.FormId);
//初始化部分数据
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.UserId = GetUserId();
model.Title = formModel.Name;
model.TimeOut = DateTime.Now.AddDays(30);
if (model != null && ModelState.IsValid)
{
//内容提交数据库
if (formContentBLL.Create(ref errors, model))
{
try
{
List <Flow_StepModel> stepModelList = stepBLL.GetList(ref setNoPagerAscBySort, model.FormId);
//查询步骤
int listCount = stepModelList.Count();
bool IsEnd = false;
//循环表单的所有步骤
for (int i = 0; i < listCount; i++)
{
string nextStep = "";
Flow_StepModel stepModel = stepModelList[i];
//获得步骤对应的规则
List <Flow_StepRuleModel> stepRuleModelList = stepRuleBLL.GetList(stepModel.Id);
//获取规则判断流转方向
foreach (Flow_StepRuleModel stepRuleModel in stepRuleModelList)
{
//获取需要判断的数值，比如请假天数
string val = new FlowHelper().GetFormAttrVal(stepRuleModel.AttrId, formModel, model);
//有满足流程结束的条件，判断请假天数是否处于这个规则内
if (!JudgeVal(stepRuleModel.AttrId, val, stepRuleModel.Operator, stepRuleModel.Result))
{
//如果符合规则，判断是否还有下一步
if (stepRuleModel.NextStep != "0")
{
//跳转后的下一步
for (int j = 0; j < listCount; j++)
{
//看看当前步骤是哪一步
if (stepModelList[j].Id == nextStep)
{
i = j;//跳到分支后的下一步，从这一步开始循环
continue;
}
}
}
else
{
IsEnd = true;
continue;
}
}
}
#region 插入步骤
//插入步骤审核表
Flow_FormContentStepCheckModel stepCheckModel = new Flow_FormContentStepCheckModel();
stepCheckModel.Id = ResultHelper.NewId;
stepCheckModel.ContentId = model.Id;
stepCheckModel.StepId = stepModel.Id;
stepCheckModel.State = (int)FlowStateEnum.Progress;
stepCheckModel.StateFlag = false;//true此步骤审核完成
stepCheckModel.CreateTime = ResultHelper.NowTime;
stepCheckModel.IsEnd = IsEnd;
stepCheckModel.IsCustom = stepModel.FlowRule == (int)FlowRuleEnum.Customer ? true : false;
if (stepCheckBLL.Create(ref errors, stepCheckModel))//新建步骤成功
{
InsertChecker(model, i, stepModel, stepCheckModel);
}
if (IsEnd)//如果是最后一步就无需要下面继续了
{
break;
}
#endregion
}
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",AttrA" + model.AttrA, "成功", "创建", "Flow_FormContent");
return(Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed)));
}
catch (Exception ex)
{
//创建失败，删除表单
formContentBLL.Delete(ref errors, model.Id);
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + "流程发生异常，请联系管理员")));
}
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",AttrA" + model.AttrA + "," + ErrorCol, "失败", "创建", "Flow_FormContent");
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Resource.InsertFail)));
}
}
public void SaveGearList()
{
JsonHandler.SaveJsonFile <GearList>(gearList, "GearList");
}
public void LoadGearList()
{
gearList = JsonHandler.LoadJsonFile <GearList>("JSON/GearList");
}
public JsonResult Create(Flow_FormContentModel model)
{
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.UserId = GetUserId();
if (model != null && ModelState.IsValid)
{
if (formContentBLL.Create(ref errors, model))
{
//当前的Form模版
Flow_FormModel formModel = formBLL.GetById(model.FormId);
//创建成功后把步骤取出
List <Flow_StepModel> stepModelList = stepBLL.GetList(ref setNoPagerAscBySort, model.FormId);
//查询步骤
bool IsEnd = false;
foreach (Flow_StepModel stepModel in stepModelList)
{
List <Flow_StepRuleModel> stepRuleModelList = stepRuleBLL.GetList(stepModel.Id);
//获取规则判断流转方向
foreach (Flow_StepRuleModel stepRuleModel in stepRuleModelList)
{
string val = new FlowHelper().GetFormAttrVal(stepRuleModel.AttrId, formModel, model);
//有满足不流程结束的条件
if (!JudgeVal(stepRuleModel.AttrId, val, stepRuleModel.Operator, stepRuleModel.Result))
{
if (stepRuleModel.NextStep != "0")
{
IsEnd = false;
}
}
}
//插入步骤审核表
Flow_FormContentStepCheckModel stepCheckModel = new Flow_FormContentStepCheckModel();
stepCheckModel.Id = ResultHelper.NewId;
stepCheckModel.ContentId = model.Id;
stepCheckModel.StepId = stepModel.Id;
stepCheckModel.State = 2; //0不通过1通过2审核中
stepCheckModel.StateFlag = false; //true此步骤审核完成
stepCheckModel.CreateTime = ResultHelper.NowTime;
stepCheckModel.IsEnd = IsEnd; //是否流程的最后一步
if (formContentStepCheckBLL.Create(ref errors, stepCheckModel)) //新建步骤成功
{
//获得流转规则下的审核人员
List <string> userIdList = GetStepCheckMemberList(stepModel.Id, model.Id);
if (userIdList.Count > 0)
{
foreach (string userId in userIdList)
{
//批量建立步骤审核人表
Flow_FormContentStepCheckStateModel stepCheckStateModel = new Flow_FormContentStepCheckStateModel();
stepCheckStateModel.Id = ResultHelper.NewId;
stepCheckStateModel.StepCheckId = stepCheckModel.Id;
stepCheckStateModel.UserId = userId;
stepCheckStateModel.CheckFlag = 2;
stepCheckStateModel.Reamrk = "";
stepCheckStateModel.TheSeal = "";
stepCheckStateModel.CreateTime = ResultHelper.NowTime;
stepCheckStateBLL.Create(ref errors, stepCheckStateModel);
}
}
}
if (IsEnd)//如果是最后一步就无需要下面继续了
{
break;
}
IsEnd = true;
}
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",AttrA" + model.AttrA, "成功", "创建", "Flow_FormContent");
return(Json(JsonHandler.CreateMessage(1, Suggestion.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",AttrA" + model.AttrA + "," + ErrorCol, "失败", "创建", "Flow_FormContent");
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail)));
}
}
public static bool ProcessCachedResults(string filename, JsonHandler handler) {
var rc = false;
try {
using (var file = new StreamReader(filename)) {
var line = file.ReadLine();
var status = line.Split(' ');
if (status == null) return rc;
if (status.Length != 3) return rc;
if (int.Parse(status[1]) != 200) return rc;
line = null;
status = null;
Debug.GC(true);
var length = file.BaseStream.Length;
while (length-- > 0) {
var c = (Char)file.Peek();
if (c == '{') {
try {
handler(file);
rc = true;
} catch (Exception e) {
Debug.Print(e.Message);
}
break;
} else {
c = (Char)file.Read();
}
}
}
} catch (IOException e) {
Debug.Print(e.Message);
}
Debug.GC(true);
return rc;
}
