private void uploadB_Click(object sender, EventArgs e)
{
var dbCon = DBConn.Instance();
dbCon.Connection = null;
dbCon.DatabaseName = "570_abp";
dbCon.Host = "5.187.7.31";
if (dbCon.IsConnect())
{
allCount++;
string query = "";
try
{
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value.ToString() != ""
// && dataGridView1.Rows[i].Cells[1].Value.ToString() != ""
&& dataGridView1.Rows[i].Cells[2].Value.ToString() != ""
&& nameTBox.Text!="")
{
if ((Regex.IsMatch(dataGridView1.Rows[i].Cells[0].Value.ToString(), "\\bАКБ\\b") || Regex.IsMatch(dataGridView1.Rows[i].Cells[0].Value.ToString(), "\\bакб\\b")) && dataGridView1.Rows[i].Cells[1].Value.ToString() != "")
{
query = String.Format("INSERT INTO priem(name, serial,count,employee,date,num_post) VALUES('{0}','{1}','{2}','{3}','{4}','{5}')",
dataGridView1.Rows[i].Cells[0].Value.ToString(),
dataGridView1.Rows[i].Cells[1].Value.ToString(),
dataGridView1.Rows[i].Cells[2].Value.ToString(),
nameTBox.Text.ToString(),
thisDay.ToString("d"),
allCount.ToString());
var cmd = new MySqlCommand(query, dbCon.Connection);
cmd.ExecuteNonQuery();
} else if (!(Regex.IsMatch(dataGridView1.Rows[i].Cells[0].Value.ToString(), "\\bАКБ\\b"))){
query = String.Format("INSERT INTO priem(name,count,employee,date,num_post) VALUES('{0}','{1}','{2}','{3}','{4}')",
dataGridView1.Rows[i].Cells[0].Value.ToString(),
dataGridView1.Rows[i].Cells[2].Value.ToString(),
nameTBox.Text.ToString(),
thisDay.ToString("d"),
allCount.ToString());
var cmd = new MySqlCommand(query, dbCon.Connection);
cmd.ExecuteNonQuery();
}
}
else
{
MessageBox.Show("Ошибка добавления");
}
//for(int j = 0; j < 3; j++)
// {
// if (dataGridView1.Rows[i].Cells[j].Value != null)
// }
}
}catch(MySqlException ee)
{
MessageBox.Show("MysqlError: " + ee.ToString());
}
}
else
{
MessageBox.Show("Ошибка с сервером");
}
dbCon.Close();
}