/// <summary>
/// 导入综合素质数据
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private bool ImportZhongheSuzi(DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
string xjh = dr["学籍号"].ToString();
Bmk bmk = Bmk.FindOne(p => p.xstbh == xjh);
if (bmk != null)
{
// 审美与艺术 运动与健康 探究与实践 劳动与技能 综合表现
if (dt.Columns.Contains("审美与艺术"))
bmk.km71 = dr["审美与艺术"].ToString();
if (dt.Columns.Contains("运动与健康"))
bmk.km72 = dr["运动与健康"].ToString();
if (dt.Columns.Contains("探究与实践"))
bmk.km73 = dr["探究与实践"].ToString();
if (dt.Columns.Contains("劳动与技能"))
bmk.km74 = dr["劳动与技能"].ToString();
if (dt.Columns.Contains("综合表现评定"))
bmk.km81 = dr["综合表现评定"].ToString();
if (dt.Columns.Contains("综合表现评语"))
bmk.km8 = dr["综合表现评语"].ToString();
bmk.Save();
}
}
return true;
}
/// <summary>
/// 导入学生名单
/// </summary>
/// <param name="datatable">数据表</param>
/// <returns>是否成功</returns>
private bool ImportStudent(DataTable datatable)
{
foreach (DataRow dr in datatable.Rows)
{
Bmk bmk = Bmk.FindOne(p => p.bmxh == dr["bmxh"].ToString());
if (bmk == null)
bmk = new Bmk();
bmk.byxxdm = dr["byxxdm"].ToString();
bmk.byxxmc = dr["byxxmc"].ToString();
bmk.bmxh = dr["bmxh"].ToString();
bmk.xm = dr["xm"].ToString();
bmk.bj = dr["class"].ToString();
bmk.xh = dr["xh"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.sfzh = dr["sfzh"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.csny = dr["csny"].ToString();
bmk.ty = dr["ty"].ToString();
bmk.mz = dr["mz"].ToString();
bmk.kslb = dr["kslb"].ToString();
bmk.hk = dr["hk"].ToString();
bmk.tel = dr["tel"].ToString();
bmk.jtzz = dr["jtzz"].ToString();
bmk.post = dr["post"].ToString();
bmk.syqk = dr["syqk"].ToString();
bmk.bz1 = dr["bz1"].ToString();
bmk.bz2 = dr["bz2"].ToString();
bmk.bz3 = dr["bz3"].ToString();
bmk.bz4 = dr["bz4"].ToString();
bmk.Save();
}
return true;
}
private static void ImportFromJson(string jsonContent)
{
var list = JsonConvert.DeserializeObject <List <Bmk> >(jsonContent);
foreach (var item in list)
{
Bmk bmk = null;
if (item.bmxh.IsNullOrEmpty() == false)
{
bmk = Bmk.FindOne(p => p.bmxh == item.bmxh);
}
else
{
bmk = Bmk.FindOne(p => p.RecordGuid == item.RecordGuid);
}
if (bmk == null)
{
bmk = new Bmk();
}
ModelCopier.CopyModel(item, bmk, new[] { "Id" });
bmk.Save();
}
}
/// <summary>
/// 从excel文件导入
/// </summary>
/// <param name="filepath"></param>
private void ImportFromExcel(string filepath)
{
var list = ExcelHelper.GetSheetNameList(filepath);
string sheetName = "Sheet1";
if (list.Count == 0)
{
throw new Exception("Excel文件中不存在任何表格");
}
else
{
bool flag = false;
foreach (var item in list)
{
if (item.Name == sheetName)
{
flag = true;
break;
}
}
if (flag == false)
{
sheetName = list[0].Name;
}
}
DataTable datatable = ExcelHelper.ExcelToDataTable(filepath, sheetName);
//报名序号 学籍主号 姓名 班级 班内编号 性别 出生日期 民族
//政治面貌 户籍类别 家庭电话 监护人手机 现居住地址 家庭邮码 学籍辅号
int total = 0; //总共
int import = 0; //导入数据
if (datatable.Columns.Contains("学籍辅号") && datatable.Columns.Contains("姓名") &&
datatable.Columns.Contains("班级"))
{
foreach (DataRow row in datatable.Rows)
{
total++;
string xstbh = row["学籍辅号"].ToString();
string xm = row["姓名"].ToString();
string bj = row["班级"].ToString();
if (!xstbh.IsNullOrEmpty())
{
var stu = Bmk.FindOne(p => p.xstbh == xstbh);
if (stu == null)
{
stu = new Bmk();
stu.xstbh = xstbh;
}
stu.xm = xm;
if (bj.IsNullOrEmpty() == false)
{
stu.bj = bj.Substring(bj.IndexOf('(') + 1).TrimEnd(')').PadLeft(2, '0');
}
;
stu.Save();
import++;
}
}
JsUtil.MessageBox(this, string.Format("学生总共{0}人,导入{1}", total, import));
}
else
{
JsUtil.MessageBox(this, "学籍辅号 姓名 班级 这3列必须存在");
}
}
/// <summary>
/// 从~/Data/Dbf/userdbfs/bmk.dbf导入数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnImportFromDatapath_Click(object sender, EventArgs e)
{
string dbfPath = Server.MapPath("~/Data/Dbf/userdbfs/");
string dbfTable = "bmk.dbf";
DataTable dt = DbfHelper.ToDataTable(dbfPath, dbfTable);
foreach (DataRow dr in dt.Rows)
{
string bmxh = dr["bmxh"].ToString();
Bmk bmk = Bmk.FindOne(p => p.bmxh == bmxh);
if (bmk == null)
{
bmk = new Bmk();
bmk.RecordGuid = Guid.NewGuid().ToString();
bmk.bmxh = bmxh;
}
bmk.xm = dr["xm"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.bmxh = dr["bmxh"].ToString();
bmk.zkzh = dr["zkzh"].ToString();
bmk.xm = dr["xm"].ToString();
bmk.sfzh = dr["sfzh"].ToString();
bmk.xb = dr["xb"].ToString();
bmk.mz = dr["mz"].ToString();
bmk.csny = dr["csny"].ToString();
bmk.ty = dr["ty"].ToString();
bmk.tcxm = dr["tcxm"].ToString();
bmk.hk = dr["hk"].ToString();
bmk.xz = dr["xz"].ToString();
bmk.kslb = dr["kslb"].ToString();
bmk.byxxdm = dr["byxxdm"].ToString();
bmk.byxxmc = dr["byxxmc"].ToString();
bmk.xh = dr["xh"].ToString();
bmk.bj = dr["class"].ToString();
bmk.kl = dr["kl"].ToString();
bmk.jtzz = dr["jtzz"].ToString();
bmk.tel = dr["tel"].ToString();
bmk.post = dr["post"].ToString();
bmk.bz1 = dr["bz1"].ToString();
bmk.bz2 = dr["bz2"].ToString();
bmk.bz3 = dr["bz3"].ToString();
bmk.bz4 = dr["bz4"].ToString();
bmk.xstbh = dr["xstbh"].ToString();
bmk.kddm = dr["kddm"].ToString();
bmk.kdmc = dr["kdmc"].ToString();
bmk.scbm = dr["scbm"].ToString();
bmk.tbsch = dr["tbsch"].ToString();
bmk.zwh = dr["zwh"].ToString();
bmk.scmh = dr["scmh"].ToString();
//bmk.km1 = dr["km1"].to();
//bmk.km2 = dr["km2"].ToString();
//bmk.km3 = dr["km3"].ToString();
//bmk.km31 = dr["km31"].ToString();
//bmk.km32 = dr["km32"].ToString();
//bmk.km4 = dr["km4"].ToString();
//bmk.km5 = dr["km5"].ToString();
//bmk.km51 = dr["km51"].ToString();
//bmk.km61 = dr["km61"].ToString();
//bmk.km62 = dr["km62"].ToString();
//bmk.km621 = dr["km621"].ToString();
//bmk.km63 = dr["km63"].ToString();
//bmk.km6 = dr["km6"].ToString();
bmk.km71 = dr["km71"].ToString();
bmk.km72 = dr["km72"].ToString();
bmk.km73 = dr["km73"].ToString();
bmk.km74 = dr["km74"].ToString();
bmk.km81 = dr["km81"].ToString();
//bmk.tyf = dr["tyf"].ToString();
//bmk.tzf = dr["tzf"].ToString();
//bmk.tcf = dr["tcf"].ToString();
//bmk.zf = dr["zf"].ToString();
//bmk.tot1 = dr["tot1"].ToString();
//bmk.tot2 = dr["tot2"].ToString();
//bmk.mch = dr["mch"].ToString();
//bmk.tzdm = dr["tzdm"].ToString();
//bmk.tzmc = dr["tzmc"].ToString();
bmk.tcdm = dr["tcdm"].ToString();
bmk.tcmc = dr["tcmc"].ToString();
bmk.zy11 = dr["zy11"].ToString();
bmk.zy12 = dr["zy12"].ToString();
bmk.zy13 = dr["zy13"].ToString();
bmk.zy21 = dr["zy21"].ToString();
bmk.zy22 = dr["zy22"].ToString();
bmk.zy23 = dr["zy23"].ToString();
bmk.zy31 = dr["zy31"].ToString();
bmk.zy32 = dr["zy32"].ToString();
bmk.zy33 = dr["zy33"].ToString();
bmk.zy41 = dr["zy41"].ToString();
bmk.zy42 = dr["zy42"].ToString();
bmk.zy43 = dr["zy43"].ToString();
bmk.zy51 = dr["zy51"].ToString();
bmk.zy52 = dr["zy52"].ToString();
bmk.zy53 = dr["zy53"].ToString();
bmk.fc = dr["fc"].ToString();
bmk.jb = dr["jb"].ToString();
bmk.syqk = dr["syqk"].ToString();
bmk.Save();
}
this.Succeed("导入完毕!");
}
