/// <summary>
/// Saves the traninees information.
/// </summary>
/// <param name="license">The license.</param>
/// <returns></returns>
public static int SaveTranineesInfo(TrainLicense license)
{
if (license != null)
{
List <SQLiteParameter> cmdparams = new List <SQLiteParameter>
{
new SQLiteParameter("sfzmhm", license.PidNo),
new SQLiteParameter("currenttime", DateTime.Now.ToLocalTime().ToString()),
new SQLiteParameter("licenseinfo", JsonConvert.SerializeObject(license))
};
return(SqlLiteHelper.ExecuteNonQuery("insert into Traninees (sfzmhm,currenttime,licenseinfo) values (@sfzmhm,@currenttime,@licenseinfo)", cmdparams));
}
return(0);
}
/// <summary>
/// Saves the charges information.
/// </summary>
/// <param name="info">The information.</param>
/// <returns></returns>
public static int SaveChargesInfo(ChargesInfo info)
{
if (info != null)
{
List <SQLiteParameter> cmdparams = new List <SQLiteParameter>
{
new SQLiteParameter("sfzmhm", info.PidNo),
new SQLiteParameter("autoid", info.AutoId),
new SQLiteParameter("starttime", info.StartTime),
new SQLiteParameter("endtime", info.EndTime),
new SQLiteParameter("mode", info.Mode),
new SQLiteParameter("currentmileage", info.CurrentMileage),
new SQLiteParameter("currentminutes", info.CurrentMinutes),
new SQLiteParameter("surplustimes", info.SurplusTimes)
};
return(SqlLiteHelper.ExecuteNonQuery("insert into ChargeProcInfo (sfzmhm,autoid,starttime,endtime,mode,currentmileage,currentminutes,surplustimes) values (@sfzmhm,@autoid,@starttime,@endtime,@mode,@currentmileage,@currentminutes,@surplustimes)", cmdparams));
}
return(0);
}
