private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessWorkPlace bc = new project.Business.Base.BusinessWorkPlace();
bc.load(jp.getValue("id"));
//if (obj.PopulateDataSet("select 1 from Mstr_WorkPlace where WPNo='" + bc.Entity.WPNo + "'").Tables[0].Rows.Count > 0)
//{
// flag = "3";
//}
//else
//{
if (bc.Entity.WPStatus == "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.WPNo);
}
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("WPNoS"), jp.getValue("WPTypeS"), jp.getValue("WPLOCNo1S"), jp.getValue("WPLOCNo2S"),
jp.getValue("WPLOCNo3S"), jp.getValue("WPLOCNo4S"), jp.getValue("WPRMIDS"), jp.getValue("WPStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string validaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessWorkPlace bc = new project.Business.Base.BusinessWorkPlace();
bc.load(jp.getValue("id"));
bc.Entity.WPISEnable = !bc.Entity.WPISEnable;
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.AddOrUpdateWorkPlace(JsonConvert.SerializeObject(bc.Entity));
}
catch (Exception ex)
{
syncResult = ex.ToString();
}
collection.Add(new JsonStringValue("sync", syncResult));
#endregion
}
if (bc.Entity.WPISEnable)
{
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("WPNoS"), jp.getValue("WPTypeS"), jp.getValue("WPLOCNo1S"), jp.getValue("WPLOCNo2S"),
jp.getValue("WPLOCNo3S"), jp.getValue("WPLOCNo4S"), jp.getValue("WPRMIDS"), jp.getValue("WPStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessWorkPlace bc = new project.Business.Base.BusinessWorkPlace();
bc.load(jp.getValue("id"));
//if (obj.PopulateDataSet("select 1 from Mstr_WorkPlace where WPNo='" + bc.Entity.WPNo + "'").Tables[0].Rows.Count > 0)
//{
// flag = "3";
//}
//else
//{
if (bc.Entity.WPStatus == "use")
{
flag = "4";
}
else
{
int r = bc.delete();
if (r <= 0)
{
flag = "2";
}
else
{
collection.Add(new JsonStringValue("ZYSync", bc.SyncResource("del")));
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("WPNoS"), jp.getValue("WPTypeS"), jp.getValue("WPLOCNo1S"), jp.getValue("WPLOCNo2S"),
jp.getValue("WPLOCNo3S"), jp.getValue("WPLOCNo4S"), jp.getValue("WPRMIDS"), jp.getValue("WPStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string submitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessWorkPlace bc = new project.Business.Base.BusinessWorkPlace();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.WPType = jp.getValue("WPType");
bc.Entity.WPSeat = ParseIntForString(jp.getValue("WPSeat"));
bc.Entity.WPSeatPrice = ParseDecimalForString(jp.getValue("WPSeatPrice"));
bc.Entity.WPLOCNo1 = jp.getValue("WPLOCNo1");
bc.Entity.WPLOCNo2 = jp.getValue("WPLOCNo2");
bc.Entity.WPLOCNo3 = jp.getValue("WPLOCNo3");
bc.Entity.WPLOCNo4 = jp.getValue("WPLOCNo4");
bc.Entity.WPRMID = jp.getValue("WPRMID");
bc.Entity.WPProject = jp.getValue("WPProject");
bc.Entity.WPAddr = jp.getValue("WPAddr");
bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics"));
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_WorkPlace where WPNo='" + jp.getValue("WPNo") + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.WPNo = jp.getValue("WPNo");
bc.Entity.WPType = jp.getValue("WPType");
bc.Entity.WPSeat = ParseIntForString(jp.getValue("WPSeat"));
bc.Entity.WPSeatPrice = ParseDecimalForString(jp.getValue("WPSeatPrice"));
bc.Entity.WPLOCNo1 = jp.getValue("WPLOCNo1");
bc.Entity.WPLOCNo2 = jp.getValue("WPLOCNo2");
bc.Entity.WPLOCNo3 = jp.getValue("WPLOCNo3");
bc.Entity.WPLOCNo4 = jp.getValue("WPLOCNo4");
bc.Entity.WPRMID = jp.getValue("WPRMID");
bc.Entity.WPProject = jp.getValue("WPProject");
bc.Entity.WPAddr = jp.getValue("WPAddr");
bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics"));
bc.Entity.WPCreator = user.Entity.UserName;
bc.Entity.WPCreateDate = 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("WPNoS"), jp.getValue("WPTypeS"), jp.getValue("WPLOCNo1S"), jp.getValue("WPLOCNo2S"),
jp.getValue("WPLOCNo3S"), jp.getValue("WPLOCNo4S"), jp.getValue("WPRMIDS"), jp.getValue("WPStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessWorkPlace bc = new project.Business.Base.BusinessWorkPlace();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("WPNo", bc.Entity.WPNo));
collection.Add(new JsonStringValue("WPType", bc.Entity.WPType));
collection.Add(new JsonStringValue("WPSeat", bc.Entity.WPSeat.ToString()));
collection.Add(new JsonStringValue("WPSeatPrice", bc.Entity.WPSeatPrice.ToString("0.####")));
collection.Add(new JsonStringValue("WPLOCNo1", bc.Entity.WPLOCNo1));
collection.Add(new JsonStringValue("WPLOCNo2", bc.Entity.WPLOCNo2));
collection.Add(new JsonStringValue("WPLOCNo3", bc.Entity.WPLOCNo3));
collection.Add(new JsonStringValue("WPLOCNo4", bc.Entity.WPLOCNo4));
collection.Add(new JsonStringValue("WPRMID", bc.Entity.WPRMID));
collection.Add(new JsonStringValue("WPProject", bc.Entity.WPProject));
collection.Add(new JsonStringValue("WPAddr", bc.Entity.WPAddr));
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.WPLOCNo1))
{
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.WPLOCNo2))
{
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.WPLOCNo3))
{
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.BusinessWorkPlace bc = new project.Business.Base.BusinessWorkPlace();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.WPType = jp.getValue("WPType");
bc.Entity.WPSeat = ParseIntForString(jp.getValue("WPSeat"));
bc.Entity.WPSeatPrice = ParseDecimalForString(jp.getValue("WPSeatPrice"));
bc.Entity.WPLOCNo1 = jp.getValue("WPLOCNo1");
bc.Entity.WPLOCNo2 = jp.getValue("WPLOCNo2");
bc.Entity.WPLOCNo3 = jp.getValue("WPLOCNo3");
bc.Entity.WPLOCNo4 = jp.getValue("WPLOCNo4");
bc.Entity.WPRMID = jp.getValue("WPRMID");
bc.Entity.WPProject = jp.getValue("WPProject");
bc.Entity.WPAddr = jp.getValue("WPAddr");
bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics"));
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.AddOrUpdateWorkPlace(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_WorkPlace where WPNo='" + jp.getValue("WPNo") + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.WPNo = jp.getValue("WPNo");
bc.Entity.WPType = jp.getValue("WPType");
bc.Entity.WPSeat = ParseIntForString(jp.getValue("WPSeat"));
bc.Entity.WPSeatPrice = ParseDecimalForString(jp.getValue("WPSeatPrice"));
bc.Entity.WPLOCNo1 = jp.getValue("WPLOCNo1");
bc.Entity.WPLOCNo2 = jp.getValue("WPLOCNo2");
bc.Entity.WPLOCNo3 = jp.getValue("WPLOCNo3");
bc.Entity.WPLOCNo4 = jp.getValue("WPLOCNo4");
bc.Entity.WPRMID = jp.getValue("WPRMID");
bc.Entity.WPProject = jp.getValue("WPProject");
bc.Entity.WPAddr = jp.getValue("WPAddr");
bc.Entity.IsStatistics = bool.Parse(jp.getValue("IsStatistics"));
bc.Entity.WPCreator = user.Entity.UserName;
bc.Entity.WPCreateDate = 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.AddOrUpdateWorkPlace(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("WPNoS"), jp.getValue("WPTypeS"), jp.getValue("WPLOCNo1S"), jp.getValue("WPLOCNo2S"),
jp.getValue("WPLOCNo3S"), jp.getValue("WPLOCNo4S"), jp.getValue("WPRMIDS"), jp.getValue("WPStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}