protected string ImportDataItem(DataSet ds, ref int success, ref int error)//基础数据
{
string result = "";
BLL.CCOM.Topic bll = new BLL.CCOM.Topic();
Model.CCOM.Topic model = new Model.CCOM.Topic();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string checkmsg = null;
string topic_name = ds.Tables[0].Rows[i]["题目名称"].ToString().Trim();
if (!ValidDFValue(topic_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目名称" + checkmsg + "<br/>";
error++;
continue;
}
else if (topic_name != "")
{
model.Topic_name = topic_name;
}
string Topic_nature = ds.Tables[0].Rows[i]["题目性质"].ToString().Trim();
if (!ValidDFValue(Topic_nature, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目性质" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_nature != "")
{
model.Topic_nature = Topic_nature;
}
string Topic_source = ds.Tables[0].Rows[i]["题目来源"].ToString().Trim();
if (!ValidDFValue(Topic_source, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目来源" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_source != "")
{
model.Topic_source = Topic_source;
}
string Topic_content = ds.Tables[0].Rows[i]["题目内容"].ToString().Trim();
if (!ValidDFValue(Topic_content, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目内容" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_content != "")
{
model.Topic_content = Topic_content;
}
string Topic_task = ds.Tables[0].Rows[i]["任务书"].ToString().Trim();
if (!ValidDFValue(Topic_task, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目内容" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_task != "")
{
model.Topic_task = Topic_task;
}
model.Selected_state = false;
model.Check_state = 0;
model.Teacher_id = GetAdminInfo_CCOM().User_id;
model.Company = "软件学院";
if (bll.Add(model) == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
}
return(result);
}
protected string ImportDataItem(DataSet ds, ref int success, ref int error)//基础数据
{
string result = "";
BLL.CCOM.User_information stu_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information stu_model = new Model.CCOM.User_information();
BLL.CCOM.Topic topic_bll = new BLL.CCOM.Topic();
Model.CCOM.Topic topic_model = new Model.CCOM.Topic();
BLL.CCOM.Topic_relation rela_bll = new BLL.CCOM.Topic_relation();
Model.CCOM.Topic_relation rela_model = new Model.CCOM.Topic_relation();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string checkmsg = null;
#region 添加学生信息==========================
//学号
string number = ds.Tables[0].Rows[i]["学号"].ToString().Trim();
if (!ValidDFValue(number, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，学号" + checkmsg + "<br/>";
error++;
continue;
}
else if (stu_bll.GetModel(" User_number='" + number + "'") != null)
{
stu_model = stu_bll.GetModel(" User_number='" + number + "'");
}
else if (number != "")
{
stu_model.User_number = number;
}
//姓名
string name = ds.Tables[0].Rows[i]["姓名"].ToString().Trim();
if (!ValidDFValue(name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，姓名" + checkmsg + "<br/>";
error++;
continue;
}
else if (name != "")
{
stu_model.User_realname = name;
}
//性别
//string gender = ds.Tables[0].Rows[i]["性别"].ToString().Trim();
//if (!ValidDFValue(gender, true, "男|女", ref checkmsg))
//{
// result += "×第" + (i + 1).ToString() + "行数据更新失败，性别" + checkmsg + "<br/>";
// error++;
// continue;
//}
//else if (gender == "男")
//{
// stu_model.User_gender = false;
//}
//else if (gender == "女")
//{
// stu_model.User_gender = true;
//}
//机构
stu_model.User_gender = false;
string angency = ds.Tables[0].Rows[i]["行政班"].ToString().Trim();
if (!ValidDFValue(angency, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，所在班号" + checkmsg + "<br/>";
error++;
continue;
}
BLL.CCOM.Agency agency_bll = new BLL.CCOM.Agency();
Model.CCOM.Agency agency_model = new Model.CCOM.Agency();
agency_model = agency_bll.GetModel(" Agency_name='" + angency + "'");
if (agency_model == null)
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，所在班号不存在<br/>";
error++;
continue;
}
stu_model.Agency_id = agency_model.Agency_id;
stu_model.Role_id = 3;
stu_model.User_password = DESEncrypt.MD5Encrypt(number);
if (stu_bll.GetModel(" User_number='" + number + "'") == null)
{
stu_model.User_id = stu_bll.Add(stu_model);
if (stu_model.User_id == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information user_model = user_bll.GetModel("User_number='" + number + "'");
BLL.CCOM.Student student_bll = new BLL.CCOM.Student();
Model.CCOM.Student student_model = new Model.CCOM.Student();
student_model.User_id = user_model.User_id;
student_model.Period_id = 4;
student_bll.Add(student_model);
}
}
else
{
if (!stu_bll.Update(stu_model))
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
}
#endregion
#region 更新导师信息==========================
var tea_model = new Model.CCOM.Tutor();
//姓名
string tea_name = ds.Tables[0].Rows[i]["指导教师"].ToString().Trim();
if (!ValidDFValue(tea_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，指导教师" + checkmsg + "<br/>";
error++;
continue;
}
else if (tea_name != "")
{
var tea_user_model = new BLL.CCOM.User_information().GetModel(" User_realname='" + tea_name + "'");
if (tea_user_model == null)
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，指导教师" + tea_name + "不存在<br/>";
error++;
continue;
}
tea_model = new BLL.CCOM.Tutor().GetModel(" User_id=" + tea_user_model.User_id);
string title_name = ds.Tables[0].Rows[i]["职称"].ToString().Trim();
if (!ValidDFValue(title_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，职称" + checkmsg + "<br/>";
error++;
continue;
}
else if (title_name != "")
{
var title_model = new BLL.CCOM.Title().GetModel(" Title_name='" + title_name + "'");
if (title_model == null)
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，职称" + title_name + "不存在<br/>";
error++;
continue;
}
tea_model.Title_id = title_model.Title_id;
if (!new BLL.CCOM.Tutor().Update(tea_model))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，更新导师信息失败<br/>";
error++;
continue;
}
}
}
#endregion
#region 导入选题信息==========================
string topic_name = ds.Tables[0].Rows[i]["毕业设计题目"].ToString().Trim();
if (!ValidDFValue(topic_name, true, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目名称" + checkmsg + "<br/>";
error++;
continue;
}
else if (topic_name != "")
{
topic_model.Topic_name = topic_name;
}
string Topic_nature = ds.Tables[0].Rows[i]["题目性质"].ToString().Trim();
if (!ValidDFValue(Topic_nature, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目性质" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_nature != "")
{
topic_model.Topic_nature = Topic_nature;
}
string Topic_source = ds.Tables[0].Rows[i]["题目来源"].ToString().Trim();
if (!ValidDFValue(Topic_source, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目来源" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_source != "")
{
topic_model.Topic_source = Topic_source;
}
string Topic_content = ds.Tables[0].Rows[i]["题目详情"].ToString().Trim();
if (!ValidDFValue(Topic_content, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，题目详情" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_content != "")
{
topic_model.Topic_content = Topic_content;
}
string Topic_task = ds.Tables[0].Rows[i]["任务书"].ToString().Trim();
if (!ValidDFValue(Topic_task, false, "", ref checkmsg))
{
result += "×第" + (i + 1).ToString() + "行数据更新失败，任务书" + checkmsg + "<br/>";
error++;
continue;
}
else if (Topic_task != "")
{
topic_model.Topic_task = Topic_task;
}
topic_model.Selected_state = true;
topic_model.Check_state = 1;
topic_model.Teacher_id = tea_model.User_id;
topic_model.Company = "软件学院";
topic_model.Topic_id = topic_bll.Add(topic_model);
if (topic_model.Topic_id == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
#endregion
#region 题对应关系信息==========================
if (rela_bll.GetModel(" Student_id=" + stu_model.User_id) != null && rela_bll.GetModel(" Student_id=" + stu_model.User_id).Accept_state != 2)
{
result += "×第" + (i + 1).ToString() + "行学生选题对应关系更新异常，该学生已经在系统有选题记录！<br/>";
error++;
continue;
}
rela_model.Student_id = stu_model.User_id;
rela_model.Teacher_id = tea_model.User_id;
rela_model.Topic_id = topic_model.Topic_id;
rela_model.Accept_state = 1;
rela_model.Apply_time = DateTime.Now;
rela_model.Topic_relation_id = rela_bll.Add(rela_model);
if (rela_model.Topic_relation_id == 0)
{
result += "×第" + (i + 1).ToString() + "行数据更新异常<br/>";
error++;
continue;
}
else
{
success++;
}
#endregion
}
return(result);
}