public void addChartEvolutionSeries(Eleve eleve, Matiere matiere) { Series s = new Series { ChartType = SeriesChartType.Line }; s.BorderWidth = 3; int i = 0; s.IsValueShownAsLabel = true; s.Name = matiere.intitule; Login.read = DBConnect.Gets(string.Format("SELECT avg(note), titre FROM examiner where id_etudiant = {0} and id_groupe = {1} and id_matiere = {2} group by titre order by titre", eleve.id, this.id_class, matiere.id)); while (Login.read.Read()) { s.Points.AddXY(Login.read[1].ToString(), Math.Round(float.Parse(Login.read[0].ToString()), 2)); s.Points[i].MarkerSize = 9; s.Points[i++].MarkerStyle = MarkerStyle.Circle; } Login.read.Close(); this.c.Series.Add(s); MaterialSkin.Controls.MaterialCheckBox b = new MaterialSkin.Controls.MaterialCheckBox(); b.Text = s.Name; b.Checked = true; this.series_bs.Add(b); b.CheckedChanged += B_Click; }
private bool initPrivateSetting() { if (setting == null) { setting = new TaskGroup_GetUrlsByKeywords_Setting(); } MaterialSkin.Controls.MaterialCheckBox t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox_GetRank", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsGetBaiduRank = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox_TopLevelDomain", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsTopLevelDomain = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox5", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseBaiduSearch = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox6", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUse360Search = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox7", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseSougouSearch = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox8", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseBingSearch = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox9", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseShenmaSearch = t.Checked; } t = ((TaskGroup_GetUrlsByKeywords_Form)uiPanel).Controls.Find("materialCheckBox10", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseGoogleSearch = t.Checked; } return(true); }
private bool initPrivateSetting() { if (setting == null) { setting = new TaskGroup_GetSimilarKeywords_Setting(); } MaterialSkin.Controls.MaterialCheckBox t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox_GetRank", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsGetBaiduRank = t.Checked; } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox_StopUntilCount", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsStopUntilCount = t.Checked; } MaterialSkin.Controls.MaterialSingleLineTextField l = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialSingleLineTextField_StopUntilCount", true).FirstOrDefault() as MaterialSkin.Controls.MaterialSingleLineTextField; if (l != null) { setting.StopCount = Convert.ToInt32(l.Text); if (setting.StopCount <= 0) { setting.IsStopUntilCount = false; } } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox5", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseBaiduSearch = t.Checked; } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox6", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUse360Search = t.Checked; } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox7", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseSougouSearch = t.Checked; } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox8", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseBingSearch = t.Checked; } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox9", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseShenmaSearch = t.Checked; } t = ((TaskGroup_GetSimilarKeywords_Form)uiPanel).Controls.Find("materialCheckBox10", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsUseGoogleSearch = t.Checked; } return(true); }
public void incluir(MaterialSkin.Controls.MaterialSingleLineTextField txtNome, MaterialSkin.Controls.MaterialCheckBox checkAtivo, MaterialSkin.Controls.MaterialSingleLineTextField txtEstoque, RichTextBox txtDescricao, MaterialSkin.Controls.MaterialSingleLineTextField txtPreco, MaterialSkin.Controls.MaterialSingleLineTextField txtTamanho, PictureBox pcbFoto, PictureBox pcbLoading) { Cursor.Current = Cursors.WaitCursor; try { Conexao objConexao = new Conexao(); objConexao.ConexaoDB(); var objDados = objConexao.objDados; var objCmd = objConexao.objComando; var objCnx = objConexao.objConect; int ativo = 0; objCnx.Close(); objCnx.Open(); if (checkAtivo.Checked == true) { ativo = 1; } else { ativo = 0; } string sql_Select = "INSERT INTO produtos (nomeProd, estoque, tamanho, descricao, ativo, foto, preco) " + "values ('" + txtNome.Text + "','" + txtEstoque.Text + "','" + txtTamanho.Text + "', '" + txtDescricao.Text + "','" + ativo + "', @foto, '" + txtPreco.Text + "')"; objCmd.Parameters.AddWithValue("@foto", classUtil.PreparaFoto(pcbFoto.Image)); objCmd.CommandText = sql_Select; objCmd.Connection = objCnx; objDados = objCmd.ExecuteReader(); if (objDados.RecordsAffected > 0) { MessageBox.Show("Incluído com sucesso !"); pcbLoading.Visible = false; } else { MessageBox.Show("Falha na inclusão !"); pcbLoading.Visible = false; } objCnx.Close(); Cursor.Current = Cursors.Default; } catch (Exception e) { MessageBox.Show("Erro ->" + e.Message); pcbLoading.Visible = false; Cursor.Current = Cursors.Default; } }
public void montaSelect(int id, MaterialSkin.Controls.MaterialSingleLineTextField txtId, MaterialSkin.Controls.MaterialSingleLineTextField txtNome, MaterialSkin.Controls.MaterialCheckBox checkAtivo, MaterialSkin.Controls.MaterialSingleLineTextField txtEstoque, RichTextBox txtDescricao, MaterialSkin.Controls.MaterialSingleLineTextField txtPreco, MaterialSkin.Controls.MaterialSingleLineTextField txtTamanho, PictureBox pcbFoto) { Cursor.Current = Cursors.WaitCursor; try { Conexao objConexao = new Conexao(); objConexao.ConexaoDB(); var objDados = objConexao.objDados; var objCmd = objConexao.objComando; var objCnx = objConexao.objConect; objCnx.Close(); objCnx.Open(); string sql_Select = "SELECT * FROM produtos WHERE id = " + id; objCmd.CommandText = sql_Select; objCmd.Connection = objCnx; objDados = objCmd.ExecuteReader(); if (!objDados.HasRows) { MessageBox.Show("Não há dados para exibir!"); } else { while (objDados.Read()) { if (objDados["ativo"].ToString() == "1") { checkAtivo.Checked = true; } txtEstoque.Text = objDados["estoque"].ToString(); txtId.Text = objDados["id"].ToString(); txtNome.Text = objDados["nomeProd"].ToString(); txtPreco.Text = objDados["preco"].ToString(); txtDescricao.Text = objDados["descricao"].ToString(); txtTamanho.Text = objDados["tamanho"].ToString(); if (objDados["foto"].ToString() != "") { byte[] imgbyte1 = (byte[])objDados["foto"]; try { pcbFoto.Image = classUtil.RecuperaImagem(imgbyte1); } catch { MessageBox.Show("Imagem 1 com problema na abertura", "Imagem", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } objCnx.Close(); Cursor.Current = Cursors.Default; } catch (Exception e) { MessageBox.Show("Erro ->" + e.Message); Cursor.Current = Cursors.Default; } }
public void atualizar(MaterialSkin.Controls.MaterialSingleLineTextField txtId, MaterialSkin.Controls.MaterialSingleLineTextField txtNome, MaterialSkin.Controls.MaterialCheckBox checkAtivo, MaterialSkin.Controls.MaterialSingleLineTextField txtEstoque, RichTextBox txtDescricao, MaterialSkin.Controls.MaterialSingleLineTextField txtPreco, MaterialSkin.Controls.MaterialSingleLineTextField txtTamanho, PictureBox pcbFoto) { Cursor.Current = Cursors.WaitCursor; try { Conexao objConexao = new Conexao(); objConexao.ConexaoDB(); var objDados = objConexao.objDados; var objCmd = objConexao.objComando; var objCnx = objConexao.objConect; int ativo = 0; objCnx.Close(); objCnx.Open(); if (checkAtivo.Checked == true) { ativo = 1; } else { ativo = 0; } string sql_Select = "UPDATE produtos SET nomeProd = '" + txtNome.Text + "', ativo = '" + ativo + "', estoque = '" + txtEstoque.Text + "', tamanho = '" + txtTamanho.Text + "', descricao = '" + txtDescricao.Text + "', preco = '" + txtPreco.Text + "', foto = @foto WHERE id = '" + txtId.Text + "'"; objCmd.Parameters.AddWithValue("@foto", classUtil.PreparaFoto(pcbFoto.Image)); objCmd.CommandText = sql_Select; objCmd.Connection = objCnx; objDados = objCmd.ExecuteReader(); if (objDados.RecordsAffected > 0) { MessageBox.Show("Atualizado com sucesso !"); } else { MessageBox.Show("Falha na atualização !"); } objCnx.Close(); Cursor.Current = Cursors.Default; } catch (Exception e) { MessageBox.Show("Erro ->" + e.Message); Cursor.Current = Cursors.Default; } }
public void limpaCampos(MaterialSkin.Controls.MaterialSingleLineTextField txtCodigo, MaterialSkin.Controls.MaterialSingleLineTextField txtNome, MaterialSkin.Controls.MaterialCheckBox checkAtivo, MaterialSkin.Controls.MaterialSingleLineTextField txtEstoque, RichTextBox txtDescricao, MaterialSkin.Controls.MaterialSingleLineTextField txtPreco, MaterialSkin.Controls.MaterialSingleLineTextField txtTamanho, PictureBox pcbFoto) { txtNome.Text = ""; txtCodigo.Text = ""; txtEstoque.Text = ""; txtDescricao.Text = ""; txtPreco.Text = ""; txtTamanho.Text = ""; pcbFoto.Image = null; checkAtivo.Checked = false; }
private bool initPrivateSetting() { if (setting == null) { setting = new TaskGroup_FileCheck_Setting(); } MaterialSkin.Controls.MaterialCheckBox t = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("materialCheckBox1", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsShow301302 = t.Checked; } t = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("materialCheckBox2", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsShow500 = t.Checked; } t = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("materialCheckBox3", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsGetServerType = t.Checked; } t = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("materialCheckBox4", true).FirstOrDefault() as MaterialSkin.Controls.MaterialCheckBox; if (t != null) { setting.IsGetMiddleWare = t.Checked; } MaterialSkin.Controls.MaterialRadioButton rd = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("materialRadioButton1", true).FirstOrDefault() as MaterialSkin.Controls.MaterialRadioButton; if (rd != null && rd.Checked) { setting.ScanType = ENUM_ScanType.eScanType_Head; } rd = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("materialRadioButton2", true).FirstOrDefault() as MaterialSkin.Controls.MaterialRadioButton; if (rd != null && rd.Checked) { setting.ScanType = ENUM_ScanType.eScanType_Get; } CheckedListBox clb = ((TaskGroup_FileCheck_Form)uiPanel).Controls.Find("checkedListBox_dict", true).FirstOrDefault() as CheckedListBox; if (clb.SelectedItems.Count <= 0) { MessageBox.Show("请选择扫描字典!"); return(false); } // 合并字典 suffixDirs.Clear(); foreach (String dir in clb.CheckedItems) { String cdir = dir.Split('|')[0]; List <String> clist = null; Boolean isget = dirs.TryGetValue(cdir, out clist); foreach (String scanDir in clist) { if (!suffixDirs.Contains(scanDir)) { suffixDirs.Add(scanDir); } } } return(true); }
public void Init(List <Pollution> pollutions) { //pollutions = new List<Pollution>() //{ // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.017}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.011}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.014}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.015}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.016}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("07.11.2016"),Value=0.046}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("20.07.2017"),Value=0.05}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.013}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.017}, // new Pollution{Location="ALTON",LastUpdate=Convert.ToDateTime("11.10.2018"),Value=0.018} //}; cartesianChart1.Series.Clear(); panelLocations.Controls.Clear(); //pollutions = _pollutionContext.Pollutions.Where(p => p.City == "Tucson" && p.Location == "22nd Street & Craycr" && p.Parameter == "o3").ToList(); var map = Mappers.Xy <DataModel>().X(p => p.Number).Y(p => p.Value); var dates = pollutions.Select(p => p.LastUpdate.ToString("dd.MM.yyyy HH:mm:ss")).ToList(); dates = dates.Distinct().ToList(); dates.Sort(new ComparerDate()); foreach (var item in pollutions) { if (!cartesianChart1.Series.Any(p => p.Title == item.Location)) { Series series; if (pollutions.FindAll(p => p.Location == item.Location).Count > 1) { series = new LineSeries(map); } else { series = new LineSeries(map) { PointGeometrySize = 19 }; } series.Title = item.Location; series.Values = new ChartValues <DataModel>() { new DataModel { Value = item.Value, Number = dates.FindIndex(p => p == item.LastUpdate.ToString("dd.MM.yyyy HH:mm:ss")) } }; cartesianChart1.Series.Add(series); var checkBox = new MaterialSkin.Controls.MaterialCheckBox(); checkBox.Text = series.Title; checkBox.Checked = true; checkBox.Dock = DockStyle.Top; checkBox.CheckedChanged += CheckBox_CheckedChanged; panelLocations.Controls.Add(checkBox); } else { cartesianChart1.Series.FirstOrDefault(p => p.Title == item.Location).Values.Add( new DataModel { Value = item.Value, Number = dates.FindIndex(p => p == item.LastUpdate.ToString("dd.MM.yyyy HH:mm:ss")) }); } } cartesianChart1.AxisX.Clear(); cartesianChart1.AxisX.Add(new Axis { Labels = dates }); cartesianChart1.LegendLocation = LegendLocation.Right; if (cartesianChart1.AxisY.Count == 0) { cartesianChart1.AxisY.Add(new Axis()); } cartesianChart1.AxisY.FirstOrDefault().LabelFormatter = p => p + " " + pollutions?.FirstOrDefault()?.Unit; }