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