private static void testETL() { clsMAST_INSR_POLICY_TB clstb = new clsMAST_INSR_POLICY_TB(); clsMAST_INSR_POLICY_TB_MIRROR clstb_m = new clsMAST_INSR_POLICY_TB_MIRROR(); clsMAST_INSR_POLICY_TB_MIRROR.TableClear(); DataTable dt = clstb.Select(); //DatabaseLayer.DataBaseConnection.SqlConnection_.Close(); //DatabaseLayer.DataBaseConnection.SqlConnection_ = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\project\InsuranceHedgeProject\InsruranceHedge_sln\InsuranceHedge\HedgeSystemAsh.mdf;Integrated Security=True"); int i = 1; foreach (DataRow dr in dt.Select()) { clsMAST_INSR_POLICY_TB_MIRROR.Create(dr).Insert(); Console.WriteLine(i); i = i + 1; } }
public clsMAST_INSR_POLICY_TB_MIRROR Clone() { try { clsMAST_INSR_POLICY_TB_MIRROR cloneTB = new clsMAST_INSR_POLICY_TB_MIRROR(); cloneTB._Cal_Date = this._Cal_Date; cloneTB._Pdt_Type = this._Pdt_Type; cloneTB._Sales_Ch = this._Sales_Ch; cloneTB._Po_Date = this._Po_Date; cloneTB._IR_Code = this._IR_Code; cloneTB._Po_PmType = this._Po_PmType; cloneTB._Po_No = this._Po_No; cloneTB._C_Rate = this._C_Rate; cloneTB._Acc_No = this._Acc_No; cloneTB._Mc_FA = this._Mc_FA; cloneTB._Gs_Prem = this._Gs_Prem; cloneTB._Mc_Prem = this._Mc_Prem; cloneTB._Sb_Prem = this._Sb_Prem; cloneTB._Sp_Prem = this._Sp_Prem; cloneTB._Poh1_Age = this._Poh1_Age; cloneTB._Poh2_Age = this._Poh2_Age; cloneTB._Poh1_Sex = this._Poh1_Sex; cloneTB._Poh2_Sex = this._Poh2_Sex; cloneTB._N_Prd = this._N_Prd; cloneTB._N1_Prd = this._N1_Prd; cloneTB._M_Prd = this._M_Prd; cloneTB._Pdt_Code = this._Pdt_Code; return cloneTB; } catch(Exception ex) { throw new Exception(ex.Message); } }
public static clsMAST_INSR_POLICY_TB_MIRROR Create(DataRow dr) { try { clsMAST_INSR_POLICY_TB_MIRROR tb = new clsMAST_INSR_POLICY_TB_MIRROR(); tb._Cal_Date = "20150703";//Convert.ToString(dr[0]); tb._Pdt_Type = Convert.ToInt32(dr[1]); tb._Sales_Ch = Convert.ToInt32(dr[2]); tb._Po_Date = "20150101";//Convert.ToString(dr[3]); tb._IR_Code = Convert.ToInt32(dr[4]); tb._Po_PmType = Convert.ToInt32(dr[5]); tb._Po_No = Convert.ToInt64(dr[6]); tb._C_Rate = Convert.ToDouble(dr[7]); tb._Acc_No = Convert.ToInt32(dr[8]); tb._Mc_FA = Convert.ToDouble(dr[9]); tb._Gs_Prem = Convert.ToDouble(dr[10]); tb._Mc_Prem = Convert.ToDouble(dr[11]); tb._Sb_Prem = Convert.ToDouble(dr[12]); tb._Sp_Prem = Convert.ToDouble(dr[13]); tb._Poh1_Age = Convert.ToInt32(dr[14]); tb._Poh2_Age = Convert.ToInt32(dr[15]); tb._Poh1_Sex = Convert.ToInt32(dr[16]); tb._Poh2_Sex = Convert.ToInt32(dr[17]); tb._N_Prd = Convert.ToInt32(dr[18]); tb._N1_Prd = Convert.ToInt32(dr[19]); tb._M_Prd = Convert.ToInt32(dr[20]); tb._Pdt_Code = Convert.ToInt32(dr[21]); return tb; } catch(Exception ex) { throw new Exception(ex.Message); } }