/// <summary> /// 显示查询结果 /// </summary> private void ShowRecord() { _showList = new List<ViewInfo>(); try { this.lblRecordAmount.Text = "0"; this.lvList.Items.Clear(); DateTime startTime = DateTime.Parse(dtpDateFrom.Value.ToString("yyyy/MM/dd")); DateTime endTime = DateTime.Parse(dtpDateTo.Value.ToString("yyyy/MM/dd")); if (startTime > endTime) { base.MessageDialog("提示", "开始时间要小于结束时间!"); return; } System.TimeSpan ts = endTime.Subtract(startTime);//TimeSpan得到dt1和dt2的时间间隔 int countDays = ts.Days;//相隔天数 if (countDays > 60) { base.MessageDialog("提示", "最多只能查询前后60天的记录!"); startTime = startTime.AddDays(60); this.dtpDateTo.Value = startTime; return; } CardUserAccount_cua_Info cuaInfo = new CardUserAccount_cua_Info(); cuaInfo.cua_cCUSID = _userID; cuaInfo = _icuaBL.SearchRecords(cuaInfo).FirstOrDefault() as CardUserAccount_cua_Info; CardUserAccountDetail_cuad_Info cuadInfo = new CardUserAccountDetail_cuad_Info(); cuadInfo.cuad_cCUAID = cuaInfo.cua_cRecordID; cuadInfo.OptTime_From = startTime; cuadInfo.OptTime_To = endTime.AddDays(1); List<CardUserAccountDetail_cuad_Info> infoList = _icuadBL.SearchRecords(cuadInfo); if (infoList != null) { infoList = infoList.OrderByDescending(x => x.cuad_dOptTime).ToList(); int rowNo = 1; for (int index = 0; index < infoList.Count; index++) { cuadInfo = infoList[index] as CardUserAccountDetail_cuad_Info; ViewInfo vi = new ViewInfo(); vi.index = rowNo; vi.times = cuadInfo.cuad_dOptTime.ToString("yyyy/MM/dd"); vi.cost = cuadInfo.cuad_fFlowMoney.ToString(); vi.type = cuadInfo.cuad_cFlowType; try { //PreConsumeRecord_pcs_Info pcsinfo = new PreConsumeRecord_pcs_Info(); //pcsinfo.pcs_cRecordID = (Guid)cuadInfo.cuad_cConsumeID; //pcsinfo = _ipcrBL.DisplayRecord(pcsinfo); //if (pcsinfo != null) //{ // vi.mealTime = pcsinfo.pcs_dConsumeDate.ToString("yyyy/MM/dd HH:mm:ss"); //} //else //{ // vi.mealTime = cuadInfo.cuad_dOptTime.ToString("yyyy/MM/dd HH:mm:ss"); //} ConsumeRecord_csr_Info csrInfo = new ConsumeRecord_csr_Info(); csrInfo.csr_cRecordID = (Guid)cuadInfo.cuad_cConsumeID; csrInfo = _IConsumeRecordBL.DisplayRecord(csrInfo); if (csrInfo != null) { vi.mealTime = csrInfo.csr_dConsumeDate.ToString("yyyy/MM/dd HH:mm:ss"); } else { PreConsumeRecord_pcs_Info pcsinfo = new PreConsumeRecord_pcs_Info(); pcsinfo.pcs_cRecordID = (Guid)cuadInfo.cuad_cConsumeID; pcsinfo = _ipcrBL.DisplayRecord(pcsinfo); if (pcsinfo != null) { vi.mealTime = pcsinfo.pcs_dConsumeDate.ToString("yyyy/MM/dd HH:mm:ss"); } else { vi.mealTime = cuadInfo.cuad_dOptTime.ToString("yyyy/MM/dd HH:mm:ss"); } } } catch { } if (cuadInfo.MacNo != null) { vi.CostType = cuadInfo.MacNo.ToString() + "号机"; } else { vi.CostType = "系统补扣"; } SetShowViewInfo(vi, _showList); //_showList.Add(vi); rowNo = _showList.Count + 1; } } if (_showList.Count == 0) { if (startTime == endTime && startTime == DateTime.Parse(System.DateTime.Now.ToString("yyyy/MM/dd"))) { base.MessageDialog("提示", "今天内无消费记录!"); } else { base.MessageDialog("提示", "查找时间内无消费记录!"); } } this.lblRecordAmount.Text = _showList.Count.ToString(); } catch { } finally { //計算最大頁數 if (_showList != null) { _MaxPage = _showList.Count / _PageSize; if (_showList.Count % _PageSize != 0) { _MaxPage++; } if (_MaxPage == 0) { _PageIndex = 0; } else { if (_PageIndex == 0) { _PageIndex = 1; } } ShowList();//顯示內容 } SetUpDownBtnStatus(); } }
public ReturnValueInfo UpdateRecord(PreConsumeRecord_pcs_Info infoObject) { ReturnValueInfo rvInfo = new ReturnValueInfo(); try { if (infoObject != null) { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { PreConsumeRecord_pcs record = db.PreConsumeRecord_pcs.Where(x => x.pcs_cRecordID == infoObject.pcs_cRecordID).FirstOrDefault(); if (record != null) { record.pcs_cConsumeType = infoObject.pcs_cConsumeType; record.pcs_cAdd = infoObject.pcs_cAdd; record.pcs_cAccountID = infoObject.pcs_cAccountID; record.pcs_dAddDate = infoObject.pcs_dAddDate; record.pcs_dConsumeDate = infoObject.pcs_dConsumeDate; record.pcs_fCost = infoObject.pcs_fCost; db.SubmitChanges(); rvInfo.boolValue = true; } else { rvInfo.messageText = "GetEntity is null"; } } } else { rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull; } } catch (Exception ex) { rvInfo.isError = true; rvInfo.messageText = ex.Message; } return rvInfo; }
public ReturnValueInfo InsertRecord(PreConsumeRecord_pcs_Info infoObject) { ReturnValueInfo rvInfo = new ReturnValueInfo(); try { if (infoObject != null) { using (SIOTSDB_HHZXDataContext db = new SIOTSDB_HHZXDataContext()) { PreConsumeRecord_pcs record = Common.General.CopyObjectValue<PreConsumeRecord_pcs_Info, PreConsumeRecord_pcs>(infoObject); if (record != null) { db.PreConsumeRecord_pcs.InsertOnSubmit(record); db.SubmitChanges(); rvInfo.boolValue = true; rvInfo.ValueObject = infoObject; } else { rvInfo.messageText = "TransEntity is null"; } } } else { rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull; } } catch (Exception ex) { rvInfo.isError = true; rvInfo.messageText = ex.Message; } return rvInfo; }
/// <summary> /// 将数据库中原始值加工为实际金额 /// </summary> /// <param name="target">原始数据</param> /// <param name="listFormula">公式列表</param> /// <returns></returns> void CostValueProfile(PreConsumeRecord_pcs_Info target, List<CodeMaster_cmt_Info> listFormula) { CodeMaster_cmt_Info formula = listFormula.Find(x => x.cmt_cKey2 == target.pcs_cConsumeType); if (formula != null) { target.pcs_fCost *= formula.cmt_fNumber; } else { target.pcs_fCost *= -1; } }
public PreCostDetailInfo(PreConsumeRecord_pcs_Info PreCostInfo) { RecordID = PreCostInfo.pcs_cRecordID; Cost = Math.Round(PreCostInfo.pcs_fCost, 2); if (PreCostInfo.pcs_cConsumeType == Common.DefineConstantValue.ConsumeMoneyFlowType.Recharge_AdvanceMoney.ToString()) { ConsumeType = "透支款补扣"; } else { ConsumeType = Common.DefineConstantValue.GetMoneyFlowDesc(PreCostInfo.pcs_cConsumeType); } ConsumeDate = PreCostInfo.pcs_dConsumeDate; }
/// <summary> /// 搜索用户 /// </summary> void searchUsers() { try { CardUserMaster_cus_Info queryInfo = new CardUserMaster_cus_Info(); List<CardUserMaster_cus_Info> listUserInfos = new List<CardUserMaster_cus_Info>(); List<UnconfirmMealCostInfo> listPreCost = new List<UnconfirmMealCostInfo>(); this.Cursor = Cursors.WaitCursor; bool resSearchInfo = true; if (!string.IsNullOrEmpty(nudCardNo.Text)) { #region 定向查询,卡号查人 List<UserCardPair_ucp_Info> listPairInfo = this._IUserCardPairBL.SearchRecords(new UserCardPair_ucp_Info() { ucp_iCardNo = int.Parse(nudCardNo.Text) }); if (listPairInfo == null || (listPairInfo != null && listPairInfo.Count < 1)) { base.ShowInformationMessage(Common.DefineConstantValue.SystemMessageText.strMessageText_W_RecordIsEmpty); this.Cursor = Cursors.Default; return; } else { UserCardPair_ucp_Info pairInfo = listPairInfo.Where(x => x.ucp_dReturnTime == null).FirstOrDefault(); if (pairInfo != null) { queryInfo.cus_cRecordID = pairInfo.ucp_cCUSID; CardUserMaster_cus_Info userInfo = this._ICardUserMasterBL.DisplayRecord(queryInfo); if (userInfo != null) { listUserInfos.Add(userInfo); } else { base.ShowInformationMessage(Common.DefineConstantValue.SystemMessageText.strMessageText_W_RecordIsEmpty); this.Cursor = Cursors.Default; return; } } else { base.ShowInformationMessage(Common.DefineConstantValue.SystemMessageText.strMessageText_W_RecordIsEmpty); this.Cursor = Cursors.Default; return; } } #endregion } else { #region 条件查询 if (cbbClass.SelectedValue != null && !string.IsNullOrEmpty(cbbClass.Text)) { queryInfo.cus_cClassID = new Guid(cbbClass.SelectedValue.ToString()); queryInfo.cus_cIdentityNum = Common.DefineConstantValue.CodeMasterDefine.KEY2_SIOT_CardUserIdentity_Student; resSearchInfo = resSearchInfo && false; } if (cbbDepartment.SelectedValue != null && !string.IsNullOrEmpty(cbbDepartment.Text)) { queryInfo.cus_cClassID = new Guid(cbbDepartment.SelectedValue.ToString()); queryInfo.cus_cIdentityNum = Common.DefineConstantValue.CodeMasterDefine.KEY2_SIOT_CardUserIdentity_Staff; resSearchInfo = resSearchInfo && false; } if (!string.IsNullOrEmpty(tbxUserNum.Text)) { queryInfo.cus_cStudentID = tbxUserNum.Text.Trim(); resSearchInfo = resSearchInfo && false; } if (!string.IsNullOrEmpty(tbxUserName.Text)) { queryInfo.cus_cChaName = tbxUserName.Text.Trim(); resSearchInfo = resSearchInfo && false; } if (cbbSex.SelectedValue != null && !string.IsNullOrEmpty(cbbSex.Text)) { queryInfo.cus_cSexNum = cbbSex.SelectedValue.ToString(); resSearchInfo = resSearchInfo && false; } if (resSearchInfo) { if (!base.ShowQuestionMessage("未有选择任何筛选条件,可能导致搜索记录时间较长,是否要继续?")) { this.Cursor = Cursors.Default; return; } } listUserInfos = this._ICardUserMasterBL.SearchRecords(queryInfo); listUserInfos = listUserInfos.Where(x => x.PairInfo != null).ToList(); #endregion } try { if (listUserInfos == null || (listUserInfos != null && listUserInfos.Count < 1)) { base.ShowInformationMessage(Common.DefineConstantValue.SystemMessageText.strMessageText_I_strNotFindRecord); } else { PreConsumeRecord_pcs_Info preCostQuery = new PreConsumeRecord_pcs_Info(); //查找时,只需要显示【定餐未确定扣款】类型 preCostQuery.pcs_cConsumeType = Common.DefineConstantValue.ConsumeMoneyFlowType.IndeterminateCost.ToString(); List<PreConsumeRecord_pcs_Info> listPreCostQuery = this._IPreConsumeRecordBL.SearchRecords(preCostQuery); if (listPreCostQuery != null) { listPreCostQuery = listPreCostQuery.Where(x => x.pcs_lIsSettled == false).ToList(); } if (listPreCostQuery == null || (listPreCostQuery != null && listPreCostQuery.Count < 1)) { base.ShowInformationMessage(Common.DefineConstantValue.SystemMessageText.strMessageText_W_RecordIsEmpty); } else { foreach (CardUserMaster_cus_Info userQuery in listUserInfos) { List<PreConsumeRecord_pcs_Info> listInsertPreCost = listPreCostQuery.Where(x => x.pcs_cUserID == userQuery.cus_cRecordID).ToList(); if (listInsertPreCost != null && listInsertPreCost.Count > 0) { this._CurrentListPreCost.AddRange(listInsertPreCost); foreach (PreConsumeRecord_pcs_Info preCostItem in listInsertPreCost) { UnconfirmMealCostInfo unconfirmInfo = Common.General.CopyObjectValue<PreConsumeRecord_pcs_Info, UnconfirmMealCostInfo>(preCostItem); unconfirmInfo.CardNo = userQuery.PairInfo.ucp_iCardNo.ToString(); unconfirmInfo.GroupName = userQuery.ClassInfo == null ? userQuery.DeptInfo.dpm_cName : userQuery.ClassInfo.csm_cClassName; unconfirmInfo.UserName = userQuery.cus_cChaName; unconfirmInfo.UserNum = userQuery.cus_cStudentID; listPreCost.Add(unconfirmInfo); } if (listPreCost.Count > 0) { lvPreCostList.SetDataSource<UnconfirmMealCostInfo>(listPreCost); gbxLeftDown.Enabled = true; } } } } } } catch (Exception Ex) { ShowErrorMessage(Ex); } } catch (Exception exx) { ShowErrorMessage(exx); } this.Cursor = Cursors.Default; }