private bool ImportExcel() { //bool result; System.Data.DataTable dt; var openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "Excel (*.XLS)|*.xls"; if (!(bool)(openFileDialog.ShowDialog())) { return(false); } else { string excelName = openFileDialog.FileName; dt = _excelHelper.LoadExcel(excelName); } if (dt == null) { return(false); } else { var tradeNo = openFileDialog.SafeFileName.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries)[0]; LvTradeInfo.Add(new T_Trade_Sta_Ext() { Trade_No = tradeNo, Sort = LvTradeInfo.Count() }); dt.Rows.RemoveAt(0); dt.Columns.RemoveAt(9); ld.Add(dt); return(true); } }
//确定 private void Okay() { bool result = true; //sql语句列表 var SqlList = new Dictionary <List <string>, string>(); string guid; guid = Guid.NewGuid().ToString("N").ToUpper(); SqlList.Add(new List <string> { guid, QuestionName, Difficulty, "1" }, SQL.AddQuestions); //添加操作题标准答案交易 for (int i = 0; i < LvTradeInfo.Count(); i++) { string tradeGuid = Guid.NewGuid().ToString("N").ToUpper(); SqlList.Add(new List <string> { tradeGuid, guid, LvTradeInfo[i].Trade_No, LvTradeInfo[i].Proportion.ToString(), LvTradeInfo[i].Sort.ToString() }, SQL.ADDTRADESTAANSWER); foreach (DataRow item in ld[i].Rows) { string answerGuid = Guid.NewGuid().ToString("N").ToUpper(); SqlList.Add(new List <string> { answerGuid, tradeGuid, item["F_VALUE_TYPE"].ToString(), item["F_DOMAIN"].ToString(), item["F_DOMAIN_VALUE"].ToString(), item["F_IS_WRITE"].ToString(), item["F_PROPORTION"].ToString(), item["F_SORT"].ToString() }, SQL.ADDTRADEVALSTAANSWER); } } //执行事务处理 result = ExamHandle.TryExecute(SqlList.Values.ToArray(), SqlList.Keys.Select(c => c.ToArray()).ToArray()); if (result) { Messenger.Default.Send("提交成功!"); Close(); } else { Messenger.Default.Send("提交失败!"); } }