public static void InsertRecEntity(string guid,IssueRecEntity entity)
{
if (recEntity.Count == 0)
{
Init(capacity);
}
Dictionary<string, IssueRecEntity> dict = new Dictionary<string, IssueRecEntity>();
dict.Add(guid,entity);
recEntity[looper] = dict;
looper += 1;
if (looper > capacity - 1)
{
looper = 0;
}
}
private void PackageInstruct(Dictionary<string, string> newInstruct)
{
/* Data Struct
* data[0] Guid
* data[1] key count
* data[2] auth
* data[3] building
* data[4] room
* data[5] commdoors
* data[6] arrival
* data[7] departure
*/
InitData();
//发卡次数
string keycount = newInstruct["KT"];
if (keycount != string.Empty)
{
Data[1] = keycount;
}
//------初始化发卡数据-----
//楼号
Data[3] = Building_Addr;
//房号
string room = newInstruct["RN"];
Data[4] = room;
//VIP功能；
Data[5] = newInstruct["CD"];
//卡开始时间
string dateFormat = InstructMap["Date"];
string timeFormat = InstructMap["Time"];
string sDateTime = newInstruct["AD"] + "000000";
string format = dateFormat + "HHmmss";
DateTime dateTimeA = DateTime.ParseExact(sDateTime, format,
System.Globalization.CultureInfo.InvariantCulture);
Data[6] = string.Format("{0:yyyy-MM-dd hh:mm:ss}", dateTimeA);
//卡结束时间
string outTime;
switch (CheckOutType)
{
case "customize":
outTime = CheckOutTime;
timeFormat = "HH:mm:ss";
break;
case "interface":
outTime = newInstruct["CT"];
break;
default:
outTime = "235959";
timeFormat = "HHmmss";
break;
}
sDateTime = newInstruct["DD"] + outTime;
DateTime dateTimeB = DateTime.ParseExact(sDateTime, dateFormat + timeFormat,
System.Globalization.CultureInfo.InvariantCulture);
Data[7] = string.Format("{0:yyyy-MM-dd hh:mm:ss}", dateTimeB);
IssueRecEntity entity = new IssueRecEntity();
entity.RoomNumber = room;
entity.KeyCount = Data[1];
entity.KeyType = "New Key";
entity.OperateTime = "";
entity.Workstation = "";
entity.KeyCoder = newInstruct["KC"];
entity.GuestName = newInstruct["GN"];
entity.ArrivalDate = Data[6];
entity.DepartureDate = Data[7];
Manage.InsertRecEntity(Data[0], entity);
}
private bool InsertIssueRec(IssueRecEntity entity)
{
string sql = "insert into IssueRec (RoomNumber,KeyCount,KeyType,OperateTime,"
+ "Workstation,KeyCoder,GuestName,ArrivalDate,DepartureDate) "
+ "values (@RoomNumber,@KeyCount,@KeyType,@OperateTime,"
+ "@Workstation,@KeyCoder,@GuestName,@ArrivalDate,@DepartureDate)";
OleDbParameter[] parms = new OleDbParameter[]
{
new OleDbParameter("@RoomNumber",OleDbType.VarWChar),
new OleDbParameter("@KeyCount",OleDbType.VarWChar),
new OleDbParameter("@KeyType",OleDbType.VarWChar),
new OleDbParameter("@OperateTime",OleDbType.VarWChar),
new OleDbParameter("@Workstation",OleDbType.VarWChar),
new OleDbParameter("@KeyCoder",OleDbType.VarWChar),
new OleDbParameter("@GuestName",OleDbType.VarWChar),
new OleDbParameter("@ArrivalDate",OleDbType.VarWChar),
new OleDbParameter("@DepartureDate",OleDbType.VarWChar)
};
parms[0].Value = entity.RoomNumber;
parms[1].Value = entity.KeyCount;
parms[2].Value = entity.KeyType;
parms[3].Value = entity.OperateTime;
parms[4].Value = entity.Workstation;
parms[5].Value = entity.KeyCoder;
parms[6].Value = entity.GuestName;
parms[7].Value = entity.ArrivalDate;
parms[8].Value = entity.DepartureDate;
sqlHelper.CurrConn = Utils.DbType.Local;
try
{
sqlHelper.ExecuteNonQuery(sql, parms);
}
catch { return false; }
return true;
}
