public ResultCalculation(string vcode) { verifyCode = vcode; dalClarity = new DJK.DAL.admin_Clarity(); dalData = new DJK.DAL.admin_MedicalData(); dalSource = new DJK.DAL.admin_MedicalSource(); modelData = new DJK.Model.djk_cloudData(); dal = new DJK.DAL.djk_cloudData(); }
private void button6_Click(object sender, EventArgs e) { OpenFileDialog file1 = new OpenFileDialog(); if (file1.ShowDialog() == DialogResult.OK) { string filename = file1.FileName; System.Data.DataTable dt = OpenCSV(filename, 0, 0, 0, 0, false); int rows = dt.Rows.Count; List <string> sqlList = new List <string>(); int added = 0; DJK.DAL.admin_MedicalData dal = new DJK.DAL.admin_MedicalData(); if (rows > 0) { sqlList.Add("delete admin_medicalSource"); foreach (DataRow dr in dt.Rows) { string sql = string.Format("insert into admin_medicalSource(medicalID,Source,SourceTable,SourceNum,SourceID) values ({0},'{1}','{2}',{3},{4})", dr[0].ToString(), "matrix" + dr[2].ToString(), "matrix", dr[2].ToString(), int.Parse(dr[2].ToString() + 322)); //int tre = dal.runSql(sql); //added += tre; sqlList.Add(sql); } //DJK.DAL.admin_MedicalData dal = new DJK.DAL.admin_MedicalData(); added = dal.insertBulk(sqlList); if (added > 0) { textBox1.AppendText("Source导入" + rows + "条数据" + "\n"); } else { textBox1.AppendText("Source导入失败" + "\n"); } } else { textBox1.AppendText("文件中没有数据" + "\n"); } } }
private void button4_Click_1(object sender, EventArgs e) { OpenFileDialog file1 = new OpenFileDialog(); if (file1.ShowDialog() == DialogResult.OK) { string filename = file1.FileName; System.Data.DataTable dt = OpenCSV(filename, 0, 0, 0, 0, true); int rows = dt.Rows.Count; List <string> sqlList = new List <string>(); int added = 0; DJK.DAL.admin_MedicalData dal = new DJK.DAL.admin_MedicalData(); if (rows > 0) { sqlList.Add("delete admin_medicalData"); foreach (DataRow dr in dt.Rows) { string sql = string.Format("insert into admin_medicalData(ParentID,ID,Code,Item) values ({0},{1},'{2}','{3}')", dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString().Replace("'", "''")); //int tre = dal.runSql(sql); //added += tre; sqlList.Add(sql); } //DJK.DAL.admin_MedicalData dal = new DJK.DAL.admin_MedicalData(); added = dal.insertBulk(sqlList); if (added > 0) { textBox1.AppendText("Trees导入" + rows + "条数据" + "\n"); } else { textBox1.AppendText("Trees导入失败" + "\n"); } } else { textBox1.AppendText("文件中没有数据" + "\n"); } } }