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); }