public void add(TeacherDayCheckRecordModel teacherdaycheckrecord)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
IList<QueryModel> qmList = new List<QueryModel>();
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, teacherdaycheckrecord.SchoolNo));
qmList.Add(MakeUtil.getQueryModel("D_Name", "'", SqlWhere.WhereOperator.Equal, teacherdaycheckrecord.D_Name));
qmList.Add(MakeUtil.getQueryModel("DS_JID", "'", SqlWhere.WhereOperator.Equal, teacherdaycheckrecord.DS_JID));
qmList.Add(MakeUtil.getQueryModel("DS_Name", "'", SqlWhere.WhereOperator.Equal, teacherdaycheckrecord.DS_Name));
qmList.Add(MakeUtil.getQueryModel("1", "", SqlWhere.WhereOperator.Equal, "1 AND DateDiff(dd, HappenDate,getdate())=0"));
var oldList = teacherdaycheckrecordDal.getModelList(cn, tc, qmList, -1);
if (oldList.Any())
{
teacherdaycheckrecord.Evenid = oldList[0].Evenid;
teacherdaycheckrecordDal.update(cn, tc, teacherdaycheckrecord);
}
else
{
//执行新增写进数据库
teacherdaycheckrecordDal.add(cn, tc, teacherdaycheckrecord);
}
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, TeacherDayCheckRecordModel model)
{
return DbHelperSQL.updateModel<TeacherDayCheckRecordModel>(model, "TeacherDayCheckRecord", "Evenid", model.Evenid.ToString(), "'", cn, tc);
}
public bool add(SqlConnection cn, SqlTransaction tc, TeacherDayCheckRecordModel model)
{
return DbHelperSQL.insertModel<TeacherDayCheckRecordModel>(model, "TeacherDayCheckRecord", cn, tc);
}
protected void AgreeSubmitClick(object sender, EventArgs e)
{
if (StudentLeaveRecordModel.RecordState != 0)
{
Response.Redirect("SchoolChose.aspx");
}
//不作时间限制
// if (StudentLeaveRecordModel.HappenDate.ToString("yyyy-MM-dd") != DateTime.Now.ToString("yyyy-MM-dd"))
// {
// Script.alertMsg("", Page);
// return;
// }
var model = StudentLeaveRecordModel;
//同意
model.RecordState = 1;
//添加一个教师晨报的记录
var teacherDayCheckRecordModel = new TeacherDayCheckRecordModel
{
DS_JID = model.Student_JID,
DS_Name = model.Student_Name,
D_Name = model.Student_DName,
LeaveType = model.LeaveType,
Memos = model.Memos,
SchoolNo = model.SchoolNo,
HappenDate = model.TimeSelect
};
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
//
_studentLeaveRecordDal.update(cn, tc, model);
IList<QueryModel> qmList = new List<QueryModel>();
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.SchoolNo));
var sdmodel = _schoolDataDal.getModel(cn, tc, qmList);
if (sdmodel.Evenid <= 0)
{
throw new Exception("找不到相关的学校的资料,请重新登录");
}
qmList.Clear();
qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.SchoolNo));
qmList.Add(MakeUtil.getQueryModel("D_Name", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.D_Name));
qmList.Add(MakeUtil.getQueryModel("DS_JID", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.DS_JID));
qmList.Add(MakeUtil.getQueryModel("DS_Name", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.DS_Name));
qmList.Add(MakeUtil.getQueryModel("HappenDate", "", SqlWhere.WhereOperator.BiggerEqual, teacherDayCheckRecordModel.HappenDate.ToString("yyyy-MM-dd")));
qmList.Add(MakeUtil.getQueryModel("HappenDate", "", SqlWhere.WhereOperator.Smaller, teacherDayCheckRecordModel.HappenDate.AddDays(1).ToString("yyyy-MM-dd")));
var oldList = _teacherdaycheckrecordDal.getModelList(cn, tc, qmList, -1);
if (oldList.Any())
{
teacherDayCheckRecordModel.Evenid = oldList[0].Evenid;
_teacherdaycheckrecordDal.update(cn, tc, teacherDayCheckRecordModel);
}
else
{
//执行新增写进数据库
_teacherdaycheckrecordDal.add(cn, tc, teacherDayCheckRecordModel);
}
// qmList.Clear();
// qmList.Add(MakeUtil.getQueryModel("SchoolNo", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.SchoolNo));
// qmList.Add(MakeUtil.getQueryModel("D_Name", "'", SqlWhere.WhereOperator.Equal, teacherDayCheckRecordModel.D_Name));
// qmList.Add(MakeUtil.getQueryModel("1", "", SqlWhere.WhereOperator.Equal, "1 AND DateDiff(dd, HappenDate,getdate())=0"));
// if (!_teacherDayCheckSubmitRecordDal.getModelList(cn, tc, qmList, -1).Any())
// {
// var teacherdaychecksubmitrecord = new TeacherDayCheckSubmitRecordModel
// {
// D_Name = teacherDayCheckRecordModel.D_Name,
// SchoolNo = teacherDayCheckRecordModel.SchoolNo,
// IsSubmit = true
// };
//
// //执行新增写进数据库
// _teacherDayCheckSubmitRecordDal.add(cn, tc, teacherdaychecksubmitrecord);
// }
//发送同意微信到家长的微信
var rs = Helper.WxSendStudentLeaveConfirmText("同意", model.Student_Name, model.Teacher_Name, sdmodel.SchoolName,
model.Student_Openid, Helper.GetWxPublicPlatformModel());
if (rs == "SUCCESS")
{
//
Script.alertMsg("完成", Page);
Script.scriptRedirect("SchoolChose.aspx", Page);
}
else
{
throw new Exception("发生错误,错误信息为" + rs + ",请重新审核");
}
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
Script.alertMsg(dalEx.Message, Page);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
public void update(TeacherDayCheckRecordModel teacherdaycheckrecord)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc = DbHelperSQL.startTransaction(cn);
teacherdaycheckrecordDal.update(cn, tc, teacherdaycheckrecord);
DbHelperSQL.commitTransaction(tc);
}
catch (Exception dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}