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