/// <summary>
/// 序列号的list
/// </summary>
/// <returns></returns>
public List <Mdl_BurnRecord> fML_SelectSNumber()
{
List <Mdl_BurnRecord> msendcardlist = new List <Mdl_BurnRecord>();
try
{
DataTable dt = asendcard.fM_SelectSNumber();
foreach (DataRow dr in dt.Rows)
{
Mdl_BurnRecord msendcard = new Mdl_BurnRecord();
msendcard.BR_V_UCardSerialNum = dr["BR_V_UCardSerialNum"].ToString();
msendcardlist.Add(msendcard);
}
}
catch (Exception ex)
{ }
return(msendcardlist);
}
/// <summary>
/// 添加已发卡片的记录
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public bool fB_BsetAdd(Mdl_BurnRecord BurnRecord)
{
#region
StringBuilder sbrSQL = new StringBuilder();
sbrSQL.Append("INSERT INTO TBL_D_BurnRecord");
sbrSQL.Append(" (BR_V_UCardSerialNum,BR_V_CardCode,BR_V_Name,BR_V_SerialNumber,BR_V_ProcessNumber,BR_I_SendTerminalId,BR_V_SendTerminal,BR_D_SendTime)");
sbrSQL.Append(" VALUES");
sbrSQL.Append(" ('" + BurnRecord.BR_V_UCardSerialNum + "'" + "," + "'" + BurnRecord.BR_V_CardCode + "'" + "," + "'" + BurnRecord
.BR_V_Name + "'" + "," + "'" + BurnRecord.BR_V_SerialNumber + "'" + "," + "'" + BurnRecord.BR_V_ProcessNumber + "'" + "," + "'"
+ BurnRecord.BR_I_SendTerminalId + "'" + "," + "'" + BurnRecord.BR_V_SendTerminal + "'" + "," + "'" + BurnRecord.BR_D_SendTime + "'" + ")");
sbrSQL.Append(" ; ");
int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sbrSQL.ToString());
if (i > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}