public void ProcessRequest(HttpContext context) { System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); var form = context.Request["form"]; var orderId = int.Parse(context.Request["orderId"]); var workpieceNumber = int.Parse(context.Request["workpieceNumber"]); var obj = serializer.Deserialize <AddSize>(form); using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { var row = new JDJS_WMS_Quality_ManualInput_Measurement_Table { OrderID = orderId, WorkpieceNumber = workpieceNumber, SizeNumber = int.Parse(obj.SizeNumber), SizeName = obj.SizeName, StandardValue = double.Parse(obj.StandardValue), ToleranceRangeMin = double.Parse(obj.ToleranceRangeMin), ToleranceRangeMax = double.Parse(obj.ToleranceRangeMax), Measurements = double.Parse(obj.Measurements), }; entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Add(row); entities.SaveChanges(); context.Response.Write("ok"); } }
public void ProcessRequest(HttpContext context) { using (JDJS_WMS_DB_USEREntities entities = new JDJS_WMS_DB_USEREntities()) { using (System.Data.Entity.DbContextTransaction db = entities.Database.BeginTransaction()) { try { var data = context.Request["form"]; var list = Serializer.Deserialize <WorkPiece>(data); var orderNumber = int.Parse(list.orderNumber); var orderId = entities.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == list.orderNumber).FirstOrDefault().Order_ID; var newRow = new JDJS_WMS_Quality_ManualInput_Measurement_Table { OrderID = orderId, Measurements = Convert.ToDouble(list.Measurements), SizeName = list.SizeName, WorkpieceNumber = Convert.ToInt32(list.workpieceNumber), SizeNumber = Convert.ToInt32(list.SizeNumber), StandardValue = Convert.ToDouble(list.StandardValue), ToleranceRangeMax = Convert.ToDouble(list.ToleranceRangeMax), ToleranceRangeMin = Convert.ToDouble(list.ToleranceRangeMin), }; entities.JDJS_WMS_Quality_ManualInput_Measurement_Table.Add(newRow); entities.SaveChanges(); db.Commit(); context.Response.Write("ok"); } catch (Exception ex) { context.Response.Write(ex.Message); return; } } } }
public void ProcessRequest(HttpContext context) { var files = context.Request.Files; PathInfo pathInfo = new PathInfo(); var fileName = files[0].FileName; var path = Path.Combine(pathInfo.upLoadPath(), fileName); if (File.Exists(path)) { File.Delete(path); } files[0].SaveAs(path); string FilePath = path; List <QualityInfo> qualities = new List <QualityInfo>(); string fileSuffix = System.IO.Path.GetExtension(FilePath); if (fileSuffix == ".xls") { #region { DataTable dt = getData(FilePath).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { using (JDJS_WMS_DB_USEREntities CIE = new JDJS_WMS_DB_USEREntities()) { string a1 = dt.Rows[i]["订单单号"].ToString(); var order = CIE.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == a1); if (order.Count() > 0) { QualityInfo quality = new QualityInfo(); quality.OrderNum = Convert.ToInt32(order.First().Order_ID); quality.WorkpieceNumber = Convert.ToInt32(dt.Rows[i]["工件序号"].ToString()); quality.SizeNumber = Convert.ToInt32(dt.Rows[i]["尺寸序号"].ToString()); quality.SizeName = dt.Rows[i]["尺寸名称"].ToString();; quality.StandardValue = Convert.ToDouble(dt.Rows[i]["尺寸理论值"].ToString()); quality.ToleranceRangeMin = Convert.ToDouble(dt.Rows[i]["合理误差范围下公差"].ToString()); quality.ToleranceRangeMax = Convert.ToDouble(dt.Rows[i]["合理误差范围上公差"].ToString()); quality.Measurements = Convert.ToDouble(dt.Rows[i]["尺寸实测值"].ToString()); if (dt.Rows[i]["是否超差"].ToString() == "是") { quality.OutOfTolerance = 1; } else if (dt.Rows[i]["是否超差"].ToString() == "否") { quality.OutOfTolerance = 0; } else { quality.OutOfTolerance = 2; } qualities.Add(quality); } } } } #endregion } else if (fileSuffix == ".csv") { //List<QualityInfo> qualities = new List<QualityInfo>(); //using (FileStream file = new FileStream(FilePath, FileMode.Append)) //{ using (StreamReader read = new StreamReader(FilePath, Encoding.Default)) { string str = read.ReadLine(); str = read.ReadLine(); while (str != null) { if (str != null && str != ",,,,,,,") { string[] info = str.Split(','); using (JDJS_WMS_DB_USEREntities CIE = new JDJS_WMS_DB_USEREntities()) { string ordernum = info[0]; var order = CIE.JDJS_WMS_Order_Entry_Table.Where(r => r.Order_Number == ordernum); if (order.Count() > 0) { QualityInfo quality = new QualityInfo(); quality.OrderNum = Convert.ToInt32(order.First().Order_ID); quality.WorkpieceNumber = Convert.ToInt32(info[1]); quality.SizeNumber = Convert.ToInt32(info[2]); quality.SizeName = info[3]; quality.StandardValue = Convert.ToDouble(info[4]); quality.ToleranceRangeMin = Convert.ToDouble(info[5]); quality.ToleranceRangeMax = Convert.ToDouble(info[6]); quality.Measurements = Convert.ToDouble(info[7]); if (info[8] == "是") { quality.OutOfTolerance = 1; } else if (info[8] == "否") { quality.OutOfTolerance = 0; } else { quality.OutOfTolerance = 2; } qualities.Add(quality); } } } str = read.ReadLine(); } } //} } else { context.Response.Write("请输入格式为csv或xls的文件"); return; } using (JDJS_WMS_DB_USEREntities CIE = new JDJS_WMS_DB_USEREntities()) { using (System.Data.Entity.DbContextTransaction mytran = CIE.Database.BeginTransaction()) { try { foreach (var item in qualities) { JDJS_WMS_Quality_ManualInput_Measurement_Table ma = new JDJS_WMS_Quality_ManualInput_Measurement_Table() { OrderID = item.OrderNum, WorkpieceNumber = item.WorkpieceNumber, SizeNumber = item.SizeNumber, SizeName = item.SizeName, StandardValue = item.StandardValue, ToleranceRangeMin = item.ToleranceRangeMin, ToleranceRangeMax = item.ToleranceRangeMax, Measurements = item.Measurements, OutOfTolerance = item.OutOfTolerance }; CIE.JDJS_WMS_Quality_ManualInput_Measurement_Table.Add(ma); } CIE.SaveChanges(); mytran.Commit(); } catch { mytran.Rollback(); } } } context.Response.Write("ok"); }