public static CommonPara ReadCfg() { CommonPara commonPara = new CommonPara(); if (!File.Exists(Configfile)) { GenerateCfg(); } DataSet xmlset = new DataSet(); xmlset.ReadXml(Configfile); commonPara.StationGrade = xmlset.Tables["Common"].Rows[0]["StationGrade"].ToString(); commonPara.UpdateDataIntl = int.Parse(xmlset.Tables["Common"].Rows[0]["UpdateDataTime"].ToString()); SerialPara serialPara = new SerialPara { PortName = xmlset.Tables["SerialPort"].Rows[0]["PortName"].ToString(), BaudRate = int.Parse(xmlset.Tables["SerialPort"].Rows[0]["BaudRate"].ToString()), DataBits = int.Parse(xmlset.Tables["SerialPort"].Rows[0]["DataBits"].ToString()), StopBits = xmlset.Tables["SerialPort"].Rows[0]["StopBits"].ToString(), CheckBit = xmlset.Tables["SerialPort"].Rows[0]["CheckBit"].ToString() }; SqlServerPara sqlPara = new SqlServerPara { SqlIp = xmlset.Tables["SqlServer"].Rows[0]["Ip"].ToString(), SqlDb = xmlset.Tables["SqlServer"].Rows[0]["DataBase"].ToString(), SqlUser = xmlset.Tables["SqlServer"].Rows[0]["User"].ToString(), SqlPwd = xmlset.Tables["SqlServer"].Rows[0]["Password"].ToString(), }; StationPara stationParaPara = new StationPara(); if (xmlset.Tables.Contains("StationInfo")) { stationParaPara = new StationPara { StationId = xmlset.Tables["StationInfo"].Rows[0]["StationId"].ToString(), StationName = xmlset.Tables["StationInfo"].Rows[0]["StationName"].ToString(), Slong = xmlset.Tables["StationInfo"].Rows[0]["Slong"].ToString(), Slat = xmlset.Tables["StationInfo"].Rows[0]["Slat"].ToString(), }; } //x List<StationPara> lstStationPara = new List<StationPara>(); //x if (commonPara.StationGrade.Contains("省级")) //x { //x string conn = //x $"Data Source={sqlPara.SqlIp};Initial Catalog={sqlPara.SqlDb};User ID={sqlPara.SqlUser};Password={sqlPara.SqlPwd};"; //x RadarDataClassesDataContext radarDataContext = new RadarDataClassesDataContext(conn); //x var stations = (from s in radarDataContext.StationPara //x select s).Distinct().ToList(); //x for (int i = 0; i < xmlset.Tables["StationInfo"].Rows.Count; i++) //x { //x StationPara stationPara = new StationPara //x { //x StationId = xmlset.Tables["StationInfo"].Rows[i]["StationId"].ToString(), //x StationName = xmlset.Tables["StationInfo"].Rows[i]["StationName"].ToString(), //x Slong = xmlset.Tables["StationInfo"].Rows[i]["Slong"].ToString(), //x Slat = xmlset.Tables["StationInfo"].Rows[i]["Slat"].ToString(), //x }; //x lstStationPara.Add(stationPara); //x } //x } commonPara.SerialPortPara = serialPara; commonPara.SqlServerPara = sqlPara; commonPara.StationInfo = stationParaPara; //commonPara.StationList = lstStationPara; return(commonPara); }
private void btnEnter_Click(object sender, EventArgs e) { for (int i = 0; i < dgvStationList.RowCount; i++) { if (dgvStationList[0, dgvStationList.CurrentCell.RowIndex].Value != null && dgvStationList[0, dgvStationList.CurrentCell.RowIndex].Value.ToString() != string.Empty) { if (dgvStationList[1, dgvStationList.CurrentCell.RowIndex].Value == null || dgvStationList[1, dgvStationList.CurrentCell.RowIndex].Value.ToString() == string.Empty) { MessageBox.Show(@"站号必须输入", @"警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } } try { _para = new CommonPara { StationGrade = cmbGrade.SelectedItem.ToString(), UpdateDataIntl = (int)(nUdIntl.Value), SerialPortPara = { PortName = cmbSerialPort.SelectedItem.ToString(), BaudRate = int.Parse(cmbBaudRate.SelectedItem.ToString()), DataBits = int.Parse(cmbDataBits.SelectedItem.ToString()), StopBits = cmbStopBit.SelectedItem.ToString(), CheckBit = cmbCheckBit.SelectedItem.ToString() }, SqlServerPara = { SqlIp = tbSqlIp.Text, SqlDb = tbDataBase.Text, SqlUser = tbUser.Text, SqlPwd = tbPassword.Text }, }; if (_para.StationGrade.Contains("台站")) { if (dgvStationList[1, 0].Value != null && dgvStationList[1, 0].Value.ToString() != string.Empty) { StationPara station = new StationPara { StationId = dgvStationList[1, 0].Value.ToString(), StationName = dgvStationList[2, 0].Value.ToString(), Slong = dgvStationList[3, 0].Value.ToString(), Slat = dgvStationList[4, 0].Value.ToString() }; _para.StationInfo = station; } else { MessageBox.Show(@"请配置台站信息", @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } try { string conn = $"Data Source={_para.SqlServerPara.SqlIp};Initial Catalog={_para.SqlServerPara.SqlDb};User ID={_para.SqlServerPara.SqlUser};Password={_para.SqlServerPara.SqlPwd};"; DataBaseOperate.StationParaTable stationInfo = new DataBaseOperate.StationParaTable { ID = Guid.NewGuid(), StationID = _para.StationInfo.StationId, StationName = _para.StationInfo.StationName, Slong = _para.StationInfo.Slong, Slat = _para.StationInfo.Slat }; DataBaseHelper dbHelper = new DataBaseHelper(conn); dbHelper.StationParaInsertorUpdate(stationInfo); dbHelper.SaveChanges(); } catch (Exception exception) { MessageBox.Show(@"保存台站信息到远程数据库出错:" + Environment.NewLine + exception.Message, @"错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } Parameter.WriteCfg(_para); Close(); } catch (Exception exception) { CommonLogHelper.GetInstance("LogError").Error(@"保存参数文件出错", exception); MessageBox.Show(@"保存参数文件出错", @"错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }