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