/// <summary>
/// 写入场馆信息
/// </summary>
/// <param name="sysvenue">场馆实体</param>
/// <param name="cmd">语句</param>
/// <returns>成功true 失败false</returns>
public bool Inert_SYS_Venue(SYS_VENUE sysvenue, SQLiteCommand cmd)
{
StringBuilder strbulid = new StringBuilder();
strbulid.Append("Insert into sys_venue(VENUE_ID,VENUE_NAME,STAT,OPE_USER_ID,OPE_TIME)");
strbulid.Append(" values(@VENUE_ID,@VENUE_NAME,@STAT,@OPE_USER_ID,@OPE_TIME) ");
cmd.CommandText = strbulid.ToString();
cmd.Parameters.Add("VENUE_ID", DbType.Int64);
cmd.Parameters.Add("VENUE_NAME", DbType.String, 100);
cmd.Parameters.Add("STAT", DbType.String, 1);
cmd.Parameters.Add("OPE_USER_ID", DbType.String, 50);
cmd.Parameters.Add("OPE_TIME", DbType.DateTime);
cmd.Parameters["VENUE_ID"].Value = sysvenue.VenueId;
cmd.Parameters["VENUE_NAME"].Value = sysvenue.VenueName;
cmd.Parameters["STAT"].Value = sysvenue.Stat;
cmd.Parameters["OPE_USER_ID"].Value = sysvenue.OpeUserId;
cmd.Parameters["OPE_TIME"].Value = T_Date.ConvertLongToDateTime(sysvenue.OpeTime);
int tmpRows = 0;
try
{
tmpRows = cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
_log.Error(typeof(D_Venue), ex);
return(false);
}
}
private void T_NGuest_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
T_Date.Focus();
}
}
/// <summary>
/// 新增黑名单信息
/// </summary>
/// <param name="varEmpRegisterModel">黑名单信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/22</ Remark >
public bool InsertBlackList(SYS_BLACK_LIST varEmpRegisterModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_BLACK_LIST(");
tmpStrSql.Append("BLACK_LIST_ID,CARD_TYPE,LOSS_DT,TICKET_ID,STAT,CHIP_ID,LOSS_REASON,OPE_USER_ID,OPE_TIME,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@BLACK_LIST_ID,@CARD_TYPE,@LOSS_DT,@TICKET_ID,@STAT,@CHIP_ID,@LOSS_REASON,@OPE_USER_ID,@OPE_TIME,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@BLACK_LIST_ID", DbType.String, 50),
new SQLiteParameter("@CARD_TYPE", DbType.String, 1),
new SQLiteParameter("@LOSS_DT", DbType.DateTime),
new SQLiteParameter("@TICKET_ID", DbType.String, 10),
new SQLiteParameter("@STAT", DbType.String, 1),
new SQLiteParameter("@CHIP_ID", DbType.String, 20),
new SQLiteParameter("@LOSS_REASON", DbType.String, 200),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 50),
new SQLiteParameter("@OPE_TIME", DbType.DateTime),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varEmpRegisterModel.BlackListId;
tmpParameters[1].Value = varEmpRegisterModel.CardType;
tmpParameters[2].Value = T_Date.ConvertLongToDateTime(varEmpRegisterModel.LossDt);
tmpParameters[3].Value = varEmpRegisterModel.TicketId;
tmpParameters[4].Value = varEmpRegisterModel.Stat;
tmpParameters[5].Value = varEmpRegisterModel.ChipId;
tmpParameters[6].Value = varEmpRegisterModel.LossReason;
tmpParameters[7].Value = varEmpRegisterModel.OpeUserId;
tmpParameters[8].Value = T_Date.ConvertLongToDateTime(varEmpRegisterModel.OpeTime);
tmpParameters[9].Value = T_Date.ConvertLongToDateTime(varEmpRegisterModel.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_BlackList), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取根据员工登记表最新版本号
/// </summary>
/// <returns>最新版本号</returns>
/// <Remark>郝毅志，2017/06/22</ Remark >
public DateTime GetLasterVersion()
{
SQLiteCommand tmpCmd = new SQLiteCommand("SELECT MAX(VERSION_NO) FROM SYS_EMP_REGISTER");
DataSet tmpDtable = SQLiteHelper.ExecuteDataSet(SQLiteHelper.LocalDbConnectionString, tmpCmd);
String tmpVersion = (String)tmpDtable.Tables[0].Rows[0].ItemArray[0];
return(Convert.ToDateTime(tmpVersion, T_Date.DateFormatSet()));
}
/// <summary>
/// 更新票种信息(同步下载处理)
/// </summary>
/// <param name="varTicketTypeModel">票种信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool UpdateTicketType(SYS_TICKET_TYPE varTicketTypeModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("UPDATE SYS_TICKET_TYPE ");
tmpStrSql.Append("SET TICKET_TYPE_NAME=@TICKET_TYPE_NAME,TEAM_FLAG=@TEAM_FLAG,VALIDATE_TIMES=@VALIDATE_TIMES,LESS_FLAG=@LESS_FLAG,DAY_NIGHT_FLAG=@DAY_NIGHT_FLAG,DAY_VALIDATE_FLAG=@DAY_VALIDATE_FLAG,");
tmpStrSql.Append("PRICE=@PRICE,OPE_USER_ID=@OPE_USER_ID,OPE_TIME=@OPE_TIME,VERSION_NO=@VERSION_NO ");
tmpStrSql.Append("WHERE TICKET_TYPE_ID=@TICKET_TYPE_ID");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@TICKET_TYPE_ID", DbType.String, 2),
new SQLiteParameter("@TICKET_TYPE_NAME", DbType.String, 200),
new SQLiteParameter("@TEAM_FLAG", DbType.String, 1),
new SQLiteParameter("@VALIDATE_TIMES", DbType.Int32),
new SQLiteParameter("@LESS_FLAG", DbType.String, 1),
new SQLiteParameter("@DAY_NIGHT_FLAG", DbType.String, 1),
new SQLiteParameter("@DAY_VALIDATE_FLAG", DbType.String, 1),
new SQLiteParameter("@PRICE", DbType.Int32),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 50),
new SQLiteParameter("@OPE_TIME", DbType.DateTime),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varTicketTypeModel.TicketTypeId;
tmpParameters[1].Value = varTicketTypeModel.TicketTypeName;
tmpParameters[2].Value = varTicketTypeModel.TeamFlag;
tmpParameters[3].Value = varTicketTypeModel.ValidateTimes;
tmpParameters[4].Value = varTicketTypeModel.LessFlag;
tmpParameters[5].Value = varTicketTypeModel.DayNightFlag;
tmpParameters[6].Value = varTicketTypeModel.DayValidateFlag;
tmpParameters[7].Value = varTicketTypeModel.Price;
tmpParameters[8].Value = varTicketTypeModel.OpeUserId;
tmpParameters[9].Value = T_Date.ConvertLongToDateTime(varTicketTypeModel.OpeTime);
tmpParameters[10].Value = T_Date.ConvertLongToDateTime(varTicketTypeModel.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_TicketType), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 新增字典信息
/// </summary>
/// <param name="varEmpRegisterModel">字典信息信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertDictionary(SYS_DICTIONARY varDictionaryModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_DICTIONARY(");
tmpStrSql.Append("DICTIONARY_ID,KEY_CD,KEY_NAME,ITEM_CD,ITEM_NAME,ITEM_VAL,STAT,ORDER_NUM,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@DICTIONARY_ID,@KEY_CD,@KEY_NAME,@ITEM_CD,@ITEM_NAME,@ITEM_VAL,@STAT,@ORDER_NUM,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@DICTIONARY_ID", DbType.String, 60),
new SQLiteParameter("@KEY_CD", DbType.String, 100),
new SQLiteParameter("@KEY_NAME", DbType.String, 100),
new SQLiteParameter("@ITEM_CD", DbType.String, 100),
new SQLiteParameter("@ITEM_NAME", DbType.String, 100),
new SQLiteParameter("@ITEM_VAL", DbType.String, 500),
new SQLiteParameter("@STAT", DbType.String, 1),
new SQLiteParameter("@ORDER_NUM", DbType.Int32),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varDictionaryModel.DictionaryId;
tmpParameters[1].Value = varDictionaryModel.KeyCd;
tmpParameters[2].Value = varDictionaryModel.KeyName;
tmpParameters[3].Value = varDictionaryModel.ItemCd;
tmpParameters[4].Value = varDictionaryModel.ItemName;
tmpParameters[5].Value = varDictionaryModel.ItemVal;
tmpParameters[6].Value = varDictionaryModel.Stat;
tmpParameters[7].Value = varDictionaryModel.OrderNum;
tmpParameters[8].Value = T_Date.ConvertLongToDateTime(varDictionaryModel.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_Dictionary), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增票种检票规则信息
/// </summary>
/// <param name="varTicketTypeRule">票种检票规则信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertTicketTypeRule(SYS_TICKET_TYPE_RULE varTicketTypeRule, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_TICKET_TYPE_RULE(");
tmpStrSql.Append("RULE_ID,TICKET_TYPE_ID,BEGIN_DT,END_DT,BEGIN_TIME,END_TIME,OPE_USER_ID,OPE_TIME,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@RULE_ID,@TICKET_TYPE_ID,@BEGIN_DT,@END_DT,@BEGIN_TIME,@END_TIME,@OPE_USER_ID,@OPE_TIME,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@RULE_ID", DbType.String, 60),
new SQLiteParameter("@TICKET_TYPE_ID", DbType.String, 3),
new SQLiteParameter("@BEGIN_DT", DbType.DateTime),
new SQLiteParameter("@END_DT", DbType.DateTime),
new SQLiteParameter("@BEGIN_TIME", DbType.Int64),
new SQLiteParameter("@END_TIME", DbType.Int64),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 50),
new SQLiteParameter("@OPE_TIME", DbType.DateTime),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varTicketTypeRule.RuleId;
tmpParameters[1].Value = varTicketTypeRule.TicketTypeId;
tmpParameters[2].Value = T_Date.ConvertLongToDateTime(varTicketTypeRule.BeginDt);
tmpParameters[3].Value = T_Date.ConvertLongToDateTime(varTicketTypeRule.EndDt);
tmpParameters[4].Value = varTicketTypeRule.BeginTime;
tmpParameters[5].Value = varTicketTypeRule.EndTime;
tmpParameters[6].Value = varTicketTypeRule.OpeUserId;
tmpParameters[7].Value = T_Date.ConvertLongToDateTime(varTicketTypeRule.OpeTime);
tmpParameters[8].Value = T_Date.ConvertLongToDateTime(varTicketTypeRule.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_TicketTypeRule), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增参数信息
/// </summary>
/// <param name="varParemeterModel">参数信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertParemeter(SYS_PAREMETER varParemeterModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_PAREMETER(");
tmpStrSql.Append("PAREMETER_ID,PAREMETER_NAME,PAREMETER_VAL,OPE_USER_ID,OPE_TIME,PAREMETER_TYPE,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@PAREMETER_ID,@PAREMETER_NAME,@PAREMETER_VAL,@OPE_USER_ID,@OPE_TIME,@PAREMETER_TYPE,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@PAREMETER_ID", DbType.String, 60),
new SQLiteParameter("@PAREMETER_NAME", DbType.String, 100),
new SQLiteParameter("@PAREMETER_VAL", DbType.String, 100),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 50),
new SQLiteParameter("@OPE_TIME", DbType.DateTime),
new SQLiteParameter("@PAREMETER_TYPE", DbType.String, 1),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varParemeterModel.ParemeterId;
tmpParameters[1].Value = varParemeterModel.ParemeterName;
tmpParameters[2].Value = varParemeterModel.ParemeterVal;
tmpParameters[3].Value = varParemeterModel.OpeUserId;
tmpParameters[4].Value = T_Date.ConvertLongToDateTime(varParemeterModel.OpeTime);
tmpParameters[5].Value = varParemeterModel.ParemeterType;
tmpParameters[6].Value = T_Date.ConvertLongToDateTime(varParemeterModel.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_Paremeter), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增预售期信息
/// </summary>
/// <param name="varEmpRegisterModel">预售期信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/26</ Remark >
public bool InsertPeriod(SL_PERIOD varPeriodModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SL_PERIOD(");
tmpStrSql.Append("SALE_PERIOD_ID,TICKET_TYPE_ID,SALE_PERIOD_NAME,BEGIN_DT,END_DT,DISCOUNT_PRICE,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@SALE_PERIOD_ID,@TICKET_TYPE_ID,@SALE_PERIOD_NAME,@BEGIN_DT,@END_DT,@DISCOUNT_PRICE,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@SALE_PERIOD_ID", DbType.String, 60),
new SQLiteParameter("@TICKET_TYPE_ID", DbType.String, 3),
new SQLiteParameter("@SALE_PERIOD_NAME", DbType.String, 100),
new SQLiteParameter("@BEGIN_DT", DbType.DateTime),
new SQLiteParameter("@END_DT", DbType.DateTime),
new SQLiteParameter("@DISCOUNT_PRICE", DbType.Int64),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varPeriodModel.SalePeriodId;
tmpParameters[1].Value = varPeriodModel.TicketTypeId;
tmpParameters[2].Value = varPeriodModel.SalePeriodName;
tmpParameters[3].Value = T_Date.ConvertLongToDateTime(varPeriodModel.BeginDt);
tmpParameters[4].Value = T_Date.ConvertLongToDateTime(varPeriodModel.EndDt);
tmpParameters[5].Value = varPeriodModel.DiscountPrice;
tmpParameters[6].Value = T_Date.ConvertLongToDateTime(varPeriodModel.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_PERIOD), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增票种场馆信息
/// </summary>
/// <param name="varTicketTypeVenueModel">票种场馆信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertTicetTypeVenue(SYS_TICKET_TYPE_VENUE varTicketTypeVenueModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_TICKET_TYPE_VENUE(");
tmpStrSql.Append("TICKET_TYPE_ID,VENUE_ID,VERSION_NO,OPE_USER_ID,OPE_TIME)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@TICKET_TYPE_ID,@VENUE_ID,@VERSION_NO,@OPE_USER_ID,@OPE_TIME)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@TICKET_TYPE_ID", DbType.String, 3),
new SQLiteParameter("@VENUE_ID", DbType.Int32),
new SQLiteParameter("@VERSION_NO", DbType.DateTime),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 50),
new SQLiteParameter("@OPE_TIME", DbType.DateTime)
};
tmpParameters[0].Value = varTicketTypeVenueModel.TicketTypeId;
tmpParameters[1].Value = varTicketTypeVenueModel.VenueId;
tmpParameters[2].Value = T_Date.ConvertLongToDateTime(varTicketTypeVenueModel.VersionNo);
tmpParameters[3].Value = varTicketTypeVenueModel.OpeUserId;
tmpParameters[4].Value = T_Date.ConvertLongToDateTime(varTicketTypeVenueModel.OpeTime);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_TicketTyptVenue), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增员工通行场馆信息
/// </summary>
/// <param name="varEmpVenue">员工通行场馆信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/22</ Remark >
public bool InsertEmpVenue(SYS_EMP_VENUE varEmpVenue, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_EMP_VENUE(");
tmpStrSql.Append("EMP_VENUE_ID,EMP_ID,VENUE_ID,VERSION_NO)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@EMP_VENUE_ID,@EMP_ID,@VENUE_ID,@VERSION_NO)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@EMP_VENUE_ID", DbType.String, 50),
new SQLiteParameter("@EMP_ID", DbType.Int64),
new SQLiteParameter("@VENUE_ID", DbType.Int32),
new SQLiteParameter("@VERSION_NO", DbType.DateTime)
};
tmpParameters[0].Value = varEmpVenue.EmpVenueId;
tmpParameters[1].Value = varEmpVenue.EmpId;
tmpParameters[2].Value = varEmpVenue.VenueId;
tmpParameters[3].Value = T_Date.ConvertLongToDateTime(varEmpVenue.VersionNo);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_EmpVenue), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btn_GQ_Click(object sender, RoutedEventArgs e)
{
//*************************将所选票种张数，金额写入临时销售主表中**************
this.parent.mSelfHelpClass.OrderID = ""; //销售单号暂不生成 T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalTicket_Prefix_ZG, 1);//销售单号
T_SellTicketRecord.slorder.OrderId = this.parent.mSelfHelpClass.OrderID; //销售单号
T_SellTicketRecord.slorder.OrderType = T_SellTicketRecord.LocalTicket_Prefix_ZG; //销售类型 ZG 自助购票
// T_SellTicketRecord.slorder.TicketCount = this.parent.SelfHelpInfo.TicketCount;//销售张数
T_SellTicketRecord.slorder.DueSum = this.parent.mSelfHelpClass.DueSum; //应收金额
T_SellTicketRecord.slorder.RealSum = this.parent.mSelfHelpClass.RealSum; //实收金额
T_SellTicketRecord.slorder.Remark = "自助售票"; //订单说明
T_SellTicketRecord.slorder.PayStat = "1"; //支付状态(1-待支付 2-已支付 3-支付失败)
T_SellTicketRecord.slorder.SaleTime = T_Date.ConvertDataTimeToLong(DateTime.Now); //售票时间
T_SellTicketRecord.slorder.VersionNo = T_Date.ConvertDataTimeToLong(DateTime.Now); //版本号
T_SellTicketRecord.slorder.SaleUserId = Convert.ToString(M_Configuration.CLIENTID); //售票人存为终端编号
//*************************将所选票种张数，金额写入临时销售主表中**************
//******************将销售信息写入临时销售主表
#region//待删除
//if (T_SellTicketRecord.Inert_SL_ORDER_Temp(T_SellTicketRecord.slorder))
//{
// this.parent.Operation("gp4");
//}
//else
//{
// MessageBox.Show("票据信息保存失败！", T_SellTicketRecord.str_Apption, MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
#endregion
if (T_SellTicketRecord.Judge_TicketAlarmCount(this.parent.mSelfHelpClass.TicketTypeID, this.nCount))
{
MessageBox.Show("所购票数已超过当前票箱允许的售票数！", T_SellTicketRecord.str_Apption, MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
else
{
this.parent.Operation("gp4");
}
}
/// <summary>
/// 设置系统日期为服务器日期
/// </summary>
/// <param name="varClientId">终端编号</param>
/// <param name="varClientName">终端名称</param>
public bool SetSystemDT()
{
//调用rpc获取服务器时间
long tmpDateTime;
try
{
//获取服务器日期时间
tmpDateTime = _rpcClient.GetSystemDateTimeRpc();
//本地日期时间与服务器日期时间相差超过1min,设置本地日期时间
long tmpLocal = T_Date.ConvertDataTimeToLong(DateTime.Now);
long tmpSub = Math.Abs(tmpLocal - tmpDateTime);
if (tmpSub > 60000)
{
T_System.SetLocalTime(T_System.ConvertDateTimeToSystemTime(T_Date.ConvertLongToDateTime(tmpDateTime)));
}
}
catch (Exception ex)
{
_log.Error(typeof(B_BaseDataSync), ex);
return(false);
}
return(true);
}
/// <summary>
/// 场馆表同步(全量)
/// </summary>
/// <returns></returns>
public bool SysVenueSync()
{
#region
_log.Info("场馆表同步开始...");
//查询参数表版本号
M_SYNCRecord tmpSyncRecord = m_SyncRecord.QueryVersion("SYS_VENUE");
long tmpVersion = T_Date.ConvertDataTimeToLong(tmpSyncRecord.Version_no);
//调用rpc参数表下载接口
List <SYS_VENUE> tmpParemeter = null;
try
{
tmpParemeter = _rpcClient.VebueSyncRpc();
}
catch (Exception ex)
{
_log.Error("同步场馆表出错", ex);
return(false);
}
if (tmpParemeter.Count < 1 || tmpParemeter == null)
{
_log.Info("没有需要同步的数据!");
return(true);
}
//同步数据，只要有一条记录没有同步成功则失败,写到一个事务里
SQLiteConnection tmpConnect = null;
SQLiteCommand tmpCommand = null;
SQLiteTransaction tmpTrans = null;
try
{
tmpConnect = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString);
if (tmpConnect.State != ConnectionState.Open)
{
tmpConnect.Open();
}
tmpCommand = new SQLiteCommand();
tmpTrans = tmpConnect.BeginTransaction(IsolationLevel.ReadCommitted);
tmpCommand.Transaction = tmpTrans;
}
catch (Exception ex)
{
_log.Error(typeof(B_BaseDataSync), ex);
return(false);
}
if (!m_Venue.DEL_SYS_Venue(tmpCommand))
{
_log.Error("场馆表清空失败!");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
for (int i = 0; i < tmpParemeter.Count; i++)
{
if (!m_Venue.Inert_SYS_Venue(tmpParemeter[i], tmpCommand))
{
_log.Error("常规表插入失败! 参数编号[" + tmpParemeter[i].VenueId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
tmpTrans.Commit();
tmpConnect.Close();
//更新版本号
DateTime tmpLasterVersion = m_Paremeter.GetLasterVersion();
m_SyncRecord.UpdateVersion("SYS_Venue", tmpLasterVersion);
_log.Info("场馆表同步成功...");
return(true);
#endregion
}
/// <summary>
/// 预售期信息表下载(全量)
/// </summary>
/// <Remark>郝毅志，2017/06/26</ Remark >
public bool SalePeriodSync()
{
_log.Info("预售期表同步开始...");
//查询预售期表版本号
M_SYNCRecord tmpSyncRecord = m_SyncRecord.QueryVersion("SL_PERIOD");
long tmpVersion = T_Date.ConvertDataTimeToLong(tmpSyncRecord.Version_no);
//调用rpc预售期表下载接口
List <SL_PERIOD> tmpPeriod = null;
try
{
tmpPeriod = _rpcClient.SalePeriodSyncRpc(tmpVersion);
}
catch (Exception ex)
{
_log.Error("同步预售期表出错", ex);
return(false);
}
if (tmpPeriod.Count < 1 || tmpPeriod == null)
{
_log.Info("没有需要同步的数据!");
return(true);
}
//同步数据，只要有一条记录没有同步成功则失败,写到一个事务里
SQLiteConnection tmpConnect = null;
SQLiteCommand tmpCommand = null;
SQLiteTransaction tmpTrans = null;
try
{
tmpConnect = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString);
if (tmpConnect.State != ConnectionState.Open)
{
tmpConnect.Open();
}
tmpCommand = new SQLiteCommand();
tmpTrans = tmpConnect.BeginTransaction(IsolationLevel.ReadCommitted);
tmpCommand.Transaction = tmpTrans;
}
catch (Exception ex)
{
_log.Error(typeof(B_BaseDataSync), ex);
return(false);
}
if (!m_Period.CleartPeriod(tmpCommand))
{
_log.Error("预售期表清空失败!");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
for (int i = 0; i < tmpPeriod.Count; i++)
{
if (!m_Period.InsertPeriod(tmpPeriod[i], tmpCommand))
{
_log.Error("预售期表插入失败! 预售期编号[" + tmpPeriod[i].SalePeriodId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
tmpTrans.Commit();
tmpConnect.Close();
//更新版本号
DateTime tmpLasterVersion = m_Period.GetLasterVersion();
m_SyncRecord.UpdateVersion("SL_PERIOD", tmpLasterVersion);
_log.Info("预售表同步成功...");
return(true);
}
/// <summary>
/// 字典表下载(全量)
/// </summary>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool DictionarySync()
{
_log.Info("字典表同步开始...");
//查询字典表版本号
M_SYNCRecord tmpSyncRecord = m_SyncRecord.QueryVersion("SYS_DICTIONARY");
long tmpVersion = T_Date.ConvertDataTimeToLong(tmpSyncRecord.Version_no);
//调用rpc字典表下载接口
List <SYS_DICTIONARY> tmpDictionary = null;
try
{
tmpDictionary = _rpcClient.DictionarySyncRpc(tmpVersion);
}
catch (Exception ex)
{
_log.Error("同步字典表出错", ex);
return(false);
}
if (tmpDictionary.Count < 1 || tmpDictionary == null)
{
_log.Info("没有需要同步的数据!");
return(true);
}
//同步数据，只要有一条记录没有同步成功则失败,写到一个事务里
SQLiteConnection tmpConnect = null;
SQLiteCommand tmpCommand = null;
SQLiteTransaction tmpTrans = null;
try
{
tmpConnect = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString);
if (tmpConnect.State != ConnectionState.Open)
{
tmpConnect.Open();
}
tmpCommand = new SQLiteCommand();
tmpTrans = tmpConnect.BeginTransaction(IsolationLevel.ReadCommitted);
tmpCommand.Transaction = tmpTrans;
}
catch (Exception ex)
{
_log.Error(typeof(B_BaseDataSync), ex);
return(false);
}
if (!m_Dictionary.ClearDictionary(tmpCommand))
{
_log.Error("字典表清空失败!");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
for (int i = 0; i < tmpDictionary.Count; i++)
{
if (!m_Dictionary.InsertDictionary(tmpDictionary[i], tmpCommand))
{
_log.Error("字典表插入失败! 字典编号[" + tmpDictionary[i].DictionaryId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
tmpTrans.Commit();
tmpConnect.Close();
//更新版本号
DateTime tmpLasterVersion = m_Dictionary.GetLasterVersion();
m_SyncRecord.UpdateVersion("SYS_DICTIONARY", tmpLasterVersion);
_log.Info("字典表同步成功...");
return(true);
}
/// <summary>
/// 黑名单表下载(增量)
/// </summary>
/// <Remark>郝毅志，2017/06/23</ Remark >
public bool BlackListSync()
{
_log.Info("黑名单表同步开始...");
//查询黑名单表版本号
M_SYNCRecord tmpSyncRecord = m_SyncRecord.QueryVersion("SYS_BLACK_LIST");
long tmpVersion = T_Date.ConvertDataTimeToLong(tmpSyncRecord.Version_no);
//调用rpc黑名单表下载接口
List <SYS_BLACK_LIST> tmpBlackList = null;
try
{
tmpBlackList = _rpcClient.BlackListSyncRpc(tmpVersion);
}
catch (Exception ex)
{
_log.Error("同步黑名单表出错", ex);
return(false);
}
if (tmpBlackList.Count < 1 || tmpBlackList == null)
{
_log.Info("没有需要同步的数据!");
return(true);
}
//同步数据，只要有一条记录没有同步成功则失败,写到一个事务里
SQLiteConnection tmpConnect = null;
SQLiteCommand tmpCommand = null;
SQLiteTransaction tmpTrans = null;
try
{
tmpConnect = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString);
if (tmpConnect.State != ConnectionState.Open)
{
tmpConnect.Open();
}
tmpCommand = new SQLiteCommand();
tmpTrans = tmpConnect.BeginTransaction(IsolationLevel.ReadCommitted);
tmpCommand.Transaction = tmpTrans;
}
catch (Exception ex)
{
_log.Error("同步黑名单开启事务", ex);
return(false);
}
for (int i = 0; i < tmpBlackList.Count; i++)
{
//判断黑名单编号是否在表中存在
int tmpIsExist = m_BlackList.IsExist(tmpBlackList[i].BlackListId);
if (tmpIsExist == 1)
{
//存在，则更新
if (!m_BlackList.UpdateBlackList(tmpBlackList[i], tmpCommand))
{
_log.Error("黑名单更新失败! 黑名单编号[" + tmpBlackList[i].BlackListId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
else if (tmpIsExist == 2)
{
//不存在，则插入
if (!m_BlackList.InsertBlackList(tmpBlackList[i], tmpCommand))
{
_log.Error("黑名单插入失败! 黑名单编号[" + tmpBlackList[i].BlackListId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
else
{
//查询出错
_log.Error("查询SYS_BLACK_LIST表失败");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
tmpTrans.Commit();
tmpConnect.Close();
//更新版本号
DateTime tmpLasterVersion = m_BlackList.GetLasterVersion();
m_SyncRecord.UpdateVersion("SYS_BLACK_LIST", tmpLasterVersion);
_log.Info("黑名单表同步成功...");
return(true);
}
/// <summary>
/// 票种表下载(全量)
/// </summary>
/// <Remark>郝毅志，2017/06/23</ Remark >
public bool TicketTypeSync()
{
_log.Info("票种表同步开始...");
//查询员票种表版本号
M_SYNCRecord tmpSyncRecord = m_SyncRecord.QueryVersion("SYS_TICKET_TYPE");
long tmpVersion = T_Date.ConvertDataTimeToLong(tmpSyncRecord.Version_no);
//调用rpc票种表下载接口
List <SYS_TICKET_TYPE> tmpTicketType = null;
try
{
tmpTicketType = _rpcClient.TicketTypeSyncRpc(tmpVersion);
}
catch (Exception ex)
{
_log.Error("票种表同步错误", ex);
return(false);
}
if (tmpTicketType.Count < 1 || tmpTicketType == null)
{
_log.Info("没有需要同步的数据!");
return(true);
}
//同步数据，只要有一条记录没有同步成功则失败,写到一个事务里
SQLiteConnection tmpConnect = null;
SQLiteCommand tmpCommand = null;
SQLiteTransaction tmpTrans = null;
try
{
tmpConnect = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString);
if (tmpConnect.State != ConnectionState.Open)
{
tmpConnect.Open();
}
tmpCommand = new SQLiteCommand();
tmpTrans = tmpConnect.BeginTransaction(IsolationLevel.ReadCommitted);
tmpCommand.Transaction = tmpTrans;
}
catch (Exception ex)
{
_log.Error("同步票种时创建事务出错", ex);
return(false);
}
//先清空再插入
if (!m_TicketType.ClearTicketType(tmpCommand))
{
_log.Error("票种表清空失败! ");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
if (!m_TicketTypeRule.ClearTicketType(tmpCommand))
{
_log.Error("票种检票规则清空失败!");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
if (!m_TicketTypeVenue.ClearTicetTypeVenue(tmpCommand))
{
_log.Error("票种场馆清空失败! ");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
for (int i = 0; i < tmpTicketType.Count; i++)
{
if (!m_TicketType.InsertTicketType(tmpTicketType[i], tmpCommand))
{
_log.Error("票种表登录插入失败! 票种编号[" + tmpTicketType[i].TicketTypeId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
//同步处理票种检票规则
if (tmpTicketType[i].SysTicketTypeRulelist.Count > 0)
{
for (int j = 0; j < tmpTicketType[i].SysTicketTypeRulelist.Count; j++)
{
if (!m_TicketTypeRule.InsertTicketTypeRule(tmpTicketType[i].SysTicketTypeRulelist[j], tmpCommand))
{
_log.Error(
"票种检票规则插入失败! 规则编号[" + tmpTicketType[i].SysTicketTypeRulelist[j].RuleId + "]"
);
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
}
//同步处理票种场馆
if (tmpTicketType[i].SysTicketTypeVenuelist.Count > 0)
{
for (int j = 0; j < tmpTicketType[i].SysTicketTypeVenuelist.Count; j++)
{
if (!m_TicketTypeVenue.InsertTicetTypeVenue(tmpTicketType[i].SysTicketTypeVenuelist[j], tmpCommand))
{
_log.Error(
"票种场馆插入失败! 场馆编号[" + tmpTicketType[i].SysTicketTypeVenuelist[j].VenueId + "]"
);
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
}
}
tmpTrans.Commit();
tmpConnect.Close();
//更新版本号
DateTime tmpLasterVersion = m_TicketType.GetLasterVersion();
m_SyncRecord.UpdateVersion("SYS_TICKET_TYPE", tmpLasterVersion);
_log.Info("票种表同步成功...");
return(true);
}
/// <summary>
/// 员工卡登记表下载(增量)
/// </summary>
/// <Remark>郝毅志，2017/06/22</ Remark >
public bool EmpRegisterSync()
{
_log.Info("员工卡登记表同步开始...");
//查询员工卡登记表版本号
M_SYNCRecord tmpSyncRecord = m_SyncRecord.QueryVersion("SYS_EMP_REGISTER");
long tmpVersion = T_Date.ConvertDataTimeToLong(tmpSyncRecord.Version_no);
//调用rpc员工卡登记表下载接口
List <SYS_EMP_REGISTER> tmpEmpRegister = null;
try
{
tmpEmpRegister = _rpcClient.EmpRegisterSyncRpc(tmpVersion);
}
catch (Exception ex)
{
_log.Error("同步员工登记表错误", ex);
return(false);
}
if (tmpEmpRegister.Count < 1 || tmpEmpRegister == null)
{
_log.Info("没有需要同步的员工数据!");
return(true);
}
//同步数据，只要有一条记录没有同步成功则失败,写到一个事务里
SQLiteConnection tmpConnect = null;
SQLiteCommand tmpCommand = null;
SQLiteTransaction tmpTrans = null;
try {
tmpConnect = new SQLiteConnection(SQLiteHelper.LocalDbConnectionString);
if (tmpConnect.State != ConnectionState.Open)
{
tmpConnect.Open();
}
tmpCommand = new SQLiteCommand();
tmpTrans = tmpConnect.BeginTransaction(IsolationLevel.ReadCommitted);
tmpCommand.Transaction = tmpTrans;
}
catch (Exception ex) {
_log.Error("同步员工数据时开启事务失败", ex);
return(false);
}
for (int i = 0; i < tmpEmpRegister.Count; i++)
{
//判断员工是否在表中存在
int tmpIsExist = m_EmpRegister.IsExist(tmpEmpRegister[i].EmpId);
if (tmpIsExist == 1)
{
//存在，则更新
if (!m_EmpRegister.UpdateEmpRegister(tmpEmpRegister[i], tmpCommand))
{
_log.Error(
"员工卡登记表登录更新失败! 员工编号[" + tmpEmpRegister[i].EmpId + "]"
);
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
else if (tmpIsExist == 2)
{
//不存在，则插入
if (!m_EmpRegister.InsertEmpRegister(tmpEmpRegister[i], tmpCommand))
{
_log.Error(
"员工卡登记表登录插入失败! 员工编号[" + tmpEmpRegister[i].EmpId + "]"
);
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
else
{
//查询出错
_log.Error("查询SYS_EMP_REGISTER表失败");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
//通行场馆删除再插入
if (!m_EmpVenue.DeleteEmpVenue(tmpEmpRegister[i].EmpId, tmpCommand))
{
_log.Error("员工通行场馆表删除失败! 员工编号[" + tmpEmpRegister[i].EmpId + "]");
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
if (tmpEmpRegister[i].SysEmpVenuelist.Count > 0)
{
for (int j = 0; j < tmpEmpRegister[i].SysEmpVenuelist.Count; j++)
{
if (!m_EmpVenue.InsertEmpVenue(tmpEmpRegister[i].SysEmpVenuelist[j], tmpCommand))
{
_log.Error(
"员工通行场馆插入失败! 场馆编号[" + tmpEmpRegister[i].SysEmpVenuelist[j].EmpVenueId + "]"
);
tmpTrans.Rollback();
tmpConnect.Close();
return(false);
}
}
}
}
tmpTrans.Commit();
tmpConnect.Close();
//更新版本号
DateTime tmpLasterVersion = m_EmpRegister.GetLasterVersion();
m_SyncRecord.UpdateVersion("SYS_EMP_REGISTER", tmpLasterVersion);
_log.Error("员工卡登记表同步成功...");
return(true);
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
//this.parent.SelfHelpInfo.PayType = "alipay";
//this.parent.SelfHelpInfo.PayodNo = string.Empty;
//this.parent.SelfHelpInfo.PayRefNo = string.Empty;
//this.parent.SelfHelpInfo.PayTxnId = string.Empty;
//this.parent.SelfHelpInfo.PaySuccess = false;
//this.parent.SelfHelpInfo.PayReturnInfo = string.Empty;
// this.ticketDate.Text = this.parent.SelfHelpInfo.SaleTime;
//this.ticketCount.Text = this.parent.SelfHelpInfo.TicketCount.ToString();
//this.ticketType.Text = ConfigHelper.GetConfigValue("ticket", "t" + this.parent.SelfHelpInfo.TicketType);
//this.ticketPriceTotal.Text = this.parent.SelfHelpInfo.TicketPriceTotal.ToString();
//this.ticketTotal.Text = this.parent.SelfHelpInfo.TicketPriceTotal.ToString();
//********************************支付部分*****************************
this.parent.mSelfHelpClass.OperType = "0"; //取票还是购票 0表示购票 1表示取票 自助售票类
this.parent.mSelfHelpClass.PayType = "04"; //支付方式 自助售票类 01-现金,02-POS付款,03-微信，04-支付宝，05-代理
this.parent.mSelfHelpClass.PayStat = "1"; //支付状态(1-待支付 2-已支付 3-支付失败)
this.parent.mSelfHelpClass.PayTypeID = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalPayType_Prefix, 1); //支付单号 自助售票类
this.parent.mSelfHelpClass.PayID = string.Empty; //第三方支付单号 自助售票类
this.parent.mSelfHelpClass.PaySuccess = false; //是否支付成功 自助售票类
// this.ticketDate.Text = this.parent.mSelfHelpClass.SaleTime;//销售时间 自助售票类
this.ticketCount.Text = this.parent.mSelfHelpClass.TicketCount.ToString(); //票数 自助售票类
this.ticketType.Text = T_SellTicketRecord.GetTicketTypeName(this.parent.mSelfHelpClass.TicketTypeID); //票种 自助售票类
this.ticketPriceTotal.Text = this.parent.mSelfHelpClass.RealSum.ToString(); //销售金额 自助售票类
// this.ticketTotal.Text = this.parent.mSelfHelpClass.RealSum.ToString();//销售金额 自助售票类
//********************************支付部分*****************************
//********************支付部分***********************
T_SellTicketRecord.slpaytype.OrderId = this.parent.mSelfHelpClass.OrderID; //销售单号
T_SellTicketRecord.slpaytype.PayTypeId = this.parent.mSelfHelpClass.PayTypeID; //支付单号
T_SellTicketRecord.slpaytype.PayType = this.parent.mSelfHelpClass.PayType; //支付方式
T_SellTicketRecord.slpaytype.Amt = this.parent.mSelfHelpClass.RealSum; //支付金额
T_SellTicketRecord.slpaytype.VersionNo = T_Date.ConvertDataTimeToLong(DateTime.Now); //版本号
//***************获取支付方式*****************
//*******************写入数据***************************
this.parent.mSelfHelpClass.PayTypeID = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalPayType_Prefix, 1); //支付单号 自助售票类
this.parent.mSelfHelpClass.OrderID = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalTicket_Prefix_ZG, 1); //销售单号
this.parent.mSelfHelpClass.PayStat = "2"; //支付状态(1-待支付 2-已支付 3-支付失败)
if (!T_SellTicketRecord.Insert_GP_Data(this.parent.mSelfHelpClass))
{
_log.Error("支付宝购票数据写入失败！");
return;
}
//*******************写入数据***************************
this.odNo = ConfigHelper.GetConfigValue("pay", "odNoHead").PadLeft(2, '0') + ConfigHelper.GetConfigValue("window", "deviceNo").PadLeft(2, '0') + ConfigHelper.GetConfigValue("window", "busNo").PadLeft(2, '0') + DateTime.Now.ToString("yyMMddHHmmss");
//this.ss.SelectVoiceByHints(VoiceGender.Female);
//this.ss.SpeakAsync("使用支付宝扫一扫，扫描右侧二维码");
this.counttimer = new DispatcherTimer();
this.counttimer.Interval = new TimeSpan(0, 0, 0, 1, 0); //10秒支付时间
this.counttimer.Tick += new EventHandler(this.timer_Tick);
this.counttimer.Start();
this.inputBox.Focus();
//委托用
this.timer_test = new DispatcherTimer();
this.timer_test.Interval = new TimeSpan(0, 0, 0, 1, 0);
this.timer_test.Tick += new EventHandler(this.Timer_test);
this.timer_test.Start();
this.isre = false;
this.istest = false;
}
/// <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);
}
/// <summary>
/// 更新员工登记信息(同步下载处理)
/// </summary>
/// <param name="varEmpRegisterModel">员工登记信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/22</ Remark >
public bool UpdateEmpRegister(SYS_EMP_REGISTER varEmpRegisterModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("UPDATE SYS_EMP_REGISTER ");
tmpStrSql.Append("SET EMP_NAME=@EMP_NAME,CHIP_ID=@CHIP_ID,DEPARTMENT=@DEPARTMENT,PHOTO=@PHOTO,STAT=@STAT,CARD_TYPE=@CARD_TYPE,");
tmpStrSql.Append("CARD_ID=@CARD_ID,MAIL=@MAIL,GENDER=@GENDER,TEL=@TEL,VERSION_NO=@VERSION_NO,OPE_USER_ID=@OPE_USER_ID,OPE_TIME=@OPE_TIME ");
tmpStrSql.Append("WHERE EMP_ID=@EMP_ID");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@EMP_ID", DbType.Int64),
new SQLiteParameter("@EMP_NAME", DbType.String, 100),
new SQLiteParameter("@CHIP_ID", DbType.String, 20),
new SQLiteParameter("@DEPARTMENT", DbType.String, 100),
new SQLiteParameter("@PHOTO", DbType.Binary),
new SQLiteParameter("@STAT", DbType.String, 1),
new SQLiteParameter("@CARD_TYPE", DbType.String, 2),
new SQLiteParameter("@CARD_ID", DbType.String, 100),
new SQLiteParameter("@MAIL", DbType.String, 200),
new SQLiteParameter("@GENDER", DbType.String, 1),
new SQLiteParameter("@TEL", DbType.String, 15),
new SQLiteParameter("@VERSION_NO", DbType.DateTime),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 60),
new SQLiteParameter("@OPE_TIME", DbType.DateTime)
};
tmpParameters[0].Value = varEmpRegisterModel.EmpId;
tmpParameters[1].Value = varEmpRegisterModel.EmpName;
tmpParameters[2].Value = varEmpRegisterModel.ChipId;
tmpParameters[3].Value = varEmpRegisterModel.Department;
tmpParameters[4].Value = varEmpRegisterModel.Photo;
tmpParameters[5].Value = varEmpRegisterModel.Stat;
tmpParameters[6].Value = varEmpRegisterModel.CardType;
tmpParameters[7].Value = varEmpRegisterModel.CardId;
tmpParameters[8].Value = varEmpRegisterModel.Mail;
tmpParameters[9].Value = varEmpRegisterModel.Gender;
tmpParameters[10].Value = varEmpRegisterModel.Tel;
tmpParameters[11].Value = T_Date.ConvertLongToDateTime(varEmpRegisterModel.VersionNo);
tmpParameters[12].Value = varEmpRegisterModel.OpeUserId;
tmpParameters[13].Value = T_Date.ConvertLongToDateTime(varEmpRegisterModel.OpeTime);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_EmpRegister), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
return(false);
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
//this.parent.SelfHelpInfo.PayType = "weixin";
//this.parent.SelfHelpInfo.PayodNo = string.Empty;
//this.parent.SelfHelpInfo.PayRefNo = string.Empty;
//this.parent.SelfHelpInfo.PayTxnId = string.Empty;
//this.parent.SelfHelpInfo.PaySuccess = false;
//this.parent.SelfHelpInfo.PayReturnInfo = string.Empty;
//this.ticketDate.Text = this.parent.SelfHelpInfo.SaleTime;
//this.ticketCount.Text = this.parent.SelfHelpInfo.TicketCount.ToString();
//this.ticketType.Text = ConfigHelper.GetConfigValue("ticket", "t" + this.parent.SelfHelpInfo.TicketType);
//this.ticketPriceTotal.Text = this.parent.SelfHelpInfo.TicketPriceTotal.ToString();
//this.ticketTotal.Text = this.parent.SelfHelpInfo.TicketPriceTotal.ToString();//wjl
//**********************支付部分*********************
this.parent.mSelfHelpClass.OperType = "0"; //取票还是购票 0表示购票 1表示取票 自助售票类
this.parent.mSelfHelpClass.PayType = "03"; //支付方式 自助售票类 01-现金,02-POS付款,03-微信，04-支付宝，05-代理
this.parent.mSelfHelpClass.PayStat = "1"; //支付状态(1-待支付 2-已支付 3-支付失败)
this.parent.mSelfHelpClass.PayTypeID = ""; //支付单号暂不生成 T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalPayType_Prefix, 1);//支付单号 自助售票类
this.parent.mSelfHelpClass.PayID = string.Empty; //第三方支付单号 自助售票类
this.parent.mSelfHelpClass.PaySuccess = false; //是否支付成功 自助售票类
// this.ticketDate.Text = this.parent.mSelfHelpClass.SaleTime;//销售时间 自助售票类
this.ticketCount.Text = this.parent.mSelfHelpClass.TicketCount.ToString(); //票数 自助售票类
this.ticketType.Text = T_SellTicketRecord.GetTicketTypeName(this.parent.mSelfHelpClass.TicketTypeID); //票种 自助售票类
this.ticketPriceTotal.Text = this.parent.mSelfHelpClass.RealSum.ToString(); //销售金额 自助售票类
// this.ticketTotal.Text = this.parent.mSelfHelpClass.RealSum.ToString();//销售金额 自助售票类
//********************支付部分***********************
T_SellTicketRecord.slpaytype.OrderId = this.parent.mSelfHelpClass.OrderID; //销售单号
T_SellTicketRecord.slpaytype.PayTypeId = this.parent.mSelfHelpClass.PayTypeID; //支付单号
T_SellTicketRecord.slpaytype.PayType = this.parent.mSelfHelpClass.PayType; //支付方式
T_SellTicketRecord.slpaytype.Amt = this.parent.mSelfHelpClass.RealSum; //支付金额
T_SellTicketRecord.slpaytype.VersionNo = T_Date.ConvertDataTimeToLong(DateTime.Now); //版本号
//***************获取支付方式*****************
//*******************写入数据***************************
this.parent.mSelfHelpClass.PayTypeID = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalPayType_Prefix, 1); //支付单号 自助售票类
this.parent.mSelfHelpClass.OrderID = T_SellTicketRecord.CreateTableUID(M_Configuration.CLIENTID, T_SellTicketRecord.LocalTicket_Prefix_ZG, 1); //销售单号
this.parent.mSelfHelpClass.PayStat = "2"; //支付状态(1-待支付 2-已支付 3-支付失败)
if (!T_SellTicketRecord.Insert_GP_Data(this.parent.mSelfHelpClass))
{
_log.Error("微信支付数据写入失败！");
return;
}
//*******************写入数据***************************
//this.ss.SelectVoiceByHints(VoiceGender.Female);
//this.ss.SpeakAsync("使用微信扫一扫，扫描右侧二维码");
// this.parent.SelfHelpInfo.PaySuccess = false;
this.counttimer = new DispatcherTimer();
this.counttimer.Interval = new TimeSpan(0, 0, 0, 1, 0);
this.counttimer.Tick += new EventHandler(this.timer_Tick);
this.counttimer.Start();
this.inputBox.Focus();
this.timer_test = new DispatcherTimer();
this.timer_test.Interval = new TimeSpan(0, 0, 0, 1, 0);
this.timer_test.Tick += new EventHandler(this.test);
this.timer_test.Start();
this.isre = false;
this.istest = false;
//string str = AppDomain.CurrentDomain.BaseDirectory + "flash" + "\\f3.swf";
//this.web.Navigate(str);
}
/// <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>
/// <returns></returns>
public bool?TicketCheckSync()
{
DataTable dt = new DataTable();
SQLiteConnection sqliteConn = new SQLiteConnection(_dbConnString);
try
{
sqliteConn.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from SL_CHECK where version_no is null", sqliteConn);
da.Fill(dt);
}
catch (Exception ex)
{
_log.Error("读取待上传检票数据时异常！", ex);
return(false);
}
finally
{
if (sqliteConn.State == ConnectionState.Open)
{
sqliteConn.Close();
}
}
if (dt.Rows.Count == 0)
{
return(null);
}
bool rst = false;
try
{
List <SL_CHECK> upSL_Check = new List <SL_CHECK>();
foreach (DataRow dr in dt.Rows)
{
SL_CHECK checkRec = new SL_CHECK();
checkRec.VenueId = long.Parse(dr["venue_id"].ToString());
checkRec.CheckId = dr["check_id"].ToString();
checkRec.ClientId = int.Parse(dr["client_id"].ToString());
checkRec.ErrorCode = dr["error_code"].ToString();
checkRec.NopassReason = dr["nopass_reason"].ToString();
checkRec.OpeTime = T_Date.ConvertDataTimeToLong((DateTime)dr["ope_time"]);
checkRec.PassFlag = dr["pass_flag"].ToString();
checkRec.RemainTimes = int.Parse(dr["remain_times"].ToString());
checkRec.TicketClass = dr["ticket_class"].ToString();
checkRec.TicketId = long.Parse(dr["ticket_id"].ToString());
checkRec.TicketUid = dr["ticket_UID"].ToString();
upSL_Check.Add(checkRec);
}
rst = _rpcClient.UPTicketCheckRecord(upSL_Check);
}
catch (Exception ex)
{
_log.Error("检票记录上传失败！", ex);
return(false);
}
if (rst)
{
try
{
sqliteConn.Open();
SQLiteTransaction tran = sqliteConn.BeginTransaction();//实例化一个事务
try
{
SQLiteCommand cmd = new SQLiteCommand("update SL_CHECK set version_no=@version_no where check_id=@check_id", sqliteConn);
cmd.Parameters.Add("check_id", DbType.String, 30);
cmd.Parameters.Add("version_no", DbType.DateTime).Value = DateTime.Now;
foreach (DataRow dr in dt.Rows)
{
cmd.Parameters["check_id"].Value = dr["check_id"];
cmd.ExecuteNonQuery();
}
tran.Commit();
return(true);
}
catch (Exception ex)
{
_log.Error("检票记录上传成功，但更新本地数据库失败！", ex);
tran.Rollback();
return(false);
}
}
catch (Exception ex)
{
_log.Error("检票记录上传成功，但更新本地数据库失败！", ex);
return(false);
}
finally
{
if (sqliteConn.State == ConnectionState.Open)
{
sqliteConn.Close();
}
}
}
return(false);
}
/// <summary>
/// 新增终端信息
/// </summary>
/// <param name="varParemeterModel">终端信息实体</param>
/// <returns>true成功 false失败</returns>
/// <Remark>郝毅志，2017/06/24</ Remark >
public bool InsertClient(SYS_CLIENT varClientModel, SQLiteCommand varCommand)
{
StringBuilder tmpStrSql = new StringBuilder();
tmpStrSql.Append("INSERT INTO SYS_CLIENT(");
tmpStrSql.Append("CLIENT_ID,CLIENT_NAME,CLIENT_TYPE,REGION_ID,OUTLET_ID,IP_ADDR,PORT,STAT,GATE_MODE,RUN_STAT,REPORT_TIME,TOKEN,OPE_USER_ID,OPE_TIME)");
tmpStrSql.Append(" values (");
tmpStrSql.Append("@CLIENT_ID,@CLIENT_NAME,@CLIENT_TYPE,@REGION_ID,@OUTLET_ID,@IP_ADDR,@PORT,@STAT,@GATE_MODE,@RUN_STAT,@REPORT_TIME,@TOKEN,@OPE_USER_ID,@OPE_TIME)");
SQLiteParameter[] tmpParameters =
{
new SQLiteParameter("@CLIENT_ID", DbType.Int64),
new SQLiteParameter("@CLIENT_NAME", DbType.String, 200),
new SQLiteParameter("@CLIENT_TYPE", DbType.String, 1),
new SQLiteParameter("@REGION_ID", DbType.Int64),
new SQLiteParameter("@OUTLET_ID", DbType.Int64),
new SQLiteParameter("@IP_ADDR", DbType.String, 20),
new SQLiteParameter("@PORT", DbType.String, 20),
new SQLiteParameter("@STAT", DbType.String, 1),
new SQLiteParameter("@GATE_MODE", DbType.Int32),
new SQLiteParameter("@RUN_STAT", DbType.Int32),
new SQLiteParameter("@REPORT_TIME", DbType.DateTime),
new SQLiteParameter("@TOKEN", DbType.String, 100),
new SQLiteParameter("@OPE_USER_ID", DbType.String, 60),
new SQLiteParameter("@OPE_TIME", DbType.DateTime)
};
tmpParameters[0].Value = varClientModel.ClientId;
tmpParameters[1].Value = varClientModel.ClientName;
tmpParameters[2].Value = varClientModel.ClientType;
tmpParameters[3].Value = varClientModel.RegionId;
tmpParameters[4].Value = varClientModel.OutletId;
tmpParameters[5].Value = varClientModel.IpAddr;
tmpParameters[6].Value = varClientModel.Port;
tmpParameters[7].Value = varClientModel.Stat;
tmpParameters[8].Value = varClientModel.GateMode;
tmpParameters[9].Value = varClientModel.RunStat;
tmpParameters[10].Value = T_Date.ConvertLongToDateTime(varClientModel.ReportTime);
tmpParameters[11].Value = varClientModel.Token;
tmpParameters[12].Value = varClientModel.OpeUserId;
tmpParameters[13].Value = T_Date.ConvertLongToDateTime(varClientModel.OpeTime);
//执行命令配置
varCommand.CommandText = tmpStrSql.ToString();
varCommand.CommandType = CommandType.Text;
foreach (SQLiteParameter parm in tmpParameters)
{
varCommand.Parameters.Add(parm);
}
int tmpRows = 0;
try
{
tmpRows = varCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
_log.Error(typeof(D_Client), ex);
return(false);
}
if (tmpRows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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);
}
