/// <summary>
/// 展示子窗体
/// </summary>
/// <param name="classInfo">需要更新的实体信息</param>
/// <param name="editOpt">编辑操作</param>
public void ShowForm(ClassMaster_csm_Info classInfo, DefineConstantValue.EditStateEnum editOpt)
{
this._CurrentClassInfo = classInfo;
this._EditOpt = editOpt;
if (editOpt == Common.DefineConstantValue.EditStateEnum.OE_Insert)
{
this.Text = "新增--" + this.Text;
}
else if (editOpt == Common.DefineConstantValue.EditStateEnum.OE_Update)
{
this.Text = "编辑--" + this.Text;
labClassID.Text = classInfo.csm_cRecordID.ToString();
cbxGradeName.SelectItemForValue(classInfo.csm_cGDMID.ToString());
cbxClassName.SelectItemForValue(classInfo.csm_cClassNum);
cbxHeadTeacher.SelectItemForValue(classInfo.csm_cMasterID.ToString());
tbxRemarks.Text = classInfo.csm_cRemark;
}
else
{
return;
}
this.ShowDialog();
}
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (!String.IsNullOrEmpty(this.rspSearch.RSP_ClassID.ToString()))
{
ClassMaster_csm_Info classInfo = new ClassMaster_csm_Info();
classInfo.csm_cRecordID = this.rspSearch.RSP_ClassID;
List<ClassMaster_csm_Info> csmList = _icmBL.AllRecords();
CardUserMaster_cus_Info cusInfo = new CardUserMaster_cus_Info();
if (this.rspSearch.RSP_ClassID != Guid.Empty)
{
cusInfo.cus_cClassID = this.rspSearch.RSP_ClassID;
}
else if (this.rspSearch.RSP_DepartmentID != Guid.Empty)
{
cusInfo.cus_cClassID = this.rspSearch.RSP_DepartmentID;
}
cusInfo.cus_cStudentID = this.rspSearch.RSP_StudentID;
cusInfo.cus_cChaName = this.rspSearch.RSP_ChaName;
List<CardUserAccount_cua_Info> cuaList = _imbBL.SearchRecords(cusInfo);
if (cuaList != null && cuaList.Count > 0)
{
cuaList = cuaList.OrderBy(p => p.cua_cClassName).OrderBy(p => p.cus_cStudentID).OrderBy(p => p.cua_dAddDate).ToList();
ShowReport(cuaList);
}
else
{
ShowWarningMessage("找不到符合条件的记录。");
}
}
}
catch
{
}
this.Cursor = Cursors.Default;
}
private void sysToolBar_OnItemSave_Click(object sender, EventArgs e)
{
if (this._EditOpt == DefineConstantValue.EditStateEnum.OE_Update)
{
if (!ShowQuestionMessage("是否确认保存修改？"))
{
return;
}
}
if (cbxGradeName.SelectedValue == null || string.IsNullOrEmpty(cbxGradeName.Text))
{
ShowWarningMessage("请先选择【年级】。");
cbxGradeName.Focus();
return;
}
if (cbxClassName.SelectedValue == null || string.IsNullOrEmpty(cbxClassName.Text))
{
ShowWarningMessage("请先选择【班级名称】。");
cbxClassName.Focus();
return;
}
if (cbxHeadTeacher.SelectedValue == null || string.IsNullOrEmpty(cbxHeadTeacher.Text))
{
ShowWarningMessage("请先选择【班主任】。");
cbxHeadTeacher.Focus();
return;
}
ClassMaster_csm_Info searchInfo = new ClassMaster_csm_Info();
searchInfo.csm_cClassNum = cbxClassName.SelectedValue.ToString();
searchInfo.csm_cGDMID = new Guid(cbxGradeName.SelectedValue.ToString());
IClassMasterBL classBL = MasterBLLFactory.GetBLL<IClassMasterBL>(MasterBLLFactory.ClassMaster);
List<ClassMaster_csm_Info> listClassInfos = classBL.SearchRecords(searchInfo);
if (listClassInfos != null && listClassInfos.Count > 0)
{
if (this._CurrentClassInfo != null && listClassInfos[0].csm_cClassNum == this._CurrentClassInfo.csm_cClassNum && listClassInfos[0].csm_cGDMID == this._CurrentClassInfo.csm_cGDMID)
{
}
else
{
ShowWarningMessage("已存在相同定义的班级，请重新选择后再试。");
return;
}
}
searchInfo.csm_cRecordID = new Guid(labClassID.Text);
searchInfo.csm_cLast = this.UserInformation.usm_cUserLoginID;
searchInfo.csm_cMasterID = new Guid(cbxHeadTeacher.SelectedValue.ToString());
searchInfo.csm_cRemark = tbxRemarks.Text;
ReturnValueInfo rvInfo = new ReturnValueInfo();
//保存新纪录或修改记录
if (this._EditOpt == DefineConstantValue.EditStateEnum.OE_Insert)
{
searchInfo.csm_cRecordID = Guid.NewGuid();
searchInfo.csm_cAdd = this.UserInformation.usm_cUserLoginID;
rvInfo = classBL.Save(searchInfo, DefineConstantValue.EditStateEnum.OE_Insert);
}
else if (this._EditOpt == DefineConstantValue.EditStateEnum.OE_Update)
{
rvInfo = classBL.Save(searchInfo, DefineConstantValue.EditStateEnum.OE_Update);
}
if (!rvInfo.isError && rvInfo.boolValue)
{
ShowInformationMessage("保存成功。");
this.Close();
}
else
{
ShowErrorMessage("保存失败。" + rvInfo.messageText);
}
}
public List<MealBooking_mbk_info> SearchRecords(IModelObject searchCondition)
{
List<MealBooking_mbk_info> returnList = new List<MealBooking_mbk_info>();
try
{
if (searchCondition != null)
{
IPaymentUDMealStateBL ipumsBL = MasterBLLFactory.GetBLL<IPaymentUDMealStateBL>(MasterBLLFactory.PaymentUDMealState);
//IClassMasterDA icmDA = MasterDAFactory.GetDAL<IClassMasterDA>(MasterDAFactory.ClassMaster);
ICardUserMasterBL icumBL = MasterBLLFactory.GetBLL<ICardUserMasterBL>(MasterBLLFactory.CardUserMaster);
IConsumeRecordDA icrDA = MasterDAFactory.GetDAL<IConsumeRecordDA>(MasterDAFactory.ConsumeRecord);
MealBooking_mbk_info searchObj = searchCondition as MealBooking_mbk_info;
DateTime startTime = DateTime.Parse(searchObj.StartTime.ToString("yyyy/MM/dd"));
DateTime endTime = DateTime.Parse(searchObj.EndTime.ToString("yyyy/MM/dd"));
DateTime nowTime = DateTime.Parse(System.DateTime.Now.ToString("yyyy/MM/dd"));
//查詢班級
List<ClassMaster_csm_Info> csmList = new List<ClassMaster_csm_Info>();
//查詢人員
List<CardUserMaster_cus_Info> cusList = new List<CardUserMaster_cus_Info>();
MealBooking_mbk_info mbk = new MealBooking_mbk_info();
if (searchObj.ClassID == Guid.Empty && searchObj.GradeID == Guid.Empty)
{
//csmList = icmDA.AllRecords();
// return null;
}
else if (searchObj.GradeID != Guid.Empty)
{
ClassMaster_csm_Info csmInfo = new ClassMaster_csm_Info();
csmInfo.csm_cGDMID = searchObj.GradeID;
//csmList = icmDA.SearchRecords(csmInfo);
cusList = icumBL.GetGradeStudents(searchObj.GradeID);
mbk.GradeID = searchObj.GradeID;
}
else if (searchObj.ClassID != Guid.Empty)
{
ClassMaster_csm_Info csmInfo = new ClassMaster_csm_Info();
csmInfo.csm_cRecordID = searchObj.ClassID;
//csmInfo = icmDA.DisplayRecord(csmInfo);
csmList.Add(csmInfo);
//ClassMaster_csm_Info csmInfo = new ClassMaster_csm_Info();
//csmInfo.csm_cRecordID = searchObj.ClassID;
cusList = icumBL.GetClassStudents(csmInfo);
mbk.ClassID = searchObj.ClassID;
}
if (cusList != null)
{
if(startTime < nowTime)
{
DateTime et;
if (endTime < nowTime)
{
et = endTime;
}
else
{
et = nowTime.AddDays(-1);
}
for (DateTime dt = startTime; dt <= et; dt = dt.AddDays(1))
{
mbk.StartTime = dt;
mbk.EndTime = dt.AddDays(1);
returnList.AddRange(_imbDA.GetClassBookingHistory(mbk));
}
}
//for (DateTime dt = startTime; dt <= endTime; dt = dt.AddDays(1))//查詢預計定餐情況
//{
// if(dt < nowTime)
// {
// }
//}
if (startTime <= nowTime || endTime >= nowTime)
{
DateTime et;
if (startTime <= nowTime && endTime >= nowTime)
{
et = nowTime;
}
else if (startTime > nowTime)
{
et = startTime;
}
else
{
et = endTime.AddDays(1);
}
for (DateTime dt = et; dt <= endTime; dt = dt.AddDays(1))
{
mbk.StartTime = dt;
mbk.EndTime = dt.AddDays(1);
returnList.AddRange(_imbDA.GetPlanBooking(mbk));
}
}
}
#region
//if (csmList != null)
//{
// for (int classNo = 0; classNo < csmList.Count; classNo++)//查找所有班級
// {
// ClassMaster_csm_Info csmInfo = csmList[classNo];
// CardUserMaster_cus_Info cusInfo = new CardUserMaster_cus_Info();
// cusInfo.cus_cClassID = csmInfo.csm_cRecordID;
// List<CardUserMaster_cus_Info> cusList = icumBL.SearchRecords(cusInfo);//查班級內的人
// if (cusList != null)
// {
// for (DateTime dt = startTime; dt <= endTime; dt = dt.AddDays(1))//查詢預計定餐情況
// {
// MealBooking_mbk_info mbkInfo = new MealBooking_mbk_info();
// mbkInfo.className = csmInfo.csm_cClassName;
// mbkInfo.bookingDate = dt.ToString("yyyy/MM/dd");
// mbkInfo.userAmount = cusList.Count;
// for (int userNo = 0; userNo < cusList.Count; userNo++)
// {
// cusInfo = cusList[userNo] as CardUserMaster_cus_Info;
// if (cusInfo.ClassInfo != null)
// {
// mbkInfo.gradeName = cusInfo.ClassInfo.GradeInfo.gdm_cGradeName;
// }
// PaymentUDMealState_pms_Info pmsInfo = new PaymentUDMealState_pms_Info();
// pmsInfo.pms_cCardUserID = cusInfo.cus_cRecordID;
// pmsInfo.pms_cClassID = cusInfo.cus_cClassID;
// pmsInfo.pms_cGradeID = csmInfo.csm_cGDMID;
// pmsInfo.TimeFrom = dt;
// pmsInfo.TimeTo = dt;
// List<PaymentUDMealState_pms_Info> pmsList = ipumsBL.SearchMealRecords(pmsInfo);//查預計定餐
// if (pmsList != null && pmsList.Count > 0)
// {
// PaymentUDMealState_pms_Info pInfo = pmsList.FirstOrDefault();
// if (pInfo.pms_cBreakfast != null && (bool)(pInfo.pms_cBreakfast))
// {
// mbkInfo.breakfast_Est++;
// }
// if (pInfo.pms_cLunch != null && (bool)(pInfo.pms_cLunch))
// {
// mbkInfo.lunch_Est++;
// }
// if (pInfo.pms_cDinner != null && (bool)(pInfo.pms_cDinner))
// {
// mbkInfo.dinner_Est++;
// }
// }
// }
// List<ConsumeRecord_csr_Info> csrList = icrDA.GetClassConsumeRecord(cusInfo.cus_cClassID, dt);
// if (csrList != null)
// {
// for (int recNo = 0; recNo < csrList.Count; recNo++)
// {
// ConsumeRecord_csr_Info csrInfo = csrList[recNo];
// if (csrInfo.csr_cMealType == DefineConstantValue.MealType.Breakfast.ToString())
// {
// mbkInfo.breakfast_Act++;
// }
// else if (csrInfo.csr_cMealType == DefineConstantValue.MealType.Lunch.ToString())
// {
// mbkInfo.lunch_Act++;
// }
// else if (csrInfo.csr_cMealType == DefineConstantValue.MealType.Supper.ToString())
// {
// mbkInfo.dinner_Act++;
// }
// }
// }
// returnList.Add(mbkInfo);
// }
// }
// }
//}
#endregion
}
}
catch
{
}
return returnList;
}
private void sysToolBar_OnItemDelete_Click(object sender, EventArgs e)
{
if (lvClassList.SelectedItems != null && lvClassList.SelectedItems.Count > 0)
{
if (!ShowQuestionMessage("是否确认需要删除选中项？"))
{
return;
}
try
{
ClassMaster_csm_Info delInfo = new ClassMaster_csm_Info();
delInfo.csm_cRecordID = new Guid(lvClassList.SelectedItems[0].SubItems[0].Text);
List<CardUserMaster_cus_Info> listSubCardUser = this._ICardUserMasterBL.SearchRecords(new CardUserMaster_cus_Info() { cus_cClassID = delInfo.csm_cRecordID });
if (listSubCardUser != null && listSubCardUser.Count > 0)
{
ShowWarningMessage("此班级仍与部分学生关联，请更新或删除相关学生信息后再试。");
return;
}
ReturnValueInfo returnInfo = this._IClassMasterBL.Save(delInfo, Common.DefineConstantValue.EditStateEnum.OE_Delete);
if (returnInfo.boolValue)
{
ShowInformationMessage("删除成功！");
loadAllClassList();
}
else
{
ShowErrorMessage(returnInfo.messageText);
}
}
catch (Exception Ex)
{
ShowErrorMessage(Ex.Message);
}
}
}
/// <summary>
/// 弹出子界面（新增、修改）
/// </summary>
/// <param name="editStatc"></param>
private void ShowDetailForm(DefineConstantValue.EditStateEnum editStatc)
{
ReturnValueInfo returnInfo = null;
ClassMaster_csm_Info classInfo = new ClassMaster_csm_Info();
frmClassMasterDetailNew frmNew = new frmClassMasterDetailNew();
frmNew.UserInformation = this.UserInformation;
try
{
switch (editStatc)
{
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
{
classInfo.csm_cRecordID = Guid.NewGuid();
frmNew.ShowForm(classInfo, editStatc);
break;
}
case Common.DefineConstantValue.EditStateEnum.OE_Update:
{
if (lvClassList.SelectedItems != null && lvClassList.SelectedItems.Count > 0)
{
classInfo.csm_cRecordID = new Guid(lvClassList.SelectedItems[0].Text);
classInfo = this._IClassMasterBL.DisplayRecord(classInfo) as ClassMaster_csm_Info;
frmNew.ShowForm(classInfo, editStatc);
}
else
{
ShowWarningMessage("请先选择一条记录。");
}
break;
}
default:
break;
}
}
catch (Exception Ex)
{
ShowErrorMessage(Ex.Message);
}
loadAllClassList();
}
/// <summary>
/// 获得班级名称
/// </summary>
/// <param name="info"></param>
private void GetClassName(ClassMaster_csm_Info info)
{
if (info != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
GradeMaster_gdm tagGrade = db.GradeMaster_gdm.FirstOrDefault(t => t.gdm_cRecordID == info.csm_cGDMID);
if (tagGrade != null)
{
info.csm_cClassName = tagGrade.gdm_cGradeName;
CodeMaster_cmt tagClass = db.CodeMaster_cmt.FirstOrDefault(t => t.cmt_cKey1 == Common.DefineConstantValue.CodeMasterDefine.KEY1_SIOT_CardUserClass && t.cmt_cKey2 == info.csm_cClassNum);
if (tagClass != null)
{
string strClassNum = tagClass.cmt_cValue;
/*B000001:Modify by Don 20150312*/
if (string.IsNullOrEmpty(strClassNum))
{
strClassNum = string.Empty;
}
if (strClassNum.Length > 1)
{
strClassNum = "(" + strClassNum.Substring(0, strClassNum.Length - 1) + ")" + strClassNum.Substring(strClassNum.Length - 1, 1);
}
/*B000001:EndModify Don 20150312*/
else
{
strClassNum = "(" + strClassNum + ")";
}
info.csm_cClassName += strClassNum;
}
}
}
}
catch (Exception Ex)
{
throw Ex;
}
}
}
public ReturnValueInfo UpdateRecord(ClassMaster_csm_Info infoObject)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
if (infoObject != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
GetClassName(infoObject);
ClassMaster_csm updateData = db.ClassMaster_csm.FirstOrDefault(t => t.csm_cRecordID == infoObject.csm_cRecordID);
if (updateData != null)
{
updateData.csm_cClassName = infoObject.csm_cClassName;
updateData.csm_cClassNum = infoObject.csm_cClassNum;
updateData.csm_cGDMID = infoObject.csm_cGDMID;
updateData.csm_cMasterID = infoObject.csm_cMasterID;
updateData.csm_cRemark = infoObject.csm_cRemark;
updateData.csm_cLast = infoObject.csm_cLast;
updateData.csm_dLastDate = infoObject.csm_dLastDate;
db.SubmitChanges();
returnInfo.boolValue = true;
returnInfo.ValueObject = infoObject;
}
else
{
returnInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_UpdateDataNull;
}
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
else
{
returnInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
}
return returnInfo;
}
public ReturnValueInfo InsertRecord(ClassMaster_csm_Info infoObject)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
if (infoObject != null)
{
try
{
using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext())
{
GetClassName(infoObject);
ClassMaster_csm insertData = Common.General.CopyObjectValue<ClassMaster_csm_Info, ClassMaster_csm>(infoObject);
db.ClassMaster_csm.InsertOnSubmit(insertData);
db.SubmitChanges();
returnInfo.boolValue = true;
returnInfo.ValueObject = infoObject;
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
else
{
returnInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
}
return returnInfo;
}
public List<CardUserMaster_cus_Info> GetClassStudents(ClassMaster_csm_Info classInfo)
{
try
{
return this._cardUserMasterDA.GetClassStudents(classInfo);
}
catch (Exception Ex)
{
throw Ex;
}
}
