/// <summary>
/// 数据集操作
/// </summary>
/// <param name="ds"></param>
private void DataSetOperator(DataSet ds, string filePath)
{
int k = 0;
if (ds.Tables[0].Rows.Count < 1)
{
JscriptMsg(350, 230, "错误提示", "<b>没有数据！</b>", "back", "Error");
return;
}
try
{
string strPlatform=this.ddlPlatform.SelectedValue;
//string strFirstLetter=this.ddlFirstLetter.SelectedValue;
ArrayList SQLStringList1 = new ArrayList();
Spread.BLL.Game bllGame = new BLL.Game();
bllGame.DeletByPlatform(strPlatform);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
k++;
string sqlStr1 = "insert into Game(Name,Platform,FirstLetter,UpdateDate,IsLock)";
sqlStr1 += "values ('" + ds.Tables[0].Rows[i][1].ToString().Trim() + "',";
sqlStr1 += "'" + strPlatform + "',";
sqlStr1 += "'" + ds.Tables[0].Rows[i][0].ToString().Trim() + "',";
sqlStr1 += "'" + DateTime.Now + "',";
sqlStr1 += "'False')";//其他备注
SQLStringList1.Add(sqlStr1);
}
DbHelper.ExecuteSqlTran(SQLStringList1);
}
catch (Exception ex)
{
JscriptMsg(350, 230, "错误提示", "<b>没有数据！" + ex.Message + "</b>", "back", "Error");
}
finally
{
JscriptMsg(350, 230, "上传成功", "上传成功" + k + "条", "back", "Error");
File.Delete(filePath);
}
}
