//调整顺序
public JsonResult UpdateIndex(int startIndex, int stopIndex, string GDH)
{
using (var db = new MySqlServer())
try
{
if (HanderDataForXF_SYService.GetOne(T => T.GDH == GDH) != null)
{
db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]=-1 where [index]={0} and GDH='{1}' ", stopIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]={0} where [index]={1} and GDH='{2}' ", stopIndex, startIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]={0} where [index]={1} and GDH='{2}' ", startIndex, -1, GDH));
return(Json(new { state = 1, msg = "排序成功。" }, JsonRequestBehavior.AllowGet));
}
else if (HanderDataForXF_KZService.GetOne(T => T.GDH == GDH) != null)
{
db.Database.GetInt(string.Format("update HanderDataForXF_KZ set [index]=-1 where [index]={0} and GDH='{1}' ", stopIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_KZ set [index]={0} where [index]={1} and GDH='{2}' ", stopIndex, startIndex, GDH));
db.Database.GetInt(string.Format("update HanderDataForXF_KZ set [index]={0} where [index]={1} and GDH='{2}' ", startIndex, -1, GDH));
return(Json(new { state = 1, msg = "排序成功。" }, JsonRequestBehavior.AllowGet));
}
else
{
throw new Exception("系统出错：数据库中找不到对应数据。");
}
}
catch (Exception ex)
{
return(Json(new { state = 0, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
//删除处理数据
public void DeleteForHanderData(string GDH, string Action)
{
try
{
#region 除重复数据
switch (Action)
{
case "XF_SY_NAN":
case "XF_SY_NU":
var SY_NU = HanderDataForXF_SYService.Query(T => T.GDH == GDH, O => O.Index, false);
foreach (var item in SY_NU)
{
HanderDataForXF_SYService.Delete(item.Id);
}
break;
case "XF_KZ_NAN":
case "XF_KZ_NU":
var KZ_NU = HanderDataForXF_KZService.Query(T => T.GDH == GDH, O => O.Index, false);
foreach (var item in KZ_NU)
{
HanderDataForXF_KZService.Delete(item.Id);
}
break;
}
#endregion
}
catch (Exception)
{
throw;
}
}
//获取初排数据
public JsonResult GetListForHanderData(string GDH, string Order, string type)
{
using (var db = new MySqlServer())
try
{
Order = Order.TrimEnd(',');
if (HanderDataForXF_SYService.GetOne(T => T.GDH == GDH) != null)
{
string xxxxdsadsax = string.Format("select ROW_NUMBER()over(order by {0}) rownum,* from (select * from HanderDataForXF_SY ) as list order by {0}", Order);
//list.Height,list.Sleeve,list.Bust
var SYList = db.Database.GetDataTable(string.Format("select ROW_NUMBER()over(order by {0}) rownum,* from (select * from HanderDataForXF_SY ) as list order by {0}", Order));
if (type != "NotOrder")
{
for (int i = 0; i < SYList.Rows.Count; i++)
{
var xxxxx = db.Database.GetInt(string.Format("update HanderDataForXF_SY set [index]={0} where id={1}", SYList.Rows[i]["rownum"].ToString(), SYList.Rows[i]["Id"].ToString()));
}
}
return(Json(new { state = 1, action = "HanderDataForXF_SY", msg = HanderDataForXF_SYService.Query(T => T.GDH == GDH, O => O.Index, false) }, JsonRequestBehavior.AllowGet));
}
else if (HanderDataForXF_KZService.GetOne(T => T.GDH == GDH) != null)
{
return(Json(new { state = 1, action = "HanderDataForXF_KZ", msg = HanderDataForXF_KZService.Query(T => T.GDH == GDH, O => O.Index, false) }, JsonRequestBehavior.AllowGet));
}
else
{
throw new Exception("系统出错：数据库中找不到对应数据。");
}
}
catch (Exception ex)
{
return(Json(new { state = 0, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public bool Handle_XF_KZ(string SizeCode, string GDH)
{
List <XF_SY_NAN_ChiMaDto> list = null;
#region 获取待处理数据
List <DCL_DataDto> GDData = DCL_DataService.Query(T => T.GDH == GDH, O => O.Id, false);
#endregion
try
{
#region 开始处理数据
List <DCL_DataDto> DLCData = new List <DCL_DataDto>();
#region 判断数据中是否有尺码编号 没有择手动补全
for (int i = 0; i < GDData.Count; i++)
{
DCL_DataDto dto = new DCL_DataDto();
dto = GDData[i];
if (string.IsNullOrEmpty(GDData[i].SizeCode))
{
dto.SizeCode = SizeCode;
}
DLCData.Add(dto);
}
#endregion
int index = 1;
foreach (DCL_DataDto item in DLCData)
{
decimal height_kz_nu = Convert.ToDecimal(item.ReCodeSize.ToString().Split('/')[0]);
string a02 = item.ReCodeSize.ToString().Split('/')[1];
string temp = a02.Substring(a02.Length - 1, 1);
string Code = a02.Substring(0, a02.Length - 1);
XF_KZ_CodeSizeDto dto = XF_KZ_CodeSizeService.GetOne(T => T.CP_WaistWidth.Contains(Code) && T.Code == temp && T.Size_Code == item.SizeCode && T.Status == 1);//TO DO
if (dto != null)
{
HanderDataForXF_KZDto sy = new HanderDataForXF_KZDto();
sy.Height = Convert.ToDecimal(item.ReCodeSize.Split('/')[0]);
sy.RtnQCode = item.ReCodeSize.ToString();
sy.OrderCode = item.Orderid.ToString();
sy.Name = item.Name.ToString();
sy.Number = item.Number;
sy.SZ_Hipline = dto.SZ_HipLength_CP;
sy.DZ_Hipline = dto.DZ_HipLength_CP;
sy.waistWidth = Convert.ToDecimal(Code);
sy.Index = index;
sy.GDH = item.GDH;
HanderDataForXF_KZService.Add(sy);
}
else
{
throw new CustomCatch(2, "没有查询到对应的尺码表数据,请更换尺码表编号");
}
}
#endregion
return(true);
}
catch (Exception)
{
throw;
}
}
//导出裁单
public JsonResult ExportCaiDan(FormCollection fm)
{
string GDH = fm["GDH_ZH"];
try
{
if (HanderDataForXF_SYService.GetOne(T => T.GDH == GDH) != null)
{
var data = HanderDataForXF_SYService.Query(T => T.GDH == GDH, O => O.Index, false);
DataTable table = new DataTable();
table.Columns.Add("姓名");
table.Columns.Add("归码后尺码");
table.Columns.Add("备注");
table.Columns.Add("数量");
table.Columns.Add("流水号");
table.Columns.Add("至流水号");
int liushui = Convert.ToInt32(fm["caidanindex"]);
foreach (var item in data)
{
DataRow row = table.NewRow();
row["姓名"] = item.Name;
row["归码后尺码"] = item.RtnQCode;
row["备注"] = item.Note;
row["数量"] = item.Number;
liushui++;
row["流水号"] = liushui;
liushui += item.Number;
row["至流水号"] = liushui;
table.Rows.Add(row);
}
ExcelHelper.BuildExcel(table, "裁床记录表");
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
}
else if (HanderDataForXF_KZService.GetOne(T => T.GDH == GDH) != null)
{
var data = HanderDataForXF_KZService.Query(T => T.GDH == GDH, O => O.Index, false);
DataTable table = new DataTable();
table.Columns.Add("姓名");
table.Columns.Add("归码后尺码");
table.Columns.Add("备注");
table.Columns.Add("数量");
table.Columns.Add("流水号");
table.Columns.Add("至流水号");
int liushui = Convert.ToInt32(fm["caidanindex"]);
foreach (var item in data)
{
DataRow row = table.NewRow();
row["姓名"] = item.Name;
row["归码后尺码"] = item.RtnQCode;
row["备注"] = item.Note;
row["数量"] = item.Number;
liushui++;
row["流水号"] = liushui;
liushui += item.Number;
row["至流水号"] = liushui;
table.Rows.Add(row);
}
ExcelHelper.BuildExcel(table, "裁床记录表");
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
}
else
{
throw new Exception("系统出错：数据库中找不到对应数据。");
}
}
catch (Exception ex)
{
return(Json(new
{
state = 0,
msg = ex.Message
}, JsonRequestBehavior.AllowGet));
}
}
