private void run_upload_data(DataSet Excelds)
{
int i = 0;
string name = "";
string stuno = "";
string ksno = "";
string CardID = "";
string score = "";
string luquxueyuan = "";
string luquzhuanye = "";
string kstype = "";
zs.Model.Tbl_Chaxun chaxun = new zs.Model.Tbl_Chaxun();
//PJXT.Model.teacher teacher = new PJXT.Model.teacher();
//PJXT.Model.classes classes = new PJXT.Model.classes();
//PJXT.Model.student student = new PJXT.Model.student();
while (i < Excelds.Tables[0].Rows.Count)
{
name = Excelds.Tables[0].Rows[i][0].ToString();
stuno = Excelds.Tables[0].Rows[i][1].ToString();
ksno = Excelds.Tables[0].Rows[i][2].ToString();
CardID = Excelds.Tables[0].Rows[i][3].ToString();
score = Excelds.Tables[0].Rows[i][4].ToString();
luquxueyuan = Excelds.Tables[0].Rows[i][5].ToString();
luquzhuanye = Excelds.Tables[0].Rows[i][6].ToString();
kstype = Excelds.Tables[0].Rows[i][7].ToString();
if (bll.GetModelList("cardid='" + CardID + "'").Count > 0)
{
chaxun = bll.GetModelList("cardid='" + CardID + "'")[0];
chaxun.name = name;
chaxun.stuno = stuno;
chaxun.ksno = ksno;
chaxun.cardid = CardID;
chaxun.score = score;
chaxun.luquxueyuan = luquxueyuan;
chaxun.luquzhuanye = luquzhuanye;
chaxun.kstype = kstype;
bll.Update(chaxun);
}
else
{
chaxun.name = name;
chaxun.stuno = stuno;
chaxun.ksno = ksno;
chaxun.cardid = CardID;
chaxun.score = score;
chaxun.luquxueyuan = luquxueyuan;
chaxun.luquzhuanye = luquzhuanye;
chaxun.kstype = kstype;
bll.Add(chaxun);
}
i++;
}
this.lb_Result.Text = "共新增数据：" + i + "条。";
BindData();
//Allusers.WriteLogsFile("管理员,导入学生" + i + "个成功!IP:" + Request.UserHostAddress.ToString());
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <zs.Model.Tbl_Chaxun> DataTableToList(DataTable dt)
{
List <zs.Model.Tbl_Chaxun> modelList = new List <zs.Model.Tbl_Chaxun>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
zs.Model.Tbl_Chaxun model;
for (int n = 0; n < rowsCount; n++)
{
model = new zs.Model.Tbl_Chaxun();
if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
if (dt.Rows[n]["name"] != null && dt.Rows[n]["name"].ToString() != "")
{
model.name = dt.Rows[n]["name"].ToString();
}
if (dt.Rows[n]["stuno"] != null && dt.Rows[n]["stuno"].ToString() != "")
{
model.stuno = dt.Rows[n]["stuno"].ToString();
}
if (dt.Rows[n]["ksno"] != null && dt.Rows[n]["ksno"].ToString() != "")
{
model.ksno = dt.Rows[n]["ksno"].ToString();
}
if (dt.Rows[n]["cardid"] != null && dt.Rows[n]["cardid"].ToString() != "")
{
model.cardid = dt.Rows[n]["cardid"].ToString();
}
if (dt.Rows[n]["score"] != null && dt.Rows[n]["score"].ToString() != "")
{
model.score = dt.Rows[n]["score"].ToString();
}
if (dt.Rows[n]["luquxueyuan"] != null && dt.Rows[n]["luquxueyuan"].ToString() != "")
{
model.luquxueyuan = dt.Rows[n]["luquxueyuan"].ToString();
}
if (dt.Rows[n]["luquzhuanye"] != null && dt.Rows[n]["luquzhuanye"].ToString() != "")
{
model.luquzhuanye = dt.Rows[n]["luquzhuanye"].ToString();
}
if (dt.Rows[n]["kstype"] != null && dt.Rows[n]["kstype"].ToString() != "")
{
model.kstype = dt.Rows[n]["kstype"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
public static string GetStr(string str)
{
zs.BLL.Tbl_Chaxun bll = new zs.BLL.Tbl_Chaxun();
if (bll.Exists(str))
{
zs.Model.Tbl_Chaxun model = bll.GetModel(str);
StringBuilder sb = new StringBuilder();
sb.Append("<strong>恭喜您被录取了，以下是您的录取信息，请核对：</strong>");
sb.Append("<ul>");
sb.Append("<li>姓名：" + model.name + "</li>");
sb.Append("<li>学号：" + model.stuno + "</li>");
sb.Append("<li>分数：" + model.score + "</li>");
sb.Append("<li>学院：" + model.luquxueyuan + "</li>");
sb.Append("<li>专业：" + model.luquzhuanye + "</li>");
sb.Append("</ul>");
return(sb.ToString());
}
else
{
return("<strong>非常抱歉，没有" + str + "相应的录取信息，请您核对输入是否正确，或联系我们核实。</strong>");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(zs.Model.Tbl_Chaxun model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(zs.Model.Tbl_Chaxun model)
{
return(dal.Add(model));
}
