public void StartOperation(string step) { try { //bool flag = this.SelfHelpInfo == null; //if (flag) //{ // //this.SelfHelpInfo = new SelfHelpClass(); // this.mSelfHelpClass = new M_SelfHelpClass();//自助售票类 //} bool flag1 = this.mSelfHelpClass == null; if (flag1) { this.mSelfHelpClass = new M_SelfHelpClass();//自助售票类 } this.StartSecond(); this.row2.Height = new GridLength(0.0); this.row3.Height = new GridLength(this.mainGrid.Height - this.row1.Height.Value); this.Operation(step); this.operationpage.Height = this.row3.Height.Value; this.imagepage.imageThread.Stop(); //this.videopage.Pause(); this.topFrame.Content = this.notice; } catch (Exception ex) { this._log.Error("切换显示页面时发生错误:" + this.GetType().ToString(), ex); } }
//[DllImport("user32.dll")] //private static extern bool ShowWindowAsync(IntPtr hWnd, int nCmdShow); //[DllImport("user32.dll", SetLastError = true)] //private static extern IntPtr FindWindow(string lpClassName, string lpWindowName); //[DllImport("user32.dll", SetLastError = true)] //private static extern long SetParent(IntPtr hWndChild, IntPtr hWndNewParent); //[DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)] //private static extern int SendMessage(IntPtr hwnd, uint wMsg, int wParam, int lParam); public MainWindow() { this.InitializeComponent(); // this.SelfHelpInfo = new SelfHelpClass(); this.mSelfHelpClass = new M_SelfHelpClass();//自助售票类 string configValue = ConfigHelper.GetConfigValue("window", "autoPowerOff"); bool flag = !DateTime.TryParse(configValue, out this.shutdownTime); if (flag) { this.shutdownTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 18:00:00")); } // this.senderCardControl = new OldSenderCardControl(ConfigHelper.GetConfigValue("comport", "senderPort"), int.Parse(ConfigHelper.GetConfigValue("comport", "senderBaudRate")), ConfigHelper.GetConfigValue("comport", "CardPort"), int.Parse(ConfigHelper.GetConfigValue("comport", "CardBaudRate"))); _log.Info("MainWindow启动"); }
/// <summary> /// 支付成功后 向销售主表 支付表写入数据 /// </summary> /// <param name="selfhelpcalss">自助售票类</param> /// <param name="selltype">0表示销售主表 1表示支付表</param> /// <param name="paystat">支付状态(1-待支付 2-已支付 3-支付失败)</param> /// <returns></returns> public static bool Insert_GP_Data(M_SelfHelpClass selfhelpcalss) //int selltype,,int paystat { bool isok = false; string strsell = ""; string strpay = ""; SQLiteCommand cmdsell = new SQLiteCommand(); SQLiteCommand cmdpay = new SQLiteCommand(); strsell = " insert into SL_ORDER(ORDER_ID,ORDER_TYPE,TICKET_COUNT,DUE_SUM,REAL_SUM,SALE_USER_ID,SALE_TIME,VERSION_NO,REMARK,PAY_STAT)" + " values('" + selfhelpcalss.OrderID + "','" + LocalTicket_Prefix_ZG + "','" + selfhelpcalss.TicketCount.ToString() + "','" + selfhelpcalss.DueSum.ToString() + "','" + selfhelpcalss.RealSum.ToString() + "','" + M_Configuration.CLIENTID.ToString() + "',DateTime('now','localtime'),DateTime('now','localtime'),'自助售票','" + selfhelpcalss.PayStat + "')"; strpay = " insert into SL_PAY_TYPE(PAY_TYPE_ID,ORDER_ID,PAY_TYPE,AMT,VERSION_NO) " + " values('" + selfhelpcalss.PayTypeID + "','" + selfhelpcalss.OrderID + "','" + selfhelpcalss.PayType + "','" + selfhelpcalss.RealSum.ToString() + "',DateTime('now','localtime')) "; //***************起事物写入销售主表与支付表************* using (SQLiteConnection conn = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString)) { conn.Open(); SQLiteTransaction tran = conn.BeginTransaction(); try { cmdsell.CommandText = strsell; cmdsell.Connection = conn; cmdsell.ExecuteNonQuery(); cmdpay.CommandText = strpay; cmdpay.Connection = conn; cmdpay.ExecuteNonQuery(); tran.Commit(); isok = true; } catch (Exception ex) { conn.Close(); tran.Rollback(); _log.Error(typeof(T_SellTicketRecord), ex); } finally { tran.Dispose(); } } //***************起事物写入销售主表与支付表************* return(isok); }
public void EndOperation() { try { this.InitControlSize(); this.operationpage.Height = this.row3.Height.Value; this.operationpage = pageTest; //new FirstPage(this); this.mainFrame.Content = this.operationpage; this.imagepage.imageThread.Start(); //this.topFrame.Content = this.videopage; //this.videopage.Resume(); this.StopSecond(); //this.SelfHelpInfo = new SelfHelpClass(); this.mSelfHelpClass = new M_SelfHelpClass();//自助售票类 } catch (Exception ex) { this._log.Error("返回首页时发生错误:" + this.GetType().ToString(), ex); } }
/// <summary> /// 将售票信息写入SL_ORDER_DETAIL_表中 /// </summary> /// <param name="ticketType">票种实体</param> /// <param name="ticketid">票号</param> /// <param name="selltype">0自助购票 1自助取票</param> /// <param name="selfhelpclass">自助售票类</param> /// <param name="index">取票时表示明细的序号</param> /// <returns></returns> public static bool Insert_SL_ORDER_DETAIL(M_TicketType ticketType, string ticketid, int selltype, M_SelfHelpClass selfhelpclass, string XiaoMX, int index) { bool isok = false; try { string strIn = ""; if (selltype == 0) //购票 { string strOutLet = Convert.ToString(M_Configuration.CLIENTID).Substring(1, 3); //网点编号 strIn = "insert into SL_ORDER_DETAIL(order_detail_id,order_id,ticket_class,ticket_id," + "ticket_type_id,validate_times,remain_times,original_price,sale_price," + "check_flag,useless_flag,ope_user_id,ope_time,version_no,SellType,OUTLET_ID,CLIENT_ID,EJECT_USER_ID,EJECT_TICKET_STAT,EJECT_TICKET_TIME)" + " values('" + XiaoMX + "','" + selfhelpclass.OrderID + "','1','" + ticketid + "','" + selfhelpclass.TicketTypeID + "','" + ticketType.VALIDATE_TIMES.ToString() + "'," + ticketType.VALIDATE_TIMES.ToString() + ",'" + selfhelpclass.OriginalPrice.ToString() + "','" + selfhelpclass.SalePrice.ToString() + "'," + " 'N','N','" + M_Configuration.CLIENTID.ToString() + "',DateTime('now','localtime'),DateTime('now','localtime'),'" + selltype.ToString() + "','" + strOutLet + "','" + M_Configuration.CLIENTID.ToString() + "','" + M_Configuration.CLIENTID.ToString() + "','2','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "') "; } else if (selltype == 1)//取票 { strIn = "insert into SL_ORDER_DETAIL(order_detail_id,order_id,ticket_class,ticket_id," + "ticket_type_id,validate_times,remain_times,original_price,sale_price," + "check_flag,useless_flag,ope_user_id,ope_time,version_no,SellType,OUTLET_ID,CLIENT_ID,EJECT_USER_ID,EJECT_TICKET_STAT,EJECT_TICKET_TIME)" + " values('" + selfhelpclass.listorderdetail[index - 1].OrderDetailId + "','" + selfhelpclass.listorderdetail[index - 1].OrderId + "','2','" + ticketid + "','" + selfhelpclass.listorderdetail[index - 1].TicketTypeId + "','" + ticketType.VALIDATE_TIMES.ToString() + "'," + ticketType.VALIDATE_TIMES.ToString() + ",'" + selfhelpclass.OriginalPrice.ToString() + "','" + selfhelpclass.SalePrice.ToString() + "'," + " 'N','N','" + M_Configuration.CLIENTID.ToString() + "',DateTime('now','localtime'),DateTime('now','localtime'),'" + selltype.ToString() + "','" + selfhelpclass.OrderID + "','" + M_Configuration.CLIENTID.ToString() + "','" + M_Configuration.CLIENTID.ToString() + "','2','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "') "; } SQLiteCommand cmd = new SQLiteCommand(strIn); SQLiteHelper.ExecuteNonQuery(SQLiteHelper.LocalDbConnectionString, cmd); isok = true; } catch (Exception ex) { _log.Error(typeof(T_SellTicketRecord), ex); } return(isok); }
/// <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); }
/// <summary> /// 支付前上传销售主表,支付方式表及销售单票种明细表 三个表的数据 /// </summary> /// <param name="SaleClient">RPC</param> /// <param name="XiaoNumber">销售单号</param> /// <param name="selfhelpcalss">自助售票类</param> /// <returns></returns> public static bool SellTicketDataUP(T_RpcClient SaleClient, M_SelfHelpClass selfhelpcalss)//string XiaoNumber, { bool isresult = false; 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(); //支付方式表 //2.根据单号获取要上传的销售主表信息 string strOrder = "select * from SL_ORDER where ORDER_ID='" + selfhelpcalss.OrderID + "'"; 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='" + selfhelpcalss.OrderID + "'"; 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 = selfhelpcalss.PayodNo; //"283324266658117012";//130266842860345964//微信 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.销售单票种明细表 slorderticket.OrderId = dsOrder.Tables[0].Rows[0]["ORDER_ID"].ToString(); //销售单号 slorderticket.TicketTypeId = selfhelpcalss.TicketTypeID; //票种 slorderticket.TicketCount = Convert.ToInt64(dsOrder.Tables[0].Rows[0]["TICKET_COUNT"]); //销售张数 slorderticket.EjectTicketCount = 0; //出票张数 } if (slorder != null) { isresult = SaleClient.saleTicketByZGRPC(slorder, slorderticket); } } catch (Exception ex) { _log.Error(typeof(B_SellTicketUpData), ex); throw new Exception(ex.Message.ToString()); } return(isresult); }
/// <summary> /// 自助购票上传明细信息 /// </summary> /// <param name="SaleClient">RPC</param> /// <param name="XiaoNumber">销售单号</param> /// <param name="TicketID">要上传的票号</param> /// <returns></returns> public static bool SellTicketDataUP_MX(T_RpcClient SaleClient, string XiaoNumber, M_SelfHelpClass selfhelpclass, string TicketID) { bool isok = false; try { string strDetail = ""; List <SL_ORDER_DETAIL> listorderdetial = new List <SL_ORDER_DETAIL>(); if (selfhelpclass.OperType == "0")//购票 { strDetail = "select * from SL_ORDER_DETAIL where TICKET_CLASS='1' and ORDER_ID='" + XiaoNumber + "' and TICKET_ID='" + TicketID + "'"; } else if (selfhelpclass.OperType == "1") //取票 { //身份证取票时 实际返回的销售明细可能是多个销售单号的 strDetail = "select * from SL_ORDER_DETAIL where TICKET_CLASS='2' and EJECT_TICKET_STAT='2' and ("; string strsel = ""; for (int i = 0; i < selfhelpclass.listorderdetail.Count; i++) { strsel = strsel + "or ORDER_ID='" + selfhelpclass.listorderdetail[i].OrderId + "'and TICKET_ID='" + TicketID + "'"; } strsel = strsel.Substring(2, strsel.Length - 2); strDetail = strDetail + strsel + ")"; } SQLiteCommand cmdMX = new SQLiteCommand(strDetail); DataSet dsMX = new DataSet(); dsMX = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, cmdMX); for (int j = 0; j <= dsMX.Tables[0].Rows.Count - 1; j++) { SL_ORDER_DETAIL slorderdetail = new SL_ORDER_DETAIL(); slorderdetail.OrderDetailId = dsMX.Tables[0].Rows[j]["Order_detail_id"].ToString(); //销售明细单号 slorderdetail.OrderId = dsMX.Tables[0].Rows[j]["Order_id"].ToString(); //销售单号 slorderdetail.TicketClass = dsMX.Tables[0].Rows[j]["TICKET_CLASS"].ToString(); //门票类型(1-FRID、2-身份证、3-二维码) slorderdetail.IdenttyId = dsMX.Tables[0].Rows[j]["IDENTTY_ID"].ToString(); //身份证号码 slorderdetail.TicketId = Convert.ToInt64(dsMX.Tables[0].Rows[j]["Ticket_id"]); //票号 slorderdetail.TicketUid = ""; //票种唯一号 slorderdetail.TicketTypeId = dsMX.Tables[0].Rows[j]["Ticket_type_id"].ToString(); //票种编号 slorderdetail.ValidateTimes = Convert.ToInt64(dsMX.Tables[0].Rows[j]["Validate_times"]); //可用次数 slorderdetail.OriginalPrice = Convert.ToInt64(dsMX.Tables[0].Rows[j]["Original_price"]); //原单价 slorderdetail.SalePrice = Convert.ToInt64(dsMX.Tables[0].Rows[j]["Sale_price"]); //销售价 slorderdetail.CheckFlag = dsMX.Tables[0].Rows[j]["Check_flag"].ToString(); // 是否检票(Y是N否) slorderdetail.UselessFlag = dsMX.Tables[0].Rows[j]["Useless_flag"].ToString(); //是否作废(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(dsMX.Tables[0].Rows[j]["OUTLET_ID"]); //出票网点编号 slorderdetail.ClientId = Convert.ToInt64(dsMX.Tables[0].Rows[j]["CLIENT_ID"]); //出票终端编号 slorderdetail.EjectUserId = dsMX.Tables[0].Rows[j]["EJECT_USER_ID"].ToString(); //出票人 slorderdetail.EjectTicketStat = 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(dsMX.Tables[0].Rows[j]["Ope_time"])); //版本号 listorderdetial.Add(slorderdetail); } if (listorderdetial.Count > 0) { isok = SaleClient.ejectTicket_RPC(listorderdetial);//出票信息上传 } } catch (Exception ex) { _log.Error(typeof(B_SellTicketUpData), ex); } return(isok); }