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("提交失败!");
}
}