/// <summary>
/// 将DataSet导入到临时表StudentsExcel中
/// </summary>
/// <param name="upexcelpath"></param>
public static string DataSettoStudentsExcel(DataSet ds)
{
int count = ds.Tables[0].Rows.Count;
int columnscount = ds.Tables[0].Columns.Count;
string msg = "";
int isright = 0;
string[] strColumn = { "学号", "入学年度", "年级", "班级", "姓名", "密码", "性别", "家庭住址", "联系电话", "家长姓名", "班主任" };
for (int k = 0; k < columnscount; k++)
{
string strname = ds.Tables[0].Columns[k].ColumnName;
foreach (string str in strColumn)
{
if (strname == str)
isright++;
}
}
if (isright == strColumn.Length)
{
if (count > 0)
{
int wrong = 0;
LearnSite.Model.StudentsExcel stu = new LearnSite.Model.StudentsExcel();
LearnSite.BLL.StudentsExcel stubll = new LearnSite.BLL.StudentsExcel();
for (int i = 0; i < count; i++)
{
string strnum = ds.Tables[0].Rows[i]["学号"].ToString().Trim();
if (LearnSite.Common.WordProcess.IsNum(strnum))
{
int getnum = int.Parse(strnum);
stu.Snum = getnum.ToString();
stu.Syear = int.Parse(ds.Tables[0].Rows[i]["入学年度"].ToString());
stu.Sgrade = int.Parse(ds.Tables[0].Rows[i]["年级"].ToString());
stu.Sclass = int.Parse(ds.Tables[0].Rows[i]["班级"].ToString());
stu.Sname = ds.Tables[0].Rows[i]["姓名"].ToString();
stu.Spwd = ds.Tables[0].Rows[i]["密码"].ToString();
stu.Sex = ds.Tables[0].Rows[i]["性别"].ToString();
stu.Saddress = ds.Tables[0].Rows[i]["家庭住址"].ToString();
stu.Sphone = ds.Tables[0].Rows[i]["联系电话"].ToString();
stu.Sparents = ds.Tables[0].Rows[i]["家长姓名"].ToString();
stu.Sheadtheacher = ds.Tables[0].Rows[i]["班主任"].ToString();
stubll.AddFromExcelDs(stu);
}
else
{
wrong++;
}
}
int right = count - wrong;
msg = "成功导入" + right + "条数据！";
if (wrong > 0)
msg = msg + " 学号错误共" + wrong + "条数据";
}
else
{
msg = "无数据！";
}
}
else
{
msg = "Excel数据格式不正确，请参考样式";
}
return msg;
}
/// <summary>
/// 将DataSet导入到临时表StudentsExcel中
/// </summary>
/// <param name="upexcelpath"></param>
public static string DataSettoStudentsExcel(DataSet ds, bool pinying)
{
string msg = "";
if (ds != null)
{
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
int columnscount = ds.Tables[0].Columns.Count;
int isright = 0;
string[] strColumn = { "学号", "入学年度", "年级", "班级", "姓名", "密码", "性别", "家庭住址", "联系电话", "家长姓名", "班主任" };
for (int k = 0; k < columnscount; k++)
{
string strname = ds.Tables[0].Columns[k].ColumnName;
foreach (string str in strColumn)
{
if (strname == str)
{
isright++;
}
}
}
if (isright == strColumn.Length)
{
int wrong = 0;
LearnSite.Model.StudentsExcel stu = new LearnSite.Model.StudentsExcel();
LearnSite.BLL.StudentsExcel stubll = new LearnSite.BLL.StudentsExcel();
for (int i = 0; i < count; i++)
{
string strnum = ds.Tables[0].Rows[i]["学号"].ToString().Trim();
if (LearnSite.Common.WordProcess.IsNum(strnum))
{
string stryear = ds.Tables[0].Rows[i]["入学年度"].ToString();
string strgrade = ds.Tables[0].Rows[i]["年级"].ToString();
string strclass = ds.Tables[0].Rows[i]["班级"].ToString();
stu.Snum = strnum;
stu.Syear = int.Parse(stryear);
stu.Sgrade = int.Parse(strgrade);
stu.Sclass = int.Parse(strclass);
stu.Sname = ds.Tables[0].Rows[i]["姓名"].ToString().Replace(" ", "").Trim();//去空格，以防提交的作品名称找不到路径
if (pinying)
{
string spellname = LearnSite.Common.Gbk2Spell.Chinese.FirstLetter(stu.Sname);//取姓名的拼音缩写为密码
if (LearnSite.Common.WordProcess.IsEnNum(spellname))
{
stu.Spwd = spellname;//如果缩写为字母或数字则采用
}
else
{
stu.Spwd = ds.Tables[0].Rows[i]["密码"].ToString();//否则用原密码
}
}
else
{
stu.Spwd = ds.Tables[0].Rows[i]["密码"].ToString();
}
stu.Sex = ds.Tables[0].Rows[i]["性别"].ToString();
stu.Saddress = ds.Tables[0].Rows[i]["家庭住址"].ToString();
stu.Sphone = ds.Tables[0].Rows[i]["联系电话"].ToString();
stu.Sparents = ds.Tables[0].Rows[i]["家长姓名"].ToString();
stu.Sheadtheacher = ds.Tables[0].Rows[i]["班主任"].ToString();
stubll.AddFromExcelDs(stu);
}
else
{
wrong++;
}
}
int right = count - wrong;
msg = "成功获取" + right + "条数据到临时表！<br/>请点下一步导入数据，即可将数据导入数据库！";
if (wrong > 0)
{
msg = msg + " 学号错误(非数字格式)共" + wrong + "条数据";
}
}
else
{
msg = "Excel数据格式不正确，请参考学生导入模板";
}
}
else
{
msg = "无数据！";
}
}
else
{
msg = "没有选择Excel上传或不是标准的Excel格式，<br/>请用Excel打开再保存试试！";
}
return(msg);
}