private string reserveaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
bc.load(jp.getValue("id"));
if (bc.Entity.CRStatus == "free")
{
bc.Entity.CRCurrentCustNo = jp.getValue("ReserveCust");
bc.Entity.CRReservedDate = GetDate();
bc.Entity.CRBegReservedDate = ParseDateForString(jp.getValue("BegReserveDate"));
bc.Entity.CREndReservedDate = ParseDateForString(jp.getValue("EndReserveDate"));
int r = bc.reserve();
if (r <= 0)
{
flag = "4";
}
}
else
{
flag = "3";
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "reserve"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("CRNoS"), jp.getValue("CRNameS"), jp.getValue("CRAddrS"), jp.getValue("CRStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string unreserveaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
bc.load(jp.getValue("id"));
if (bc.Entity.CRStatus == "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("CRNoS"), jp.getValue("CRNameS"), jp.getValue("CRAddrS"), jp.getValue("CRStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string validaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
bc.load(jp.getValue("id"));
bc.Entity.CRISEnable = !bc.Entity.CRISEnable;
int r = bc.valid();
if (r <= 0)
{
flag = "2";
}
if (bc.Entity.CRISEnable)
{
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("CRNoS"), jp.getValue("CRNameS"), jp.getValue("CRAddrS"), jp.getValue("CRStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string updateaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
bc.load(jp.getValue("id"));
collection.Add(new JsonStringValue("CRNo", bc.Entity.CRNo));
collection.Add(new JsonStringValue("CRName", bc.Entity.CRName));
collection.Add(new JsonStringValue("CRCapacity", bc.Entity.CRCapacity));
collection.Add(new JsonStringValue("CRINPriceHour", bc.Entity.CRINPriceHour.ToString("0.####")));
collection.Add(new JsonStringValue("CRINPriceHalfDay", bc.Entity.CRINPriceHalfDay.ToString("0.####")));
collection.Add(new JsonStringValue("CRINPriceDay", bc.Entity.CRINPriceDay.ToString("0.####")));
collection.Add(new JsonStringValue("CROUTPriceHour", bc.Entity.CROUTPriceHour.ToString("0.####")));
collection.Add(new JsonStringValue("CROUTPriceHalfDay", bc.Entity.CROUTPriceHalfDay.ToString("0.####")));
collection.Add(new JsonStringValue("CROUTPriceDay", bc.Entity.CROUTPriceDay.ToString("0.####")));
collection.Add(new JsonStringValue("CRDeposit", bc.Entity.CRDeposit.ToString("0.####")));
collection.Add(new JsonStringValue("CRAddr", bc.Entity.CRAddr));
//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.CRLOCNo1))
//{
// 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.CRLOCNo2))
//{
// 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.CRLOCNo3))
//{
// 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 deleteaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
bc.load(jp.getValue("id"));
//if (obj.PopulateDataSet("select 1 from Mstr_ConferenceRoom where CRNo='" + bc.Entity.CRNo + "'").Tables[0].Rows.Count > 0)
//{
// flag = "3";
//}
//else
//{
if (bc.Entity.CRStatus == "use")
{
flag = "4";
}
else
{
int r = bc.delete();
if (r <= 0)
{
flag = "2";
}
}
//}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "delete"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("CRNoS"), jp.getValue("CRNameS"), jp.getValue("CRAddrS"), jp.getValue("CRStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string submitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
if (jp.getValue("tp") == "update")
{
bc.load(jp.getValue("id"));
bc.Entity.CRName = jp.getValue("CRName");
bc.Entity.CRCapacity = jp.getValue("CRCapacity");
bc.Entity.CRINPriceHour = ParseDecimalForString(jp.getValue("CRINPriceHour"));
bc.Entity.CRINPriceHalfDay = ParseDecimalForString(jp.getValue("CRINPriceHalfDay"));
bc.Entity.CRINPriceDay = ParseDecimalForString(jp.getValue("CRINPriceDay"));
bc.Entity.CROUTPriceHour = ParseDecimalForString(jp.getValue("CROUTPriceHour"));
bc.Entity.CROUTPriceHalfDay = ParseDecimalForString(jp.getValue("CROUTPriceHalfDay"));
bc.Entity.CROUTPriceDay = ParseDecimalForString(jp.getValue("CROUTPriceDay"));
bc.Entity.CRDeposit = ParseDecimalForString(jp.getValue("CRDeposit"));
bc.Entity.CRAddr = jp.getValue("CRAddr");
int r = bc.Save("update");
if (r <= 0)
{
flag = "2";
}
}
else
{
Data obj = new Data();
DataTable dt = obj.PopulateDataSet("select cnt=COUNT(*) from Mstr_ConferenceRoom where CRNo='" + jp.getValue("CRNo") + "'").Tables[0];
if (int.Parse(dt.Rows[0]["cnt"].ToString()) > 0)
{
flag = "3";
}
else
{
bc.Entity.CRNo = jp.getValue("CRNo");
bc.Entity.CRName = jp.getValue("CRName");
bc.Entity.CRCapacity = jp.getValue("CRCapacity");
bc.Entity.CRINPriceHour = ParseDecimalForString(jp.getValue("CRINPriceHour"));
bc.Entity.CRINPriceHalfDay = ParseDecimalForString(jp.getValue("CRINPriceHalfDay"));
bc.Entity.CRINPriceDay = ParseDecimalForString(jp.getValue("CRINPriceDay"));
bc.Entity.CROUTPriceHour = ParseDecimalForString(jp.getValue("CROUTPriceHour"));
bc.Entity.CROUTPriceHalfDay = ParseDecimalForString(jp.getValue("CROUTPriceHalfDay"));
bc.Entity.CROUTPriceDay = ParseDecimalForString(jp.getValue("CROUTPriceDay"));
bc.Entity.CRDeposit = ParseDecimalForString(jp.getValue("CRDeposit"));
bc.Entity.CRAddr = jp.getValue("CRAddr");
bc.Entity.CRCreator = user.Entity.UserName;
bc.Entity.CRCreateDate = GetDate();
int r = bc.Save("insert");
if (r <= 0)
{
flag = "2";
}
}
}
}
catch { flag = "2"; }
collection.Add(new JsonStringValue("type", "submit"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("CRNoS"), jp.getValue("CRNameS"), jp.getValue("CRAddrS"), jp.getValue("CRStatusS"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
//protected string CRLOCNo1Str = "";
//protected string CRLOCNo1StrS = "";
private string createList(string CRNo, string CRName, string CRAddr, string CRStatus, int page)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort\" id=\"tablelist\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th width=\"4%\">序号</th>");
sb.Append("<th width='8%'>会议室编号</th>");
sb.Append("<th width='12%'>会议室名称</th>");
sb.Append("<th width='7%'>容纳人数</th>");
sb.Append("<th width='7%'>对内价格/小时</th>");
sb.Append("<th width='7%'>对内价格/半天</th>");
sb.Append("<th width='7%'>对内价格/全天</th>");
sb.Append("<th width='7%'>对外价格/小时</th>");
sb.Append("<th width='7%'>对外价格/半天</th>");
sb.Append("<th width='7%'>对外价格/全天</th>");
sb.Append("<th width='7%'>押金</th>");
sb.Append("<th width='6%'>状态</th>");
sb.Append("<th width='6%'>是否禁用</th>");
sb.Append("<th width='8%'>操作</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
Business.Base.BusinessConferenceRoom bc = new project.Business.Base.BusinessConferenceRoom();
foreach (Entity.Base.EntityConferenceRoom it in bc.GetListQuery(CRNo, CRName, CRAddr, CRStatus, page, pageSize))
{
sb.Append("<tr class=\"text-c\" id=\"" + it.CRNo + "\">");
sb.Append("<td style=\"text-align:center;\">" + r.ToString() + "</td>");
sb.Append("<td>" + it.CRNo + "</td>");
sb.Append("<td>" + it.CRName + "</td>");
sb.Append("<td>" + it.CRCapacity + "</td>");
sb.Append("<td>" + it.CRINPriceHour.ToString("0.####") + "</td>");
sb.Append("<td>" + it.CRINPriceHalfDay.ToString("0.####") + "</td>");
sb.Append("<td>" + it.CRINPriceDay.ToString("0.####") + "</td>");
sb.Append("<td>" + it.CROUTPriceHour.ToString("0.####") + "</td>");
sb.Append("<td>" + it.CROUTPriceHalfDay.ToString("0.####") + "</td>");
sb.Append("<td>" + it.CROUTPriceDay.ToString("0.####") + "</td>");
sb.Append("<td>" + it.CRDeposit.ToString("0.####") + "</td>");
sb.Append("<td class=\"td-status\"><span class=\"label " + (it.CRStatus == "use" ? "label-success" : "") + " radius\">" + it.CRStatusName + "</span></td>");
sb.Append("<td class=\"td-status\"><span class=\"label " + (it.CRISEnable == false ? "label-success" : "") + " radius\">" + (it.CRISEnable == false ? "正常" : "已禁用") + "</span></td>");
if (it.CRStatus == "use")
{
sb.Append("<td></td>");
}
else if (it.CRStatus == "free")
{
sb.Append("<td><input class=\"btn btn-primary radius size-MINI\" style=\"padding:0px 10px; margin:0px;\" type=\"button\" value=\"预定\" onclick=\"reserve('" + it.CRNo + "')\" /></td>");
}
else
{
sb.Append("<td><input class=\"btn btn-primary radius size-MINI\" style=\"padding:0px 10px; margin:0px;\" type=\"button\" value=\"取消预定\" onclick=\"unreserve('" + it.CRNo + "')\" /></td>");
}
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append(Paginat(bc.GetListCount(CRNo, CRName, CRAddr, CRStatus), pageSize, page, 7));
return(sb.ToString());
}
