示例#1
0
        /// <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);
        }
示例#2
0
        /// <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
        }