private void ImportMCAPoolDBTable(CSVValueViewModel csv)
{
SqlHelper sqlhelper = new SqlHelper();
string sql = "insert into MCA_Pool (SampleComment,Sample,UpdateDateTime,UserName,Recipe,Version,EQP) values ('" + csv.SampleComment + "','"
+ csv.Sample + "','" + csv.DataTime + "','" + csv.User + "','" + csv.Recipe + "','" + csv.Version + "','" + csv.SampleComment.Split(' ')[0] + "')";
sqlhelper.getSomeDate(sql);
}
private void ImportMACAgDBTable(CSVValueViewModel csv)
{
SqlHelper sqlhelper = new SqlHelper();
ObservableCollection <AgSeriesViewModel> ag_list = csv.agvm_list;
foreach (AgSeriesViewModel agvm in ag_list)
{
string sql = "insert into MCA_Ag (SampleComment,IndexNo,X,Y,R,T,IncidentAngle,Z,Phi,Si_E10,Si_IntenC,Si_IntenR,Si_LLD," +
"Ge_E10,Ge_IntenC,Ge_IntenR,Ge_LLD,As_E10,As_IntenC,As_IntenR,As_LLD,Na_E10,Na_IntenC,Na_IntenR,Na_LLD,Mg_E10,Mg_IntenC,Mg_IntenR,Mg_LLD," +
"Al_E10,Al_IntenC,Al_IntenR,Al_LLD) values(@sampleComment,@indexNo,@x,@y,@r,@t,@incidentAngle,@z,@phi,@si_E10,@si_IntenC,@si_IntenR,@si_LLD," +
"@ge_E10,@ge_IntenC,@ge_IntenR,@ge_LLD,@as_E10,@as_IntenC,@as_IntenR,@as_LLD,@na_E10,@na_IntenC,@na_IntenR,@na_LLD,@mg_E10,@mg_IntenC,@mg_IntenR,@mg_LLD," +
"@al_E10,@al_IntenC,@al_IntenR,@al_LLD)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@sampleComment", csv.SampleComment),
new SqlParameter("@indexNO", agvm.Index),
new SqlParameter("@x", ConvertString2Float(agvm.Ag_X)),
new SqlParameter("@y", ConvertString2Float(agvm.Ag_Y)),
new SqlParameter("@r", ConvertString2Float(agvm.Ag_Al_R)),
new SqlParameter("@t", ConvertString2Float(agvm.Ag_T)),
new SqlParameter("@incidentAngle", ConvertString2Float(agvm.Ag_IncidentAngle)),
new SqlParameter("@z", ConvertString2Float(agvm.Ag_Z)),
new SqlParameter("@phi", ConvertString2Float(agvm.Ag_Phi)),
new SqlParameter("@si_E10", ConvertString2Float(agvm.Ag_Si_E10)),
new SqlParameter("@si_IntenC", ConvertString2Float(agvm.Ag_Si_C)),
new SqlParameter("@si_IntenR", ConvertString2Float(agvm.Ag_Si_R)),
new SqlParameter("@si_LLD", ConvertString2Float(agvm.Ag_Si_LLD)),
new SqlParameter("@ge_E10", ConvertString2Float(agvm.Ag_Ge_E10)),
new SqlParameter("@ge_IntenC", ConvertString2Float(agvm.Ag_Ge_C)),
new SqlParameter("@ge_IntenR", ConvertString2Float(agvm.Ag_Ge_R)),
new SqlParameter("@ge_LLD", ConvertString2Float(agvm.Ag_Ge_LLD)),
new SqlParameter("@as_E10", ConvertString2Float(agvm.Ag_As_E10)),
new SqlParameter("@as_IntenC", ConvertString2Float(agvm.Ag_As_C)),
new SqlParameter("@as_IntenR", ConvertString2Float(agvm.Ag_As_R)),
new SqlParameter("@as_LLD", ConvertString2Float(agvm.Ag_As_LLD)),
new SqlParameter("@na_E10", ConvertString2Float(agvm.Ag_Na_E10)),
new SqlParameter("@na_IntenC", ConvertString2Float(agvm.Ag_Na_C)),
new SqlParameter("@na_IntenR", ConvertString2Float(agvm.Ag_Na_R)),
new SqlParameter("@na_LLD", ConvertString2Float(agvm.Ag_Na_LLD)),
new SqlParameter("@mg_E10", ConvertString2Float(agvm.Ag_Mg_E10)),
new SqlParameter("@mg_IntenC", ConvertString2Float(agvm.Ag_Mg_C)),
new SqlParameter("@mg_IntenR", ConvertString2Float(agvm.Ag_Mg_R)),
new SqlParameter("@mg_LLD", ConvertString2Float(agvm.Ag_Mg_LLD)),
new SqlParameter("@al_E10", ConvertString2Float(agvm.Ag_Al_E10)),
new SqlParameter("@al_IntenC", ConvertString2Float(agvm.Ag_Al_C)),
new SqlParameter("@al_IntenR", ConvertString2Float(agvm.Ag_Al_R)),
new SqlParameter("@al_LLD", ConvertString2Float(agvm.Ag_Al_LLD))
};
sqlhelper.getSomeData2(sql, para);
}
}
//获取csv数据
private CSVValueViewModel CSVVM(string type, DataTable dt)
{
CSVValueViewModel csvvm = new CSVValueViewModel();
if (type == "Ag")
{
ObservableCollection <AgSeriesViewModel> agvm_list = new ObservableCollection <AgSeriesViewModel>();
for (int i = 0; i < dt.DefaultView.Count - 19 - 8; i++)
{
agvm_list.Add(GetAgData(i, dt));
}
csvvm.agvm_list = agvm_list;
}
else if (type == "W")
{
ObservableCollection <WSeriesViewModel> wvm_list = new ObservableCollection <WSeriesViewModel>();
for (int i = 0; i < dt.DefaultView.Count - 19 - 8; i++)
{
wvm_list.Add(GetWData(i, dt));
}
csvvm.wvm_list = wvm_list;
}
csvvm.User = dt.DefaultView[0][1].ToString();
csvvm.DataTime = dt.DefaultView[1][1].ToString();
csvvm.Sample = dt.DefaultView[2][1].ToString();
csvvm.SampleComment = dt.DefaultView[3][1].ToString();
csvvm.ConditionName = dt.DefaultView[5][1].ToString();
csvvm.ConditionComment = dt.DefaultView[6][1].ToString();
csvvm.Repeat = dt.DefaultView[8][1].ToString();
csvvm.RepeatMax = dt.DefaultView[9][1].ToString();
csvvm.Recipe = dt.DefaultView[11][1].ToString();
csvvm.RecipeComment = dt.DefaultView[12][1].ToString();
csvvm.Version = dt.DefaultView[14][1].ToString();
string filepath = dt.DefaultView[15][1].ToString();
csvvm.FileDir = Path.GetDirectoryName(filepath);
csvvm.FileName = Path.GetFileName(filepath);
return(csvvm);
}
private void ImportMCAWDBTable(CSVValueViewModel csv)
{
SqlHelper sqlhelper = new SqlHelper();
ObservableCollection <WSeriesViewModel> w_list = csv.wvm_list;
foreach (WSeriesViewModel wvm in w_list)
{
string sql = "insert into MCA_W (SampleComment,IndexNo,X,Y,R,T,IncidentAngle,Z,Phi,Si_E10,Si_IntenC,Si_IntenR,Si_LLD,S_E10,S_IntenC,S_IntenR,S_LLD,Cl_E10,Cl_IntenC,Cl_IntenR,Cl_LLD,K_E10,K_IntenC,K_IntenR,K_LLD,Ca_E10,Ca_IntenC,Ca_IntenR,Ca_LLD,Ti_E10,Ti_IntenC,Ti_IntenR,Ti_LLD,V_E10,V_IntenC,V_IntenR,V_LLD,Cr_E10,Cr_IntenC,Cr_IntenR,Cr_LLD,Mn_E10,Mn_IntenC,Mn_IntenR,Mn_LLD,Fe_E10,Fe_IntenC,Fe_IntenR,Fe_LLD,Co_E10,Co_IntenC,Co_IntenR,Co_LLD,Ni_E10,Ni_IntenC,Ni_IntenR,Ni_LLD,Cu_E10,Cu_IntenC,Cu_IntenR,Cu_LLD,Zn_E10,Zn_IntenC,Zn_IntenR,Zn_LLD,Sb_E10,Sb_IntenC,Sb_IntenR,Sb_LLD,Te_E10,Te_IntenC,Te_IntenR,Te_LLD,Na_E10,Na_IntenC,Na_IntenR,Na_LLD,Mg_E10,Mg_IntenC,Mg_IntenR,Mg_LLD,Al_E10,Al_IntenC,Al_IntenR,Al_LLD,POOL_UID) values (@sampleComment,@indexNo,@x,@y,@r,@t,@incidentAngle,@z,@phi,@si_E10,@si_IntenC,@si_IntenR,@si_LLD,@s_E10,@s_IntenC,@s_IntenR,@s_LLD,@cl_E10,@cl_IntenC,@cl_IntenR,@cl_LLD,@k_E10,@k_IntenC,@k_IntenR,@k_LLD,@ca_E10,@ca_IntenC,@ca_IntenR,@ca_LLD,@ti_E10,@ti_IntenC,@ti_IntenR,@ti_LLD,@v_E10,@v_IntenC,@v_IntenR,@v_LLD,@cr_E10,@cr_IntenC,@cr_IntenR,@cr_LLD,@mn_E10,@mn_IntenC,@mn_IntenR,@mn_LLD,@fe_E10,@fe_IntenC,@fe_IntenR,@fe_LLD,@co_E10,@co_IntenC,@co_IntenR,@co_LLD,@ni_E10,@ni_IntenC,@ni_IntenR,@ni_LLD,@cu_E10,@cu_IntenC,@cu_IntenR,@cu_LLD,@zn_E10,@zn_IntenC,@zn_IntenR,@zn_LLD,@sb_E10,@sb_IntenC,@sb_IntenR,@sb_LLD,@te_E10,@te_IntenC,@te_IntenR,@te_LLD,@na_E10,@na_IntenC,@na_IntenR,@na_LLD,@mg_E10,@mg_IntenC,@mg_IntenR,@mg_LLD,@al_E10,@al_IntenC,@al_IntenR,@al_LLD,@pool_uid)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@sampleComment", csv.SampleComment),
new SqlParameter("@indexNO", wvm.Index),
new SqlParameter("@x", ConvertString2Float(wvm.W_X)),
new SqlParameter("@y", ConvertString2Float(wvm.W_Y)),
new SqlParameter("@r", ConvertString2Float(wvm.W_Al_R)),
new SqlParameter("@t", ConvertString2Float(wvm.W_T)),
new SqlParameter("@incidentAngle", ConvertString2Float(wvm.W_IncidentAngle)),
new SqlParameter("@z", ConvertString2Float(wvm.W_Z)),
new SqlParameter("@phi", ConvertString2Float(wvm.W_Phi)),
new SqlParameter("@si_E10", ConvertString2Float(wvm.W_Si_E10)),
new SqlParameter("@si_IntenC", ConvertString2Float(wvm.W_Si_C)),
new SqlParameter("@si_IntenR", ConvertString2Float(wvm.W_Si_R)),
new SqlParameter("@si_LLD", ConvertString2Float(wvm.W_S_LLD)),
new SqlParameter("@s_E10", ConvertString2Float(wvm.W_S_E10)),
new SqlParameter("@s_IntenC", ConvertString2Float(wvm.W_S_C)),
new SqlParameter("@s_IntenR", ConvertString2Float(wvm.W_S_R)),
new SqlParameter("@s_LLD", ConvertString2Float(wvm.W_S_LLD)),
new SqlParameter("@cl_E10", ConvertString2Float(wvm.W_Cl_E10)),
new SqlParameter("@cl_IntenC", ConvertString2Float(wvm.W_Cl_C)),
new SqlParameter("@cl_IntenR", ConvertString2Float(wvm.W_Cl_R)),
new SqlParameter("@cl_LLD", ConvertString2Float(wvm.W_Cl_LLD)),
new SqlParameter("@k_E10", ConvertString2Float(wvm.W_K_E10)),
new SqlParameter("@k_IntenC", ConvertString2Float(wvm.W_K_C)),
new SqlParameter("@k_IntenR", ConvertString2Float(wvm.W_K_R)),
new SqlParameter("@k_LLD", ConvertString2Float(wvm.W_K_LLD)),
new SqlParameter("@ca_E10", ConvertString2Float(wvm.W_Ca_E10)),
new SqlParameter("@ca_IntenC", ConvertString2Float(wvm.W_Ca_C)),
new SqlParameter("@ca_IntenR", ConvertString2Float(wvm.W_Ca_R)),
new SqlParameter("@ca_LLD", ConvertString2Float(wvm.W_Ca_LLD)),
new SqlParameter("@ti_E10", ConvertString2Float(wvm.W_Ti_E10)),
new SqlParameter("@ti_IntenC", ConvertString2Float(wvm.W_Ti_C)),
new SqlParameter("@ti_IntenR", ConvertString2Float(wvm.W_Ti_R)),
new SqlParameter("@ti_LLD", ConvertString2Float(wvm.W_Ti_LLD)),
new SqlParameter("@v_E10", ConvertString2Float(wvm.W_V_E10)),
new SqlParameter("@v_IntenC", ConvertString2Float(wvm.W_V_C)),
new SqlParameter("@v_IntenR", ConvertString2Float(wvm.W_V_R)),
new SqlParameter("@v_LLD", ConvertString2Float(wvm.W_V_LLD)),
new SqlParameter("@cr_E10", ConvertString2Float(wvm.W_Cr_E10)),
new SqlParameter("@cr_IntenC", ConvertString2Float(wvm.W_Cr_C)),
new SqlParameter("@cr_IntenR", ConvertString2Float(wvm.W_Cr_R)),
new SqlParameter("@cr_LLD", ConvertString2Float(wvm.W_Cr_LLD)),
new SqlParameter("@mn_E10", ConvertString2Float(wvm.W_Mn_E10)),
new SqlParameter("@mn_IntenC", ConvertString2Float(wvm.W_Mn_C)),
new SqlParameter("@mn_IntenR", ConvertString2Float(wvm.W_Mn_R)),
new SqlParameter("@mn_LLD", ConvertString2Float(wvm.W_Mn_LLD)),
new SqlParameter("@fe_E10", ConvertString2Float(wvm.W_Fe_E10)),
new SqlParameter("@fe_IntenC", ConvertString2Float(wvm.W_Fe_C)),
new SqlParameter("@fe_IntenR", ConvertString2Float(wvm.W_Fe_R)),
new SqlParameter("@fe_LLD", ConvertString2Float(wvm.W_Fe_LLD)),
new SqlParameter("@co_E10", ConvertString2Float(wvm.W_Co_E10)),
new SqlParameter("@co_IntenC", ConvertString2Float(wvm.W_Co_C)),
new SqlParameter("@co_IntenR", ConvertString2Float(wvm.W_Co_R)),
new SqlParameter("@co_LLD", ConvertString2Float(wvm.W_Co_LLD)),
new SqlParameter("@ni_E10", ConvertString2Float(wvm.W_Ni_E10)),
new SqlParameter("@ni_IntenC", ConvertString2Float(wvm.W_Ni_C)),
new SqlParameter("@ni_IntenR", ConvertString2Float(wvm.W_Ni_R)),
new SqlParameter("@ni_LLD", ConvertString2Float(wvm.W_Ni_LLD)),
new SqlParameter("@cu_E10", ConvertString2Float(wvm.W_Cu_E10)),
new SqlParameter("@cu_IntenC", ConvertString2Float(wvm.W_Cu_C)),
new SqlParameter("@cu_IntenR", ConvertString2Float(wvm.W_Cu_R)),
new SqlParameter("@cu_LLD", ConvertString2Float(wvm.W_Cu_LLD)),
new SqlParameter("@zn_E10", ConvertString2Float(wvm.W_Zn_E10)),
new SqlParameter("@zn_IntenC", ConvertString2Float(wvm.W_Zn_C)),
new SqlParameter("@zn_IntenR", ConvertString2Float(wvm.W_Zn_R)),
new SqlParameter("@zn_LLD", ConvertString2Float(wvm.W_Zn_LLD)),
new SqlParameter("@sb_E10", ConvertString2Float(wvm.W_Sb_E10)),
new SqlParameter("@sb_IntenC", ConvertString2Float(wvm.W_Sb_C)),
new SqlParameter("@sb_IntenR", ConvertString2Float(wvm.W_Sb_R)),
new SqlParameter("@sb_LLD", ConvertString2Float(wvm.W_Sb_LLD)),
new SqlParameter("@te_E10", ConvertString2Float(wvm.W_Te_E10)),
new SqlParameter("@te_IntenC", ConvertString2Float(wvm.W_Te_C)),
new SqlParameter("@te_IntenR", ConvertString2Float(wvm.W_Te_R)),
new SqlParameter("@te_LLD", ConvertString2Float(wvm.W_Te_LLD)),
new SqlParameter("@na_E10", ConvertString2Float(wvm.W_Na_E10)),
new SqlParameter("@na_IntenC", ConvertString2Float(wvm.W_Na_C)),
new SqlParameter("@na_IntenR", ConvertString2Float(wvm.W_Na_R)),
new SqlParameter("@na_LLD", ConvertString2Float(wvm.W_Na_LLD)),
new SqlParameter("@mg_E10", ConvertString2Float(wvm.W_Mg_E10)),
new SqlParameter("@mg_IntenC", ConvertString2Float(wvm.W_Mg_C)),
new SqlParameter("@mg_IntenR", ConvertString2Float(wvm.W_Mg_R)),
new SqlParameter("@mg_LLD", ConvertString2Float(wvm.W_Mg_LLD)),
new SqlParameter("@al_E10", ConvertString2Float(wvm.W_Al_E10)),
new SqlParameter("@al_IntenC", ConvertString2Float(wvm.W_Al_C)),
new SqlParameter("@al_IntenR", ConvertString2Float(wvm.W_Al_R)),
new SqlParameter("@al_LLD", ConvertString2Float(wvm.W_Al_LLD)),
new SqlParameter("@pool_uid", csv.GUID),
};
sqlhelper.getSomeData2(sql, para);
}
}
