public void edit(RW_CORROSION_RATE_TANK obj) { DAL.edit(int.Parse(obj.CorrosionID), (int)(obj.ID), obj.SoilSideCorrosionRate, obj.ProductSideCorrosionRate, obj.PotentialCorrosion, obj.TankPadMaterial, obj.TankDrainageType, obj.CathodicProtectionType, obj.TankBottomType, obj.SoilSideTemperature, obj.ProductCondition, obj.ProductSideTemp, obj.SteamCoil, obj.WaterDrawOff, obj.ProductSideBottom, obj.ModifiedSoilSideCorrosionRate, obj.ModifiedProductSideCorrosionRate, obj.FinalEstimatedCorrosionRate); }
private void btnAddRow_Click(object sender, EventArgs e) { RW_CORROSION_RATE_TANK_BUS busConRate = new RW_CORROSION_RATE_TANK_BUS(); RW_CORROSION_RATE_TANK obj = new RW_CORROSION_RATE_TANK(); RW_ASSESSMENT_BUS busAssessment = new RW_ASSESSMENT_BUS(); List <RW_ASSESSMENT> listAss = busAssessment.getDataSource(); //int ID = listAss.Max(RW_ASSESSMENT => RW_ASSESSMENT.ID); obj.ID = Proposal_ID; busConRate.add(obj); unitdata(showData(Proposal_ID)); }
private List <RW_CORROSION_RATE_TANK> showData(int ID) { RW_CORROSION_RATE_TANK_BUS busConRate = new RW_CORROSION_RATE_TANK_BUS(); List <RW_CORROSION_RATE_TANK> listConRate = busConRate.getDataSource(ID); List <RW_CORROSION_RATE_TANK> listdata = new List <RW_CORROSION_RATE_TANK>(); foreach (RW_CORROSION_RATE_TANK ConRate in listConRate) { RW_CORROSION_RATE_TANK RwConRate = ConRate; listdata.Add(RwConRate); } return(listdata); }
public void SaveDateCorrosinRate() { RW_CORROSION_RATE_TANK CorTank = new RW_CORROSION_RATE_TANK(); RW_CORROSION_RATE_TANK_BUS busConRate = new RW_CORROSION_RATE_TANK_BUS(); int[] selectedRowHandles = gridView1.GetSelectedRows(); for (int i = 0; i < selectedRowHandles.Length; i++) { CorTank = getData(i); MessageBox.Show(CorTank.SoilSideCorrosionRate.ToString()); CorTank.ID = (float)Proposal_ID; MessageBox.Show(CorTank.ID.ToString()); busConRate.edit(CorTank); } }
private void btnCalculateCorrosionRate_Click(object sender, EventArgs e) { RW_CORROSION_RATE_TANK CorTank = new RW_CORROSION_RATE_TANK(); Corrosion_Rate CorRate = new Corrosion_Rate(); List <RW_CORROSION_RATE_TANK> list = new List <RW_CORROSION_RATE_TANK>(); int[] selectedRowHandles = gridView1.GetSelectedRows(); for (int i = 0; i < selectedRowHandles.Length; i++) { CorTank = getData(i); CorRate.SoilSideCorrosionRate = CorTank.SoilSideCorrosionRate; CorRate.ProductSideCorrosionRate = CorTank.ProductSideCorrosionRate; CorRate.PotentialCorrosion = CorTank.PotentialCorrosion; CorRate.TankPadMaterial = CorTank.TankPadMaterial; CorRate.TankDrainageType = CorTank.TankDrainageType; CorRate.CathodicProtectionType = CorTank.CathodicProtectionType; CorRate.TankBottomType = CorTank.TankBottomType; CorRate.SoilSideTemperature = CorTank.SoilSideTemperature; CorRate.ProductCondition = CorTank.ProductCondition; CorRate.ProductSideTemp = CorTank.ProductSideTemp; CorRate.SteamCoil = CorTank.SteamCoil; CorRate.WaterDrawOff = CorTank.WaterDrawOff; CorRate.ProductSideBottom = CorTank.ProductSideBottom; CorRate.ModifiedSoilSideCorrosionRate = CorRate.CRS_Bottom(); CorRate.ModifiedProductSideCorrosionRate = CorRate.CRP_Bottom(); CorRate.FinalEstimatedCorrosionRate = CorRate.Final_CR(); CorTank.ModifiedSoilSideCorrosionRate = CorRate.CRS_Bottom(); CorTank.ModifiedProductSideCorrosionRate = CorRate.CRP_Bottom(); CorTank.FinalEstimatedCorrosionRate = CorRate.Final_CR(); //MessageBox.Show(CorTank.PotentialCorrosion.ToString()); //MessageBox.Show("SR="+CorRate.F_SR().ToString()+" PA= "+CorRate.F_PA().ToString()+" ID="+CorRate.F_ID().ToString()+" CP="+CorRate.F_CP().ToString()+" TB="+CorRate.F_TB().ToString()+" ST="+CorRate.F_ST().ToString()); Console.WriteLine(CorTank.SoilSideCorrosionRate); MessageBox.Show(CorTank.ModifiedSoilSideCorrosionRate.ToString() + "::" + CorTank.ModifiedProductSideCorrosionRate.ToString() + "::" + CorTank.FinalEstimatedCorrosionRate.ToString()); list.Add(CorTank); Console.WriteLine("update ok"); } unitdata(list); }
public void delete(RW_CORROSION_RATE_TANK obj) { DAL.delete(int.Parse(obj.CorrosionID)); }
/// get datasource /// public List <RW_CORROSION_RATE_TANK> getDataSource(int proposal_ID) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <RW_CORROSION_RATE_TANK> list = new List <RW_CORROSION_RATE_TANK>(); RW_CORROSION_RATE_TANK obj = null; String sql = "USE[rbi] SELECT [ID]" + ",[CorrosionID]" + ",[SoilSideCorrosionRate]" + ",[ProductSideCorrosionRate]" + ",[PotentialCorrosion]" + ",[TankPadMaterial]" + ",[TankDrainageType]" + ",[CathodicProtectionType]" + ",[TankBottomType]" + ",[SoilSideTemperature]" + ",[ProductCondition]" + ",[ProductSideTemp]" + ",[SteamCoil]" + ",[WaterDrawOff]" + ",[ProductSideBottom]" + ",[ModifiedSoilSideCorrosionRate]" + ",[ModifiedProductSideCorrosionRate]" + ",[FinalEstimatedCorrosionRate]" + " FROM [rbi].[dbo].[RW_CORROSION_RATE_TANK] WHERE [ID] = '" + proposal_ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new RW_CORROSION_RATE_TANK(); obj.ID = reader.GetInt32(0); obj.CorrosionID = reader.GetInt32(1); if (!reader.IsDBNull(2)) { obj.SoilSideCorrosionRate = (float)reader.GetDouble(2); } if (!reader.IsDBNull(3)) { obj.ProductSideCorrosionRate = (float)reader.GetDouble(3); } if (!reader.IsDBNull(4)) { obj.PotentialCorrosion = reader.GetString(4); } if (!reader.IsDBNull(5)) { obj.TankPadMaterial = reader.GetString(5); } if (!reader.IsDBNull(6)) { obj.TankDrainageType = reader.GetString(6); } if (!reader.IsDBNull(7)) { obj.CathodicProtectionType = reader.GetString(7); } if (!reader.IsDBNull(8)) { obj.TankBottomType = reader.GetString(8); } if (!reader.IsDBNull(9)) { obj.SoilSideTemperature = reader.GetString(9); } if (!reader.IsDBNull(10)) { obj.ProductCondition = reader.GetString(10); } if (!reader.IsDBNull(11)) { obj.ProductSideTemp = reader.GetString(11); } if (!reader.IsDBNull(12)) { obj.SteamCoil = reader.GetString(12); } if (!reader.IsDBNull(13)) { obj.WaterDrawOff = reader.GetString(13); } if (!reader.IsDBNull(14)) { obj.ProductSideBottom = reader.GetString(14); } if (!reader.IsDBNull(15)) { obj.ModifiedSoilSideCorrosionRate = (float)reader.GetDouble(15); } if (!reader.IsDBNull(16)) { obj.ModifiedProductSideCorrosionRate = (float)reader.GetDouble(16); } if (!reader.IsDBNull(17)) { obj.FinalEstimatedCorrosionRate = (float)reader.GetDouble(17); } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL"); } finally { conn.Close(); conn.Dispose(); } return(list); }
private RW_CORROSION_RATE_TANK getData(int row) { RW_CORROSION_RATE_TANK CorRate = new RW_CORROSION_RATE_TANK(); RW_CORROSION_RATE_TANK_BUS busCorRate = new RW_CORROSION_RATE_TANK_BUS(); GridColumn CorrosionID = gridView1.Columns[0]; //CorrosionID GridColumn SoilSideCorrosionRate = gridView1.Columns[1]; //"Soil Side Base Corrosion Rate" GridColumn ProductSideCorrosionRate = gridView1.Columns[2]; //"Product Side Base Corrosion Rate" GridColumn PotentialCorrosion = gridView1.Columns[3]; //"Potential Corrosion Activity(Resistivity)" GridColumn TankPadMaterial = gridView1.Columns[4]; //"Tank Pad Meterial" GridColumn TankDrainageType = gridView1.Columns[5]; //"Tank Drainage Type" GridColumn CathodicProtectionType = gridView1.Columns[6]; //"Cathodic Protection Type" GridColumn TankBottomType = gridView1.Columns[7]; //"Tank bottom Type" GridColumn SoilSideTemperature = gridView1.Columns[8]; //"Tank bottom Type" GridColumn ProductCondition = gridView1.Columns[9]; //"Product Side Condition" GridColumn ProductSideTemp = gridView1.Columns[10]; //"Product Side Temperature" GridColumn SteamCoil = gridView1.Columns[11]; //"Stram Coil"; GridColumn WaterDrawOff = gridView1.Columns[12]; //"Water Draw-off" GridColumn ProductSideBottom = gridView1.Columns[13]; //"Product Side Bottom Corrosion" GridColumn ModifiedSoilSideCorrosionRate = gridView1.Columns[14]; GridColumn ModifiedProductSideCorrosionRate = gridView1.Columns[15]; GridColumn FinalEstimatedCorrosionRate = gridView1.Columns[16]; int[] selectedRowHandles = gridView1.GetSelectedRows(); try { CorRate.CorrosionID = (int)gridView1.GetRowCellValue(row, CorrosionID); } catch { CorRate.CorrosionID = 0; } try { CorRate.SoilSideCorrosionRate = (float)gridView1.GetRowCellValue(row, SoilSideCorrosionRate); } catch { CorRate.SoilSideCorrosionRate = 0; } try { CorRate.ProductSideCorrosionRate = (float)gridView1.GetRowCellValue(row, ProductSideCorrosionRate); } catch { CorRate.ProductSideCorrosionRate = 0; } CorRate.PotentialCorrosion = gridView1.GetRowCellDisplayText(row, PotentialCorrosion).ToString(); CorRate.TankPadMaterial = gridView1.GetRowCellDisplayText(row, TankPadMaterial).ToString(); CorRate.TankDrainageType = gridView1.GetRowCellDisplayText(row, TankDrainageType).ToString(); CorRate.CathodicProtectionType = gridView1.GetRowCellDisplayText(row, CathodicProtectionType).ToString(); CorRate.TankBottomType = gridView1.GetRowCellDisplayText(row, TankBottomType).ToString(); CorRate.SoilSideTemperature = gridView1.GetRowCellDisplayText(row, SoilSideTemperature).ToString(); CorRate.ProductCondition = gridView1.GetRowCellDisplayText(row, ProductCondition).ToString(); CorRate.ProductSideTemp = gridView1.GetRowCellDisplayText(row, ProductSideTemp).ToString(); CorRate.SteamCoil = gridView1.GetRowCellDisplayText(row, SteamCoil).ToString(); CorRate.WaterDrawOff = gridView1.GetRowCellDisplayText(row, WaterDrawOff).ToString(); CorRate.ProductSideBottom = gridView1.GetRowCellDisplayText(row, ProductSideBottom).ToString(); try { CorRate.ModifiedSoilSideCorrosionRate = (float)gridView1.GetRowCellValue(row, ModifiedSoilSideCorrosionRate); } catch { CorRate.ModifiedProductSideCorrosionRate = 0; } try { CorRate.ModifiedProductSideCorrosionRate = (float)gridView1.GetRowCellValue(row, ModifiedProductSideCorrosionRate); } catch { CorRate.ModifiedProductSideCorrosionRate = 0; } try { CorRate.FinalEstimatedCorrosionRate = (float)gridView1.GetRowCellValue(row, FinalEstimatedCorrosionRate); } catch { CorRate.FinalEstimatedCorrosionRate = 0; } return(CorRate); }