/// <summary>
/// 返回指定票种的票种实体
/// </summary>
/// <param name="tickettypeid">票种</param>
/// <returns></returns>
public static SYS_TICKET_TYPE GetTicketInfo(string tickettypeid)
{
SYS_TICKET_TYPE systickettype = new SYS_TICKET_TYPE();
try
{
SQLiteDataAdapter ada = new SQLiteDataAdapter("select * from SYS_TICKET_TYPE where TICKET_TYPE_ID='" + tickettypeid + "'", SQLiteHelper.LocalDbConnectionString);
DataSet ds = new DataSet();
ada.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
systickettype.TicketTypeId = ds.Tables[0].Rows[0]["TICKET_TYPE_ID"].ToString(); //票种编号
systickettype.TicketTypeName = ds.Tables[0].Rows[0]["TICKET_TYPE_NAME"].ToString(); //票种名称
systickettype.TeamFlag = ds.Tables[0].Rows[0]["TEAM_FLAG"].ToString(); //是否团体
systickettype.ValidateTimes = Convert.ToInt64(ds.Tables[0].Rows[0]["VALIDATE_TIMES"]); //可用次数
systickettype.LessFlag = ds.Tables[0].Rows[0]["LESS_FLAG"].ToString(); //是否优惠
systickettype.DayNightFlag = ds.Tables[0].Rows[0]["DAY_NIGHT_FLAG"].ToString(); //日夜场
systickettype.DayValidateFlag = ds.Tables[0].Rows[0]["DAY_VALIDATE_FLAG"].ToString(); //是否销售日当日有效
systickettype.Price = Convert.ToInt64(ds.Tables[0].Rows[0]["PRICE"]); //票价
}
}
catch (Exception ex)
{
_log.Error(typeof(T_SellTicketRecord), ex);
}
return(systickettype);
}
/// <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="tickettypeid">票种</param>
/// <param name="listtype">票种List</param>
/// <returns></returns>
public static SYS_TICKET_TYPE GetCurTicketTypeIDInfo(string tickettypeid, List <SYS_TICKET_TYPE> listtype)
{
SYS_TICKET_TYPE systickettype = new SYS_TICKET_TYPE();
try
{
for (int i = 0; i < listtype.Count - 1; i++)
{
if (listtype[i].TeamFlag == "N") //只售非团体票
{
if (listtype[i].TicketTypeId == tickettypeid)
{
systickettype = listtype[i];
}
}
}
}
catch (Exception ex)
{
_log.Error(typeof(T_GetCurTicketInfo), ex);
}
return(systickettype);
}
