public static int AddDeviceObject(AsmDeviceObject uo)
{
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
var result = conn.Insert(uo);
return(Convert.ToInt32(result));
}
}
public static int UpdateDeviceObject(AsmDeviceObject uo)
{
var result = 0;
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
result = conn.Update(uo);
}
return(Convert.ToInt32(result));
}
public static AsmDeviceObject GetDeviceObjectByCondition(string sql)
{
AsmDeviceObject ado = null;
string sl = "SELECT * FROM dbo.C_ASM_DEVICE_T " + sql;
DataTable dt = new DataTable();
dt = ClsCommon.dbSql.ExecuteDataTable(sl);
if (dt.Rows.Count > 0)
{
ado = new AsmDeviceObject();
ado.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
ado.DEVICE_NAME = dt.Rows[0]["DEVICE_NAME"].ToString();
ado.DEVICE_STATION = dt.Rows[0]["DEVICE_STATION"].ToString();
ado.DEVICE_TYPE = dt.Rows[0]["DEVICE_TYPE"].ToString();
ado.DEVICE_IP = dt.Rows[0]["DEVICE_IP"].ToString();
ado.DEVICE_CID = dt.Rows[0]["DEVICE_CID"].ToString();
ado.DEVICE_PROTOCOL = dt.Rows[0]["DEVICE_PROTOCOL"].ToString();
ado.DEVICE_PRINTADD = dt.Rows[0]["DEVICE_PRINTADD"].ToString();
ado.DEVICE_CONTROLADD = dt.Rows[0]["DEVICE_CONTROLADD"].ToString();
}
return(ado);
}
private void BT_Save_Click(object sender, EventArgs e)
{
if (check() == true)
{
//新增
if (flag)
{
//判断设备名是否存在
if (AsmDevice_BLL.IsExistCode("DEVICE_IP='" + TB_IP.Text + "'"))
{
MessageBox.Show("IP地址存在冲突，请检查！");
}
else
{
AsmDeviceObject ado = new AsmDeviceObject();
ado.DEVICE_NAME = TB_Name.Text;
ado.DEVICE_STATION = CB_ST2.Text;
ado.DEVICE_TYPE = CB_Type2.SelectedItem.ToString();
ado.DEVICE_IP = TB_IP.Text;
ado.DEVICE_CID = TB_CID.Text;
ado.DEVICE_PROTOCOL = CB_Pro.SelectedItem.ToString();
ado.DEVICE_PRINTADD = TB_Print.Text;
ado.DEVICE_CONTROLADD = TB_Control.Text;
if (AsmDevice_BLL.AddDeviceObject(ado) > 0)
{
MessageBox.Show("新增成功！");
ClearEdit();
ReflshDataGridView();
}
else
{
MessageBox.Show("新增失败！");
ReflshDataGridView();
}
}
}
//修改
else
{
if (AsmDevice_BLL.IsExistCode("DEVICE_IP='" + oldIP + "'"))
{
AsmDeviceObject ado = AsmDevice_BLL.GetDeviceObjectByCondition("where DEVICE_IP='" + oldIP + "'");
ado.DEVICE_NAME = TB_Name.Text;
ado.DEVICE_STATION = CB_ST2.Text;
ado.DEVICE_TYPE = CB_Type2.SelectedItem.ToString();
ado.DEVICE_IP = TB_IP.Text;
ado.DEVICE_CID = TB_CID.Text;
ado.DEVICE_PROTOCOL = CB_Pro.SelectedItem.ToString();
ado.DEVICE_PRINTADD = TB_Print.Text;
ado.DEVICE_CONTROLADD = TB_Control.Text;
if (AsmDevice_BLL.UpdateDeviceObject(ado) > 0)
{
MessageBox.Show("修改成功！");
ClearEdit();
ReflshDataGridView();
}
else
{
MessageBox.Show("修改失败！");
ReflshDataGridView();
}
}
else
{
MessageBox.Show("该设备不存在！");
}
}
}
}
public static int UpdateDeviceObject(AsmDeviceObject uo)
{
int a = AsmDevice_DAL.UpdateDeviceObject(uo);
return(a);
}
public static AsmDeviceObject GetDeviceObjectByCondition(string sql)
{
AsmDeviceObject ado = AsmDevice_DAL.GetDeviceObjectByCondition(sql);
return(ado);
}
public static int AddDeviceObject(AsmDeviceObject uo)
{
int a = AsmDevice_DAL.AddDeviceObject(uo);
return(a);
}
