/// <summary>
/// 编辑xf_sy_nan_chima
/// </summary>
/// <param name="dto">实体</param>
/// <returns></returns>
public bool Update(XF_SY_NAN_ChiMaDto dto)
{
using (var scope = _dbScopeFactory.Create())
{
var db = GetDb(scope);
var dbSet = GetDbSet(db);
var entity = Mapper.Map <XF_SY_NAN_ChiMaDto, XF_SY_NAN_ChiMaEntity>(dto);
dbSet.AddOrUpdate(entity);
return(db.SaveChanges() > 0);
}
}
public JsonResult DeleteCode(FormCollection fm)
{
try
{
int Id;
if (!int.TryParse(fm["Id"], out Id))
{
throw new Exception("系统出错：Id格式错误");
}
switch (fm["Action"])
{
case "XF_SY_NAN":
XF_SY_NAN_ChiMaDto dto = XF_SY_NAN_ChiMa.GetOne(T => T.Id == Id);
dto.IsDeleted = true;
XF_SY_NAN_ChiMa.Update(dto);
break;
case "XF_SY_NU":
XF_SY_NU_CodeSizeDto dtonu = XF_SY_NU_ChiMa.GetOne(T => T.Id == Id);
dtonu.IsDeleted = true;
XF_SY_NU_ChiMa.Update(dtonu);
break;
case "XF_KZ_NAN":
case "XF_KZ_NU":
XF_KZ_CodeSizeDto dtokz = XF_KZ_CodeSizeService.GetOne(T => T.Id == Id);
dtokz.IsDeleted = true;
XF_KZ_CodeSizeService.Update(dtokz);
break;
}
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = -1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public bool Handle_XF_SY_NAN(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
#region 验证此数据是否可以处理
string Action = isSYorKZTo(DLCData);
if (isSYorKZTo(DLCData) == "")
{
throw new Exception("此工单号数据不统一或是没有对应的处理程序。");
}
#endregion
DeleteForHanderData(GDH, Action);
decimal Height; //身高
string JingXiongWei; //净胸围
string XiuChang; //袖长
string TeShuShuJu; //特殊数据
int index = 1;
string NetBustNan = "";
foreach (DCL_DataDto item in DLCData)
{
NetBustNan = item.ReCodeSize.ToString().Split('/')[1];
string isT = "[\u4e00-\u9fa5]";
Regex Regex = new Regex(isT);
string DcHeight = item.ReCodeSize.ToString().Split('/')[0];
#region 处理特殊身高
if (Regex.IsMatch(DcHeight))
{
Height = Convert.ToDecimal(DcHeight.Substring(1, DcHeight.Length));
}
else
{
Height = Convert.ToDecimal(DcHeight);
}
#endregion
JingXiongWei = item.ReCodeSize.ToString().Split('/')[1];//净胸围
Regex rex = new Regex("[\u4e00-\u9fa5]{2}[-/+][0-9]{0,3}");
if (Regex.IsMatch(item.ReCodeSize.ToString().Split('/')[2]))
{
XiuChang = item.ReCodeSize.ToString().Split('/')[2].Substring(0, 1);//袖长
}
else
{
XiuChang = item.ReCodeSize.ToString().Split('/')[2];//袖长
}
//获取尺码表数据
XF_SY_NAN_ChiMaDto dtonan = XF_SY_NAN_ChiMaService.GetOne(T => T.Height == Height && T.NetBust == JingXiongWei && T.Size_Code == SizeCode && T.Status == 1);
if (dtonan != null)
{
HanderDataForXF_SYDto sy = new HanderDataForXF_SYDto();
sy.Height = dtonan.Height;
sy.RtnQCode = item.ReCodeSize.ToString();
sy.OrderCode = item.Orderid.ToString();
sy.Name = item.Name.ToString();
sy.RtnHCode = JingXiongWei;
sy.Number = item.Number;
sy.GDH = item.GDH;
sy.Yichang = Convert.ToDecimal(dtonan.FrontLength);
#region 处理袖长
string[] Sleecve = dtonan.Sleecve_Show.Split(' ');
for (int i = 0; i < Sleecve.Length; i++)
{
if (Sleecve[i].IndexOf(';') > 0)
{
if (Sleecve[i].Split(';')[0] == XiuChang)
{
sy.Sleeve = Convert.ToDecimal(Sleecve[i].Split(';')[1]);
}
}
else if (Sleecve[i].IndexOf(':') > 0)
{
if (Sleecve[i].Split(':')[0] == XiuChang)
{
sy.Sleeve = Convert.ToDecimal(Sleecve[i].Split(':')[1]);
}
}
}
#endregion
sy.Bust = dtonan.FinishedBust;
sy.Index = index;
var TsArrey = rex.Matches(item.ReCodeSize.ToString().Split('/')[2]);
#region 處理特躰
foreach (Match TsItem in TsArrey)
{
Regex Tn = new Regex("[\u4e00-\u9fa5]{2}"); //名称
Regex Tysf = new Regex("[-/+]"); //运算符
Regex Tv = new Regex("[0-9]{1,2}"); //值
switch (Tn.Match(TsItem.Value).Value)
{
case "袖长": //袖长
decimal Sleeve = sy.Sleeve;
if (Tysf.Match(TsItem.Value).Value == "+")
{
sy.Sleeve = Sleeve + Convert.ToInt32(Tv.Match(TsItem.Value));
}
else
{
sy.Sleeve = Sleeve + Convert.ToInt32(Tv.Match(TsItem.Value));
}
break;
case "下摆": //下摆
break;
case "三围": //三围
if (Tysf.Match(TsItem.Value).Value == "+")
{
sy.Yichang += Convert.ToInt32(Tv.Match(TsItem.Value));
sy.Bust += Convert.ToInt32(Tv.Match(TsItem.Value));
}
else
{
string xxx = Tv.Match(TsItem.Value).Value;
sy.Yichang -= Convert.ToInt32(Tv.Match(TsItem.Value).Value);
sy.Bust -= Convert.ToInt32(Tv.Match(TsItem.Value).Value);
}
break;
case "肩宽": //肩宽
break;
}
}
#endregion
HanderDataForXF_SYService.Add(sy);
}
index++;
}
#endregion
return(true);
}
catch (Exception)
{
throw;
}
}
//上传西服上衣尺码表
public bool Import_XF_SY(DataTable table, string size_code, string gender, out string errmsg)
{
try
{
List <XF_SY_NAN_ChiMaDto> list = new List <XF_SY_NAN_ChiMaDto>();
for (int i = 0; i < table.Rows.Count; i++)
{
#region 处理不符合要求得数据
DataRow row = table.Rows[i];
row.BeginEdit();
for (int a = 0; a < table.Columns.Count; a++)
{
if (row[a].ToString().IndexOf("....") > 0)
{
row[a] = row[a].ToString().Replace("....", ".");
}
if (row[a].ToString().IndexOf("...") > 0)
{
row[a] = row[a].ToString().Replace("...", ".");
}
if (row[a].ToString().IndexOf("..") > 0)
{
row[a] = row[a].ToString().Replace("..", ".");
}
}
row.EndEdit();
#endregion
}
if (gender == "男")
{
for (int i = 0; i < table.Rows.Count; i++)
{
XF_SY_NAN_ChiMaDto cs = new XF_SY_NAN_ChiMaDto();
cs.Height = Convert.ToDecimal(table.Rows[i]["Height"]);
cs.FrontLength = table.Rows[i]["FrontLength"] + "";
cs.NetBust = table.Rows[i]["NetBust"] + "";
cs.FinishedBust = Convert.ToDecimal(table.Rows[i]["FinishedBust"]);
cs.InWaist = Convert.ToDecimal(table.Rows[i]["InWaist"]);
cs.FinishedHem_NoFork = Convert.ToDecimal(table.Rows[i]["FinishedHem_NoFork"]);
cs.FinishedHem_SplitEnds = Convert.ToDecimal(table.Rows[i]["FinishedHem_SplitEnds"]);
cs.ShoulderWidth = Convert.ToDecimal(table.Rows[i]["ShoulderWidth"]);
cs.Size_Code = size_code;
cs.Sleecve_Show = table.Rows[i]["FK_Sleeve_ID"] + "";
cs.CreateDateTime = DateTime.Now;
cs.IsDeleted = false;
cs.Status = 1;
list.Add(cs);
}
XF_SY_NAN_ChiMa.Add(list);
}
else
{
List <XF_SY_NU_CodeSizeDto> list_NU = new List <XF_SY_NU_CodeSizeDto>();
for (int i = 0; i < table.Rows.Count; i++)
{
XF_SY_NU_CodeSizeDto cs = new XF_SY_NU_CodeSizeDto();
cs.Height = Convert.ToDecimal(table.Rows[i]["Height"]);
cs.FrontLength = table.Rows[i]["FrontLength"] + "";
cs.NetBust = table.Rows[i]["NetBust"] + "";
cs.FinishedBust = Convert.ToDecimal(table.Rows[i]["FinishedBust"]);
cs.InWaist = Convert.ToDecimal(table.Rows[i]["InWaist"]);
cs.FinishedHem_NoFork = Convert.ToDecimal(table.Rows[i]["FinishedHem_NoFork"]);
cs.SleeveWidth = Convert.ToDecimal(table.Rows[i]["SleeveWidth"]);
cs.ShoulderWidth = Convert.ToDecimal(table.Rows[i]["ShoulderWidth"]);
cs.Size_Code = size_code;
cs.Sleecve_Show = table.Rows[i]["FK_Sleeve_ID"] + "";
cs.CreateDateTime = DateTime.Now;
cs.IsDeleted = false;
cs.Status = 1;
list_NU.Add(cs);
}
XF_SY_NU_ChiMa.Add(list_NU);
}
errmsg = "";
return(true);
}
catch (Exception ex)
{
errmsg = ex.Message;
return(false);
}
}
public JsonResult UpdateCode(FormCollection fm)
{
using (var db = new MySqlServer())
try
{
switch (fm["Action"])
{
case "XF_SY_NAN":
List <XF_SY_NAN_ChiMaDto> xfnanlist = new List <XF_SY_NAN_ChiMaDto>();
int count = fm["Height"].Split(',').Count();
for (int i = 0; i < count; i++)
{
int upid = 0;
if (!int.TryParse(fm["ID"].Split(',')[i], out upid))
{
XF_SY_NAN_ChiMaDto tjdto = new XF_SY_NAN_ChiMaDto();
tjdto.Height = Convert.ToInt32(fm["Height"].Split(',')[i]);
tjdto.FrontLength = fm["FrontLength"].Split(',')[i];
tjdto.NetBust = fm["NetBust"].Split(',')[i];
tjdto.FinishedBust = Convert.ToDecimal(fm["FinishedBust"].Split(',')[i]);
tjdto.InWaist = Convert.ToDecimal(fm["InWaist"].Split(',')[i]);
tjdto.FinishedHem_NoFork = Convert.ToDecimal(fm["FinishedHem_NoFork"].Split(',')[i]);
tjdto.FinishedHem_SplitEnds = Convert.ToDecimal(fm["FinishedHem_SplitEnds"].Split(',')[i]);
tjdto.ShoulderWidth = Convert.ToDecimal(fm["ShoulderWidth"].Split(',')[i]);
tjdto.Sleecve_Show = fm["Sleecve_Show"].Split(',')[i];
tjdto.Id = upid;
tjdto.Status = 0;
tjdto.Size_Code = fm["Size_Code"];
XF_SY_NAN_ChiMa.Update(tjdto);
}
else
{
XF_SY_NAN_ChiMaDto xfnan = XF_SY_NAN_ChiMa.GetOne(t => t.Id == upid);
xfnan.Height = Convert.ToInt32(fm["Height"].Split(',')[i]);
xfnan.FrontLength = fm["FrontLength"].Split(',')[i];
xfnan.NetBust = fm["NetBust"].Split(',')[i];
xfnan.FinishedBust = Convert.ToDecimal(fm["FinishedBust"].Split(',')[i]);
xfnan.InWaist = Convert.ToDecimal(fm["InWaist"].Split(',')[i]);
xfnan.FinishedHem_NoFork = Convert.ToDecimal(fm["FinishedHem_NoFork"].Split(',')[i]);
xfnan.FinishedHem_SplitEnds = Convert.ToDecimal(fm["FinishedHem_SplitEnds"].Split(',')[i]);
xfnan.ShoulderWidth = Convert.ToDecimal(fm["ShoulderWidth"].Split(',')[i]);
xfnan.Sleecve_Show = fm["Sleecve_Show"].Split(',')[i];
xfnan.Id = upid;
xfnan.Status = 1;
XF_SY_NAN_ChiMa.Update(xfnan);
}
}
break;
case "XF_SY_NU":
int count2 = fm["Height"].Split(',').Count();
List <XF_SY_NU_CodeSizeDto> synulist = new List <XF_SY_NU_CodeSizeDto>();
for (int i = 0; i < count2; i++)
{
int upid = 0;
if (!int.TryParse(fm["ID"].Split(',')[i], out upid))
{
XF_SY_NU_CodeSizeDto synu = new XF_SY_NU_CodeSizeDto();
synu.Height = Convert.ToDecimal(fm["Height"].Split(',')[i]);
synu.FrontLength = fm["FrontLength"].Split(',')[i];
synu.NetBust = fm["NetBust"].Split(',')[i];
synu.FinishedBust = Convert.ToDecimal(fm["FinishedBust"].Split(',')[i]);
synu.InWaist = Convert.ToDecimal(fm["InWaist"].Split(',')[i]);
synu.FinishedHem_NoFork = Convert.ToDecimal(fm["FinishedHem_NoFork"].Split(',')[i]);
synu.SleeveWidth = Convert.ToDecimal(fm["SleeveWidth"].Split(',')[i]);
synu.ShoulderWidth = Convert.ToDecimal(fm["ShoulderWidth"].Split(',')[i]);
synu.Sleecve_Show = fm["FinishedHem_NoFork"].Split(',')[i];
synu.Size_Code = fm["Size_Code"];
XF_SY_NU_ChiMa.Add(synu);
}
else
{
XF_SY_NU_CodeSizeDto synu = XF_SY_NU_ChiMa.GetOne(T => T.Id == upid);
synu.Height = Convert.ToDecimal(fm["Height"].Split(',')[i]);
synu.FrontLength = fm["FrontLength"].Split(',')[i];
synu.NetBust = fm["NetBust"].Split(',')[i];
synu.FinishedBust = Convert.ToDecimal(fm["FinishedBust"].Split(',')[i]);
synu.InWaist = Convert.ToDecimal(fm["InWaist"].Split(',')[i]);
synu.FinishedHem_NoFork = Convert.ToDecimal(fm["FinishedHem_NoFork"].Split(',')[i]);
synu.SleeveWidth = Convert.ToDecimal(fm["SleeveWidth"].Split(',')[i]);
synu.ShoulderWidth = Convert.ToDecimal(fm["ShoulderWidth"].Split(',')[i]);
synu.Sleecve_Show = fm["FinishedHem_NoFork"].Split(',')[i];
XF_SY_NU_ChiMa.Update(synu);
}
}
break;
case "XF_KZ_NAN":
case "XF_KZ_NU":
int count4 = fm["DZ_HipLength_CP"].Split(',').Count();
List <XF_KZ_CodeSizeDto> xfkznulist = new List <XF_KZ_CodeSizeDto>();
for (int i = 0; i < count4; i++)
{
int upid = 0;
if (!int.TryParse(fm["ID"].Split(',')[i], out upid))
{
XF_KZ_CodeSizeDto xfkz = new XF_KZ_CodeSizeDto();
xfkz.Code = fm["Code"].Split(',')[i];
xfkz.DZ_HipLength_CP = Convert.ToDecimal(fm["DZ_HipLength_CP"].Split(',')[i]);
xfkz.SZ_HipLength_CP = Convert.ToDecimal(fm["SZ_HipLength_CP"].Split(',')[i]);
xfkz.Crosspiece = Convert.ToDecimal(fm["Crosspiece"].Split(',')[i]);
xfkz.LegWidth_UnderTheWaves = Convert.ToDecimal(fm["LegWidth_UnderTheWaves"].Split(',')[i]);
xfkz.FrontRise_EvenWaist = Convert.ToDecimal(fm["FrontRise_EvenWaist"].Split(',')[i]);
xfkz.AfterTheWaves_EvenWaist = Convert.ToDecimal(fm["AfterTheWaves_EvenWaist"].Split(',')[i]);
xfkz.NetHip = fm["NetHip"].Split(',')[i];
xfkz.CP_WaistWidth = fm["CP_WaistWidth"].Split(',')[i];
xfkz.NetWaist = fm["NetWaist"].Split(',')[i];
xfkz.Size_Code = fm["Size_Code"];
XF_KZ_Service.Add(xfkz);
}
else
{
XF_KZ_CodeSizeDto xfkz = XF_KZ_Service.GetOne(T => T.Id == upid);
xfkz.Code = fm["Code"].Split(',')[i];
xfkz.DZ_HipLength_CP = Convert.ToDecimal(fm["DZ_HipLength_CP"].Split(',')[i]);
xfkz.SZ_HipLength_CP = Convert.ToDecimal(fm["SZ_HipLength_CP"].Split(',')[i]);
xfkz.Crosspiece = Convert.ToDecimal(fm["Crosspiece"].Split(',')[i]);
xfkz.LegWidth_UnderTheWaves = Convert.ToDecimal(fm["LegWidth_UnderTheWaves"].Split(',')[i]);
xfkz.FrontRise_EvenWaist = Convert.ToDecimal(fm["FrontRise_EvenWaist"].Split(',')[i]);
xfkz.AfterTheWaves_EvenWaist = Convert.ToDecimal(fm["AfterTheWaves_EvenWaist"].Split(',')[i]);
xfkz.NetHip = fm["NetHip"].Split(',')[i];
xfkz.CP_WaistWidth = fm["CP_WaistWidth"].Split(',')[i];
xfkz.NetWaist = fm["NetWaist"].Split(',')[i];
XF_KZ_Service.Update(xfkz);
}
}
int IsKc = 0;
for (int i = 0; i < fm.AllKeys.Length; i++)
{
if (fm.AllKeys[i] == "HK_Height")
{
IsKc++;
}
}
if (IsKc > 0)
{
int hkCount = fm["HK_Height"].Split(',').Count();
List <HeightKuChangDto> HKList = new List <HeightKuChangDto>();
for (int i = 0; i < hkCount; i++)
{
HeightKuChangDto dto = new HeightKuChangDto();
dto.Id = Convert.ToInt32(fm["HK_Id"].Split(',')[i]);
dto.Height = Convert.ToDouble(fm["HK_Height"].Split(',')[i]);
dto.KuChang = Convert.ToDouble(fm["HK_KuChang"].Split(',')[i]);
dto.Size_Code = fm["Size_Code"];
HKList.Add(dto);
}
}
break;
default:
break;
}
return(Json(new { state = 1, msg = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = -1, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
