public void Clone(User user) { userID = user.userID; userName = user.userName; password = user.password; userType = user.userType; tel = user.tel; email = user.email; joinTime = user.joinTime; teamStr = user.teamStr; teams = user.teams; policyModTeam = user.policyModTeam; policyModCar = user.policyModCar; policyOrder = user.policyOrder; policyExportCars = user.policyExportCars; policyDeclare = user.policyDeclare; policyAlarmList = user.policyAlarmList; policyOverTime = user.policyOverTime; policyNotify = user.policyNotify; }
//��ʼ��ϵͳ���� private bool LoadInfoFromDB() { bool ret = false; dbm = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw); if(dbm != null) { try { //regionList.Clear(); teamList.Clear(); userList.Clear(); DataTable dt = null; /*dbm.ExecuteQuery("select_region"); foreach(DataRow dr in dt.Rows) { int id = Int32.Parse(dr[0].ToString()); String s = dr[1].ToString(); Region region = new Region(dr[2].ToString()); region.RegionID = id; region.RegionName = s; regionList.Add(region); }*/ dt = dbm.ExecuteQuery("select_team"); foreach(DataRow dr in dt.Rows) { Team team = new Team(); team.TeamID = Int32.Parse(dr[0].ToString()); team.Password = dr[1].ToString(); team.TeamName = dr[2].ToString(); team.TeamLinkman = dr[3].ToString(); team.TeamTel = dr[4].ToString(); team.TeamAddress = dr[5].ToString(); team.JoinTime = dr[6].ToString(); team.PolicyModCar = Int32.Parse(dr[7].ToString()); team.PolicyOrder = Int32.Parse(dr[8].ToString()); team.PolicyRegion = Int32.Parse(dr[9].ToString()); team.PolicyRegionAlarm = Int32.Parse(dr[10].ToString()); teamList.Add(team); } dt = dbm.ExecuteQuery("select_car"); foreach(DataRow dr in dt.Rows) { Car car = Car.ParseWithPosition(dr); if(car != null) { //if(car.RegionID != 0) //car.Region = GetRegionByID(car.RegionID); car.Team = GetTeamByID(car.TeamID); car.Team.Cars.Add(car); } } dt = dbm.ExecuteQuery("select_user"); foreach(DataRow dr in dt.Rows) { User user = new User(); user.UserID = Int32.Parse(dr[0].ToString()); user.UserName = dr[1].ToString(); user.Password = dr[2].ToString(); user.UserType = Int32.Parse(dr[3].ToString()); user.Tel = dr[4].ToString(); user.Email = dr[5].ToString(); user.JoinTime = dr[6].ToString(); if(user.UserType != User.USER_ADMIN) { user.Teams = new List<Team>(); String ts = dr[7].ToString(); if(ts.Length > 0) { if(ts[0] == Constant.SPLIT_EX_1) ts = ts.Substring(1); if(ts[ts.Length - 1] == Constant.SPLIT_EX_1) ts = ts.Substring(0, ts.Length - 1); } if(ts != null && ts != "") { user.TeamStr = ts; String[] temp = ts.Split(Constant.SPLIT_EX_1); foreach(String s in temp) { if(s == null || s == "") continue; try { Team team = GetTeamByID(Int32.Parse(s)); if(team != null) user.Teams.Add(team); } catch { } } } else user.TeamStr = ""; user.PolicyModTeam = Int32.Parse(dr[8].ToString()); user.PolicyModCar = Int32.Parse(dr[9].ToString()); user.PolicyOrder = Int32.Parse(dr[10].ToString()); user.PolicyExportCars = Int32.Parse(dr[11].ToString()); user.PolicyDeclare = Int32.Parse(dr[12].ToString()); user.PolicyAlarmList = Int32.Parse(dr[13].ToString()); user.PolicyOverTime = Int32.Parse(dr[14].ToString()); user.PolicyNotify = Int32.Parse(dr[15].ToString()); } else { user.Teams = teamList; } userList.Add(user); } dt = dbm.ExecuteQuery("select_alarm"); foreach(DataRow dr in dt.Rows) { AlarmPosition apos = new AlarmPosition(); apos.Id = Int32.Parse(dr[0].ToString()); apos.CarID = Int32.Parse(dr[1].ToString()); apos.GpsTime = dr[2].ToString(); apos.Pointed = Int32.Parse(dr[3].ToString()); apos.Lo = Double.Parse(dr[4].ToString()); apos.La = Double.Parse(dr[5].ToString()); apos.Speed = Int32.Parse(dr[6].ToString()); apos.Direction = Int32.Parse(dr[7].ToString()); apos.Status = dr[8].ToString(); apos.Alarm = dr[9].ToString(); //GetCarByID(apos.CarID).AlarmPos.Add(apos); ��������Ի��� } dt = dbm.ExecuteQuery("select carID from tDeclare where opUser=''"); foreach(DataRow dr in dt.Rows) { try { GetCarByID(Int32.Parse(dr[0].ToString())).DeclareCount++; } catch{} } ret = true; } catch(Exception e) { if(FormMain.LOG_ERR) logger.AddErr(e, ""); } } inited = ret; return ret; }
public static User Parse(String s) { User user = new User(); String[] ss = s.Split(Constant.SPLIT2); user.userID = Int32.Parse(ss[0]); user.userName = ss[1]; user.password = ss[2]; user.userType = Int32.Parse(ss[3]); user.tel = ss[4]; user.email = ss[5]; if(ss[6] == "") user.joinTime = Pub.DateTimeStr; else user.joinTime = ss[6]; user.teamStr = ss[7]; user.policyModTeam = Int32.Parse(ss[8]); user.policyModCar = Int32.Parse(ss[9]); user.policyOrder = Int32.Parse(ss[10]); user.policyExportCars = Int32.Parse(ss[11]); user.policyDeclare = Int32.Parse(ss[12]); user.policyAlarmList = Int32.Parse(ss[13]); user.policyOverTime = Int32.Parse(ss[14]); user.policyNotify = Int32.Parse(ss[15]); return user; }