/// <summary>
/// 保存刷卡记录
/// </summary>
/// <param name="objData">刷卡实体</param>
private void SaveSwipingCardData(SwipingCardData objData)
{
if (objData != null)
{
try
{
IDAL.ICardLog objDAL = DALFactory.DALFactory.CardLog();
int iNewID = objDAL.Add(objData, out string strErrInfo);
if (!string.IsNullOrEmpty(strErrInfo))
{
DoNotice(string.Format("保存刷卡记录失败，错误原因：\r\n{0}", strErrInfo));
}
}
catch (Exception err)
{
DoNotice(string.Format("保存刷卡记录失败，错误原因：\r\n{0}", err.Message));
}
}
}
/// <summary>
/// 绑定数据到列表
/// </summary>
/// <param name="selNum">数据条数</param>
/// <param name="sqlWhereAndOrderBy">条件</param>
protected override void BindLVData(int selNum = 0, string sqlWhereAndOrderBy = null)
{
this.lvContent.BeginUpdate();
this.lvContent.Items.Clear();
try
{
if (selNum <= 0)
{
selNum = this.DefaultPageSize;
}
if (string.IsNullOrEmpty(sqlWhereAndOrderBy) || sqlWhereAndOrderBy.Equals(""))
{
sqlWhereAndOrderBy = "1=1";
}
this.CurrentSqlWhere = sqlWhereAndOrderBy;
IList <CardLog> listData = null;
IDAL.ICardLog objDAL = DALFactory.DALFactory.CardLog();
listData = objDAL.GetListByWhere(selNum, sqlWhereAndOrderBy);
if (!(listData == null || listData.Count <= 0))
{
foreach (CardLog model in listData)
{
//序号,50|刷卡时间,130|卡号,80|卡片类型,70|有效期,100|设备类型,100|设备号,100|小区编码,60|楼栋编码,60|单元编码,60|房间编码,80|卡片系列号,210|持卡者姓名,100|联系电话,100|所在房间,100|所在单元,100|所在楼栋,100|所在小区,120
ListViewItem item = new ListViewItem(new string[] { Convert.ToString(lvContent.Items.Count + 1), Functions.ConvertToNormalTime(model.CreateDate).ToString(Config.LongTimeFormat), model.CardNo.ToString(), model.CardTypeDesc, ((model.CardNo <= 0 || (model.CardType < 0 || model.CardType > 2)) ? "未知" : Functions.ConvertToNormalTime(model.ExpiryDate).ToString(Config.TimeFormat))
, model.DeviceTypeDesc, model.DeviceNo, ((model.RAreaCode >= 0) ? FormatBuildingCode(model.RAreaCode) : ""), ((model.RBuildCode >= 0) ? FormatBuildingCode(model.RBuildCode) : ""), ((model.RUnitCode >= 0) ? FormatBuildingCode(model.RUnitCode) : ""), ((model.RRoomCode >= 0) ? FormatRoomCode(model.RRoomCode) : ""), model.SerialNo, model.Contact, model.Tel,
model.RoomName, model.UnitName, model.BuildName, model.AreaName })
{
Tag = model,
Font = new Font("宋体", 9, FontStyle.Regular)
};
this.lvContent.Items.Add(item);
}
}
}
catch (Exception err)
{
CMessageBox.ShowWaring(err.Message, Config.DialogTitle);
}
this.lvContent.EndUpdate();
}
