private void btnFind_Click(object sender, EventArgs e) { try { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); DataTable allMaster = _billQuery.LoadMaster(BuildConditionParams()); _dispMasterDt = allMaster.Clone(); DataRow[] filterRows; if (this.txtInvoiceNoQuery.Text.Trim() == "00000000") { filterRows = allMaster.Select("INVOICENUM<>0 and DrugOC_Flag=0"); } else { filterRows = allMaster.Select("INVOICENUM=" + Convert.ToInt32(txtInvoiceNoQuery.Text) + " and DrugOC_Flag=1"); } foreach (DataRow dr in filterRows) { _dispMasterDt.Rows.Add(dr.ItemArray); } dgrdDRMaster.AutoGenerateColumns = false; dgrdDRMaster.DataSource = _dispMasterDt; } catch (Exception error) { MessageBox.Show(error.Message); } }
/// <summary> /// 加载已发药消息列表 /// </summary> private void LoadDispHisMaster() { try { if (_recipeOrder != null) { _recipeOrder.Rows.Clear(); _recipeOrder = null; } BillQuery _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); DataTable allMaster = _billQuery.LoadMaster(BuildConditionParams()); _dispMasterDt = allMaster.Clone(); foreach (DataRow dr in allMaster.Rows) { _dispMasterDt.Rows.Add(dr.ItemArray); } if (_dispOrderDt != null) { _dispOrderDt.Rows.Clear(); } treeDrugMsg.Nodes.Clear(); TreeNode allDeptNode = new TreeNode("全院科室"); allDeptNode.Tag = 0; allDeptNode.ImageIndex = 0; treeDrugMsg.Nodes.Add(allDeptNode); for (int index = 0; index < _deptDt.Rows.Count; index++) { TreeNode deptNode = new TreeNode(_deptDt.Rows[index]["NAME"].ToString()); deptNode.ImageIndex = 0; deptNode.Tag = Convert.ToInt32(_deptDt.Rows[index]["DEPT_ID"]); if (Convert.ToInt32(deptNode.Tag) > 0) { allDeptNode.Nodes.Add(deptNode); DataRow[] rows = _dispMasterDt.Select("currdeptcode='" + deptNode.Tag.ToString().Trim() + "'"); if (rows != null && rows.Length > 0) { for (int temp = 0; temp < rows.Length; temp++) { TreeNode msgNode = new TreeNode(); string nodetext = rows[temp]["patientname"].ToString() + "-- 发药时间 --" + Convert.ToDateTime(rows[temp]["optime"]).ToString("yyyy-MM-dd HH:mm:ss"); msgNode.Text = nodetext; if (rows[temp]["optype"].ToString() == "004") { msgNode.ForeColor = Color.Red; } msgNode.Tag = rows[temp]; deptNode.Nodes.Add(msgNode); } } } deptNode.Expand(); } allDeptNode.Expand(); } catch (Exception error) { throw error; } }
private void FrmYFInMaster_Load(object sender, EventArgs e) { try { chkRegTime.Checked = true; cobPayState.SelectedIndex = 0; if (_belongSystem == ConfigManager.YF_SYSTEM) { _billQurey = BillFactory.GetQuery(ConfigManager.OP_YF_INSTORE); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_INSTORE); tsrbtnPay.Visible = false; tsrbtnPrintTotal.Visible = false; dgrdInMaker.Columns["ColBtnBackStore"].Visible = false; } else { _billQurey = BillFactory.GetQuery(ConfigManager.OP_YK_INOPTYPE); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_INOPTYPE); } LoadData(); } catch (Exception error) { MessageBox.Show(error.Message); } }
private void LoadData() { try { if (tabDispQuery.SelectedTab == tabPgSingle) { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); DataTable allMaster = _billQuery.LoadMaster(BuildConditionParams()); _dispMasterDt = allMaster.Clone(); if (cobOPType.Text == "门诊") { DataRow[] filterRows; if (txtQueryCode.Text == "") { filterRows = allMaster.Select("INVOICENUM<>0"); } else { filterRows = allMaster.Select("INVOICENUM=" + txtQueryCode.Text); } foreach (DataRow dr in filterRows) { _dispMasterDt.Rows.Add(dr.ItemArray); } } else { DataRow[] filterRows; if (txtQueryCode.Text == "") { filterRows = allMaster.Select("INVOICENUM=0"); } else { filterRows = allMaster.Select("INPATIENTID='" + txtQueryCode.Text + "' AND INVOICENUM=0"); } foreach (DataRow dr in filterRows) { _dispMasterDt.Rows.Add(dr.ItemArray); } } dgrdDRMaster.DataSource = _dispMasterDt; if (_dispOrderDt != null) { _dispOrderDt.Rows.Clear(); } } else { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE + "ZY_TL"); _deptDispDt = _billQuery.LoadMaster(BuildConditionParams()); dgrdDispDept.AutoGenerateColumns = false; dgrdDispDept.DataSource = _deptDispDt; } } catch (Exception error) { throw error; } }
public MZFrmDrugRefund(long currentUserId, long currentDeptId, string chineseName) { _currentUserId = currentUserId; _currentDeptId = currentDeptId; _chineseName = chineseName; _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_REFUND + "MZ"); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); InitializeComponent(); this.Text = _chineseName; }
private void tabDispQuery_SelectedIndexChanged(object sender, EventArgs e) { if (tabDispQuery.SelectedTab == tabPgSingle) { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); } else { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE + "ZY_TL"); } }
private void FrmDispenseQuery_Load(object sender, EventArgs e) { try { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); cobOPType.SelectedIndex = 0; LoadData(); } catch (Exception error) { MessageBox.Show(error.Message); } }
public FrmYFApplyorder(long currentUserId, long currentDeptId, int beginState, bool isBuildByLimit) { _currentUserId = currentUserId; _currentDeptId = currentDeptId; _currentState = beginState; _isBuildByLimit = isBuildByLimit; _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_APPLYIN); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_APPLYIN); _storeQuery = StoreFactory.GetQuery(ConfigManager.YK_SYSTEM); InitializeComponent(); //设置起始焦点 }
private void treeDrugMsg_AfterSelect(object sender, TreeViewEventArgs e) { if (tabMsgMaster.SelectedIndex == 0 && e.Node != null) { if (e.Node.Level == 2) { ShowCurrentPat(((ZY_PatList)e.Node.Tag).CureNo); } } else if (tabMsgMaster.SelectedIndex == 1 && e.Node != null) { try { if (e.Node.Level == 2) { BillQuery _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE); dgrdDROrder.AutoGenerateColumns = false; dgrdDROrder.ClearLines(); DataTable dt = _dispMasterDt.Clone(); dt.Clear(); dt.Rows.Add(((DataRow)e.Node.Tag).ItemArray); HIS.SYSTEM.PubicBaseClasses.ApiFunction.DataTableToObject(dt, 0, _currentMaster); DataTable dtDrugs = _billQuery.LoadOrder(_currentMaster); for (int i = 0; i < dtDrugs.Rows.Count; i++) { decimal presamount = (dtDrugs.Rows[i]["recipenum"] == null || dtDrugs.Rows[i]["recipenum"].ToString() == "0" ? 1 : Convert.ToDecimal(dtDrugs.Rows[i]["recipenum"].ToString())); dtDrugs.Rows[i]["drugocnum"] = Convert.ToDecimal(dtDrugs.Rows[i]["drugocnum"].ToString()) / presamount; } if (_currentMaster.OpType == "004") { for (int i = 0; i < dtDrugs.Rows.Count; i++) { dtDrugs.Rows[i]["drugocnum"] = -1 * Convert.ToDecimal(dtDrugs.Rows[i]["drugocnum"]); dtDrugs.Rows[i]["recipenum"] = -1 * Convert.ToDecimal(dtDrugs.Rows[i]["recipenum"]); } } dgrdDROrder.DataSource = dtDrugs; } } catch (Exception error) { MessageBox.Show(error.Message); } finally { this.Cursor = DefaultCursor; } } }
/// <summary> /// 加载已发药消息列表 /// </summary> private void LoadDispHisMaster() { try { if (_recipeOrder != null) { _recipeOrder.Rows.Clear(); _recipeOrder = null; } BillQuery _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE + "ZY_TL"); DataTable deptDispDt = _billQuery.LoadMaster(BuildConditionParams()); treeDrugMsg.Nodes.Clear(); TreeNode allDeptNode = new TreeNode("全院科室"); allDeptNode.Tag = 0; allDeptNode.ImageIndex = 0; treeDrugMsg.Nodes.Add(allDeptNode); for (int index = 0; index < _deptDt.Rows.Count; index++) { TreeNode deptNode = new TreeNode(_deptDt.Rows[index]["NAME"].ToString()); deptNode.ImageIndex = 0; deptNode.Tag = Convert.ToInt32(_deptDt.Rows[index]["DEPT_ID"]); if (Convert.ToInt32(deptNode.Tag) > 0) { allDeptNode.Nodes.Add(deptNode); if (deptDispDt != null) { for (int temp = 0; temp < deptDispDt.Rows.Count; temp++) { DataRow currentRow = deptDispDt.Rows[temp]; if (Convert.ToInt32(currentRow["DISPDEPT"]) == Convert.ToInt32(deptNode.Tag)) { TreeNode msgNode = new TreeNode(); string date = Convert.ToDateTime(currentRow["OPTIME"]).ToString("yyyy-MM-dd HH:mm"); msgNode.Text = date; msgNode.Tag = currentRow; deptNode.Nodes.Add(msgNode); } } } } deptNode.Expand(); } allDeptNode.Expand(); } catch (Exception error) { throw error; } }
public FrmStockControl(IFrmStockPlan frmstockplan) { try { _frmstockplan = frmstockplan; _drugInfo = DrugBaseDataBll.YD_LoadDrugInfo(0, 0); _frmstockplan.RefreshDurgInfo(_drugInfo); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_STOCKPLAN); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YK_STOCKPLAN); } catch (Exception error) { throw error; } }
public async Task <IActionResult> Get([FromBody] BillQuery query) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (query.UserId == Guid.Empty) { return(BadRequest()); } var bills = await billRepo.GetAsync(query); return(Ok(bills)); }
public FrmOutMaster(long currentUserId, long currentDeptId, string chineseName, string belongSystem) { _currentUserId = currentUserId; _currentDeptId = currentDeptId; _chineseName = chineseName; this.Text = _chineseName; _belongSystem = belongSystem; if (_belongSystem == ConfigManager.YK_SYSTEM) { _billQuery = BillFactory.GetQuery(ConfigManager.DEF_YK_OUT); } else { _billQuery = BillFactory.GetQuery(ConfigManager.DEF_YF_OUT); } InitializeComponent(); }
private void FrmOutOrder_Load(object sender, EventArgs e) { txtApplyPeople.Text = new User(_currentUserId).Name; if (_opType == ConfigManager.OP_YK_REPORTLOSS || _opType == ConfigManager.OP_YF_REPORTLOSS) { txtOpType.Text = "药品报损"; txtOutDept.Text = "无领药科室"; txtOutDept.ReadOnly = true; txtApplyPeople.ReadOnly = true; txtByOptype.ReadOnly = false; } else { this.txtOpType.Text = "科室领药"; txtByOptype.ReadOnly = true; } if (_belongSystem == ConfigManager.YK_SYSTEM) { _billQuery = BillFactory.GetQuery(ConfigManager.DEF_YK_OUT); } else if (_belongSystem == ConfigManager.YF_SYSTEM) { _billQuery = BillFactory.GetQuery(ConfigManager.DEF_YF_OUT); txtBatchNum.ReadOnly = true; } _billProcessor = BillFactory.GetProcessor(_opType); //如果是添加单据状态 if (_currentState == ADD) { //生成一个新的单据表头 _currentMaster = (YP_OutMaster)(_billProcessor.BuildNewMaster(_currentDeptId, _currentUserId)); _currentMaster.OpType = _opType; _currentOrder = (YP_OutOrder)(_billProcessor.BuildNewoder(_currentDeptId, _currentMaster)); LoadData(); } else if (_currentState == UPDATE) { _currentOrder = (YP_OutOrder)(_billProcessor.BuildNewoder(_currentDeptId, _currentMaster)); LoadData(); dgrdOrderInfo_CurrentCellChanged(null, null); } //显示当前表头信息 ShowCurrentMaster(); }
public FrmYPAdjMaster(long currentUserId, long currentDeptId, string chineseName, string belongSystem) { _currentUserId = currentUserId; _currentDeptId = currentDeptId; _chineseName = chineseName; _belongSystem = belongSystem; if (_belongSystem == ConfigManager.YF_SYSTEM) { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_ADJPRICE); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_ADJPRICE); } else { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YK_ADJPRICE); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_ADJPRICE); } InitializeComponent(); }
public FrmCheckMaster(long currentUserId, long currentDeptId, string chineseName, string belongSystem) { _currentUserId = currentUserId; _currentDeptId = currentDeptId; _chineseName = chineseName; this.Text = _chineseName; _belongSystem = belongSystem; if (_belongSystem == ConfigManager.YF_SYSTEM) { _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_CHECK); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_CHECK); } else if (_belongSystem == ConfigManager.YK_SYSTEM) { _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_CHECK); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YK_CHECK); } InitializeComponent(); }
public async Task <IQueryable <Bill> > GetAsync(BillQuery query) { //var cardIds = _cardContext.CardShares.AsNoTracking().Where(t => t.UserId == query.UserId && t.CardShareStatus == CardShareStatus.Normal).Select(t => t.CardId); //cardIds = cardIds.Union(_cardContext.CardInfos.AsNoTracking().Where(t => t.UserId == query.UserId && t.CardStatus == CardStatus.Normal).Select(t => t.Id)); //var bills = await GetListAsync(t => cardIds.Contains(t.CardId)); var bills = await GetListAsync(t => _cardContext.CardInfos.AsNoTracking().Any(t1 => t1.UserId == query.UserId && t1.CardStatus == CardStatus.Normal && t1.UserId == t.Id) || _cardContext.CardShares.AsNoTracking().Any(t2 => t2.UserId == query.UserId && t2.CardShareStatus == CardShareStatus.Normal && t2.UserId == t.Id)); if (query.BillStatus > 0) { bills = bills.Where(t => t.BillStatus == query.BillStatus); } bills.OrderByDescending(t => t.CreateTime).ThenByDescending(t => t.BillingDate).ThenByDescending(t => t.RepayDate); return(bills); }
private void FrmCheckOrder_Load(object sender, EventArgs e) { try { dgrdCheckOrder.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", (float)9); if (_belongSystem == ConfigManager.YK_SYSTEM) { dgrdCheckOrder.Columns.Remove("AccountNum"); dgrdCheckOrder.Columns.Remove("UnitName"); dgrdCheckOrder.Columns.Remove("CheckNum"); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_CHECK); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YK_CHECK); txtFtPackNum.TextFormat = GWI.HIS.Windows.Controls.TextFormatStyle.Numberic; txtFtBaseNum.ReadOnly = true; } else if (_belongSystem == ConfigManager.YF_SYSTEM) { _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_CHECK); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_CHECK); dgrdCheckOrder.Columns.Remove("BatchNum"); cobValidityDate.Enabled = false; } if (_currentState == UPDATE) { this.tsrbtnLoadData.Visible = false; this.txtDgCode.ReadOnly = true; this.btnAddOrder.Enabled = false; this.btnDelOrder.Enabled = false; } _checkOrderDt = _billQuery.LoadOrder(_currentMaster); dgrdCheckOrder.DataSource = _checkOrderDt; _drugInfoDt = _storeQuery.GetCheckDrug((int)_currentDeptId); txtDgCode.SetSelectionCardDataSource(_drugInfoDt); txtQueryCode.SetSelectionCardDataSource(_drugInfoDt); ShowCurrentMaster(); } catch (Exception error) { MessageBox.Show(error.Message); } }
private void CreateProcessorBySystem() { if (_belongSystem == ConfigManager.YF_SYSTEM) { _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_INSTORE); _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_INSTORE); this.txtBatchNum.ReadOnly = true; this.chkIsFirstIn.Visible = false; this.txtBaseNum.ReadOnly = false; this.txtDeliverNum.Visible = false; this.lblDeliverNum.Visible = false; this.txtInNum.TextFormat = GWI.HIS.Windows.Controls.TextFormatStyle.Integer; this.btnQuerySupportHis.Visible = false; } else { if (_currentState == ADD) { _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_INOPTYPE); this.chkIsFirstIn.Visible = true; } else if (_currentState == BACK) { _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_BACKSTORE); this.chkIsFirstIn.Visible = false; } else if (_currentState == UPDATE) { if (_currentMaster != null) { _billProcessor = BillFactory.GetProcessor(_currentMaster.OpType); } this.chkIsFirstIn.Visible = (_currentMaster.OpType == ConfigManager.OP_YK_BACKSTORE ? false : true); } _billQuery = BillFactory.GetQuery(ConfigManager.OP_YK_INOPTYPE); this.txtBaseNum.ReadOnly = true; this.txtDeliverNum.Visible = true; this.btnQuerySupportHis.Visible = true; } }
private void FrmAdjOrder_Load(object sender, EventArgs e) { try { if (_belongSystem == ConfigManager.YF_SYSTEM) { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YF_ADJPRICE); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YF_ADJPRICE); } else { _billQuery = BillFactory.GetQuery(ConfigManager.OP_YK_ADJPRICE); _billProcessor = BillFactory.GetProcessor(ConfigManager.OP_YK_ADJPRICE); } if (_currentState == ADD) { this._currentOrder = (YP_AdjOrder)(_billProcessor.BuildNewoder(0, _adjMaster)); LoadData(); this.txtNewRetail.Text = "0.00"; this.txtNewTrade.Text = "0.00"; ShowMaster(); this.txtAdjCode.Focus(); this.txtAdjCode.SelectAll(); } else { LoadData(); _currentOrder = (YP_AdjOrder)(_billProcessor.BuildNewoder(0, _adjMaster)); dgrdAdjOrder_CurrentCellChanged(null, null); ShowInQuery(); ShowMaster(); } } catch (Exception error) { MessageBox.Show(error.Message); } }
/// <summary> /// 打印药库入库单汇总表 /// </summary> /// <param name="path">路径</param> /// <param name="inMasterDt">入库单头表</param> /// <param name="billTime">单据时间</param> /// <param name="deptId">部门ID</param> /// <param name="printer">打印人员ID</param> static public void PringInStoreTotal(string path, DataTable inMasterDt, string billTime, int deptId, int printer) { try { decimal xy_RetailFee = 0, zcy_RetailFee = 0, zy_RetailFee = 0, xy_TradeFee = 0, zcy_TradeFee = 0, zy_TradeFee = 0, wz_RetailFee = 0, wz_TradeFee = 0; decimal xy_RetailFee1 = 0, zcy_RetailFee1 = 0, zy_RetailFee1 = 0, xy_TradeFee1 = 0, zcy_TradeFee1 = 0, zy_TradeFee1 = 0, wz_RetailFee1 = 0, wz_TradeFee1 = 0; int supportId = 0; string supportName = ""; report = new grproLib.GridppReport(); report.LoadFromFile(path); report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName + "入库单汇总"; if (inMasterDt != null) { if (inMasterDt.Rows.Count >= 1) { report.ParameterByName("BillTime").AsString = Convert.ToDateTime(inMasterDt.Rows[0]["AUDITTIME"]).ToString() + "到" + Convert.ToDateTime(inMasterDt.Rows[inMasterDt.Rows.Count - 1]["AUDITTIME"]).ToString(); } else { report.ParameterByName("BillTime").AsString = billTime; } report.ParameterByName("BillCount").AsString = inMasterDt.Rows.Count.ToString(); for (int index = 0; index < inMasterDt.Rows.Count; index++) { DataRow currentRow = inMasterDt.Rows[index]; int masterId = Convert.ToInt32(currentRow["MASTERINSTORAGEID"]); if (supportId != Convert.ToInt32(currentRow["SUPPORTDICID"])) { supportId = Convert.ToInt32(currentRow["SUPPORTDICID"]); string currentSupporter = BindEntity <HIS.Model.YP_SupportDic> .CreateInstanceDAL(oleDb, BLL.Tables.YP_SUPPORTDIC).GetModel(supportId).Name; if (supportName.IndexOf(currentSupporter + ",") == -1) { supportName += currentSupporter + ","; } } //加载类型汇金额总表 DataTable typeFeeDt = BillQuery.LoadTotalFeeByInOrder(masterId); DataTable outFeeDt = BillQuery.LoadTotalFeeByOutOrder(masterId); //按类型累加各单据批发金额和零售金额(入库) for (int temp = 0; temp < typeFeeDt.Rows.Count; temp++) { DataRow typeFeeRow = typeFeeDt.Rows[temp]; if (typeFeeRow["TypeDicID"] != DBNull.Value) { int typeId = Convert.ToInt32(typeFeeRow["TypeDicID"]); switch (typeId) { case 1: xy_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]); xy_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; case 2: zcy_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]); zcy_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; case 3: zy_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]); zy_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; case 4: wz_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]); wz_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; default: break; } } } //按类型累加各单据批发金额和零售金额(退库) //update by heyan 增加退库汇总信息 for (int temp = 0; temp < outFeeDt.Rows.Count; temp++) { DataRow typeFeeRow = outFeeDt.Rows[temp]; if (typeFeeRow["TypeDicID"] != DBNull.Value) { int typeId = Convert.ToInt32(typeFeeRow["TypeDicID"]); switch (typeId) { case 1: xy_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]); xy_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; case 2: zcy_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]); zcy_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; case 3: zy_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]); zy_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; case 4: wz_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]); wz_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]); break; default: break; } } } } //报表参数赋值 report.ParameterByName("SupportName").AsString = supportName; report.ParameterByName("TradeFee").AsString = (xy_TradeFee + zcy_TradeFee + zy_TradeFee + wz_TradeFee).ToString("0.00"); report.ParameterByName("DiffFee").AsString = (xy_RetailFee + zcy_RetailFee + zy_RetailFee + wz_RetailFee - xy_TradeFee - zcy_TradeFee - zy_TradeFee - wz_TradeFee).ToString("0.00"); report.ParameterByName("RetailFee").AsString = (xy_RetailFee + zcy_RetailFee + zy_RetailFee + wz_RetailFee).ToString("0.00"); report.ParameterByName("RetailFee_XY").AsString = xy_RetailFee.ToString("0.00"); report.ParameterByName("RetailFee_ZCY").AsString = zcy_RetailFee.ToString("0.00"); report.ParameterByName("RetailFee_ZY").AsString = zy_RetailFee.ToString("0.00"); report.ParameterByName("RetailFee_WZ").AsString = wz_RetailFee.ToString("0.00"); report.ParameterByName("TradeFee_XY").AsString = xy_TradeFee.ToString("0.00"); report.ParameterByName("TradeFee_ZCY").AsString = zcy_TradeFee.ToString("0.00"); report.ParameterByName("TradeFee_ZY").AsString = zy_TradeFee.ToString("0.00"); report.ParameterByName("TradeFee_WZ").AsString = wz_TradeFee.ToString("0.00"); report.ParameterByName("DiffFee_XY").AsString = (xy_RetailFee - xy_TradeFee).ToString("0.00"); report.ParameterByName("DiffFee_ZCY").AsString = (zcy_RetailFee - zcy_TradeFee).ToString("0.00"); report.ParameterByName("DiffFee_ZY").AsString = (zy_RetailFee - zy_TradeFee).ToString("0.00"); report.ParameterByName("DiffFee_WZ").AsString = (wz_RetailFee - wz_TradeFee).ToString("0.00"); report.ParameterByName("DeptName").AsString = BaseData.GetDeptName(deptId.ToString()); report.ParameterByName("Printer").AsString = BaseData.GetUserName(printer); report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime; report.ParameterByName("TradeFee1").AsString = (xy_TradeFee1 + zcy_TradeFee1 + zy_TradeFee1 + wz_TradeFee1).ToString("0.00"); report.ParameterByName("DiffFee1").AsString = (xy_RetailFee1 + zcy_RetailFee1 + zy_RetailFee1 + wz_RetailFee1 - xy_TradeFee1 - zcy_TradeFee1 - zy_TradeFee1 - wz_TradeFee1).ToString("0.00"); report.ParameterByName("RetailFee1").AsString = (xy_RetailFee1 + zcy_RetailFee1 + zy_RetailFee1 + wz_RetailFee1).ToString("0.00"); report.ParameterByName("RetailFee_XY1").AsString = xy_RetailFee1.ToString("0.00"); report.ParameterByName("RetailFee_ZCY1").AsString = zcy_RetailFee1.ToString("0.00"); report.ParameterByName("RetailFee_ZY1").AsString = zy_RetailFee1.ToString("0.00"); report.ParameterByName("RetailFee_WZ1").AsString = wz_RetailFee1.ToString("0.00"); report.ParameterByName("TradeFee_XY1").AsString = xy_TradeFee1.ToString("0.00"); report.ParameterByName("TradeFee_ZCY1").AsString = zcy_TradeFee1.ToString("0.00"); report.ParameterByName("TradeFee_ZY1").AsString = zy_TradeFee1.ToString("0.00"); report.ParameterByName("TradeFee_WZ1").AsString = wz_TradeFee1.ToString("0.00"); report.ParameterByName("DiffFee_XY1").AsString = (xy_RetailFee1 - xy_TradeFee1).ToString("0.00"); report.ParameterByName("DiffFee_ZCY1").AsString = (zcy_RetailFee1 - zcy_TradeFee1).ToString("0.00"); report.ParameterByName("DiffFee_ZY1").AsString = (zy_RetailFee1 - zy_TradeFee1).ToString("0.00"); report.ParameterByName("DiffFee_WZ1").AsString = (wz_RetailFee1 - wz_TradeFee1).ToString("0.00"); report.PrintPreview(false); } } catch (Exception error) { throw error; } }
public BillQuery Bill([Inject] BillQuery entityQuery) { return(entityQuery); }