/// <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; } }