//西裤尺码表解析
public static object Ret_Excel_trousrs(DataTable table)
{
List <TrousersSize> cslist = new List <TrousersSize>();
for (int i = 0; i < table.Rows.Count; i++)
{
decimal ty = 0;
TrousersSize ts = new TrousersSize();
ts.Code = table.Rows[i]["Code"] + "";
if (decimal.TryParse(table.Rows[i]["DZ_HipLength_CP"] + "", out ty))
{
ts.DZ_HipLength_CP = ty;
}
else
{
ts.DZ_HipLength_CP = 0;
}
ts.SZ_HipLength_CP = 0;
if (decimal.TryParse(table.Rows[i]["SZ_HipLength_CP"] + "", out ty))
{
ts.SZ_HipLength_CP = ty;
}
else
{
ts.SZ_HipLength_CP = 0;
}
if (decimal.TryParse(table.Rows[i]["Crosspiece"] + "", out ty))
{
ts.Crosspiece = ty;
}
else
{
ts.Crosspiece = 0;
}
if (decimal.TryParse(table.Rows[i]["LegWidth_UnderTheWaves"] + "", out ty))
{
ts.LegWidth_UnderTheWaves = ty;
}
else
{
ts.LegWidth_UnderTheWaves = 0;
}
if (decimal.TryParse(table.Rows[i]["FrontRise_EvenWaist"] + "", out ty))
{
ts.FrontRise_EvenWaist = ty;
}
else
{
ts.FrontRise_EvenWaist = 0;
}
if (decimal.TryParse(table.Rows[i]["AfterTheWaves_EvenWaist"] + "", out ty))
{
ts.AfterTheWaves_EvenWaist = ty;
}
else
{
ts.AfterTheWaves_EvenWaist = 0;
}
ts.NetHip = table.Rows[i]["NetHip"] + "";
ts.CP_WaistWidth = table.Rows[i]["CP_WaistWidth"] + "";
ts.Height = table.Rows[i]["Height"] + "";
ts.LongPants = table.Rows[i]["LongPants"] + "";
ts.NetWaist = table.Rows[i]["NetWaist"] + "";
cslist.Add(ts);
}
return(cslist);
}
//上传西服裤子尺码表
public static bool Import_Excel_trousrs(DataTable table, string Size_Code, out string errmsg)
{
using (var db = SugarDao.GetInstance())
try
{
List <TrousersSize> tszie_list = new List <TrousersSize>();
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("..", ".");
}
if (row[a].ToString().IndexOf("null") > 0)
{
row[a] = row[a].ToString().Replace("null", "0");
}
if (string.IsNullOrEmpty(row[a].ToString()))
{
row[a] = 0;
}
}
row.EndEdit();
#endregion
#region 保存尺码
TrousersSize tszie = new TrousersSize();
foreach (DataRow item in table.Rows)
{
tszie.Code = item["Code"].ToString();
decimal ty = 0;
if (decimal.TryParse(item["DZ_HipLength_CP"].ToString(), out ty))
{
tszie.DZ_HipLength_CP = ty;
}
else
{
tszie.DZ_HipLength_CP = 0;
}
if (decimal.TryParse(item["SZ_HipLength_CP"].ToString(), out ty))
{
tszie.SZ_HipLength_CP = ty;
}
else
{
tszie.SZ_HipLength_CP = 0;
}
if (decimal.TryParse(item["Crosspiece"].ToString(), out ty))
{
tszie.Crosspiece = ty;
}
else
{
tszie.Crosspiece = 0;
}
if (decimal.TryParse(item["LegWidth_UnderTheWaves"].ToString(), out ty))
{
tszie.LegWidth_UnderTheWaves = ty;
}
else
{
tszie.LegWidth_UnderTheWaves = 0;
}
if (decimal.TryParse(item["FrontRise_EvenWaist"].ToString(), out ty))
{
tszie.FrontRise_EvenWaist = ty;
}
else
{
tszie.FrontRise_EvenWaist = 0;
}
if (decimal.TryParse(item["AfterTheWaves_EvenWaist"].ToString(), out ty))
{
tszie.AfterTheWaves_EvenWaist = ty;
}
else
{
tszie.AfterTheWaves_EvenWaist = 0;
}
tszie.NetHip = item["NetHip"].ToString();
tszie.CP_WaistWidth = item["CP_WaistWidth"].ToString();
tszie.Height = item["Height"].ToString();
tszie.LongPants = item["LongPants"].ToString();
tszie.NetWaist = item["NetWaist"].ToString();
tszie.Size_Code = Size_Code;
}
tszie_list.Add(tszie);
#endregion
}
db.InsertRange(tszie_list);
db.CommitTran();
errmsg = "";
return(true);
}
catch (Exception ex)
{
db.RollbackTran(); //回滚事务
errmsg = ex.Message;
return(false);
}
}
