public static int AddAlarmCode(AsmAlarmCodeObject uo)
{
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
var result = conn.Insert(uo);
return(Convert.ToInt32(result));
}
}
public static int UpdateAlarmCode(AsmAlarmCodeObject uo)
{
var result = 0;
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
result = conn.Update(uo);
}
return(Convert.ToInt32(result));
}
public static AsmAlarmCodeObject GetAlarmCodeObjectByCondition(string sql)
{
AsmAlarmCodeObject aaco = null;
string sl = "SELECT * FROM dbo.C_ASM_ALARM_CODE_T " + sql;
DataTable dt = new DataTable();
dt = ClsCommon.dbSql.ExecuteDataTable(sl);
if (dt.Rows.Count > 0)
{
aaco = new AsmAlarmCodeObject();
aaco.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
aaco.DT = Convert.ToDateTime(dt.Rows[0]["DT"].ToString());
aaco.ALARM_CODE = Convert.ToInt32(dt.Rows[0]["ALARM_CODE"].ToString());
aaco.ALARM_TEXT = dt.Rows[0]["ALARM_TEXT"].ToString();
aaco.ALARM_ENGLISH = dt.Rows[0]["ALARM_ENGLISH"].ToString();
}
return(aaco);
}
private void BT_Save_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(TB_Code.Text) && !String.IsNullOrEmpty(TB_ChineseInfor.Text) && !String.IsNullOrEmpty(TB_EnglishInfor.Text))
{
//新增
if (flag)
{
if (AsmAlarmCode_BLL.IsExistCode("ALARM_CODE='" + TB_Code.Text + "'"))
{
MessageBox.Show("该报警代码已存在！");
}
else
{
AsmAlarmCodeObject aaco = new AsmAlarmCodeObject();
aaco.DT = DateTime.Now;
aaco.ALARM_CODE = int.Parse(TB_Code.Text);
aaco.ALARM_TEXT = TB_ChineseInfor.Text;
aaco.ALARM_ENGLISH = TB_EnglishInfor.Text;
if (AsmAlarmCode_BLL.AddAlarmCode(aaco) > 0)
{
MessageBox.Show("保存成功！");
ClearPL_Edit();
ReflshDataGridView();
}
else
{
MessageBox.Show("保存失败！");
ReflshDataGridView();
}
}
}
//修改
else
{
if (AsmAlarmCode_BLL.IsExistCode("ALARM_CODE='" + TB_Code.Text + "'"))
{
AsmAlarmCodeObject aaco = AsmAlarmCode_BLL.GetAlarmCodeObjectByCondition("where ALARM_CODE='" + TB_Code.Text + "'");
aaco.DT = DateTime.Now;
aaco.ALARM_CODE = int.Parse(TB_Code.Text);
aaco.ALARM_TEXT = TB_ChineseInfor.Text;
aaco.ALARM_ENGLISH = TB_EnglishInfor.Text;
if (AsmAlarmCode_BLL.UpdateAlarmCode(aaco) > 0)
{
MessageBox.Show("修改成功！");
ClearPL_Edit();
ReflshDataGridView();
}
else
{
MessageBox.Show("修改失败！");
ReflshDataGridView();
}
}
else
{
MessageBox.Show("该报警信息不存在！");
}
}
}
else
{
MessageBox.Show("请完整输入信息");
}
}
public static AsmAlarmCodeObject GetAlarmCodeObjectByCondition(string sql)
{
AsmAlarmCodeObject aaco = AsmAlarmCode_DAL.GetAlarmCodeObjectByCondition(sql);
return(aaco);
}
public static int UpdateAlarmCode(AsmAlarmCodeObject uo)
{
int a = AsmAlarmCode_DAL.UpdateAlarmCode(uo);
return(a);
}
public static int AddAlarmCode(AsmAlarmCodeObject uo)
{
int a = AsmAlarmCode_DAL.AddAlarmCode(uo);
return(a);
}
