protected string CombSqlTxt(string _keywords)
{
StringBuilder strTemp = new StringBuilder();
//if (GetSonUOList(apply_id) != "") strTemp.Append(" Agency_id in (" + GetSonUOList(apply_id) + ")");
//else strTemp.Append(" Agency_id = 0");
//BLL.CCOM.Period per_bll = new BLL.CCOM.Period();
//Model.CCOM.Period per_model = per_bll.GetModel(" Period_state=1");
//if (per_model != null) strTemp.Append(" and Period_id='" + per_model.Period_id + "'");
//else strTemp.Append(" and Period_id='0'");
BLL.CCOM.Reply_group per_bll = new BLL.CCOM.Reply_group();
Model.CCOM.Reply_group per_model = per_bll.GetModel("Group_id=" + apply_id);
strTemp.Append(" Role_id != 3 and Role_id != 1 and Role_id != 4 and User_id !=" + per_model.User_id);//非学生，教学干事，系统管理员，组长
_keywords = _keywords.Replace("'", "");
if (!string.IsNullOrEmpty(_keywords))
{
strTemp.Append(" and (");
strTemp.Append(" User_realname like '%" + _keywords + "%' ");
strTemp.Append(" or User_number like '%" + _keywords + "%' ");
strTemp.Append(" or Agency_name like '%" + _keywords + "%' ");
strTemp.Append(")");
}
return(strTemp.ToString());
}
private string DoAction()
{
string result = "";
BLL.CCOM.Reply_group bll = new BLL.CCOM.Reply_group();
Model.CCOM.Reply_group model;
if (action != MyEnums.ActionEnum.Edit.ToString())
{
model = new Model.CCOM.Reply_group();
}
else
{
model = bll.GetModel(Group_id);
}
string GroupName = this.txtGroupName.Text.Trim();
string TeaNumber = this.txtTeaNumber.Text.Trim();
// string Time = this.txtReplyTime.Text.Trim();
string Room = this.txtReplyRoom.Text.Trim();
string Goup_type = this.ddltype.SelectedValue;
//必填部分
if (Tools.CheckParams(GroupName + TeaNumber + Room))
{
return("请勿输入非法字符");
}
if (GroupName == "")
{
return("请填答辩组名称");
}
if (TeaNumber == "")
{
return("请填组长工号");
}
if (this.txtReplyTime.Value == "")
{
return("请填写答辩时间");
}
if (Room == "")
{
return("请填写答辩地点");
}
if (Goup_type == "#")
{
return("请选择答辩类型");
}
else if (Goup_type == "0")
{
model.Group_type = 0;
}
else if (Goup_type == "1")
{
model.Group_type = 1;
}
else if (Goup_type == "2")
{
model.Group_type = 2;
}
model.Group_name = GroupName;
model.Reply_time = Convert.ToDateTime(this.txtReplyTime.Value);;
model.Reply_room = Room;
BLL.CCOM.User_information user_bll = new BLL.CCOM.User_information();
Model.CCOM.User_information uset_model;
uset_model = user_bll.GetModel("User_number='" + TeaNumber + "'and Role_id!=3");
if (uset_model == null)
{
return("该教师用户不存在");
}
else
{
model.User_id = uset_model.User_id;
}
try
{
if (action == MyEnums.ActionEnum.Edit.ToString()) //修改
{
bll.Update(model);
}
else
{
bll.Add(model);
}
}
catch (Exception ex)
{
result = action == MyEnums.ActionEnum.Edit.ToString() ? "修改失败" : "添加失败" + ex.Message.ToString();
}
return(result);
}
protected string AddStudent()
{
JsonData data = new JsonData();
string Group_id = MyRequest.GetString("GroupID");
string User_id = MyRequest.GetString("StudentID");
string msg = "";
if (Tools.CheckParams(Group_id + User_id))
{
msg = "传输异常，存在非法字符！";
}
else
{
try
{
long userid = long.Parse(User_id);
long groupid = long.Parse(Group_id);
//判断学生是否已经选题
var topic_model = new BLL.CCOM.Topic_relation().GetModel(" Student_id=" + userid + " and Accept_state=1");
if (topic_model == null)
{
msg = "该同学尚未选择毕设题目！";
}
BLL.CCOM.Reply_student bll = new BLL.CCOM.Reply_student();
Model.CCOM.Reply_student model = bll.GetModel(" Group_id=" + groupid + " and User_id=" + userid);
if (msg == "")
{
if (model != null)
{
msg = "学生已在该答辩组中";
}
else
{
bool isIn = true;
var student_models = new BLL.CCOM.Reply_student().GetModelList(" User_id=" + User_id);
var group_model = new BLL.CCOM.Reply_group().GetModel(long.Parse(Group_id));
Model.CCOM.Reply_group other_model = null;;
foreach (Model.CCOM.Reply_student student_model in student_models)
{
if (new BLL.CCOM.Reply_group().GetModel(student_model.Group_id).Group_type.Equals(group_model.Group_type))
{
isIn = false;
other_model = new BLL.CCOM.Reply_group().GetModel(student_model.Group_id);
break;
}
}
if (isIn)
{
model = new Model.CCOM.Reply_student();
model.Group_id = groupid;
model.User_id = userid;
if (bll.Add(model) <= 0)
{
msg = "添加失败";
}
}
else
{
string name = new BLL.CCOM.User_information().GetModel(userid).User_realname;
msg = "学生" + name + "已在" + other_model.Group_name + "答辩组中";
}
}
}
}
catch (Exception)
{
msg = "添加发生异常！";
}
}
if (msg == "")
{
data["msg"] = "添加成功";
data["code"] = 1;
}
else
{
data["msg"] = msg;
data["code"] = 0;
}
return(data.ToJson());
}
