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