public static ResultData LoadData(TSearch item)
{
ResultData r = new ResultData();
PTTGC_EPIEntities db = new PTTGC_EPIEntities();
List <ClassExecute.TDataOutput> lstDataT1 = new List <ClassExecute.TDataOutput>();
List <ClassExecute.TDataOutput> lstData = new List <ClassExecute.TDataOutput>();
int nFormID = 0;
var qForm = db.TEPI_Forms.FirstOrDefault(w => w.IDIndicator == item.nIndicator && w.OperationTypeID == item.nOperationType && w.FacilityID == item.nFacility && w.sYear == item.sYear);
if (qForm != null)
{
nFormID = qForm.FormID;
}
if (item.nIndicator == 10)
{
lstData = FunctionGetData.GetWasteDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 8)
{
lstData = FunctionGetData.GetMaterialDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 6)
{
lstData = FunctionGetData.GetIntensityDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 11)
{
lstData = FunctionGetData.GetWaterDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 1)
{
lstData = FunctionGetData.GetComplaintDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 2)
{
lstData = FunctionGetData.GetComplianceDataOutput(nFormID, item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 3)
{
lstData = FunctionGetData.GetDataOutput(item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
else if (item.nIndicator == 4)
{
lstData = FunctionGetData.GetDataOutput(item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
lstDataOutputEmission(item.nIndicator, item.nOperationType, item.nFacility, item.sYear, r);
}
else if (item.nIndicator == 9)
{
lstData = FunctionGetData.GetDataOutput(item.nIndicator, item.nOperationType, item.nFacility, item.sYear);
}
r.lstData = lstData;
r.sFormID = nFormID + "";
r.Status = SystemFunction.process_Success;
return(r);
}
public void AddProductOutput_Calculate(List <ClassExecute.TDataOutput> lstTemp, int nEPIFormID)
{
int IndicaotrID = 0;
int nFacID = 0;
int nOperaID = 0;
string sYear = "0";
var qEPIForm = db.TEPI_Forms.Where(w => w.FormID == nEPIFormID).FirstOrDefault();
if (qEPIForm != null)
{
IndicaotrID = qEPIForm.IDIndicator;
nFacID = qEPIForm.FacilityID ?? 0;
nOperaID = qEPIForm.OperationTypeID;
sYear = qEPIForm.sYear;
}
//Old Data
List <ClassExecute.TDataOutput> lstOldDataOutput = new List <ClassExecute.TDataOutput>();
lstOldDataOutput = FunctionGetData.GetDataOutput(IndicaotrID, nOperaID, nFacID, sYear);
// Clear data
string sql = "delete from TProductOutput where FormID = " + CommonFunction.ReplaceInjection(nEPIFormID + "") + "";
CommonFunction.ExecuteSQL(SystemFunction.strConnect, sql);
//Data for check product specific
var query = db.mTProductIndicatorOutput.Where(w => w.IDIndicator == IndicaotrID && w.cDel == "N").Select(s => new ClassExecute.TDataOutput {
ProductID = s.ProductID, sMakeField1 = s.sIsSpecific
}).ToList();
//add new data
foreach (var item in lstTemp)
{
TProductOutput t = new TProductOutput();
t.FormID = nEPIFormID;
t.ProductID = item.ProductID;
t.M1 = ConvertToInsertOutput(item.nM1);
t.M2 = ConvertToInsertOutput(item.nM2);
t.M3 = ConvertToInsertOutput(item.nM3);
t.M4 = ConvertToInsertOutput(item.nM4);
t.M5 = ConvertToInsertOutput(item.nM5);
t.M6 = ConvertToInsertOutput(item.nM6);
t.M7 = ConvertToInsertOutput(item.nM7);
t.M8 = ConvertToInsertOutput(item.nM8);
t.M9 = ConvertToInsertOutput(item.nM9);
t.M10 = ConvertToInsertOutput(item.nM10);
t.M11 = ConvertToInsertOutput(item.nM11);
t.M12 = ConvertToInsertOutput(item.nM12);
if (!IsProductSpecific(query, IndicaotrID, item.ProductID))
{
t.Target = ConvertToInsertOutput(item.nTarget);
}
else
{
t.Target = GetValueFromListOutput(lstOldDataOutput, 0, item.ProductID) + "";
}
t.nTotal = ConvertToInsertOutput(item.nTotal);
t.Q1 = ConvertToInsertOutput(item.nQ1);
t.Q2 = ConvertToInsertOutput(item.nQ2);
t.Q3 = ConvertToInsertOutput(item.nQ3);
t.Q4 = ConvertToInsertOutput(item.nQ4);
t.H1 = ConvertToInsertOutput(item.nH1);
t.H2 = ConvertToInsertOutput(item.nH2);
db.TProductOutput.Add(t);
}
db.SaveChanges();
}
public string SetTextDetail(int i, sysGlobalClass.T_TIntensity_Other f)
{
string sText = "";
switch (i)
{
//ชื่อ
//string[] Arr_Column = { "No.", "PG", "Subject", "Employee ID", "Name", "Type", "Indicator", "Status" };
case 0:
sText = f.sIndicator + "";
break;
case 1:
sText = !string.IsNullOrEmpty(f.sUnit) ? sText = FunctionGetData.ReplaceHtmlUnit(f.sUnit) : "Tonnes Product";
break;
//ชื่อเมนู
case 2:
sText = f.sTarget + "";
break;
//คำอธิบาย
case 3:
sText = f.M1 + "";
break;
//วันที่สร้าง
case 4:
sText = f.M2 + "";
break;
case 5:
sText = f.M3 + "";
break;
case 6:
sText = f.M4 + "";
break;
case 7:
sText = f.M5 + "";
break;
case 8:
sText = f.M6 + "";
break;
case 9:
sText = f.M7 + "";
break;
case 10:
sText = f.M8 + "";
break;
case 11:
sText = f.M9 + "";
break;
case 12:
sText = f.M10 + "";
break;
case 13:
sText = f.M11 + "";
break;
case 14:
sText = f.M12 + "";
break;
case 15:
sText = "";
break;
}
return(sText);
}
public string SetText(int i, sysGlobalClass.TData_Intensity f)
{
string sText = "";
switch (i)
{
//ชื่อ
//string[] Arr_Column = { "No.", "PG", "Subject", "Employee ID", "Name", "Type", "Indicator", "Status" };
case 0:
sText = f.ProductName + "";
break;
case 1:
sText = FunctionGetData.ReplaceHtmlUnit(f.sUnit);
break;
//ชื่อเมนู
case 2:
sText = f.Target + "";
break;
//คำอธิบาย
case 3:
sText = f.M1 + "";
break;
//วันที่สร้าง
case 4:
sText = f.M2 + "";
break;
case 5:
sText = f.M3 + "";
break;
case 6:
sText = f.M4 + "";
break;
case 7:
sText = f.M5 + "";
break;
case 8:
sText = f.M6 + "";
break;
case 9:
sText = f.M7 + "";
break;
case 10:
sText = f.M8 + "";
break;
case 11:
sText = f.M9 + "";
break;
case 12:
sText = f.M10 + "";
break;
case 13:
sText = f.M11 + "";
break;
case 14:
sText = f.M12 + "";
break;
case 15:
sText = f.sRemark + "";
break;
//UnSuccess//onProcess
}
return(sText);
}
