public Message Delete(IoT_Community info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
// 获得上下文对象中的表信息
Table <IoT_Community> tbl = dd.GetTable <IoT_Community>();
var s = tbl.Where(p => p.ID == info.ID).Single();
tbl.DeleteOnSubmit(s as IoT_Community);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = "删除小区参数成功！"
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "删除小区参数失败！" + e.Message
};
}
return(m);
}
public Message Edit(IoT_Community info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
string checkSQL = $"Select count(*) from IoT_Street where ID={info.ID}";
object[] param = new object[0];
int iCount = dd.ExecuteQuery <int>(checkSQL, param).Single <int>();
if (iCount > 0)
{
throw new Exception("小区已被使用，不能删除");
}
var count = dd.GetTable <IoT_Community>().Where(p => p.StreetID == info.StreetID && p.Ser == info.Ser && p.ID != info.ID).Count();
if (count > 0)
{
m = new Message()
{
Result = false,
TxtMessage = "小区编号不能重复!"
};
return(m);
}
IoT_Community dbinfo = dd.GetTable <IoT_Community>().Where(p =>
p.ID == info.ID).SingleOrDefault();
ConvertHelper.Copy <IoT_Community>(dbinfo, info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_Community>(dbinfo)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "编辑小区参数失败！" + e.Message
};
}
return(m);
}
public Message Add(IoT_Community info)
{
// 定义执行结果
Message m;
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
Table <IoT_Community> tbl = dd.GetTable <IoT_Community>();
var count = tbl.Where(p => p.StreetID == info.StreetID && p.Ser == info.Ser).Count();
if (count > 0)
{
m = new Message()
{
Result = false,
TxtMessage = "小区编号不能重复!"
};
return(m);
}
// 调用新增方法
tbl.InsertOnSubmit(info);
// 更新操作
dd.SubmitChanges();
m = new Message()
{
Result = true,
TxtMessage = JSon.TToJson <IoT_Community>(info)
};
}
catch (Exception e)
{
m = new Message()
{
Result = false,
TxtMessage = "新增小区参数失败！" + e.Message
};
}
return(m);
}
