public void add(TeacherStudentMessageModel teacherstudentmessage)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//执行新增写进数据库
teacherstudentmessageDal.add(cn, tc, teacherstudentmessage);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
public bool add(SqlConnection cn, SqlTransaction tc, TeacherStudentMessageModel model)
{
return DbHelperSQL.insertModel<TeacherStudentMessageModel>(model, "TeacherStudentMessage", cn, tc);
}
public bool update(SqlConnection cn, SqlTransaction tc, TeacherStudentMessageModel model)
{
return DbHelperSQL.updateModel<TeacherStudentMessageModel>(model, "TeacherStudentMessage", "Evenid", model.Evenid.ToString(), "'", cn, tc);
}
private string SendMessage_Teacher_To_Parent_HANDLE()
{
var message = Post("Message");
var parentOpenId = Post("ParentOpenId");
var teacherOpenId = Post("TeacherOpenId");
var schoolNo = Post("SchoolNo");
IList<QueryModel> qmList = new List<QueryModel>();
qmList.Add(MakeUtil.getQueryModel("OpenId", "'", SqlWhere.WhereOperator.Equal, parentOpenId));
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, schoolNo));
var stuparent = _isjDepartStaffEbi.GetStudentParentDtoList(qmList, -1);
if (stuparent.Count <= 0)
{
return "Error";
}
qmList.Clear();
qmList.Add(MakeUtil.getQueryModel("OpenId", "'", SqlWhere.WhereOperator.Equal, teacherOpenId));
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, schoolNo));
var teacher = _teacherBindInfoEbi.getDtoList(qmList, 1).FirstOrDefault();
if (teacher == null || teacher.OpenId == "")
{
return "Error";
}
var parentName = string.Join(",", stuparent.Select(p => p.DS_Name));
TeacherStudentMessageModel tsmm = new TeacherStudentMessageModel
{
SchoolNo = schoolNo,
FromName = teacher.DS_Name,
FromOpenId = teacherOpenId,
ToName = parentName,
ToOpenId = parentOpenId,
Message = message,
MessageType = 1
};
_teacherStudentMessageEbi.add(tsmm);
//发送微信提醒到家长的微信上
SendWarningMessage(parentOpenId);
return "OK";
}
