public bool SavePrice(string resourceID, FormCollection form)
{
bool success = false;
bool add = false;
var obj = dc.Set <T_ResourcePrice>();
var price = obj.Where(a => a.ResourceID == resourceID).FirstOrDefault();
if (price == null)
{
price = new T_ResourcePrice();
add = true;
}
if (TryUpdateModel(price, "", form.AllKeys, new string[] { "ID" }))
{
if (add)
{
price.ResourceID = resourceID;
obj.Add(price);
}
success = true;
}
return(success);
}
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));
}
