/// <summary> /// 上传身份证购票的信息数据 /// </summary> /// <param name="SaleClient">RPC</param> /// <param name="XiaoNumber">销售单号</param> /// <returns></returns> public static bool SellTicketDataUP_IDCard(T_RpcClient SaleClient, string XiaoNumber, M_SelfHelpClass selfhelpclass) { bool isresult = false; M_TicketType mticketType; //票种实体 string XiaoMX = ""; //明细单号 try { //1.创建实体 SL_ORDER slorder = new SL_ORDER(); //销售主表 SL_ORDER_TICKETTYPE_DETAIL slorderticket = new SL_ORDER_TICKETTYPE_DETAIL(); //销售单票种明细表 List <SL_PAY_TYPE> listsl_pay_type = new List <SL_PAY_TYPE>(); SL_PAY_TYPE slpaytype = new SL_PAY_TYPE(); //支付方式表 List <SL_ORDER_DETAIL> listorderdetial = new List <SL_ORDER_DETAIL>(); //2.根据单号获取要上传的销售主表信息 string strOrder = "select * from SL_ORDER where ORDER_ID='" + XiaoNumber + "'"; SQLiteCommand cmdOrder = new SQLiteCommand(strOrder); DataSet dsOrder = new DataSet(); dsOrder = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, cmdOrder); if (dsOrder.Tables[0].Rows.Count > 0) { slorder.OrderId = dsOrder.Tables[0].Rows[0]["ORDER_ID"].ToString(); //销售单号 slorder.OrderType = dsOrder.Tables[0].Rows[0]["ORDER_TYPE"].ToString(); //销售类型(XC-现场售票、ZY-自营售票、TD-团队换票、WL-网络人工换票、ST-实体代理、BP-补票、ZG-自助购票、ZQ-自助取票) slorder.TicketCount = Convert.ToInt64(dsOrder.Tables[0].Rows[0]["TICKET_COUNT"]); //销售张数 slorder.DueSum = Convert.ToInt64(dsOrder.Tables[0].Rows[0]["DUE_SUM"]); //应收金额 slorder.RealSum = Convert.ToInt64(dsOrder.Tables[0].Rows[0]["REAL_SUM"]); //实收金额 slorder.Remark = dsOrder.Tables[0].Rows[0]["REMARK"].ToString(); //订单说明 slorder.PayStat = dsOrder.Tables[0].Rows[0]["PAY_STAT"].ToString(); //支付状态 slorder.SaleUserId = dsOrder.Tables[0].Rows[0]["SALE_USER_ID"].ToString(); //出票人 在此指终端号 slorder.SaleTime = T_Date.ConvertDataTimeToLong(Convert.ToDateTime(dsOrder.Tables[0].Rows[0]["SALE_TIME"])); //售票时间 slorder.VersionNo = T_Date.ConvertDataTimeToLong(Convert.ToDateTime(dsOrder.Tables[0].Rows[0]["VERSION_NO"])); //版本号 //2.根据销售单号获取支付信息 string strPay = "select * from SL_PAY_TYPE where ORDER_ID='" + XiaoNumber + "'"; SQLiteCommand cmdPay = new SQLiteCommand(strPay); DataSet dsPay = new DataSet(); dsPay = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, cmdPay); slpaytype.PayTypeId = dsPay.Tables[0].Rows[0]["PAY_TYPE_ID"].ToString(); //支付单号 slpaytype.OrderId = dsPay.Tables[0].Rows[0]["ORDER_ID"].ToString(); //销售单号 slpaytype.PayType = dsPay.Tables[0].Rows[0]["PAY_TYPE"].ToString(); //支付方式 slpaytype.Amt = Convert.ToInt64(dsPay.Tables[0].Rows[0]["AMT"]); //支付金额 slpaytype.PayId = ""; //第三方支付单号 slpaytype.PaymentCode = selfhelpclass.PayodNo; //付款码 slpaytype.VersionNo = T_Date.ConvertDataTimeToLong(Convert.ToDateTime(dsPay.Tables[0].Rows[0]["VERSION_NO"])); //版本号 listsl_pay_type.Add(slpaytype); slorder.SlPayTypelist = listsl_pay_type; //支付方式 //3.销售单明细表 //string strDetail = "select * from SL_PAY_TYPE where ORDER_ID='" + XiaoNumber + "'"; //SQLiteCommand cmdMX = new SQLiteCommand(strDetail); //DataSet dsMX = new DataSet(); //dsMX = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, cmdMX); //获到票种实体 mticketType = D_TicketType.GetTicketTypeInfo(selfhelpclass.TicketTypeID); for (int j = 0; j <= selfhelpclass.TicketCount - 1; j++) { XiaoMX = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalTicketMX_Prefix_ZG, j); SL_ORDER_DETAIL slorderdetail = new SL_ORDER_DETAIL(); slorderdetail.OrderDetailId = XiaoMX; //dsMX.Tables[0].Rows[j]["Order_detail_id"].ToString();//销售明细单号 slorderdetail.OrderId = XiaoNumber; //dsMX.Tables[0].Rows[j]["Order_id"].ToString();//销售单号 slorderdetail.TicketClass = "2"; //dsMX.Tables[0].Rows[j]["TICKET_CLASS"].ToString();//门票类型(1-FRID、2-身份证、3-二维码) slorderdetail.IdenttyId = selfhelpclass.GetTicketUserNumber; //dsMX.Tables[0].Rows[j]["IDENTTY_ID"].ToString();//身份证号码 slorderdetail.TicketId = 0; // Convert.ToInt64(dsMX.Tables[0].Rows[j]["Ticket_id"]);//票号 slorderdetail.TicketUid = ""; //票种唯一号 slorderdetail.TicketTypeId = selfhelpclass.TicketTypeID; //dsMX.Tables[0].Rows[j]["Ticket_type_id"].ToString();//票种编号 slorderdetail.ValidateTimes = mticketType.VALIDATE_TIMES; //可用次数 slorderdetail.OriginalPrice = selfhelpclass.OriginalPrice; //原单价 slorderdetail.SalePrice = selfhelpclass.SalePrice; //销售价 slorderdetail.CheckFlag = "N"; // 是否检票(Y是N否) slorderdetail.UselessFlag = "N"; //是否作废(Y是N否) // slorderdetail.OpeUserId = dsMX.Tables[0].Rows[j]["Ope_user_id"].ToString();//操作人 // slorderdetail.OpeTime = T_Date.ConvertDataTimeToLong(Convert.ToDateTime(dsMX.Tables[0].Rows[j]["Ope_time"]));//操作时间 slorderdetail.OutletId = Convert.ToInt64(M_Configuration.CLIENTID.ToString().Substring(1, 3)); //Convert.ToInt64(dsMX.Tables[0].Rows[j]["OUTLET_ID"]);//出票网点编号 slorderdetail.ClientId = M_Configuration.CLIENTID; //Convert.ToInt64(dsMX.Tables[0].Rows[j]["CLIENT_ID"]);//出票终端编号 //slorderdetail.EjectUserId = dsMX.Tables[0].Rows[j]["EJECT_USER_ID"].ToString();//出票人 slorderdetail.EjectTicketStat = "1"; //dsMX.Tables[0].Rows[j]["EJECT_TICKET_STAT"].ToString();//出票状态(1-待出票 2-已出票) //slorderdetail.EjectTicketTime = T_Date.ConvertDataTimeToLong(Convert.ToDateTime(dsMX.Tables[0].Rows[j]["EJECT_TICKET_TIME"]));//出票时间 slorderdetail.VersionNo = T_Date.ConvertDataTimeToLong(Convert.ToDateTime(dsOrder.Tables[0].Rows[0]["VERSION_NO"])); //版本号;//版本号 listorderdetial.Add(slorderdetail); } slorder.SlOrderDetaillist = listorderdetial;//销售明细表 } if (slorder != null) { isresult = SaleClient.saleTicketByIdenttyZG_RPC(slorder);//身份证购票信息上传 } } catch (Exception ex) { _log.Error(typeof(B_SellTicketUpData), ex); throw new Exception(ex.Message.ToString()); } return(isresult); }
//****写票函数 private bool WriteTicket() { bool isok = false; try { //具体写票操作 bool hasTicket = rfidReader.WaitForTicketPresent(1000); #region try { if (hasTicket) { //读取发行信息 TicketPublishInfo tpInfo = rfidReader.readTicketPublishInfo(); _log.Debug("已读取到门票,票号:" + tpInfo.ID.ToString()); CurTicketID = tpInfo.ID.ToString(); //票号 上传时用到 //读取销售信息 TicketSaleInfo?tsInfo = rfidReader.readTicketSaleInfo(); if (!tsInfo.HasValue) //未做过销售的 { #region //验证出票与购票的票种是否相同 if ((tpInfo.TicketClass.ToString() == M_Configuration.TicketTypeID_1) || (tpInfo.TicketClass.ToString() == M_Configuration.TicketTypeID_2)) { //获到票种实体 mticketType = D_TicketType.GetTicketTypeInfo(tpInfo.TicketClass.ToString()); #region //首先判断票种是否存在 if (mticketType.TICKET_TYPE_ID != null) //当前票票种存在的 { #region //两个票箱票种互换的情况 if ((this.parent.mSelfHelpClass.BoxNumber == "A" && tpInfo.TicketClass.ToString() != M_Configuration.TicketTypeID_1) || (this.parent.mSelfHelpClass.BoxNumber == "B" && tpInfo.TicketClass.ToString() != M_Configuration.TicketTypeID_2)) { // 票箱设置的票种与实际所放票种不一致 //TPU_OUT(1);//回收票据 _log.Error("票箱设置票种与实际出票票种不符!"); this.parent.ticketbox_isErr = 1;//票种放反 rfidReader.LongBeep(); isok = false; return(isok); } #endregion Yu_Price = T_SellTicketRecord.Get_sl_period_Price(tpInfo.TicketClass.ToString()); //获取预售期票价 #region //是否团体票 if (mticketType.TEAM_FLAG == "Y") //团体票 { BeginDate = DateTime.Now; EndDate = DateTime.Now.AddMinutes(M_Configuration.Teamtickettime);//从参数表中取出结束时间//Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 16:00:00")); _log.Error("此门票为团体票,不能在此销售!"); rfidReader.LongBeep(); return(false); } else { if (mticketType.DAY_VALIDATE_FLAG == "Y")//当日有效 { BeginDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); EndDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); } else //非当日有效 { BeginDate = DateTime.Now; EndDate = DateTime.Now.AddYears(2); } } #endregion //真正写票 并保存到数据库中 #region if (rfidReader.writeTicketSaleInfo(BeginDate, EndDate, 1)) { _log.Debug("写票成功!"); if (this.parent.mSelfHelpClass.OperType == "0")//购票时生成销售明细单号 { XiaoMX = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalTicketMX_Prefix_ZG, this.cardCount); } //保存数据 #region if (T_SellTicketRecord.Insert_SL_ORDER_DETAIL(mticketType, tpInfo.ID.ToString(), Convert.ToInt32(this.parent.mSelfHelpClass.OperType), this.parent.mSelfHelpClass, XiaoMX, this.cardCount)) { _log.Debug("本地缓存写入成功!"); isok = true; } else { _log.Warn("本地缓存写入失败!"); } #endregion } else { _log.Warn("写入票据信息失败!"); } #endregion } else//该票的票种不存在 { _log.Error("系统中不存在当前票种!票种:" + tpInfo.TicketClass.ToString()); rfidReader.LongBeep(); } #endregion } else//购票与出票 票种不符 { _log.Error("当前门票同所购门票的票种不符!票种:" + tpInfo.TicketClass.ToString()); rfidReader.LongBeep(); } #endregion } else//已做过销售的 { _log.Error("当前门票已做过销售处理!票号:" + CurTicketID.ToString()); rfidReader.LongBeep(); } } else { return(false); } } catch (Exception ex) { _log.Error("门票读取错误!", ex); rfidReader.LongBeep(); } #endregion } catch (Exception ex) { _log.Error("读卡器异常!", ex); rfidReader.LongBeep(); } finally { //rfidReader.WaitForTicketRemoval(0); } return(isok); }