private string unreserveaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessRoom bc = new project.Business.Base.BusinessRoom(); bc.load(jp.getValue("id")); if (bc.Entity.RMStatus == "reserve") { int r = bc.unreserve(); if (r <= 0) { flag = "4"; } } else { flag = "3"; } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "unreserve")); collection.Add(new JsonStringValue("flag", flag)); collection.Add(new JsonStringValue("liststr", createList(jp.getValue("RMIDS"), jp.getValue("RMLOCNo1S"), jp.getValue("RMLOCNo2S"), jp.getValue("RMLOCNo3S"), jp.getValue("RMLOCNo4S"), jp.getValue("CustNoS"), jp.getValue("RMStatusS"), ParseIntForString(jp.getValue("page"))))); return(collection.ToString()); }
private string validaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessRoom bc = new project.Business.Base.BusinessRoom(); bc.load(jp.getValue("id")); bc.Entity.RMISEnable = !bc.Entity.RMISEnable; int r = bc.valid(); if (r <= 0) { flag = "2"; } else { #region 步到资源系统 string syncResult = string.Empty; try { ResourceService.ResourceService srv = new ResourceService.ResourceService(); srv.Url = ConfigurationManager.AppSettings["ResourceServiceUrl"].ToString(); syncResult = srv.AddOrUpdateRoom(JsonConvert.SerializeObject(bc.Entity)); } catch (Exception ex) { syncResult = ex.ToString(); } collection.Add(new JsonStringValue("sync", syncResult)); #endregion } if (bc.Entity.RMISEnable) { collection.Add(new JsonStringValue("stat", "<span class=\"label radius\">禁用</span>")); } else { collection.Add(new JsonStringValue("stat", "<span class=\"label label-success radius\">正常</span>")); } collection.Add(new JsonStringValue("id", jp.getValue("id"))); } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "valid")); collection.Add(new JsonStringValue("flag", flag)); collection.Add(new JsonStringValue("liststr", createList(jp.getValue("RMIDS"), jp.getValue("RMLOCNo1S"), jp.getValue("RMLOCNo2S"), jp.getValue("RMLOCNo3S"), jp.getValue("RMLOCNo4S"), jp.getValue("CustNoS"), jp.getValue("RMStatusS"), ParseIntForString(jp.getValue("page"))))); return(collection.ToString()); }
private string deleteaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessRoom bc = new project.Business.Base.BusinessRoom(); bc.load(jp.getValue("id")); if (bc.Entity.RMStatus == "use") { flag = "4"; } else { int r = bc.delete(); if (r <= 0) { flag = "2"; } else { #region 步到资源系统 string syncResult = string.Empty; try { ResourceService.ResourceService srv = new ResourceService.ResourceService(); srv.Url = ConfigurationManager.AppSettings["ResourceServiceUrl"].ToString(); syncResult = srv.DeleteResource(bc.Entity.RMID); } catch (Exception ex) { syncResult = ex.ToString(); } collection.Add(new JsonStringValue("sync", syncResult)); #endregion } } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "delete")); collection.Add(new JsonStringValue("flag", flag)); collection.Add(new JsonStringValue("liststr", createList(jp.getValue("RMIDS"), jp.getValue("RMLOCNo1S"), jp.getValue("RMLOCNo2S"), jp.getValue("RMLOCNo3S"), jp.getValue("RMLOCNo4S"), jp.getValue("CustNoS"), jp.getValue("RMStatusS"), ParseIntForString(jp.getValue("page"))))); return(collection.ToString()); }
private string submitaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessRoom bc = new project.Business.Base.BusinessRoom(); if (jp.getValue("tp") == "update") { bc.load(jp.getValue("id")); bc.Entity.RMLOCNo1 = jp.getValue("RMLOCNo1"); bc.Entity.RMLOCNo2 = jp.getValue("RMLOCNo2"); bc.Entity.RMLOCNo3 = jp.getValue("RMLOCNo3"); bc.Entity.RMLOCNo4 = jp.getValue("RMLOCNo4"); bc.Entity.RMRentType = jp.getValue("RMRentType"); bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics")); bc.Entity.RMBuildSize = ParseDecimalForString(jp.getValue("RMBuildSize")); bc.Entity.RMRentSize = ParseDecimalForString(jp.getValue("RMRentSize")); bc.Entity.RMAddr = jp.getValue("RMAddr"); bc.Entity.RMRemark = jp.getValue("RMRemark"); bc.Entity.HaveAirCondition = bool.Parse(jp.getValue("HaveAirCondition")); int r = bc.Save("update"); if (r <= 0) { flag = "2"; } else { collection.Add(new JsonStringValue("ZYSync", bc.SyncResource("au"))); } } else { Data obj = new Data(); DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_Room where RMID='" + jp.getValue("RMID") + "'").Tables[0]; if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0) { flag = "3"; } else { bc.Entity.RMID = jp.getValue("RMID"); bc.Entity.RMNo = jp.getValue("RMNo"); bc.Entity.RMLOCNo1 = jp.getValue("RMLOCNo1"); bc.Entity.RMLOCNo2 = jp.getValue("RMLOCNo2"); bc.Entity.RMLOCNo3 = jp.getValue("RMLOCNo3"); bc.Entity.RMLOCNo4 = jp.getValue("RMLOCNo4"); bc.Entity.RMRentType = jp.getValue("RMRentType"); bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics")); bc.Entity.RMBuildSize = ParseDecimalForString(jp.getValue("RMBuildSize")); bc.Entity.RMRentSize = ParseDecimalForString(jp.getValue("RMRentSize")); bc.Entity.RMAddr = jp.getValue("RMAddr"); bc.Entity.RMRemark = jp.getValue("RMRemark"); bc.Entity.HaveAirCondition = bool.Parse(jp.getValue("HaveAirCondition")); bc.Entity.RMCreator = user.Entity.UserName; bc.Entity.RMCreateDate = GetDate(); int r = bc.Save("insert"); if (r <= 0) { flag = "2"; } else { collection.Add(new JsonStringValue("ZYSync", bc.SyncResource("au"))); } } } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "submit")); collection.Add(new JsonStringValue("flag", flag)); collection.Add(new JsonStringValue("liststr", createList(jp.getValue("RMIDS"), jp.getValue("RMLOCNo1S"), jp.getValue("RMLOCNo2S"), jp.getValue("RMLOCNo3S"), jp.getValue("RMLOCNo4S"), jp.getValue("CustNoS"), jp.getValue("RMStatusS"), ParseIntForString(jp.getValue("page"))))); return(collection.ToString()); }
private string updateaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessRoom bc = new project.Business.Base.BusinessRoom(); bc.load(jp.getValue("id")); collection.Add(new JsonStringValue("RMID", bc.Entity.RMID)); collection.Add(new JsonStringValue("RMNo", bc.Entity.RMNo)); collection.Add(new JsonStringValue("RMLOCNo1", bc.Entity.RMLOCNo1)); collection.Add(new JsonStringValue("RMLOCNo2", bc.Entity.RMLOCNo2)); collection.Add(new JsonStringValue("RMLOCNo3", bc.Entity.RMLOCNo3)); collection.Add(new JsonStringValue("RMLOCNo4", bc.Entity.RMLOCNo4)); collection.Add(new JsonStringValue("RMRentType", bc.Entity.RMRentType)); collection.Add(new JsonStringValue("RMBuildSize", bc.Entity.RMBuildSize.ToString("0.####"))); collection.Add(new JsonStringValue("RMRentSize", bc.Entity.RMRentSize.ToString("0.####"))); collection.Add(new JsonStringValue("RMAddr", bc.Entity.RMAddr)); collection.Add(new JsonStringValue("RMRemark", bc.Entity.RMRemark)); collection.Add(new JsonStringValue("HaveAirCondition", (bc.Entity.HaveAirCondition ? "true" : "false"))); collection.Add(new JsonStringValue("IsStatistics", (bc.Entity.IsStatistics ? "true" : "false"))); string subtype = ""; int row = 0; Business.Base.BusinessLocation bt = new Business.Base.BusinessLocation(); foreach (Entity.Base.EntityLocation it in bt.GetListQuery(string.Empty, string.Empty, bc.Entity.RMLOCNo1)) { subtype += it.LOCNo + ":" + it.LOCName + ";"; row++; } collection.Add(new JsonNumericValue("row", row)); collection.Add(new JsonStringValue("subtype", subtype)); row = 0; subtype = ""; foreach (Entity.Base.EntityLocation it in bt.GetListQuery(string.Empty, string.Empty, bc.Entity.RMLOCNo2)) { subtype += it.LOCNo + ":" + it.LOCName + ";"; row++; } collection.Add(new JsonNumericValue("row1", row)); collection.Add(new JsonStringValue("subtype1", subtype)); row = 0; subtype = ""; foreach (Entity.Base.EntityLocation it in bt.GetListQuery(string.Empty, string.Empty, bc.Entity.RMLOCNo3)) { subtype += it.LOCNo + ":" + it.LOCName + ";"; row++; } collection.Add(new JsonNumericValue("row2", row)); collection.Add(new JsonStringValue("subtype2", subtype)); } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "update")); collection.Add(new JsonStringValue("flag", flag)); return(collection.ToString()); }
private string submitaction(JsonArrayParse jp) { JsonObjectCollection collection = new JsonObjectCollection(); string flag = "1"; try { Business.Base.BusinessRoom bc = new project.Business.Base.BusinessRoom(); if (jp.getValue("tp") == "update") { bc.load(jp.getValue("id")); bc.Entity.RMLOCNo1 = jp.getValue("RMLOCNo1"); bc.Entity.RMLOCNo2 = jp.getValue("RMLOCNo2"); bc.Entity.RMLOCNo3 = jp.getValue("RMLOCNo3"); bc.Entity.RMLOCNo4 = jp.getValue("RMLOCNo4"); bc.Entity.RMRentType = jp.getValue("RMRentType"); bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics")); bc.Entity.RMBuildSize = ParseDecimalForString(jp.getValue("RMBuildSize")); bc.Entity.RMRentSize = ParseDecimalForString(jp.getValue("RMRentSize")); bc.Entity.RMAddr = jp.getValue("RMAddr"); bc.Entity.RMRemark = jp.getValue("RMRemark"); bc.Entity.HaveAirCondition = bool.Parse(jp.getValue("HaveAirCondition")); int r = bc.Save("update"); if (r <= 0) { flag = "2"; } else { #region 步到资源系统 string syncResult = string.Empty; try { ResourceService.ResourceService srv = new ResourceService.ResourceService(); srv.Url = ConfigurationManager.AppSettings["ResourceServiceUrl"].ToString(); syncResult = srv.AddOrUpdateRoom(JsonConvert.SerializeObject(bc.Entity)); } catch (Exception ex) { syncResult = ex.ToString(); } collection.Add(new JsonStringValue("sync", syncResult)); #endregion } } else { Data obj = new Data(); DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_Room where RMID='" + jp.getValue("RMID") + "'").Tables[0]; if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0) { flag = "3"; } else { bc.Entity.RMID = jp.getValue("RMID"); bc.Entity.RMNo = jp.getValue("RMNo"); bc.Entity.RMLOCNo1 = jp.getValue("RMLOCNo1"); bc.Entity.RMLOCNo2 = jp.getValue("RMLOCNo2"); bc.Entity.RMLOCNo3 = jp.getValue("RMLOCNo3"); bc.Entity.RMLOCNo4 = jp.getValue("RMLOCNo4"); bc.Entity.RMRentType = jp.getValue("RMRentType"); bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics")); bc.Entity.RMBuildSize = ParseDecimalForString(jp.getValue("RMBuildSize")); bc.Entity.RMRentSize = ParseDecimalForString(jp.getValue("RMRentSize")); bc.Entity.RMAddr = jp.getValue("RMAddr"); bc.Entity.RMRemark = jp.getValue("RMRemark"); bc.Entity.HaveAirCondition = bool.Parse(jp.getValue("HaveAirCondition")); bc.Entity.RMCreator = user.Entity.UserName; bc.Entity.RMCreateDate = GetDate(); int r = bc.Save("insert"); if (r <= 0) { flag = "2"; } else { #region 步到资源系统 string syncResult = string.Empty; try { ResourceService.ResourceService srv = new ResourceService.ResourceService(); srv.Url = ConfigurationManager.AppSettings["ResourceServiceUrl"].ToString(); syncResult = srv.AddOrUpdateRoom(JsonConvert.SerializeObject(bc.Entity)); } catch (Exception ex) { syncResult = ex.ToString(); } collection.Add(new JsonStringValue("sync", syncResult)); #endregion } } } } catch { flag = "2"; } collection.Add(new JsonStringValue("type", "submit")); collection.Add(new JsonStringValue("flag", flag)); collection.Add(new JsonStringValue("liststr", createList(jp.getValue("RMIDS"), jp.getValue("RMLOCNo1S"), jp.getValue("RMLOCNo2S"), jp.getValue("RMLOCNo3S"), jp.getValue("RMLOCNo4S"), jp.getValue("CustNoS"), jp.getValue("RMStatusS"), ParseIntForString(jp.getValue("page"))))); return(collection.ToString()); }