private void InitCallLimit(CommonCar Car) { if (Car != null) { int num = 0; int num2 = 0; try { if (Car.carControlType.Trim().Length > 0) { num = int.Parse(Car.carControlType.Trim()); } if (Car.carControlMask.Trim().Length > 0) { num2 = int.Parse(Car.carControlMask.Trim()); } } catch { return; } if ((num & 1) != 0) { this.rdoCallInOpen.Checked = true; } else if ((num2 & 1) != 0) { this.rdoCallInLimit.Checked = true; if (Car.callInList != null) { this.txtCallIn.Text = Car.callInList.Replace("/", "\r\n"); } } else { this.rdoCallIn.Checked = true; } if ((num & 2) != 0) { this.rdoCallOutOpen.Checked = true; } else if ((num2 & 2) != 0) { this.rdoCallOutLimit.Checked = true; if (Car.callOutList != null) { this.txtCallOut.Text = Car.callOutList.Replace("/", "\r\n"); } } else { this.rdoCallIn.Checked = true; } if ((num & 4) != 0) { this.rdoRushOpen.Checked = true; } else if ((num2 & 4) != 0) { this.rdoRushClose.Checked = true; } else { this.rdoRush.Checked = true; } } }
private void InitCommArg(CommonCar Car) { this.cmbServerList.addItems("主服务器", "0"); this.cmbServerList.addItems("备份服务器", "1"); DataTable table = new DataTable(); DataColumn column = new DataColumn("Display"); DataColumn column2 = new DataColumn("Value"); table.Columns.AddRange(new DataColumn[] { column, column2 }); DataRow row = table.NewRow(); row[0] = "CMNET"; row[1] = "CMNET"; DataRow row2 = table.NewRow(); row2[0] = "CMWAP"; row2[1] = "CMWAP"; DataRow row3 = table.NewRow(); row3[0] = "CARD"; row3[1] = "CARD"; table.Rows.Add(row); table.Rows.Add(row2); table.Rows.Add(row3); this.cmbApnType.DataSource = table; if (Car == null) { this.cmbApnType_SelectedIndexChanged(new object(), new EventArgs()); } else { if (Car.carCommunicationType == "1") { this.rdoGprsCdma.Checked = true; } else if (Car.carCommunicationType == "2") { this.rdoMessage.Checked = true; } else { this.rdoMix.Checked = true; } if (Car.APNAddr != null) { this.cmbApnType.Text = Car.APNAddr; } this.txtUser.Text = Car.GPRSUser; this.txtPassword.Text = Car.GPRSPassword; this.txtTcpIp.Text = Car.TcpIP; this.txtTcpPort.Text = Car.TcpPort; this.txtUdpIp.Text = Car.UdpIP; this.txtUdpPort.Text = Car.UdpPort; this.chkSurrogate.Checked = Car.isUseProxy; this.txtSurrogateIp.Text = Car.AgentIP; this.txtSurrogatePort.Text = Car.AgentPort; if (Car.ServerType == 0) { this.cmbServerList.SelectedIndex = 0; } else { this.cmbServerList.SelectedIndex = 1; } } }
private void worker_DoWork(object sender, DoWorkEventArgs e) { string[] strArray = this.sCarId.Split(new char[] { ',' }); if (strArray.Length > 0) { m_CommonCar = RemotingClient.Car_GetCarDetailInfoByCarId(strArray[0]); this.dtCarConfig = RemotingClient.Car_GetCarConfig(strArray[0]); } }
private void InitCustomAlarm(CommonCar car) { string strCustName = ""; int iCarAlarmSwitch = 0; int iCarAlarmFlag = 0; int iShowAlarm = 0; int iCustLevel = 0; try { string pStrNum = car.cust_CarAlarmSwitch; string str2 = car.cust_CarAlarmFlag; string str3 = car.cust_ShowAlarm; string str4 = car.cust_level; strCustName = car.cust_Name; if (Check.isNumeric(pStrNum, Check.NumType.sInt)) { iCarAlarmSwitch = int.Parse(pStrNum); } if (Check.isNumeric(str2, Check.NumType.sInt)) { iCarAlarmFlag = int.Parse(str2); } if (Check.isNumeric(str3, Check.NumType.sInt)) { iShowAlarm = int.Parse(str3); } if (Check.isNumeric(str4, Check.NumType.sInt)) { iCustLevel = int.Parse(str4); } } catch { } this.SetChooseCustomAlarmIndex(iCarAlarmSwitch, iCarAlarmFlag, iShowAlarm, iCustLevel, strCustName); }
private void initControl() { string carId = MainForm.myCarList.SelectedCarId.Split(new char[] { ',' })[0]; CommonCar car = new CommonCar(); car = RemotingClient.Car_GetCarDetailInfoByCarId(carId); if (car != null) { this.lblAreaValue.Text = car.areaName; this.lblCarIdValue.Text = car.id.ToString(); this.lblCarNumValue.Text = car.carNum; this.lblSimNumValue.Text = car.tele; this.lblCarTypeValue.Text = car.carType; if (car.svrBeginTime.CompareTo(NullDate) != 0) { this.lblServerStartTimeValue.Text = string.Format("{0}", car.svrBeginTime.ToString()); } if (car.svrEndTime.CompareTo(NullDate) != 0) { this.lblServerEndTimeValue.Text = string.Format("{0}", car.svrEndTime.ToString()); } this.lblAheadDateValue.Text = car.awokeDays.ToString(); if (car.createTime.CompareTo(NullDate) != 0) { this.lblRegistrationTimeValue.Text = string.Format("{0}", car.createTime.ToString()); } this.lblColorValue.Text = car.CarColor; if (car.SimBeginTime.CompareTo(NullDate) != 0) { this.lblSimStartTimeValue.Text = string.Format("{0}", car.SimBeginTime.ToString()); } if (car.SimEndTime.CompareTo(NullDate) != 0) { this.lblSimEndTimeValue.Text = string.Format("{0}", car.SimEndTime.ToString()); } this.lblSimPasswordValue.Text = car.SIMpassport; DateTime now = DateTime.Now; bool result = false; if (bool.TryParse(this.lblServerEndTimeValue.Text, out result)) { if (Convert.ToDateTime(this.lblServerEndTimeValue.Text) >= DateTime.Now) { this.txtCarState.Text = "正常运营"; } else { this.txtCarState.Text = "停运"; } } else { this.txtCarState.Text = "正常运营"; } this.txtPlateColor.Text = car.CarColor; //去掉新版本不存在的东西 周立山 2014.1.16 //this.txtOperateTypeName.Text = car.OperateTypeName; this.lblTerminalTypeValue.Text = car.terminalName; this.lblTerminalVersionValue.Text = car.terminalSoftVersion; if (car.isSupportMSM) { this.lblSupportMsgValue.Text = "是"; } else { this.lblSupportMsgValue.Text = "否"; } if (car.isSupportGPRS) { this.lblSupportGprsValue.Text = "是"; } else { this.lblSupportGprsValue.Text = "否"; } if (car.isSupportCDMA) { this.lblSupportCdmaValue.Text = "是"; } else { this.lblSupportCdmaValue.Text = "否"; } this.txtTermSerial.Text = car.TermSerial; this.lblCarBrandValue.Text = car.CarModel; this.lblOwnerNameValue.Text = car.OwnerName; this.lblOwnerSimNumValue.Text = car.OwnerSimNum; this.lblOwnerEmailValue.Text = car.OwnerEmail; this.lblIdentityCardValue.Text = car.PersonID; this.lblAddressValue.Text = car.HomeAddress; this.lblCompanyValue.Text = car.CorpName; this.lblFirstLinkmanValue.Text = car.FirstConnectorName; this.lblFirstLinkmanTelValue.Text = car.FirstConnectTele; this.lblSecondLinkmanValue.Text = car.ConnectorName; this.lblSecondLinkmanTelValue.Text = car.ConnectTele; this.lblSteelGradeValue.Text = car.SteelGrade; this.lblDriverNameValue.Text = car.DrverName; this.lblDriverPhoneValue.Text = car.DriverPhone; this.lblRemarkValue.Text = car.Remark; } }
public CommonCar GetCarDetailInfoByCarId(string carId) { CommonCar car = new CommonCar(); string str = "select a.CarModel, a.CarColor, a.PlateColor, b.TermSerial, a.PersonID, a.HomeAddress, a.ConnectorName, a.FirstConnectTele,a.OtherCommunication, a.CorpName, a.ConnectTele, a.OwnerSimNum, a.OwnerEmail,a.CustomType, a.ReportCenterNum, a.DTMFAlarmNum, a.ListenRecordNum, a.HaveOwnTele,a.MedicalNum, a.RepairNum, a.HelpNum, a.Sex, a.PostCode, a.FirstConnectorName, a.APNAddr,a.GPRSUser, a.GPRSPassword, a.TcpIP, a.TcpPort, a.UdpIP, a.UdpPort, a.AgentIp, a.AgentPort,a.isUseProxy, a.carCommunicationType, a.carAlarmSwitch, a.carAlarmFlag,a.AlarmFlagType,a.AlarmFlagEx,a.CarAlarmSwitchEx,a.CarShowAlarmEx,a.isShowForm,a.callInLst, a.callOutLst, a.MobileCenter, a.carControlType, a.carControlMask,a.cust_carAlarmSwitch, a.cust_carAlarmFlag, a.cust_isShowForm, a.cust_level, a.cust_name, a.ServerType,b.carNum,b.simNum, b.CreateTime, b.OwnerName,b.Remark,b.SIMpassport, b.SVRStartTime, b.SVREndTime, b.SIMbeginTime,b.SIMendTime,b.PromptDays ,d.sms, d.gprs, d.cdma, d.name, e.SoftVersion, f.CarTypeName, c.areaName,a.FactoryPlateModel,g.[name] as drivername,g.telephone,g.LaborQualificationNo from GisCar b INNER JOIN GisCarInfoTable a ON a.CarID = b.CarID INNER JOIN GpsArea c ON b.AreaId = c.AreaID INNER JOIN GpsTerminalType d ON b.TerminalTypeID = d.TerminalTypeID INNER JOIN GpsProtocol e ON d.ProtocolCode = e.ProtocolCode INNER JOIN CarTypeTable f ON b.CarType = f.CarType left JOIN gpsdriver g on b.carid=g.carid where a.carID=" + carId; DataTable table = new SqlDataAccess().getDataBySql(str); if ((table != null) && (table.Rows.Count >= 1)) { DataRow row = table.Rows[0]; car.id = int.Parse(carId); car.carNum = row["carNum"] as string; car.tele = row["simNum"] as string; car.areaName = row["areaName"] as string; car.createTime = (DateTime) row["CreateTime"]; car.OwnerName = row["OwnerName"] as string; car.CarModel = row["CarModel"] as string; car.CarColor = row["CarColor"] as string; car.platecolor = row["PlateColor"] as string; //switch ((row["PlateColor"]==DBNull.Value)?0:int.Parse(row["PlateColor"].ToString())) //{ // case 1: // car.platecolor = "蓝色"; // break; // case 2: // car.platecolor = "黄色"; // break; // case 3: // car.platecolor = "黑色"; // break; // case 4: // car.platecolor = "白色"; // break; // case 9: // car.platecolor = "其他"; // break; // default: // car.platecolor = string.Empty; // break; //}; car.TermSerial = row["TermSerial"] as string; car.PersonID = row["PersonID"] as string; car.HomeAddress = row["HomeAddress"] as string; car.ConnectorName = row["ConnectorName"] as string; car.FirstConnectTele = row["FirstConnectTele"] as string; car.OtherCommunication = row["OtherCommunication"] as string; car.CorpName = row["CorpName"] as string; car.ConnectTele = row["ConnectTele"] as string; car.OwnerSimNum = row["OwnerSimNum"] as string; car.CustomType = row["CustomType"] as string; car.OwnerEmail = row["OwnerEmail"] as string; car.Remark = row["Remark"] as string; car.ReportCenterNum = row["ReportCenterNum"] as string; car.DTMFAlarmNum = row["DTMFAlarmNum"] as string; car.HaveOwnTele = row["HaveOwnTele"] as string; car.ListenRecordNum = row["ListenRecordNum"] as string; car.MedicalNum = row["MedicalNum"] as string; car.RepairNum = row["RepairNum"] as string; car.HelpNum = row["HelpNum"] as string; car.MobileCenterNum = row["MobileCenter"] as string; car.APNAddr = row["APNAddr"] as string; car.GPRSUser = row["GPRSUser"] as string; car.GPRSPassword = row["GPRSPassword"] as string; car.TcpIP = row["TcpIP"] as string; car.TcpPort = row["TcpPort"] as string; car.UdpPort = row["UdpPort"] as string; car.UdpIP = row["UdpIP"] as string; car.AgentIP = row["AgentIP"] as string; car.AgentPort = row["AgentPort"] as string; car.isUseProxy = (bool) row["isUseProxy"]; car.AlarmPathDot = ""; car.carCommunicationType = row["carCommunicationType"] as string; car.carControlType = row["carControlType"] as string; car.carControlMask = row["carControlMask"] as string; car.CarAlarmSwitch = row["carAlarmSwitch"] as string; car.CarAlarmFlag = row["CarAlarmFlag"] as string; car.ShowAlarm = row["isShowForm"] as string; car.AlarmFlagType = (row["AlarmFlagType"] == DBNull.Value) ? -1 : int.Parse(row["AlarmFlagType"].ToString()); car.CarAlarmFlagEx = (row["AlarmFlagEx"] == DBNull.Value) ? "" : row["AlarmFlagEx"].ToString(); car.CarAlarmSwitchEx = (row["CarAlarmSwitchEx"] == DBNull.Value) ? "" : row["CarAlarmSwitchEx"].ToString(); car.ShowAlarmEx = (row["CarShowAlarmEx"] == DBNull.Value) ? "" : row["CarShowAlarmEx"].ToString(); car.ServerType = (row["ServerType"] == DBNull.Value) ? -1 : int.Parse(row["ServerType"].ToString()); car.DrverName = (row["drivername"] == DBNull.Value) ? "" : row["drivername"].ToString(); car.DriverPhone = (row["telephone"] == DBNull.Value) ? "" : row["telephone"].ToString(); car.SteelGrade = (row["FactoryPlateModel"] == DBNull.Value) ? "" : row["FactoryPlateModel"].ToString(); car.callInList = row["callInLst"] as string; car.callOutList = row["callOutLst"] as string; if (row["SVRStartTime"] != DBNull.Value) { car.svrBeginTime = (DateTime) row["SVRStartTime"]; } if (row["SVREndTime"] != DBNull.Value) { car.svrEndTime = (DateTime) row["SVREndTime"]; } if (row["SIMbeginTime"] != DBNull.Value) { car.SimBeginTime = (DateTime) row["SIMbeginTime"]; } if (row["SIMendTime"] != DBNull.Value) { car.SimEndTime = (DateTime) row["SIMendTime"]; } if (row["PromptDays"] != DBNull.Value) { car.awokeDays = (int) row["PromptDays"]; } if (row["Sex"] == DBNull.Value) { car.Sex = this.method_2(3); } else { car.Sex = this.method_2(int.Parse(row["Sex"].ToString())); } car.PostCode = row["PostCode"] as string; car.FirstConnectorName = row["FirstConnectorName"] as string; car.regionDotStr = ""; car.terminalName = row["name"] as string; car.terminalSoftVersion = row["SoftVersion"] as string; car.isSupportMSM = (bool) row["sms"]; car.isSupportGPRS = (bool) row["gprs"]; car.isSupportCDMA = (bool) row["cdma"]; car.carType = row["carTypeName"] as string; try { car.cust_CarAlarmSwitch = row["cust_carAlarmSwitch"] as string; car.cust_CarAlarmFlag = row["cust_CarAlarmFlag"] as string; car.cust_ShowAlarm = row["cust_isShowForm"] as string; car.cust_level = row["cust_level"] as string; car.cust_Name = row["cust_name"] as string; car.SIMpassport = row["SIMpassport"] as string; } catch { } car.LaborQualificationNo = row["LaborQualificationNo"] as string; } return car; }
private void InitControl() { string sCarID = this.sCarID; CommonCar car = new CommonCar(); car = RemotingClient.Car_GetCarDetailInfoByCarId(sCarID); if (car != null) { this.lblAreaValue.Text = car.areaName; this.lblCarNumValue.Text = car.carNum; this.lblCarIdValue.Text = car.id.ToString(); this.lblSimNumValue.Text = car.tele; this.lblOwnerNameValue.Text = car.OwnerName; this.lblOwnerSimNumValue.Text = car.OwnerSimNum; this.lblCompanyValue.Text = car.CorpName; this.lblFirstLinkmanValue.Text = car.FirstConnectorName; this.lblFirstLinkmanTelValue.Text = car.FirstConnectTele; this.lblCarBrandValue.Text = car.CarModel; this.lblColorValue.Text = car.CarColor; this.lblSecondLinkmanValue.Text = car.ConnectorName; this.lblSecondLinkmanTelValue.Text = car.ConnectTele; this.lblIdentityCardValue.Text = car.PersonID; this.lblAddressValue.Text = car.HomeAddress; this.lblOwnerSimNumValue.Text = car.OwnerSimNum; this.lblOwnerSexValue.Text = car.Sex; this.lblPostCodeValue.Text = car.PostCode; } }