public void TempDataInsert(DataTable dtTask, DataTable dtResource)
{
TempWbsInfoCollection tempWbsInfoCollection = new TempWbsInfoCollection();
for (int i = 0; i < dtTask.Rows.Count; i++)
{
tempWbsInfoCollection.Add(new TempWbsInfo
{
ProjectCode = this.PrjCodeValue,
TaskCode = dtTask.Rows[i]["F2"].ToString().Trim(),
TaskName = dtTask.Rows[i]["F3"].ToString().Trim(),
Unit = dtTask.Rows[i]["F4"].ToString().Trim(),
Quantity = (dtTask.Rows[i]["F5"].ToString().Trim() == "") ? "0" : dtTask.Rows[i]["F5"].ToString().Trim(),
UnitPrice = (dtTask.Rows[i]["F6"].ToString().Trim() == "") ? "0" : dtTask.Rows[i]["F6"].ToString().Trim(),
SumPrice = (dtTask.Rows[i]["F7"].ToString().Trim() == "") ? "0" : dtTask.Rows[i]["F7"].ToString().Trim(),
Remark = dtTask.Rows[i]["F8"].ToString().Trim(),
Content = 0m
});
}
TempResourceInfoCollection tempResourceInfoCollection = new TempResourceInfoCollection();
for (int j = 0; j < dtResource.Rows.Count; j++)
{
TempResourceInfo tempResourceInfo = new TempResourceInfo();
tempResourceInfo.ListCode = dtResource.Rows[j][0].ToString().Trim();
tempResourceInfo.ListName = dtResource.Rows[j][1].ToString().Trim();
tempResourceInfo.FeeStyle = ((dtResource.Rows[j][2].ToString().Trim() == "") ? "0" : dtResource.Rows[j][2].ToString().Trim());
tempResourceInfo.SourceName = dtResource.Rows[j][3].ToString().Trim();
tempResourceInfo.SourceUnit = ((dtResource.Rows[j][4].ToString().Trim() == "") ? "0" : dtResource.Rows[j][4].ToString().Trim());
tempResourceInfo.SourcePrice = ((dtResource.Rows[j][5].ToString().Trim() == "") ? "0" : dtResource.Rows[j][5].ToString().Trim());
tempResourceInfo.Quantity = ((dtResource.Rows[j][6].ToString().Trim() == "") ? "0" : dtResource.Rows[j][6].ToString().Trim());
tempResourceInfo.Fee = ((dtResource.Rows[j][7].ToString().Trim() == "") ? "0" : dtResource.Rows[j][7].ToString().Trim());
tempResourceInfo.Fee1 = ((dtResource.Rows[j][8].ToString().Trim() == "") ? "0" : dtResource.Rows[j][8].ToString().Trim());
if (this.ImportType != 1 && this.ImportType != 3)
{
tempResourceInfo.Content = Convert.ToDecimal((dtResource.Rows[j][9].ToString().Trim() == "") ? "0" : dtResource.Rows[j][9].ToString().Trim());
tempResourceInfo.Fee = Convert.ToString(Convert.ToDecimal(tempResourceInfo.SourcePrice) * Convert.ToDecimal(tempResourceInfo.Quantity));
}
else
{
tempResourceInfo.Content = 0m;
}
tempResourceInfoCollection.Add(tempResourceInfo);
}
this.tw.TempTaskInsert(tempWbsInfoCollection, tempResourceInfoCollection, this.PrjCodeValue, this.ImportType.ToString());
}
public void TempDataInsert1(DataTable dtTask)
{
TempWbsInfoCollection tempWbsInfoCollection = new TempWbsInfoCollection();
for (int i = 0; i < dtTask.Rows.Count; i++)
{
tempWbsInfoCollection.Add(new TempWbsInfo
{
ProjectCode = this.PrjCodeValue,
TaskCode = dtTask.Rows[i]["F2"].ToString().Trim(),
TaskName = dtTask.Rows[i]["F3"].ToString().Trim(),
Unit = dtTask.Rows[i]["F4"].ToString().Trim(),
Quantity = (dtTask.Rows[i]["F5"].ToString().Trim() == "") ? "0" : dtTask.Rows[i]["F5"].ToString().Trim(),
UnitPrice = (dtTask.Rows[i]["F6"].ToString().Trim() == "") ? "0" : dtTask.Rows[i]["F6"].ToString().Trim(),
SumPrice = (dtTask.Rows[i]["F7"].ToString().Trim() == "") ? "0" : dtTask.Rows[i]["F7"].ToString().Trim()
});
}
TempResourceInfoCollection resourceList = new TempResourceInfoCollection();
this.tw.TempTaskInsert(tempWbsInfoCollection, resourceList, this.PrjCodeValue);
}
