public void add(TeacherBindInfoModel teacherbindinfo)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//执行新增写进数据库
teacherbindinfoDal.add(cn, tc, teacherbindinfo);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (OpenId.Length < 10)
{
// Script.alertMsg("获取不到openid,请先关注我们的公众品台再从微信端登录", Page);
Response.Redirect("Error.aspx");
return;
}
//先判断openid是否已经绑定了家长或教师
IList<QueryModel> qmList = new List<QueryModel>();
qmList.Add(MakeUtil.getQueryModel("OpenId", "'", SqlWhere.WhereOperator.Equal, OpenId));
ParentBindInfoModels = _isjDepartStaffEbi.GetStudentParentDtoList(qmList, -1);
ParentsRepeater.DataSource = ParentBindInfoModels;
TeacherBindInfoModel = _teacherBindInfoEbi.getModel(qmList);
this.DataBind();
}
protected void TeacherBindClick(object sender, EventArgs e)
{
IList<QueryModel> qmList = new List<QueryModel>();
var teacherId = MakeUtil.getStringFromRequestByName(Request, "TeacherId", -1);
var schoolNo = MakeUtil.getStringFromRequestByName(Request, "SchoolNo", -1);
var teacherName = MakeUtil.getStringFromRequestByName(Request, "TeacherName", -1);
if (TeacherBindInfoModel.OpenId.Length > 0)
{
Script.alertMsg("绑定失败!你的公众号已经绑定了一个教师编号,不能重复绑定", Page);
return;
}
//教师的绑定就是先用教师的编号检测一下是否已存在了这个编号
qmList.Add(MakeUtil.getQueryModel("DS_JID", "'", SqlWhere.WhereOperator.Equal, teacherId));
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, schoolNo));
qmList.Add(MakeUtil.getQueryModel("DS_Name", "'", SqlWhere.WhereOperator.Equal, teacherName));
if (_isjDepartStaffEbi.getModelList(qmList, -1).Count == 0)
{
//如果不存在则绑定失败
Script.alertMsg("绑定失败!查找不到相关的教师编号,请仔细确认所填写的教师编号和教师名称", Page);
return;
}
qmList.Clear();
qmList.Add(MakeUtil.getQueryModel("TeacherId", "'", SqlWhere.WhereOperator.Equal, teacherId));
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, schoolNo));
if (_teacherBindInfoEbi.getModelList(qmList, -1).Count > 0)
{
//如果已被绑定则绑定失败
Script.alertMsg("绑定失败!这个教师编号已被绑定", Page);
return;
}
//如果存在便将教师的编号与openid保存在BingingInformation(暂定)表中
var tbim = new TeacherBindInfoModel();
tbim.OpenId = OpenId;
tbim.TeacherId = teacherId;
tbim.SchoolNo = schoolNo;
try
{
_teacherBindInfoEbi.add(tbim);
MakeUtil.addOperationNote(Request.UserHostAddress, "微信前台", "教师微信绑定", OpenId + ":" + teacherId);
Script.alertMsg("绑定成功", Page);
Script.scriptRedirect(Request.RawUrl, Page);
}
catch (Exception ex)
{
Script.alertMsg(ex.Message, Page);
return;
}
}
public bool update(SqlConnection cn, SqlTransaction tc, TeacherBindInfoModel model)
{
return DbHelperSQL.updateModel<TeacherBindInfoModel>(model, "TeacherBindInfo", "OpenId", model.OpenId, "'", cn, tc);
}
public bool add(SqlConnection cn, SqlTransaction tc, TeacherBindInfoModel model)
{
return DbHelperSQL.insertModel<TeacherBindInfoModel>(model, "TeacherBindInfo", cn, tc);
}
