public bool SaveResource(string resourceID, FormCollection form)
{
bool success = false;
bool add = false;
var obj = dc.Set <T_Resource>();
var resource = obj.Where(a => a.ID == resourceID).FirstOrDefault();
if (resource == null)
{
resource = new T_Resource();
resource.CreateTime = DateTime.Now;
resource.CreateUser = user.Account;
resource.Enable = true;
add = true;
}
if (TryUpdateModel(resource, "", form.AllKeys, new string[] { "Enable", "Status" }))
{
resource.UpdateTime = DateTime.Now;
resource.UpdateUser = user.Account;
if (add)
{
obj.Add(resource);
}
success = true;
}
return(success);
}
/// <summary>
/// 添加权限信息
/// </summary>
/// <param name="resource"></param>
/// <returns></returns>
public ActionResult AddResourceInfo(T_Resource resource)
{
T_User userinfo = Session["T_User"] as T_User;
//实现对用户的添加信息
var resourceinfo = t_resourceservice.LoadEntities(u => u.ResourceID > 0);
List <int> resourceinf = new List <int>();
foreach (var i in resourceinfo)
{
resourceinf.Add(i.ResourceID);
}
int maxid = resourceinf.Max();
resource.ResourceID = maxid + 1;
resource.CreateOperatorID = userinfo.UserID;
resource.CreateOperatorName = userinfo.UserName;
resource.CreateTime = DateTime.Now;
resource.ModiOperatorID = "";
resource.ModiOperatorName = "";
resource.ModiTime = DateTime.Now;
var t = t_resourceservice.AddEntities(resource);
if (t != null)
{
return(Content("OK"));
}
else
{
return(Content("Error"));
}
}
/// <summary>
/// 对权限信息进行修改
/// </summary>
/// <param name="resource"></param>
/// <returns></returns>
public ActionResult UpdateResourceInfo(T_Resource resource)
{
//T_ResourceService rs = new T_ResourceService();
T_Resource num = t_resourceservice.LoadEntities(c => c.ResourceID == resource.ResourceID).FirstOrDefault();
if (num == null)
{
return(Content("修改错误，请您检查"));
}
num.ResourceName = resource.ResourceName;
num.ResDescription = resource.ResDescription;
num.Notes = resource.Notes;
t_resourceservice.UpdateEntities(num);
return(Content("OK"));
}
public string AddOrUpdateWorkPlace(string wpJsonObject)
{
Result result = new Result();
WorkPlace workplace = null;
bool add = false;
try
{
workplace = JsonConvert.DeserializeObject <WorkPlace>(wpJsonObject);
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "json转换对象异常，请查阅异常信息并检查字段！",
exmsg: ex.StackTrace)));
}
try
{
DbContext dc = DbContextFactory.Create();
var resource = dc.Set <T_Resource>().Where(a => a.ID == workplace.WPNo).FirstOrDefault();
if (resource == null)
{
result.Msg = "目标数据库无此数据，随后进行添加操作；";
resource = new T_Resource();
add = true;
}
else
{
result.Msg = "目标数据库存在此数据，随后进行更新操作；";
}
resource.ID = workplace.WPNo;
resource.Loc1 = workplace.WPLOCNo1;
resource.Loc2 = workplace.WPLOCNo2;
resource.Loc3 = workplace.WPLOCNo3;
resource.Loc4 = workplace.WPLOCNo4;
resource.Loc5 = workplace.WPRMID;
resource.ResourceKindID = 2;
resource.ResourceTypeID = workplace.WPType;
resource.Number = workplace.WPSeat;
resource.Price = workplace.WPSeatPrice;
resource.Enable = !workplace.WPISEnable;
resource.Location = workplace.WPAddr;
resource.CreateUser = workplace.WPCreator;
resource.CreateTime = workplace.WPCreateDate;
if (add)
{
dc.Set <T_Resource>().Add(resource);
}
else
{
dc.Set <T_Resource>().AddOrUpdate(resource);
}
dc.SaveChanges();
result.Msg += "操作成功！";
result.Flag = 1;
//if (dc.SaveChanges() > 0)
//{
// result.Msg += "操作成功！";
// result.Flag = 1;
//}
//else
//{
// result.Msg += "操作失败！可能存在非空、数据类型、约束等条件不满足！";
// result.Flag = 2;
//}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "添加或更新异常，请查阅异常信息！", exmsg: ex.StackTrace)));
}
return(JsonConvert.SerializeObject(result));
}
public string AddOrUpdateRoom(string rmJsonObject)
{
Result result = new Result();
Room room = null;
bool add = false;
try
{
room = JsonConvert.DeserializeObject <Room>(rmJsonObject);
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "json转换对象异常，请查阅异常信息并检查字段！",
exmsg: ex.StackTrace)));
}
try
{
DbContext dc = DbContextFactory.Create();
var resource = dc.Set <T_Resource>().Where(a => a.ID == room.RMID).FirstOrDefault();
if (resource == null)
{
result.Msg = "目标数据库无此数据，随后进行添加操作；";
resource = new T_Resource();
add = true;
}
else
{
result.Msg = "目标数据库存在此数据，随后进行更新操作；";
}
resource.ID = room.RMID;
resource.Name = room.RMNo;
resource.Loc1 = room.RMLOCNo1;
resource.Loc2 = room.RMLOCNo2;
resource.Loc3 = room.RMLOCNo3;
resource.Loc4 = room.RMLOCNo4;
resource.ResourceKindID = 1;
resource.ResourceTypeID = room.RMRentType;
resource.Area = room.RMBuildSize;
resource.RentArea = room.RMRentSize;
resource.Enable = !room.RMISEnable;
resource.CreateUser = room.RMCreator;
resource.CreateTime = room.RMCreateDate;
resource.Location = room.RMAddr;
if (add)
{
dc.Set <T_Resource>().Add(resource);
}
else
{
dc.Set <T_Resource>().AddOrUpdate(resource);
}
dc.SaveChanges();
result.Msg += "操作成功！";
result.Flag = 1;
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "添加或更新异常，请查阅异常信息！", exmsg: ex.StackTrace)));
}
return(JsonConvert.SerializeObject(result));
}
public string AddOrUpdateBillboard(string bbJsonObject)
{
Result result = new Result();
Billboard billboard = null;
bool resourceAdd = false;
bool priceAdd = false;
try
{
billboard = JsonConvert.DeserializeObject <Billboard>(bbJsonObject);
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "json转换对象异常，请查阅异常信息并检查字段！",
exmsg: ex.StackTrace)));
}
try
{
DbContext dc = DbContextFactory.Create();
var resource = dc.Set <T_Resource>().Where(a => a.ID == billboard.BBNo).FirstOrDefault();
var price = dc.Set <T_ResourcePrice>().Where(a => a.ResourceID == billboard.BBNo).FirstOrDefault();
if (price == null)
{
price = new T_ResourcePrice(); priceAdd = true;
}
if (resource == null)
{
result.Msg = "目标数据库无此数据，随后进行添加操作；";
resource = new T_Resource();
resourceAdd = true;
}
else
{
result.Msg = "目标数据库存在此数据，随后进行更新操作；";
}
resource.ID = billboard.BBNo;
resource.Name = billboard.BBName;
resource.Loc1 = billboard.BBLOCNo;
resource.ResourceKindID = 4;
resource.Size = billboard.BBSize;
resource.ResourceTypeID = billboard.BBType;
resource.Deposit = billboard.BBDeposit;
resource.Enable = !billboard.BBISEnable;
resource.CreateUser = billboard.BBCreator;
resource.CreateTime = billboard.BBCreateDate;
resource.Location = billboard.BBAddr;
price.ResourceID = billboard.BBNo;
price.DayInPrice = billboard.BBINPriceDay;
price.DayOutPrice = billboard.BBOUTPriceDay;
price.MonthInPrice = billboard.BBINPriceMonth;
price.MonthOutPrice = billboard.BBOUTPriceMonth;
price.QuaterInPrcie = billboard.BBINPriceQuarter;
price.QuaterOutPrice = billboard.BBOUTPriceQuarter;
price.YearInPrice = billboard.BBINPriceYear;
price.YearOutPrice = billboard.BBOUTPriceYear;
if (resourceAdd)
{
dc.Set <T_Resource>().Add(resource);
}
else
{
dc.Set <T_Resource>().AddOrUpdate(resource);
}
if (priceAdd)
{
dc.Set <T_ResourcePrice>().Add(price);
}
else
{
dc.Set <T_ResourcePrice>().AddOrUpdate(price);
}
dc.SaveChanges();
result.Msg += "操作成功！";
result.Flag = 1;
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "添加或更新异常，请查阅异常信息！", exmsg: ex.StackTrace)));
}
return(JsonConvert.SerializeObject(result));
}
public string AddOrUpdateConferenceRoom(string crJsonObject)
{
Result result = new Result();
ConferenceRoom conferenceRoom = null;
bool resourceAdd = false;
bool priceAdd = false;
try
{
conferenceRoom = JsonConvert.DeserializeObject <ConferenceRoom>(crJsonObject);
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "json转换对象异常，请查阅异常信息并检查字段！",
exmsg: ex.StackTrace)));
}
try
{
DbContext dc = DbContextFactory.Create();
var resource = dc.Set <T_Resource>().Where(a => a.ID == conferenceRoom.CRNo).FirstOrDefault();
var price = dc.Set <T_ResourcePrice>().Where(a => a.ResourceID == conferenceRoom.CRNo).FirstOrDefault();
if (price == null)
{
price = new T_ResourcePrice(); priceAdd = true;
}
if (resource == null)
{
result.Msg = "目标数据库无此数据，随后进行添加操作；";
resource = new T_Resource();
resourceAdd = true;
}
else
{
result.Msg = "目标数据库存在此数据，随后进行更新操作；";
}
resource.ID = conferenceRoom.CRNo;
resource.Name = conferenceRoom.CRName;
resource.Number = conferenceRoom.CRCapacity;
resource.RangeNum = conferenceRoom.CRCapacity.ToString();
resource.Area = conferenceRoom.CRBuildSize;
resource.Loc1 = conferenceRoom.ParkNo;
resource.ResourceKindID = 3;
resource.Location = conferenceRoom.CRAddr;
resource.Deposit = conferenceRoom.CRDeposit;
resource.Enable = conferenceRoom.CRISEnable;
resource.CreateUser = conferenceRoom.CRCreator;
resource.CreateTime = conferenceRoom.CRCreateDate;
resource.UpdateTime = conferenceRoom.CRUpdateDate;
resource.UpdateUser = conferenceRoom.CRUpdateUser;
price.ResourceID = conferenceRoom.CRNo;
price.HourEnable = conferenceRoom.CRIsHour;
price.HourInPrice = conferenceRoom.CRINPriceHour;
price.HourOutPrice = conferenceRoom.CROUTPriceHour;
price.HDayEnable = conferenceRoom.CRIsHalfDay;
price.HDayInPrice = conferenceRoom.CRINPriceHalfDay;
price.HDayOutPrice = conferenceRoom.CROUTPriceHalfDay;
price.DayEnable = conferenceRoom.CRIsDay;
price.DayInPrice = conferenceRoom.CRINPriceDay;
price.DayOutPrice = conferenceRoom.CROUTPriceDay;
price.DelayEnable = true;
price.DelayInPrice = conferenceRoom.CRINPriceDelay;
price.DelayOutPrice = conferenceRoom.CROUTPriceDelay;
if (resourceAdd)
{
dc.Set <T_Resource>().Add(resource);
}
else
{
dc.Set <T_Resource>().AddOrUpdate(resource);
}
if (priceAdd)
{
dc.Set <T_ResourcePrice>().Add(price);
}
else
{
dc.Set <T_ResourcePrice>().AddOrUpdate(price);
}
dc.SaveChanges();
result.Msg += "操作成功！";
result.Flag = 1;
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(Result.Exception(msg: "添加或更新异常，请查阅异常信息！", exmsg: ex.StackTrace)));
}
return(JsonConvert.SerializeObject(result));
}
