protected override void OnAfterHandleExcel(ref DataTable dtSheet)
{
var service = new SYS_PartService();
var prsbomServices = new PRS_Process_BOMService();
foreach (DataRow item in dtSheet.Rows)
{
var PartCode = item["InventoryCode"].ToString();
List <PRS_Process_BOM> part = prsbomServices.GetModelList(ParamQuery.Instance().AndWhere("InventoryCode", PartCode).AndWhere("IsEnable", 1));
if (part.Count > 0)
{
item["PartCode"] = part[part.Count - 1].PartCode;
item["PartName"] = part[part.Count - 1].PartName;
item["Weight"] = part[part.Count - 1].Weight;
var Query = ParamDelete.Instance().AndWhere("InventoryCode", PartCode);
service.Delete(Query);
}
string dName = item["WarehouseCode"].ToString();
string sql = string.Format(@"select WarehouseName from SYS_BN_Warehouse where WarehouseCode='{0}'", dName);
string hID = db.Sql(sql).QuerySingle <string>();
item["WarehouseName"] = hID;
string isSelfMade = item["IsSelfMade"].ToString();
if (isSelfMade == "否")
{
item["IsSelfMade"] = 0;
}
else
{
item["IsSelfMade"] = 1;
}
string isSupplyMade = item["IsSupplyMade"].ToString();
if (isSupplyMade == "否")
{
item["IsSupplyMade"] = 0;
}
else
{
item["IsSupplyMade"] = 1;
}
string isCastforgeMatch = item["IsCastforgeMatch"].ToString();
if (isCastforgeMatch == "否")
{
item["IsCastforgeMatch"] = 0;
}
else
{
item["IsCastforgeMatch"] = 1;
}
string isOutsouceWeiding = item["IsOutsouceWeiding"].ToString();
if (isOutsouceWeiding == "否")
{
item["IsOutsouceWeiding"] = 0;
}
else
{
item["IsOutsouceWeiding"] = 1;
}
string isElectroHydraulicMatch = item["IsElectroHydraulicMatch"].ToString();
if (isElectroHydraulicMatch == "否")
{
item["IsElectroHydraulicMatch"] = 0;
}
else
{
item["IsElectroHydraulicMatch"] = 1;
}
string isMarketMatch = item["IsMarketMatch"].ToString();
if (isMarketMatch == "否")
{
item["IsMarketMatch"] = 0;
}
else
{
item["IsMarketMatch"] = 1;
}
string isEnable = item["IsEnable"].ToString();
if (isEnable == "否")
{
item["IsEnable"] = 0;
}
else
{
item["IsEnable"] = 1;
}
//dName = item["PartTypeCode"].ToString();
//sql = string.Format(@"select PartTypeCode from SYS_PartType where TypeName='{0}'", dName);
//hID = db.Sql(sql).QuerySingle<string>();
//item["PartTypeCode"] = hID;
}
base.OnAfterHandleExcel(ref dtSheet);
}
