/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_ALARM_CONNECT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_ALARM_CONNECT set ");
strSql.Append("CTRL_ID=@CTRL_ID,");
strSql.Append("OUT_PORT=@OUT_PORT,");
strSql.Append("DOOR_ID=@DOOR_ID,");
strSql.Append("ENB_FORCE_PWD_EVENT=@ENB_FORCE_PWD_EVENT,");
strSql.Append("ENB_UNCLOSED_EVENT=@ENB_UNCLOSED_EVENT,");
strSql.Append("ENB_FORCE_ACCESS_EVENT=@ENB_FORCE_ACCESS_EVENT,");
strSql.Append("ENB_FORCE_CLOSE_EVENT=@ENB_FORCE_CLOSE_EVENT,");
strSql.Append("ENB_INVALID_CARD_EVENT=@ENB_INVALID_CARD_EVENT,");
strSql.Append("ENB_FIRE_EVENT=@ENB_FIRE_EVENT,");
strSql.Append("ENB_RELAY_EVENT=@ENB_RELAY_EVENT,");
strSql.Append("ENB_CONNECT_ITEM=@ENB_CONNECT_ITEM,");
strSql.Append("ENB_FIXED_TIME=@ENB_FIXED_TIME");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CTRL_ID", SqlDbType.Decimal, 9),
new SqlParameter("@OUT_PORT", SqlDbType.TinyInt, 1),
new SqlParameter("@DOOR_ID", SqlDbType.TinyInt, 1),
new SqlParameter("@ENB_FORCE_PWD_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_UNCLOSED_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_FORCE_ACCESS_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_FORCE_CLOSE_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_INVALID_CARD_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_FIRE_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_RELAY_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_CONNECT_ITEM", SqlDbType.TinyInt, 1),
new SqlParameter("@ENB_FIXED_TIME", SqlDbType.TinyInt, 1),
new SqlParameter("@ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.CTRL_ID;
parameters[1].Value = model.OUT_PORT;
parameters[2].Value = model.DOOR_ID;
parameters[3].Value = model.ENB_FORCE_PWD_EVENT;
parameters[4].Value = model.ENB_UNCLOSED_EVENT;
parameters[5].Value = model.ENB_FORCE_ACCESS_EVENT;
parameters[6].Value = model.ENB_FORCE_CLOSE_EVENT;
parameters[7].Value = model.ENB_INVALID_CARD_EVENT;
parameters[8].Value = model.ENB_FIRE_EVENT;
parameters[9].Value = model.ENB_RELAY_EVENT;
parameters[10].Value = model.ENB_CONNECT_ITEM;
parameters[11].Value = model.ENB_FIXED_TIME;
parameters[12].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_ALARM_CONNECT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_ALARM_CONNECT(");
strSql.Append("CTRL_ID,OUT_PORT,DOOR_ID,ENB_FORCE_PWD_EVENT,ENB_UNCLOSED_EVENT,ENB_FORCE_ACCESS_EVENT,ENB_FORCE_CLOSE_EVENT,ENB_INVALID_CARD_EVENT,ENB_FIRE_EVENT,ENB_RELAY_EVENT,ENB_CONNECT_ITEM,ENB_FIXED_TIME)");
strSql.Append(" values (");
strSql.Append("@CTRL_ID,@OUT_PORT,@DOOR_ID,@ENB_FORCE_PWD_EVENT,@ENB_UNCLOSED_EVENT,@ENB_FORCE_ACCESS_EVENT,@ENB_FORCE_CLOSE_EVENT,@ENB_INVALID_CARD_EVENT,@ENB_FIRE_EVENT,@ENB_RELAY_EVENT,@ENB_CONNECT_ITEM,@ENB_FIXED_TIME)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CTRL_ID", SqlDbType.Decimal, 9),
new SqlParameter("@OUT_PORT", SqlDbType.TinyInt, 1),
new SqlParameter("@DOOR_ID", SqlDbType.TinyInt, 1),
new SqlParameter("@ENB_FORCE_PWD_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_UNCLOSED_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_FORCE_ACCESS_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_FORCE_CLOSE_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_INVALID_CARD_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_FIRE_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_RELAY_EVENT", SqlDbType.Bit, 1),
new SqlParameter("@ENB_CONNECT_ITEM", SqlDbType.TinyInt, 1),
new SqlParameter("@ENB_FIXED_TIME", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.CTRL_ID;
parameters[1].Value = model.OUT_PORT;
parameters[2].Value = model.DOOR_ID;
parameters[3].Value = model.ENB_FORCE_PWD_EVENT;
parameters[4].Value = model.ENB_UNCLOSED_EVENT;
parameters[5].Value = model.ENB_FORCE_ACCESS_EVENT;
parameters[6].Value = model.ENB_FORCE_CLOSE_EVENT;
parameters[7].Value = model.ENB_INVALID_CARD_EVENT;
parameters[8].Value = model.ENB_FIRE_EVENT;
parameters[9].Value = model.ENB_RELAY_EVENT;
parameters[10].Value = model.ENB_CONNECT_ITEM;
parameters[11].Value = model.ENB_FIXED_TIME;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_ALARM_CONNECT GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CTRL_ID,OUT_PORT,DOOR_ID,ENB_FORCE_PWD_EVENT,ENB_UNCLOSED_EVENT,ENB_FORCE_ACCESS_EVENT,ENB_FORCE_CLOSE_EVENT,ENB_INVALID_CARD_EVENT,ENB_FIRE_EVENT,ENB_RELAY_EVENT,ENB_CONNECT_ITEM,ENB_FIXED_TIME from SMT_ALARM_CONNECT ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_ALARM_CONNECT model = new Maticsoft.Model.SMT_ALARM_CONNECT();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_ALARM_CONNECT DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_ALARM_CONNECT model = new Maticsoft.Model.SMT_ALARM_CONNECT();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["CTRL_ID"] != null && row["CTRL_ID"].ToString() != "")
{
model.CTRL_ID = decimal.Parse(row["CTRL_ID"].ToString());
}
if (row["OUT_PORT"] != null && row["OUT_PORT"].ToString() != "")
{
model.OUT_PORT = int.Parse(row["OUT_PORT"].ToString());
}
if (row["DOOR_ID"] != null && row["DOOR_ID"].ToString() != "")
{
model.DOOR_ID = int.Parse(row["DOOR_ID"].ToString());
}
if (row["ENB_FORCE_PWD_EVENT"] != null && row["ENB_FORCE_PWD_EVENT"].ToString() != "")
{
if ((row["ENB_FORCE_PWD_EVENT"].ToString() == "1") || (row["ENB_FORCE_PWD_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_FORCE_PWD_EVENT = true;
}
else
{
model.ENB_FORCE_PWD_EVENT = false;
}
}
if (row["ENB_UNCLOSED_EVENT"] != null && row["ENB_UNCLOSED_EVENT"].ToString() != "")
{
if ((row["ENB_UNCLOSED_EVENT"].ToString() == "1") || (row["ENB_UNCLOSED_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_UNCLOSED_EVENT = true;
}
else
{
model.ENB_UNCLOSED_EVENT = false;
}
}
if (row["ENB_FORCE_ACCESS_EVENT"] != null && row["ENB_FORCE_ACCESS_EVENT"].ToString() != "")
{
if ((row["ENB_FORCE_ACCESS_EVENT"].ToString() == "1") || (row["ENB_FORCE_ACCESS_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_FORCE_ACCESS_EVENT = true;
}
else
{
model.ENB_FORCE_ACCESS_EVENT = false;
}
}
if (row["ENB_FORCE_CLOSE_EVENT"] != null && row["ENB_FORCE_CLOSE_EVENT"].ToString() != "")
{
if ((row["ENB_FORCE_CLOSE_EVENT"].ToString() == "1") || (row["ENB_FORCE_CLOSE_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_FORCE_CLOSE_EVENT = true;
}
else
{
model.ENB_FORCE_CLOSE_EVENT = false;
}
}
if (row["ENB_INVALID_CARD_EVENT"] != null && row["ENB_INVALID_CARD_EVENT"].ToString() != "")
{
if ((row["ENB_INVALID_CARD_EVENT"].ToString() == "1") || (row["ENB_INVALID_CARD_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_INVALID_CARD_EVENT = true;
}
else
{
model.ENB_INVALID_CARD_EVENT = false;
}
}
if (row["ENB_FIRE_EVENT"] != null && row["ENB_FIRE_EVENT"].ToString() != "")
{
if ((row["ENB_FIRE_EVENT"].ToString() == "1") || (row["ENB_FIRE_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_FIRE_EVENT = true;
}
else
{
model.ENB_FIRE_EVENT = false;
}
}
if (row["ENB_RELAY_EVENT"] != null && row["ENB_RELAY_EVENT"].ToString() != "")
{
if ((row["ENB_RELAY_EVENT"].ToString() == "1") || (row["ENB_RELAY_EVENT"].ToString().ToLower() == "true"))
{
model.ENB_RELAY_EVENT = true;
}
else
{
model.ENB_RELAY_EVENT = false;
}
}
if (row["ENB_CONNECT_ITEM"] != null && row["ENB_CONNECT_ITEM"].ToString() != "")
{
model.ENB_CONNECT_ITEM = int.Parse(row["ENB_CONNECT_ITEM"].ToString());
}
if (row["ENB_FIXED_TIME"] != null && row["ENB_FIXED_TIME"].ToString() != "")
{
model.ENB_FIXED_TIME = int.Parse(row["ENB_FIXED_TIME"].ToString());
}
}
return(model);
}
private void DoApply(bool upload = false, bool isclose = false)
{
List <Maticsoft.Model.SMT_ALARM_SETTING> settings = new List <Maticsoft.Model.SMT_ALARM_SETTING>();
foreach (DataGridViewRow item in dgvData.Rows)
{
Maticsoft.Model.SMT_ALARM_SETTING alarmSetting = (Maticsoft.Model.SMT_ALARM_SETTING)item.Tag;
alarmSetting.CTRL_FORCE_PWD = tbForcePwd.Text.Trim();
alarmSetting.ENABLE_FORCE_PWD = (bool)selectRow.Cells[2].Value;
alarmSetting.ENABLE_CLOSED_TIMEOUT = (bool)selectRow.Cells[3].Value;
alarmSetting.ENABLE_FORCE_ACCESS = (bool)selectRow.Cells[4].Value;
alarmSetting.ENABLE_FORCE_CLOSE = (bool)selectRow.Cells[5].Value;
alarmSetting.ENABLE_INVALID_CARD = (bool)selectRow.Cells[6].Value;
alarmSetting.ENABLE_FIRE = (bool)selectRow.Cells[7].Value;
alarmSetting.ENABLE_STEAL = (bool)selectRow.Cells[8].Value;
alarmSetting.ENABLE_FORCE_CARD = (bool)selectRow.Cells[9].Value;
if (iUnClosedTimeOut.ValueObject == null)
{
alarmSetting.NOT_CLOSED_TIMEOUT = 25;
}
else
{
alarmSetting.NOT_CLOSED_TIMEOUT = iUnClosedTimeOut.Value;
}
settings.Add(alarmSetting);
}
Maticsoft.Model.SMT_ALARM_SETTING selectSetting = null;
if (selectRow != null)
{
selectSetting = (Maticsoft.Model.SMT_ALARM_SETTING)selectRow.Tag;
}
List <Maticsoft.Model.SMT_ALARM_CONNECT> conns = new List <Maticsoft.Model.SMT_ALARM_CONNECT>();
if (selectSetting != null)
{
for (int i = 0; i < ports.Count; i++)
{
Maticsoft.Model.SMT_ALARM_CONNECT conn = ports[i].AlarmConnect;
if (conn != null)
{
conn.OUT_PORT = i + 1;
conn.CTRL_ID = selectSetting.CTRL_ID;
conns.Add(conn);
}
}
}
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_ALARM_SETTING settingBll = new Maticsoft.BLL.SMT_ALARM_SETTING();
foreach (var item in settings)
{
settingBll.Update(item);
}
if (selectSetting != null)
{
Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ALARM_CONNECT where CTRL_ID=" + selectSetting.CTRL_ID);
Maticsoft.BLL.SMT_ALARM_CONNECT connBll = new Maticsoft.BLL.SMT_ALARM_CONNECT();
foreach (var item in conns)
{
item.ID = connBll.Add(item);
}
}
if (upload)
{
//上传
UploadPrivate.UploadAlarmSetting(settings);
}
WinInfoHelper.ShowInfoWindow(this, "保存成功！");
if (isclose)
{
this.BeginInvoke(new Action(() =>
{
this.Close();
}));
}
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存报警设置异常！" + ex.Message);
log.Error("保存报警设置异常:", ex);
}
});
waiting.Show(this);
}
