public SqlOperate()
{
if (mySS != null)
{
mySS = null;
}
mySS = new YM.Data.SqlScope(System.Configuration.ConfigurationSettings.AppSettings["connectionStr"]);
}
public void SetOutNumber(string id, string outtype, string number)
{
YM.Data.SqlScope ss = Dal.Sqler.Instance();
using (ss.EnterQuery())
{
//消防
if (number != "")
{
int outnum = int.Parse(number);
//删除实时报警信息
string select = "select * from T_Out_Set where FPumpID='" + id + "' and FType='" + outtype + "' and FIndex > '" + outnum + "'";
DataTable dt = ss.ExecuteDataTable(select);
for (int i = 0; i < dt.Rows.Count; i++)
{
string name = dt.Rows[i]["FName"].ToString();
string sqldelete = @"delete from T_Alarm where FPumpID = '" + id + "' and (T_Alarm.FContent ='" + name + "出水压力超高报警' or T_Alarm.FContent ='" + name + "出水压力超低报警')";
ss.ExecuteNonQuery(sqldelete);
}
//删除管道设置
string del = "delete from T_Out_Set where FPumpID='" + id + "' and FType='" + outtype + "' and FIndex > '" + outnum + "'";
ss.ExecuteNonQuery(del);
//增加多出的管道
for (int i = 0; i < outnum; i++)
{
int num = i + 1;
string sqlselect = "select * from T_Out_Set where FPumpID='" + id + "' and FType='" + outtype + "' and FIndex ='" + num + "'";
DataTable dtselect = ss.ExecuteDataTable(sqlselect);
if (dtselect.Rows.Count == 0)
{
string sqlinsert = "INSERT INTO [dbo].T_Out_Set([FPumpID],[FType],[FIndex],[FName])VALUES('" + id + "','" + outtype + "','" + num + "','" + outtype + "管道" + num + "号')";
ss.ExecuteNonQuery(sqlinsert);
}
}
}
}
}
public void Dispose()
{
// TODO: 添加 SqlOperate.Dispose 实现
mySS.Dispose();
mySS = null;
}