private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("字段必填！");
return;
}
MeteringModel m;
if (olds != null && olds.Id > 0)
{
m = new MeteringModel(olds.Id, textBox1.Text, textBox2.Text);
}
else
{
m = new MeteringModel(textBox1.Text, textBox2.Text);
}
MessageModel msg = ctrl.add(m);
if (msg.Code == 0)
{
pForm.loadData();
this.Close();
}
else
{
MessageBox.Show(msg.Msg);
}
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
if (this.dataGridView1.CurrentCell != null)
{
MeteringModel s = new MeteringModel(Convert.ToInt32(this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells["id"].Value), this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells["num"].Value.ToString(), this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells["name"].Value.ToString());
MeteringPopup popup = new MeteringPopup(this, s);
popup.Show();
}
}
public MeteringPopup(MeteringView form, object obj)
{
pForm = form;
InitializeComponent();
if (obj != null)
{
olds = (MeteringModel)obj;
textBox1.Text = olds.Num;
textBox2.Text = olds.Name;
}
}
public MessageModel add(object obj)
{
MeteringModel s = (MeteringModel)obj;
string sql = "";
if (s.Id > 0)
{
sql = "UPDATE metering SET num = '" + s.Num + "',name = '" + s.Name + "' WHERE id = '" + s.Id + "' ";
}
else
{
sql = "insert into metering (num,name) values('" + s.Num + "','" + s.Name + "');";
}
MessageModel msg;
try
{
int res = h.ExecuteNonQuery(sql, CommandType.Text);
if (res > 0)
{
msg = new MessageModel(0, "保存成功", s);
}
else
{
msg = new MessageModel(10005, "保存失败");
}
}
catch (Exception e)
{
string err = "服务器错误，请重试！";
if (e.ToString().IndexOf("num_UNIQUE") != -1)
{
err = "编码重复！";
}
msg = new MessageModel(10005, err);
}
return(msg);
}
