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; }