private void button_Add_Click(object sender, EventArgs e)
{
if (Validate(textBox_Val.Text.Trim()))
{
Service.Model.YY_DATA_REM model = new Service.Model.YY_DATA_REM();
model.STCD = comboBox_STCD.SelectedValue.ToString();
model.TM = DateTime.Parse(dateTimePicker_Add.Text);
model.DATAVALUE = decimal.Parse(textBox_Val.Text.Trim());
model.DOWNDATE = DateTime.Now;
model.NFOINDEX = 5;
model.ItemID = comboBox_Item.SelectedValue.ToString();
bool b = PublicBD.db.AddRemData(model);
if (b)
{
dateTimePicker_Add.ResetText();
textBox_Val.Text = "";
Search();
DevComponents.DotNetBar.MessageBoxEx.Show("数据添加成功！", "[提示]", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("数据添加失败！", "[提示]", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
Service.Model.YY_DATA_REM model = new Service.Model.YY_DATA_REM();
model.STCD = dataGridView1.Rows[e.RowIndex].Cells["Column1"].Value.ToString();
model.TM = (DateTime)dataGridView1.Rows[e.RowIndex].Cells["Column5"].Value;
model.DATAVALUE = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells["Column4"].Value.ToString());
model.DOWNDATE = DateTime.Now;
model.NFOINDEX = 5;
model.ItemID = dataGridView1.Rows[e.RowIndex].Cells["Column8"].Value.ToString();
string Where = "where stcd='" + model.STCD + "' and ItemID='" + model.ItemID + "' and TM='" + model.TM.ToString("yyyy-MM-dd HH:mm:ss.fff") + "'";
if (PublicBD.DB == "ORACLE")
{
Where = "where stcd='" + model.STCD + "' and ItemID='" + model.ItemID + "' and TM=to_date('" + model.TM.ToString() + "','yyyy-MM-dd HH24:MI:SS')";
}
if (dataGridView1.Columns[e.ColumnIndex].HeaderText == "删 除")
{
bool b = PublicBD.db.DelRemData(Where);
if (b)
{
Search();
DevComponents.DotNetBar.MessageBoxEx.Show("数据删除成功！", "[提示]", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("数据删除失败！", "[提示]", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if (dataGridView1.Columns[e.ColumnIndex].HeaderText == "更 新")
{
bool b = PublicBD.db.UdpRemData(model, Where);
if (b)
{
Search();
DevComponents.DotNetBar.MessageBoxEx.Show("数据更新成功！", "[提示]", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("数据更新失败！", "[提示]", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
