客运综合管理系统项目—售票管理（退票）

 IF @TYPE='frmReturnATicket_SelectTicketNews'--绑定票信息，车辆，座位，票据等信息

    
 	BEGIN
    
 SELECT     ASeatNumberList.ASeatNumberID, VehicleList.VehicleID, VehicleList.VehicleBlockNumber, ASeatNumberList.ASeatNumber, TicketNumberList.TicketNumber, BillList.GetOffStation, 
    
                   BillList.GetOnStation, BillList.TicketNumber, BillTypeList.BillTypeName, BillList.SellTicKetYuan, BillList.SellTicKetTime, StaffList.StaffName, VehicleList.Classes, 
    
                   StationList.StationID AS OpenVehicleSiteID, StationList.StationName AS OpenVehicleSite, StationList_1.StationID AS EndVehicleSiteID, StationList_1.StationName AS EndVehicleSite, BillList.BillID, 
    
                   OutVehicleList.OutVehicleTime, TicketNumberList.TicketNumberID
    
 FROM         StationList INNER JOIN
    
                   ASeatNumberList INNER JOIN
    
                   TicketNumberList ON ASeatNumberList.ASeatNumberID = TicketNumberList.ASeatNumberID INNER JOIN
    
                   VehicleList ON ASeatNumberList.VehicleID = VehicleList.VehicleID ON StationList.StationID = VehicleList.OpenVehicleSiteID INNER JOIN
    
                   StationList AS StationList_1 ON VehicleList.EndVehicleSiteID = StationList_1.StationID INNER JOIN
    
                   OutVehicleList ON VehicleList.VehicleID = OutVehicleList.VehicleID INNER JOIN
    
                   BillTypeList INNER JOIN
    
                   BillList ON BillTypeList.BillTypeID = BillList.BillTypeID INNER JOIN
    
                   StaffList ON BillList.SellTicketSatffID = StaffList.StaffID ON TicketNumberList.TicketNumberID = BillList.TicketNumberID
    
 	WHERE TicketNumberList.TicketNumberID=@TicketNumberID and ASeatNumberList.SeatStateID = 2 and BillList.BillStatusID=3 AND OutVehicleList.UserTo=1--座位状态为订，车辆明细表有用否为是
    
  END
    
    
    
    

  [OperationContract]

    
  
    
     public DataSet frmReturnATicket_SelectTicketNews(int intTicketNumberID)//绑定票信息，车辆，座位，票据等信息
    
  
    
     {
    
  
    
         SqlParameter[]mySqlParameter = { new SqlParameter("@Type", SqlDbType.Char),
    
  
    
                                         new SqlParameter("@TicketNumberID", SqlDbType.Int)};
    
  
    
         mySqlParameter[0].Value = "frmReturnATicket_SelectTicketNews";
    
  
    
         mySqlParameter[1].Value =intTicketNumberID;
    
  
    
         DataTablemyDataTable = myDALMethod.QueryDataTable("SellTicketManage_frmReturnATicket",mySqlParameter);
    
  
    
         DataSetmyDataSet = new DataSet();
    
  
    
         myDataSet.Tables.Add(myDataTable);
    
  
    
         returnmyDataSet;
    
  
    
     }
    
    
    
    

  private void cboTicketNumber_DropDownClosed(object sender, EventArgs e)//在下拉框选择数据后执行，绑定票信息，车辆，座位，票据等信息

    
     {
    
         try
    
         {
    
             PublicStaticObject.intTicketNumberID = Convert.ToInt32(cboTicketNumber.SelectedValue);//根据下拉框选择的值来获取票号ID
    
             DataTable dtTicketNews = myfrmReturnATicketClient.frmReturnATicket_SelectTicketNews(PublicStaticObject.intTicketNumberID).Tables[0];//获取票据信息
    
             //下面的是给文本框等绑定数据，即绑定票据信息
    
             cboTicketNumber.Text = dtTicketNews.Rows[0]["TicketNumber"].ToString().Trim();
    
             txtClasses.Text = dtTicketNews.Rows[0]["Classes"].ToString().Trim();
    
             dtpOpenVehicleDate.Text = dtTicketNews.Rows[0]["OutVehicleTime"].ToString().Trim();
    
             dtpOpenVehicleTime.Text = dtTicketNews.Rows[0]["OutVehicleTime"].ToString().Trim();
    
             txtTicketType.Text = dtTicketNews.Rows[0]["BillTypeName"].ToString().Trim();
    
             txtPrice.Text = dtTicketNews.Rows[0]["SellTicKetYuan"].ToString().Trim();
    
             txtSeatNumber.Text = dtTicketNews.Rows[0]["ASeatNumber"].ToString().Trim();
    
             txtStartSite.Text = dtTicketNews.Rows[0]["OpenVehicleSite"].ToString().Trim();//
    
             txtGetOnStation.Text = dtTicketNews.Rows[0]["GetOnStation"].ToString().Trim();
    
             txtArriveStation.Text = dtTicketNews.Rows[0]["GetOffStation"].ToString().Trim();
    
             txtEndVehicleSite.Text = dtTicketNews.Rows[0]["EndVehicleSite"].ToString().Trim();
    
             txtSellTicketDate.Text = dtTicketNews.Rows[0]["SellTicKetTime"].ToString().Trim();
    
         }
    
         catch
    
         { }
    
     }
    
    
    
    

  IF @TYPE='frmReturnATicket_InsertRetureTicket'--新增退票信息

    
      BEGIN
    
      INSERT INTO     ReturnATicketClearList(StationAffairFee, ReturnATicketTime, BillID, ProcedureFeeRate, 
    
         ReturnSum, TimeDifference, ReturnATicketOperatorID)
    
      VALUES   (@StationAffairFee, @ReturnATicketTime, @BillID, @ProcedureFeeRate, 
    
         @ReturnSum, @TimeDifference, @ReturnATicketOperatorID)
    
      END
    
      IF @TYPE='frmReturnATicket_UpdateTicketStaue'
    
      BEGIN
    
      Update BillList
    
      set BillList.BillStatusID=4--修改座位状态
    
      WHERE BillList.BillID=@BillID
    
      UPDATE ASeatNumberList
    
      set ASeatNumberList.SeatStateID=3--修改座位状态
    
      WHERE ASeatNumberList.ASeatNumberID=@ASeatNumberID
    
      UPDATE TicketNumberList
    
      SET TicketNumberList.UserNo=1--修改票号的有用否
    
      WHERE TicketNumberList.TicketNumberID=@TicketNumberID
    
      END
    
    
    
    

    退票逻辑层(BLL)代码
    

  [OperationContract]

    
     public int frmReturnATicket_InsertRetureTicket(string strStationAffairFee,DateTime dtReturnATicketTime,int BillID,
    
                        string strProcedureFeeRate,decimal decReturnSum,string strTimeDifference,int intReturnATicketOperatorID)//退票
    
     {
    
         SqlParameter[] mySqlParameter = { new SqlParameter("@Type", SqlDbType.Char),
    
                                          new SqlParameter("@StationAffairFee", SqlDbType.Char),
    
                                          new SqlParameter("@ReturnATicketTime", SqlDbType.DateTime),
    
                                          new SqlParameter("@BillID", SqlDbType.Int),
    
                                          new SqlParameter("@ProcedureFeeRate", SqlDbType.Char),
    
                                          new SqlParameter("@ReturnSum", SqlDbType.Char),
    
                                          new SqlParameter("@TimeDifference", SqlDbType.Char),
    
                                          new SqlParameter("@ReturnATicketOperatorID", SqlDbType.Int),};
    
         mySqlParameter[0].Value = "frmReturnATicket_InsertRetureTicket";
    
         mySqlParameter[1].Value = strStationAffairFee;
    
         mySqlParameter[2].Value = dtReturnATicketTime;
    
         mySqlParameter[3].Value = BillID;
    
         mySqlParameter[4].Value = strProcedureFeeRate;
    
         mySqlParameter[5].Value = decReturnSum;
    
         mySqlParameter[6].Value = strTimeDifference;
    
         mySqlParameter[7].Value = intReturnATicketOperatorID;
    
         return myDALMethod.UpdateData("SellTicketManage_frmReturnATicket", mySqlParameter);
    
     }
    
  
    
    
    
    

   private void btnReturnATicket_Click(object sender, EventArgs e)//退票

    
     {
    
         if (Convert.ToInt32(cboTicketNumber.SelectedValue) > 0)//判断下拉框获取的ID大于0
    
         {
    
             DataTable dtTicketNews = myfrmReturnATicketClient.frmReturnATicket_SelectTicketNews(PublicStaticObject.intTicketNumberID).Tables[0];
    
              DateTime dtTime=Convert.ToDateTime(dtTicketNews.Rows[0]["OutVehicleTime"].ToString().Trim());
    
              if (Convert.ToDateTime(dtTime) > Convert.ToDateTime(txtRetureTicket.Text))
    
             {
    
                 if (MessageBox.Show("确定退票？", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
    
                 {
    
                     if (txtHandlingCharge.Text == "")
    
                     {
    
                         MessageBox.Show("手续费不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
    
                         return;
    
                     }
    
                     if (txtReturnSum.Text == "")
    
                     {
    
                         MessageBox.Show("退还金额不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
    
                         return;
    
                     }
    
                     if (txtStationAffairFee.Text == "")
    
                     {
    
                         MessageBox.Show("站务费不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
    
                         return;
    
                     }
    
                     if (txtTimeDifference.Text == "")
    
                     {
    
                         MessageBox.Show("时差不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
    
                         return;
    
                     }
    
                     string strStationAffairFee = txtStationAffairFee.Text.ToString().Trim();//获文本框的数据
    
                     string strProcedureFeeRate = txtStationAffairFee.Text.ToString().Trim();
    
                     string strTimeDifference = txtStationAffairFee.Text.ToString().Trim();
    
                     DateTime dtReturnATicketTime = Convert.ToDateTime(txtRetureTicket.Text);
    
                     decimal decReturnSum = Convert.ToDecimal(txtReturnSum.Text);
    
                     int BillID = (int)dtTicketNews.Rows[0]["BillID"];
    
                     int intReturnATicketOperatorID = PublicStaticObject.intSatffTwo;
    
                     int ASeatNumberID = (int)dtTicketNews.Rows[0]["ASeatNumberID"];
    
                     int i = myfrmReturnATicketClient.frmReturnATicket_InsertRetureTicket(strStationAffairFee, dtReturnATicketTime, BillID,
    
                                                        strProcedureFeeRate, decReturnSum, strTimeDifference, intReturnATicketOperatorID);
    
                     if (i > 0)
    
                     {
    
                         int intTicketNumberID = (int)dtTicketNews.Rows[0]["TicketNumberID"];
    
                         myfrmReturnATicketClient.frmReturnATicket_UpdateTicketStaue(BillID, ASeatNumberID, intTicketNumberID).Tables[0].ToString().Trim();//新增退票
    
                         string KnowName = "于" + dtReturnATicketTime + "出售一张班次为" + txtClasses.Text.ToString().Trim() + "票号为" + cboTicketNumber.Text.ToString().Trim() + "的票";//新增一条信息提示
    
                         myfrmMainClient.frmMain_InsertKnow(KnowName);
    
                         MessageBox.Show("退票成功！");//提示框
    
                         frmReturnATicket_Load(null, null);//再次执行load事件的代码
    
                     }
    
                     else
    
                     {
    
                         MessageBox.Show("退票失败！");
    
                     }
    
                 }
    
             }
    
             else
    
             {
    
                 MessageBox.Show("退票时间已过，无法退票！");
    
             }
    
         }
    
         else
    
         {
    
             MessageBox.Show("请选择票号！");
    
         }
    
     }