public void Insert(IParamNoModel paramNo)
{
var sql = @"
INSERT INTO
OFTA_ParamNo (
ParamID, ParamValue)
VALUES (
@ParamID, @ParamValue) ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@ParamID", paramNo.ParamID, SqlDbType.VarChar);
cmd.AddParam("@ParamValue", paramNo.ParamValue, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(IParamNoModel paramNo)
{
var sql = @"
UPDATE
OFTA_ParamNo
SET
ParamValue = @ParamValue
WHERE
ParamID = @ParamID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@ParamID", paramNo.ParamID, SqlDbType.VarChar);
cmd.AddParam("@ParamValue", paramNo.ParamValue, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
