public bool Update(MODELWATERMETERTYPECLASS MODELWATERMETERTYPECLASS)
{
StringBuilder str = new StringBuilder();
str.Append("UPDATE WATERMETERTYPECLASS SET WATERMETERTYPECLASSNAME=@WATERMETERTYPECLASSNAME,MEMO=@MEMO ");
str.Append("WHERE WATERMETERTYPECLASSID=@WATERMETERTYPECLASSID");
SqlParameter[] para =
{
new SqlParameter("@WATERMETERTYPECLASSNAME", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.VarChar, 50),
new SqlParameter("@WATERMETERTYPECLASSID", SqlDbType.VarChar, 50)
};
para[0].Value = MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSNAME;
para[1].Value = MODELWATERMETERTYPECLASS.MEMO;
para[2].Value = MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSID;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert(MODELWATERMETERTYPECLASS MODELWATERMETERTYPECLASS)
{
StringBuilder str = new StringBuilder();
str.Append("INSERT INTO WATERMETERTYPECLASS(WATERMETERTYPECLASSID,WATERMETERTYPECLASSNAME,MEMO) ");
str.Append("VALUES(@WATERMETERTYPECLASSID,@WATERMETERTYPECLASSNAME,@MEMO)");
SqlParameter[] para =
{
new SqlParameter("@WATERMETERTYPECLASSID", SqlDbType.VarChar, 30),
new SqlParameter("@WATERMETERTYPECLASSNAME", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.VarChar, 50)
};
para[0].Value = MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSID;
para[1].Value = MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSNAME;
para[2].Value = MODELWATERMETERTYPECLASS.MEMO;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void toolSave_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim() == "")
{
mes.Show("性质名称不能为空!");
txtName.Focus();
return;
}
MODELWATERMETERTYPECLASS MODELWATERMETERTYPECLASS = new MODELWATERMETERTYPECLASS();
MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSNAME = txtName.Text;
MODELWATERMETERTYPECLASS.MEMO = txtMemo.Text;
if (isAdd)
{
MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSID = GETTABLEID.GetTableID("", "WATERMETERTYPECLASS");
bool isSuccess = BLLWATERMETERTYPECLASS.Insert(MODELWATERMETERTYPECLASS);
if (isSuccess)
{
Query();
}
else
{
mes.Show("添加失败，请重新点击保存按钮!");
return;
}
}
else
{
if (txtID.Text.Trim() == "")
{
mes.Show("如果要执行添加操作，请先点击添加按钮后再保存!");
return;
}
MODELWATERMETERTYPECLASS.WATERMETERTYPECLASSID = txtID.Text;
if (BLLWATERMETERTYPECLASS.Update(MODELWATERMETERTYPECLASS))
{
if (dgList.CurrentRow != null)
{
dgList.CurrentRow.Cells["WATERMETERTYPECLASSNAME"].Value = txtName.Text;
dgList.CurrentRow.Cells["MEMO"].Value = txtMemo.Text;
}
}
else
{
mes.Show("修改失败，请重新点击保存按钮!");
return;
}
}
dgList.Enabled = true;
toolDel.Enabled = true;
toolAdd.Text = "添加";
isAdd = false;
}
