/// <summary> /// 获取一段时间范围内操作员预交金票据作废票号 /// </summary> /// <param name="beginDate">开始时间</param> /// <param name="endDate">结束时间</param> /// <param name="operID">操作员代码</param> /// <returns>作废票号数组,失败返回null</returns> public ArrayList QueryWastePrepayInvNOByOperIDAndTime(DateTime beginDate, DateTime endDate, string operID) { string sql = string.Empty; ArrayList alPrepayInv = new ArrayList(); Neusoft.HISFC.Models.Fee.Inpatient.Prepay prepay; if (this.Sql.GetSql("Fee.InpatientDayReport.QueryWastePrepayInvNOByOperIDAndTime", ref sql) == -1) { this.Err = "获取操作员预交金票据作废票号出错!"; return(null); } sql = string.Format(sql, beginDate, endDate, operID); if (this.ExecQuery(sql) == -1) { return(null); } while (this.Reader.Read()) { prepay = new Prepay(); prepay.RecipeNO = this.Reader[0].ToString(); alPrepayInv.Add(prepay); } this.Reader.Close(); return(alPrepayInv); }
private void btnOK_Click(object sender, System.EventArgs e) { //缴费 try { if (null == cmbShow.SelectedItem) { throw new BusinessException("缴费", "请选择招聘会"); } if (txtPrepay.Text.Trim().Length == 0) { throw new BusinessException("缴费", "请输入展位费"); } UltraGridRow row = this.ultraGrid1.ActiveRow; if (null == row) { throw new BusinessException("缴费", "请选择缴费的非会员"); } string strMemberName = row.Cells["cnvcMemberName"].Value.ToString(); Prepay prepay = new Prepay(); prepay.cnnJobID = int.Parse(cmbShow.SelectedItem.DataValue.ToString()); prepay.cnvcPaperNo = row.Cells["cnvcPaperNo"].Value.ToString(); //txtPaperNo.Text; prepay.cnnPrepay = int.Parse(txtPrepay.Text); prepay.cnnBalance = prepay.cnnPrepay; prepay.cnvcOperName = this.oper.cnvcOperName; prepay.cndOperDate = DateTime.Now; Member member = new Member(); //member.cnvcMemberCardNo = row.Cells["cnvcMemberCardNo"].Value.ToString(); member.cnvcPaperNo = prepay.cnvcPaperNo; member.cnnPrepay = prepay.cnnPrepay; member.cnvcMemberName = txtMemberName.Text; member.cnvcOperName = this.oper.cnvcOperName; member.cndOperDate = DateTime.Now; //pMember = member; JobManage job = new JobManage(); job.AddPrepay(prepay, strMemberName); PrintedBill pBill = new PrintedBill(member.ToTable()); pBill.cnvcBillType = ConstApp.Bill_Type_AddPrepay; Helper.PrintTicket(pBill); //this.ultraPrintDocument1.Print(); MessageBox.Show(this, "缴费成功!", "缴费", MessageBoxButtons.OK, MessageBoxIcon.Information); txtPrepay.Text = ""; txtMemberName.Text = ""; txtPaperNo.Text = ""; btnOK.Enabled = false; cmbShow.Text = ""; } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnOK_Click(object sender, System.EventArgs e) { //退费 try { if (txtReturnPrepay.Text.Trim().Length == 0) { throw new BusinessException("退费", "请输入退费金额"); } UltraGridRow row = this.ultraGrid1.ActiveRow; if (null == row) { throw new BusinessException("退费", "请选择进行退费的非会员"); } string strBalance = row.Cells["cnnBalance"].Value.ToString(); Decimal dBalance = Decimal.Parse(strBalance); Prepay prepay = new Prepay(); //prepay.cnvcMemberCardNo = txtMemberCardNo.Text; prepay.cnnPrepayID = int.Parse(row.Cells["cnnPrepayID"].Value.ToString()); prepay.cnnJobID = int.Parse(row.Cells["cnnJobID"].Value.ToString()); prepay.cnvcPaperNo = row.Cells["cnvcPaperNo"].Value.ToString(); //prepay.cnvcMemberCardNo = row.Cells["cnvcMemberCardNo"].Value.ToString(); prepay.cnnReturn = Decimal.Parse(txtReturnPrepay.Text); prepay.cnvcOperName = this.oper.cnvcOperName; prepay.cndOperDate = DateTime.Now; if (prepay.cnnReturn > dBalance) { throw new BusinessException("退费", "退费金额过大"); } MemberManageFacade memberManage = new MemberManageFacade(); memberManage.ReturnPrepay(prepay); //PrintedBill pBill = MessageBox.Show(this, "退费成功", "退费", MessageBoxButtons.OK, MessageBoxIcon.Information); btnQuery_Click(null, null); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }