public void add(string schoolNo, string schoolName, string message, string messageHead, string messageFoot, string fromMan,
string fromName, string fromIdentityName, string toUid, string toOpenid, string url, int messageType, bool isSend = true, bool isErr = false, string errMessage = "")
{
SqlConnection cn = null;
try
{
cn = DbHelperSQL.getConnection();
var teachersendmessage = new TeacherSendMessageModel
{
SchoolNo = schoolNo,
SchoolName = schoolName,
Message = message,
MessageHead = messageHead,
MessageFoot = messageFoot,
FromMan = fromMan,
FromName = fromName,
FromIdentityName = fromIdentityName,
ToUid = toUid,
ToOpenid = toOpenid,
Url = url,
MessageType = messageType,
IsSend = isSend,
IsErr = isErr,
ErrMessage = errMessage
};
//执行新增写进数据库
teachersendmessageDal.add(cn, null, teachersendmessage);
}
catch (Exception dalEx)
{
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
public void add(TeacherSendMessageModel teachersendmessage)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//执行新增写进数据库
teachersendmessageDal.add(cn, tc, teachersendmessage);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
public bool update(SqlConnection cn, SqlTransaction tc, TeacherSendMessageModel model)
{
return DbHelperSQL.updateModel<TeacherSendMessageModel>(model, "TeacherSendMessage", "Evenid", model.Evenid.ToString(), "'", cn, tc);
}
public bool add(SqlConnection cn, SqlTransaction tc, TeacherSendMessageModel model)
{
return DbHelperSQL.insertModel<TeacherSendMessageModel>(model, "TeacherSendMessage", cn, tc);
}