Gsmarket/Sources/GS-MarketMG-2018/GSMarketSys/Controllers/GetResultController.cs

using System.Data;
using System.Text;
using System.Web.Mvc;
using SysBaseLibs;
using SysDataLibs.TableClass;
using System;
using System.Collections.Generic;
using System.IO;
using System.Threading;
using SelectPdf;
using SysDataLibs;



namespace GSMarketSys.Controllers
{
    public class GetResultController : BaseController
    {
		#region 市场信息
		/// <summary>
		/// 市场信息录入
		/// </summary>
		/// <param name="isLock"></param>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="marketType"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsListResult(string isLock, string marketType)
		{
		    string marketId = Request["MarketID"]?.Trim() ?? "",
		        names = Request["Names"]?.Trim() ?? "",
		        regionId = Request["RegionID"]?.Trim() ?? "",
		        licenseNo = Request["LicenseNo"]?.Trim() ?? "",
		        licenseName = Request["LicenseName"]?.Trim() ?? "",
		        marketTypeId = Request["MarketTypeName"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false) +
		                      " AND Markettypeid " + (marketType != "6" ? "<>" : "=") + "'6' AND " + Markets_info.cIsLock + "=" + isLock;
            string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cMarketID + " like '%" + ts + "%'";
		    ts = names;
            ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cNames + " like '%" + ts + "%'";
            ts = regionId;
            ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0 && ts.Trim()!= "100001")
		        whereSql += " AND " + Markets_info.cRegionID + " ='" + ts + "'";
		    ts = licenseNo;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cLicenseNo + " like '%" + ts + "%'";
		    ts = licenseName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cLicenseName + " like '%" + ts + "%'";
		    ts = marketTypeId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cMarketTypeID + " ='" + ts + "'";
            string lcSql = "SELECT * FROM ViewMarketInfos WHERE  " + whereSql;


            return Content(GetData.Instance.GetResultLockTran(lcSql, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 市场信息查询
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsQryResult(string pcVal, string pcItem, string marketType)
		{
			var pcValS = Encoding.UTF8.GetBytes(pcVal);
			pcVal = Encoding.UTF8.GetString(pcValS);
			string lcSql = "SELECT * FROM ViewMarketInfos WHERE MarketTypeID" + (marketType != "6" ? "<>" : "=") +
						   "'6' AND " + Markets_info.cIsLock + "=0 ";

			if (!string.IsNullOrEmpty(pcVal))
			{
				string str = Utils.GetQuerySQL(pcItem, pcVal);
				lcSql += " AND " + str;
				////市场名称、地址、市场类型、辖区工商
				//if (pcItem == "Names" || pcItem == "Address" || pcItem == "MarketTypeName" || pcItem == "RegionNames")
				//{
				//	string str = Utils.GetQuerySQL(pcItem, pcVal);
				//	lcSql += " AND " + str;
				//}
				//else if (pcItem == "WarrantNumber")//执照号码
				//{
				//	string ts = Utils.AreaToSQL(pcVal.Trim());
				//	lcSql += " AND " + Markets_info.cMarketID + " IN(SELECT " + MarketHasWarrant_info.cMarketID + " FROM " +
				//			 Tn.MarketHasWarrant + " WHERE " + MarketHasWarrant_info.cWarrantNumber + " like '%" + ts + "%')";
				//}
			}

			lcSql += " AND " + UserSessionInfo.MarketDataSql(false);
			lcSql += " ORDER BY " + Markets_info.cPractiseTime + " DESC";

			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 市场证照信息
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsWarrantResult()
		{
			string marketId = Request["MarketID"]??UserSessionInfo.MarketId?.Trim()??"";
			string lcSql = "SELECT * FROM ViewMarketWarrantInfos_New WHERE " + MarketHasWarrant_info.cMarketID + "='" + marketId + "'";
			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 市场信用评级
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsEvalRptResult()
		{
			string marketId = Request["MarketID"];

			//获取近两年的记录
			string lcSql = "SELECT * FROM " + Tn.vwMarketEvalRpt + " WHERE " + vwMarketEvalRpt_info.cMarketId + "='" + marketId + "' AND " + vwMarketEvalRpt_info.cYear + "> '" + DateTime.Now.AddYears(-2).Year + "' ORDER BY Year DESC , Month DESC ";
			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
			StringBuilder sb = new StringBuilder();
			sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
			if (loQuery.IsOpened && loQuery.RecCount > 0)
			{
				DataTable dt = loQuery.CurrentTable;
				dt.Columns.Add("TotalScoreState", typeof(string));
				dt.Columns.Add("Time", typeof(string));
				for (int i = 0; i < dt.Rows.Count; i++)
				{
					dt.Rows[i]["TotalScoreState"] = MarketEvalGrade_info.GetRankByScore((int)dt.Rows[i]["TotalScore"]);
					dt.Rows[i]["Time"] = dt.Rows[i]["Year"] + " 年 " +
										 dt.Rows[i]["Month"] + " 月";
				}
				sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
			}
			else
				sb.Append("[]");
			sb.Append("}");

			return Content(sb.ToString());
		}

		/// <summary>
		/// 加载市场图片
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsShowImage()
		{
			string chartTypeId = Request["ChartTypeId"];
			string marketId = Request["MarketId"];
			string chartId = Request["ChartId"];

			string lcSql = "";

			if (string.IsNullOrEmpty(chartId))
			{
				if (!string.IsNullOrEmpty(chartTypeId) && !string.IsNullOrEmpty(marketId))
				{
					lcSql = "SELECT * FROM ViewMarketChart WHERE ChartTypeID='" + chartTypeId + "' AND MarketID='" + marketId + "'";
				}
			}
			else
			{
				lcSql = "SELECT * FROM ViewMarketChart WHERE ID='" + chartId + "' ";
			}

			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
			if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
			{
				loQuery.MoveFirst();
				try
				{
					//if (loQuery.CurrentRow[MarketChart_info.cChart] != null)
					//{
					//	string base64Str = Convert.ToBase64String((byte[])loQuery.CurrentRow[MarketChart_info.cChart]);
					//	return Content(base64Str);

					//}
					string filePath = loQuery.GetString("FilePath");
					string fileName = loQuery.GetString("FileName");
					if (!string.IsNullOrEmpty(filePath)&&!string.IsNullOrEmpty(fileName))
					{
						return Content("../" + filePath + "/" + fileName);
					}
				}
				catch (Exception err)
				{
					ThreadLog.LogException(err);
				}
			}
			return Content("");
		}

		/// <summary>
		/// 市场信用查询
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsEvalRptQryResult(string year, string month, string isEvaluation, string pcVal, string pcItem, string marketType)
		{
		    string marketId = Request["MarketID"]?.Trim() ?? "",
		        names = Request["Names"]?.Trim() ?? "",
		        regionId = Request["RegionID"]?.Trim() ?? "",
		        licenseNo = Request["LicenseNo"]?.Trim() ?? "",
		        licenseName = Request["LicenseName"]?.Trim() ?? "",
		        isLock = Request["IsLock"]?.Trim() ?? "",
		        marketTypeId = Request["MarketTypeName"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false) +
		                      " AND Markettypeid " + (marketType != "6" ? "<>" : "=") + "'6' AND " + Markets_info.cIsLock + "=" + isLock;
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cMarketID + " like '%" + ts + "%'";
		    ts = names;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cNames + " like '%" + ts + "%'";
		    ts = regionId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0&&ts.Trim() != "100001")
		        whereSql += " AND " + Markets_info.cRegionID + " ='" + ts + "'";
		    ts = licenseNo;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cLicenseNo + " like '%" + ts + "%'";
		    ts = licenseName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cLicenseName + " like '%" + ts + "%'";
		    ts = marketTypeId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + Markets_info.cMarketTypeID + " ='" + ts + "'";
            string lcSql;
			year = Utils.AreaToSQL(year.Trim());
			month = Utils.AreaToSQL(month.Trim());
			if (isEvaluation == "0")
			{
				lcSql = "SELECT * FROM vwMarketEvalGrade_New WHERE " + UserSessionInfo.MarketDataSql(false) + " AND MarketTypeID" +
						(marketType != "6" ? "<>" : "=") +
						"'6' AND IsLock=0 ";
				//年月
				if (year.Length > 0)
					lcSql += " AND Year='" + year + "'";
				if (month.Length > 0)
					lcSql += " AND Month='" + month + "'";
			}
			else
			{
				lcSql = "SELECT * FROM ViewMarketInfos WHERE " + UserSessionInfo.MarketDataSql(false) + " AND MarketTypeID" +
						(marketType != "6" ? "<>" : "=") +
						"'6' AND IsLock=0 AND  " + Markets_info.cMarketID + " NOT IN (" + "SELECT " +
						vwMarketEvalGrade_info.cMarketID + " FROM " + Tn.vwMarketEvalGrade + " WHERE " +
						vwMarketEvalGrade_info.cYear + " = '" + year + "' AND " + vwMarketEvalGrade_info.cMonth + " = '" +
						month + "' ) ";
			}

			//if (!string.IsNullOrEmpty(pcVal))
			//{
			//	//市场名称、地址、市场类型、辖区工商
			//	if (pcItem == "Names" || pcItem == "Address" || pcItem == "MarketTypeName" || pcItem == "RegionNames")
			//	{
			//		string str = Utils.GetQuerySQL(pcItem, pcVal);
			//		lcSql += " AND " + str;
			//	}
			//	else if (pcItem == "WarrantNumber")//执照号码
			//	{
			//		string ts = Utils.AreaToSQL(pcVal.Trim());
			//		lcSql += " AND " + Markets_info.cMarketID + " IN(SELECT " + MarketHasWarrant_info.cMarketID + " FROM " +
			//				 Tn.MarketHasWarrant + " WHERE " + MarketHasWarrant_info.cWarrantNumber + " like '%" + ts + "%')";
			//	}
			//}


			lcSql += " AND " + whereSql;
			lcSql += " ORDER BY " + (isEvaluation == "0" ? vwMarketEvalGrade_info.cYear + " DESC , " + vwMarketEvalGrade_info.cMonth + " DESC" : Markets_info.cPractiseTime + " DESC");

			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 市场信用考核表
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsEvalRptQryTableStr(string year, string month, string marketId, string view)
		{
			StringBuilder sb = new StringBuilder();

			if (!string.IsNullOrEmpty(marketId))
			{
				Markets_info loMarket = new Markets_info(marketId, UserSessionInfo.DBConn);
				Evaluation_info loEval = new Evaluation_info("M", true, UserSessionInfo.DBConn);
				MarketEvalGrade_Qry loQuery = new MarketEvalGrade_Qry();
				if (view == "Y" || view == "M")
				{
					loQuery.Open("SELECT * FROM  " + Tn.MarketEvalGrade + "  WHERE "
								 + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND "
								 + MarketEvalGrade_info.cYear + "='" + year + "' AND "
								 + MarketEvalGrade_info.cMonth + "='" + month + "'", UserSessionInfo.DBConn);
				}
				string dateTime = view == "Y" || view == "M"
					? loQuery.ScoreDate.ToLongDateString()
					: DateTime.Now.ToLongDateString();
				sb.Append("{\"EvaluationTitle\":\"" + loEval.EvaluationName + "\",\"MarketName\":\"" + loMarket.Names + "\",\"DateTime\":\"" + dateTime + "\",\"tbStr\":\"");

				if (loEval.CurEvaluationItems != null && loEval.CurEvaluationItems.IsOpened)
				{
					long ldAllCount = 0;
					long ldScoreTotal = 0;
					string score = "";
					loEval.CurEvaluationItems.MoveFirst();
					for (int i = 0; i < loEval.CurEvaluationItems.RecCount; i++)
					{

						ldAllCount += loEval.CurEvaluationItems.Score;
						if (view == "Y" && loQuery.IsOpened)
						{
							if (loQuery.GoToRecordByFieldsAndValues(MarketEvalGrade_info.cEvaluationID + "," + MarketEvalGrade_info.cEvaluationItemID, loEval.EvaluationID + "," + loEval.CurEvaluationItems.EvaluationItemID))
							{
								score = "<span class='score_Input' style='width:50px;display:block'>" + loQuery.Score + "</span>";
								ldScoreTotal += loQuery.Score;
							}
						}
						else if (view == "M" && loQuery.IsOpened)
						{
							if (loQuery.GoToRecordByFieldsAndValues(MarketEvalGrade_info.cEvaluationID + "," + MarketEvalGrade_info.cEvaluationItemID, loEval.EvaluationID + "," + loEval.CurEvaluationItems.EvaluationItemID))
							{
								//loCell.InnerHtml = loQuery.Score + "";
								ldScoreTotal += loQuery.Score;
								score = "<input class='score_Input'  id='txtNum_" + loEval.EvaluationID + "_" + loEval.CurEvaluationItems.EvaluationItemID + "' value=" + loQuery.Score + " class='score_Input'  onchange=CheckValue(this," + loEval.CurEvaluationItems.Score + ")  type='text' />";
							}
						}
						else
						{
							score = " <input class='score_Input'  id='txtNum_" + loEval.EvaluationID + "_" + loEval.CurEvaluationItems.EvaluationItemID + "' value=" + loEval.CurEvaluationItems.Score + " class='inputa'  onchange=CheckValue(this," + loEval.CurEvaluationItems.Score + ")  type='text'/>";
						}
						sb.AppendFormat(
							"<tr><td style='width: 5%; height: 30px; text-align: center;' >{0}</td><td style='width: 35%; text-align: center;'>{1}</ td ><td style='width: 7%; text-align: center;'>{2}</td><td style='width: 49%; text-align: left;text-indent:2em;'>{3}</ td ><td style='width: 6%; text-align: center;'>{4}</td></tr>", i + 1, loEval.CurEvaluationItems.ItemContent, loEval.CurEvaluationItems.Score, loEval.CurEvaluationItems.EvaluationNorm, score);
						loEval.CurEvaluationItems.MoveNext();
					}
					sb.AppendFormat("<tr><td colspan = '2' style ='width: 5%; height: 30px; text-align: center;'><strong>总分</strong></td><td style='width: 7%; text-align: center;'>{0}</ td ><td style='width: 49%; text-align: left;text-indent:2em;'></td><td style='width: 6%; text-align: center;'><span class='score_Input'  id='TotalScore'><strong id='txtNum_All'>{1}</strong></span></td></tr>", ldAllCount, ldScoreTotal);
					sb.Append("\"}");
				}
			}

			return Content(sb.ToString());
		}
		#endregion

		#region 经营户信息

	    /// <summary>
	    /// 经营户信息录入
	    /// </summary>
	    /// <param name="isLock"></param>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
		public ActionResult MarketSellersListResult(string isLock, string pcVal, string pcItem, string page, string rows)
	    {
		    string whereSql = UserSessionInfo.MarketDataSql(false) + " AND " + Markets_info.cIsLock + "='" +
		                      (isLock == "0" ? "N" : "Y") + "' ";
			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
			{
		        pcVal = pcVal.Trim();
				string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
			}
			string orderSql = " SellerID DESC ," + ViewMarketSellers_info.cStallName + " DESC";


			return Content(GetData.Instance.GetResult("ViewMarketSellers_New", "*", whereSql, orderSql, Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 经营户证照信息
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellersWarrantResult()
		{
			string sellerId = Request["SellerID"];
			string lcSql = "SELECT * FROM ViewMarketSellerWarrant WHERE " + SellerHasWarrant_info.cSellerID + "='" + sellerId + "'";
			string ltRetval = GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn);
			return Content(GetData.Instance.TranFromSysStates("SellerHasWarrant", "WarrantStyle", ltRetval, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 经营户信息查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellersQryResult(string page, string rows)
		{
			string marketSellerName = Request["MarketSellerName"]?.Trim() ?? "",
				//warrantNumber = Request["WarrantNumber"]?.Trim() ?? "",
				//regionId = Request["RegionId"]?.Trim() ?? "",
                isLock = Request["IsLock"]?.Trim()=="0"?"N":"Y",
                licenseNo = Request["LicenseNo"],
				licenseName = Request["LicenseName"],
				marketId = Request["MarketID"]?.Trim() ?? "",
				tradeTypeId = Request["TradeTypeID"]?.Trim() ?? "",
				tempAddress = Request["TempAddress"]?.Trim() ?? "",
				stallName = Request["Stall"]?.Trim() ?? "";

			string whereSql = UserSessionInfo.MarketDataSql(false);
			string ts = marketSellerName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cMarketSellerName + " like '%" + ts + "%'";
			ts = tempAddress;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cTempAddress + " like '%" + ts + "%'";
			ts = stallName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cStallName + "  like '%" + ts + "%'";
			ts = tradeTypeId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cTradeTypeID + "='" + ts + "'";
			ts = marketId;
			//ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cMarketID + " IN(" + ts + ")";
			//ts = warrantNumber;
			//ts = Utils.AreaToSQL(ts);
			//if (ts.Length > 0)
			//	whereSql += "  AND " + SellerHasWarrant_info.cWarrantNumber + " like '%" + ts + "%'";
			ts = licenseNo;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cStallName + "  like '%" + ts + "%'";

			ts = licenseName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + ViewMarketSellers_info.cStallName + "  like '%" + ts + "%'";
			whereSql += " AND IsLock = '" + isLock + "'";

			//辖区
			//  string ts2 = Utils.AreaToSQL(regionId.Trim());
			//  ts2 = Regions_info.GetAllRegion(UserSessionInfo, ts2);
			//  if (ts.Length > 0)
			//whereSql += " AND " + ViewMarketSellers_info.cRegionID + " IN (" + ts2 + ")";

			string orderSql = " SellerID DESC ," + ViewMarketSellers_info.cStallName + " DESC";


			return Content(GetData.Instance.GetResult("ViewMarketSellers_New", "*", whereSql, orderSql, Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 经营户日常行为信息
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellersViolationResult()
		{
			string sellerId = Request["SellerID"];
			string lcSql = "SELECT * FROM " + Tn.SellerViolations + " WHERE " + SellerViolations_info.cSellerID + "='" + sellerId + "'";
			//string ltRetval = GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn);

			return Content(GetData.Instance.GetResultTran(lcSql, "ViolationTypeID|SellerRewardTypeID", "ViolationTypeName|SellerRewardTypeName", "SellerViolationType|SellerRewardType", "Name|Name", UserSessionInfo.DBConn));
			//return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}
		/// <summary>
		/// 经营户信用评级
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellersEvalRptResult()
		{
			string sellerId = Request["SellerID"];

			//获取近两年的记录
			string lcSql = "SELECT * FROM " + Tn.vwSellerEvalRpt + " WHERE " + vwSellerEvalRpt_info.cSellerID + "='" + sellerId + "' AND " + vwMarketEvalRpt_info.cYear + "> '" + DateTime.Now.AddYears(-2).Year + "' ORDER BY Year DESC , Month DESC ";
			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
			StringBuilder sb = new StringBuilder();
			sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
			if (loQuery.IsOpened && loQuery.RecCount > 0)
			{
				DataTable dt = loQuery.CurrentTable;
				dt.Columns.Add("TotalScoreState", typeof(string));
				dt.Columns.Add("Time", typeof(string));
				for (int i = 0; i < dt.Rows.Count; i++)
				{
					dt.Rows[i]["TotalScoreState"] = MarketEvalGrade_info.GetRankByScore((int)dt.Rows[i]["TotalScore"]);
					dt.Rows[i]["Time"] = dt.Rows[i]["Year"] + " 年 " +
										 dt.Rows[i]["Month"] + " 月";
				}
				sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
			}
			else
				sb.Append("[]");
			sb.Append("}");

			return Content(sb.ToString());
		}

		/// <summary>
		/// 经营户信用查询
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellersEvalRptQryResult(string year, string month, string isEvaluation, string pcVal, string pcItem)
		{
		    string marketSellerName = Request["MarketSellerName"]?.Trim() ?? "",
		        //warrantNumber = Request["WarrantNumber"]?.Trim() ?? "",
		        //regionId = Request["RegionId"]?.Trim() ?? "",
		        licenseNo = Request["LicenseNo"],
		        licenseName = Request["LicenseName"],
		        marketId = Request["MarketID"]?.Trim() ?? "",
		        tradeTypeId = Request["TradeTypeID"]?.Trim() ?? "",
		        tempAddress = Request["TempAddress"]?.Trim() ?? "",
		        stallName = Request["Stall"]?.Trim() ?? "";

		    string whereSql = UserSessionInfo.MarketDataSql(true);
		    string ts = marketSellerName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cMarketSellerName + " like '%" + ts + "%'";
		    ts = tempAddress;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cTempAddress + " like '%" + ts + "%'";
		    ts = stallName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cStallName + "  like '%" + ts + "%'";
		    ts = tradeTypeId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cTradeTypeID + "='" + ts + "'";
		    ts = marketId;
		    //ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cMarketID + " IN(" + ts + ")";
		    //ts = warrantNumber;
		    //ts = Utils.AreaToSQL(ts);
		    //if (ts.Length > 0)
		    //	whereSql += "  AND " + SellerHasWarrant_info.cWarrantNumber + " like '%" + ts + "%'";
		    ts = licenseNo;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cStallName + "  like '%" + ts + "%'";

		    ts = licenseName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		        whereSql += " AND " + ViewMarketSellers_info.cStallName + "  like '%" + ts + "%'";
            string lcSql;
			year = Utils.AreaToSQL(year.Trim());
			month = Utils.AreaToSQL(month.Trim());
			if (isEvaluation == "0")
			{
				lcSql = "SELECT * FROM " + Tn.vwMarketSellerEvalGrade + "  WHERE " + UserSessionInfo.MarketDataSql(false);
				//年月
				if (year.Length > 0)
					lcSql += " AND Year='" + year + "'";
				if (month.Length > 0)
					lcSql += " AND Month='" + month + "'";
			}
			else
			{
				lcSql = "SELECT Top 400 * FROM " + Tn.ViewMarketSellers + " WHERE " + UserSessionInfo.MarketDataSql(false) + " AND " + ViewMarketSellers_info.cSellerID + " NOT IN (" + "SELECT " +
						vwMarketSellerEvalGrade_info.cSellerID + " FROM " + Tn.vwMarketSellerEvalGrade + " WHERE " +
						vwMarketSellerEvalGrade_info.cYear + " = '" + year + "' AND " + vwMarketSellerEvalGrade_info.cMonth + " = '" +
						month + "' ) ";
			}

            lcSql += whereSql + " ORDER BY " + (isEvaluation == "0" ? vwMarketSellerEvalGrade_info.cYear + " DESC , " + vwMarketSellerEvalGrade_info.cMonth + " DESC" : ViewMarketSellers_info.cEnterMarketDate + " DESC");

			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 经营户信用考核表
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellersEvalRptQryTableStr(string year, string month, string marketId, string sellerId, string view)
		{
			StringBuilder sb = new StringBuilder();

			if (!string.IsNullOrEmpty(marketId) && !string.IsNullOrEmpty(sellerId))
			{
				MarketSellers_info loSeller = new MarketSellers_info(sellerId, UserSessionInfo.DBConn);
				Evaluation_info loEval = new Evaluation_info("G", true, UserSessionInfo.DBConn);

				SellerEvalGrade_Qry loQuery = new SellerEvalGrade_Qry();
				if (view == "Y" || view == "M")
				{
					loQuery.Open("SELECT * FROM  " + Tn.SellerEvalGrade + "  WHERE "
								 + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND "
								 + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND "
								 + MarketEvalGrade_info.cYear + "='" + year + "' AND "
								 + MarketEvalGrade_info.cMonth + "='" + month + "'", UserSessionInfo.DBConn);
				}
				string dateTime = view == "Y" || view == "M"
					? loQuery.ScoreDate.ToLongDateString()
					: DateTime.Now.ToLongDateString();
				sb.Append("{\"EvaluationTitle\":\"" + loEval.EvaluationName + "\",\"SellerName\":\"" + loSeller.Name + "\",\"DateTime\":\"" + dateTime + "\",\"tbStr\":\"");

				if (loEval.CurEvaluationItems != null && loEval.CurEvaluationItems.IsOpened)
				{
					long ldAllCount = 0;
					long ldScoreTotal = 0;
					string score = "";
					loEval.CurEvaluationItems.MoveFirst();
					for (int i = 0; i < loEval.CurEvaluationItems.RecCount; i++)
					{

						ldAllCount += loEval.CurEvaluationItems.Score;
						if (view == "Y" && loQuery.IsOpened)
						{
							if (loQuery.GoToRecordByFieldsAndValues(MarketEvalGrade_info.cEvaluationID + "," + MarketEvalGrade_info.cEvaluationItemID, loEval.EvaluationID + "," + loEval.CurEvaluationItems.EvaluationItemID))
							{
								score = "<span class='score_Input' style='width:50px;display:block'>" + loQuery.Score + "</span>";
								ldScoreTotal += loQuery.Score;
							}
						}
						else if (view == "M" && loQuery.IsOpened)
						{
							if (loQuery.GoToRecordByFieldsAndValues(MarketEvalGrade_info.cEvaluationID + "," + MarketEvalGrade_info.cEvaluationItemID, loEval.EvaluationID + "," + loEval.CurEvaluationItems.EvaluationItemID))
							{
								//loCell.InnerHtml = loQuery.Score + "";
								ldScoreTotal += loQuery.Score;
								score = "<input class='score_Input'  id='txtNum_" + loEval.EvaluationID + "_" + loEval.CurEvaluationItems.EvaluationItemID + "' value=" + loQuery.Score + " class='score_Input'  onchange=CheckValue(this," + loEval.CurEvaluationItems.Score + ")  type='text' />";
							}
						}
						else
						{
							score = " <input class='score_Input'  id='txtNum_" + loEval.EvaluationID + "_" + loEval.CurEvaluationItems.EvaluationItemID + "' value=" + loEval.CurEvaluationItems.Score + " class='inputa'  onchange=CheckValue(this," + loEval.CurEvaluationItems.Score + ")  type='text'/>";
						}
						sb.AppendFormat(
							"<tr><td style='width: 5%; height: 30px; text-align: center;' >{0}</td><td style='width: 35%; text-align: center;'>{1}</ td ><td style='width: 7%; text-align: center;'>{2}</td><td style='width: 49%; text-align: left;text-indent:2em;'>{3}</ td ><td style='width: 6%; text-align: center;'>{4}</td></tr>", i + 1, loEval.CurEvaluationItems.ItemContent, loEval.CurEvaluationItems.Score, loEval.CurEvaluationItems.EvaluationNorm, score);
						loEval.CurEvaluationItems.MoveNext();
					}
					sb.AppendFormat("<tr><td colspan = '2' style ='width: 5%; height: 30px; text-align: center;'><strong>总分</strong></td><td style='width: 7%; text-align: center;'>{0}</ td ><td style='width: 49%; text-align: left;text-indent:2em;'></td><td style='width: 6%; text-align: center;'><span class='score_Input'  id='TotalScore'><strong id='txtNum_All'>{1}</strong></span></td></tr>", ldAllCount, ldScoreTotal);
					sb.Append("\"}");
				}
			}

			return Content(sb.ToString());
		}
		#endregion

		#region 市场日常管理

	    /// <summary>
	    /// 品牌管理信息
	    /// </summary>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="rows"></param>
	    /// <param name="tradeTypeId"></param>
	    /// <param name="page"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult NameBrandListResult(string pcVal, string pcItem, string page, string rows,string tradeTypeId)
	    {

			//string str = Utils.GetQuerySQL(lcItem, lcVal);
			string whereSql = UserSessionInfo.MarketDataSql(false)+ " AND IsLock='N' ";
		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }
		    if (!string.IsNullOrEmpty(tradeTypeId))
		    {
			    whereSql += " AND " + NameBrands_info.cTradeTypeID + " = " + tradeTypeId;
		    }
		    return Content(GetData.Instance.GetResult("ViewNameBrandInfos", "*", whereSql,
			    "NameBrandID,MarketName,TimeCreated", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 获取品牌附件信息
		/// </summary>
		/// <param name="sourceKey"></param>
		/// <returns></returns>
	    [HttpPost]
	    public ActionResult NameBrandAttachResult(string sourceKey)
		{
			string lcSql = "select * from  " + Tn.Sys_AttachFiles + " where "
			               + Sys_AttachFiles_info.cTableId + "='NameBrands' AND " + Sys_AttachFiles_info.cColumnId + "='NameBrandID' AND " + Sys_AttachFiles_info.cSourceKey + "='" + sourceKey + "' ";
			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 主要商品价格信息
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
	    [HttpPost]
	    public ActionResult MarketMajorQuoteListResult(string pcVal, string pcItem, string page, string rows)
	    {

		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = " UpdateTime > '" + SysDefault.EnterDataDate() + "' " + UserSessionInfo.MarketDataSql(true);
		    
		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
                string str = pcItem == "MajorGoodsName"
					? MarketMajorQuote_info.cMajorGoodsName + " like '%" + Utils.AreaToSQL(pcVal) + "%'"
				    : Utils.GetQuerySQL(pcItem, pcVal);
			    whereSql += " AND " + str;
		    }
		    
		    return Content(GetData.Instance.GetResult(Tn.MarketMajorQuote, "*", whereSql,
				"QuoteDate Desc", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 主要商品价格信息查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketMajorQuoteQryResult(string page, string rows)
		{
			string marketId = Request["MarketID"]?.Trim() ?? "",
				startTime = Request["StartTime"]?.Trim() ?? "",
				endTime = Request["EndTime"]?.Trim() ?? "",
				majorGoodsName = Request["MajorGoodsName"]?.Trim() ?? "";
			string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + ViewMarketSellers_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
			ts = startTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MarketMajorQuote_info.cQuoteDate + " >='" + ts + "'";
			ts = endTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MarketMajorQuote_info.cQuoteDate + " <='" + ts + "'";
			ts = majorGoodsName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketMajorQuote_info.cMajorGoodsName + " like '%" + ts + "%'";

			return Content(GetData.Instance.GetResult(Tn.MarketMajorQuote, "*", whereSql,
				"QuoteDate Desc", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 复秤情况录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult WeightCheckLogListResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = WeightCheckLog_info.cLogDate + "> '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewWeightCheckLog_New", "*", whereSql,
			    WeightCheckLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 复秤情况查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult WeightCheckLogQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
			    startTime = Request["StartTime"]?.Trim() ?? "",
			    endTime = Request["EndTime"]?.Trim() ?? "",
			    marketSellerId = Request["MarketSellerID"]?.Trim() ?? "",
			    foodName = Request["FoodName"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    string ts = marketSellerId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		    {
			    whereSql += " AND " + WeightCheckLog_info.cSellerID + " IN('" + ts.Replace("@|@", "','") + "')";
		    }
		    else
		    {
				ts = marketId;
			    ts = Utils.AreaToSQL(ts);
			    if (ts.Length > 0)
				    whereSql += " AND " + WeightCheckLog_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
			}
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + WeightCheckLog_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + WeightCheckLog_info.cLogDate + " <='" + ts + "'";
		    ts = foodName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + WeightCheckLog_info.cFoodName + " like'%" + ts + "%'";
		   

			return Content(GetData.Instance.GetResult("ViewWeightCheckLog_New", "*", whereSql,
				WeightCheckLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 消防检查录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult FireProtectInspectLogResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = FireProtect_InspectLog_info.cLogDate + "> '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewFireProtectInspectLog", "*", whereSql,
			    FireProtect_InspectLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 消防检查查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult FireProtectInspectLogQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
			    startTime = Request["StartTime"]?.Trim() ?? "",
			    endTime = Request["EndTime"]?.Trim() ?? "",
			    inspector = Request["Inspector"]?.Trim() ?? "",
			    problem = Request["Problem"]?.Trim() ?? "",
			    content = Request["Content"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + FireProtect_InspectLog_info.cMarketID + " IN('" + ts.Replace("@|@","','") + "')";
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + FireProtect_InspectLog_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + FireProtect_InspectLog_info.cLogDate + " <='" + ts + "'";
		    ts = inspector;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + FireProtect_InspectLog_info.cInspector + " like'%" + ts + "%'";
		    ts = problem;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + FireProtect_InspectLog_info.cProblem + " like'%" + ts + "%'";
		    ts = content;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + FireProtect_InspectLog_info.cContent + " like'%" + ts + "%'";

			return Content(GetData.Instance.GetResult("ViewFireProtectInspectLog", "*", whereSql,
			    FireProtect_InspectLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 市场卫生录入
	    /// </summary>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult CleansingCheckLogResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = CleansingCheckLog_info.cLogDate + "> '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewCleansingCheckLog", "*", whereSql,
			    CleansingCheckLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 市场卫生查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult CleansingCheckLogQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
			    startTime = Request["StartTime"]?.Trim() ?? "",
			    endTime = Request["EndTime"]?.Trim() ?? "",
			    executor = Request["Executor"]?.Trim() ?? "",
			    assessLevelId = Request["AssessLevelID"]?.Trim() ?? "",
			    selfCheckFlag = Request["SelfCheckFlag"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CleansingCheckLog_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CleansingCheckLog_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CleansingCheckLog_info.cLogDate + " <='" + ts + "'";
		    ts = executor;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CleansingCheckLog_info.cExecutor + " like'%" + ts + "%'";
		    ts = assessLevelId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CleansingCheckLog_info.cAssessLevelID + " ='" + ts + "'";
		    ts = selfCheckFlag;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CleansingCheckLog_info.cSelfCheckFlag + " ='" + ts + "'";

		    return Content(GetData.Instance.GetResult("ViewCleansingCheckLog", "*", whereSql,
			    CleansingCheckLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 市场值班录入
	    /// </summary>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult DutyLogResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = DutyLog_info.cLogDate + "> '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewDutyLog", "*", whereSql,
			    CleansingCheckLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
	    /// <summary>
	    /// 市场值班查询
	    /// </summary>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult DutyLogQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
			    startTime = Request["StartTime"]?.Trim() ?? "",
			    endTime = Request["EndTime"]?.Trim() ?? "",
			    watchers = Request["Watchers"]?.Trim() ?? "",
			    notes = Request["Notes"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + DutyLog_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + DutyLog_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + DutyLog_info.cLogDate + " <='" + ts + "'";
		    ts = watchers;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + DutyLog_info.cWatchers + " like'%" + ts + "%'";
		    ts = notes;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
				whereSql += " AND " + DutyLog_info.cNotes + " like'%" + ts + "%'";
			

		    return Content(GetData.Instance.GetResult("ViewDutyLog", "*", whereSql,
			    DutyLog_info.cLogDate + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 市场制度录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketStatuteResult(string pcVal, string pcItem, string page, string rows)
	    {
			
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

			return Content(GetData.Instance.GetResultSysStatesTran("ViewMarketStatute", "*", whereSql,
				MarketStatute_info.cStatuteID + " DESC", Utils.ValI(page),
				Utils.ValI(rows),Tn.MarketStatute, "StatuteType", UserSessionInfo.DBConn));
		}
		/// <summary>
		/// 市场制度查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketStatuteQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
			    statuteType = Request["StatuteType"]?.Trim() ?? "",
			    statuteTitle = Request["StatuteTitle"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketStatute_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = statuteType;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketStatute_info.cStatuteType + " ='" + ts + "'";
		    ts = statuteTitle;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketStatute_info.cStatuteTitle + " like'%" + ts + "%'";

			return Content(GetData.Instance.GetResultSysStatesTran("ViewMarketStatute", "*", whereSql,
				MarketStatute_info.cStatuteID + " DESC", Utils.ValI(page),
				Utils.ValI(rows), Tn.MarketStatute, "StatuteType", UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 市场分布和管理人员示意图查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketChartQryResult(string page, string rows)
		{
			string marketId = Request["MarketID"]?.Trim() ?? "",
				chartTypeId = Request["ChartTypeID"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketChart_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = chartTypeId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketChart_info.cChartTypeID + " ='" + ts + "'";

		    return Content(GetData.Instance.GetResultSysStatesTran("ViewMarketChart", "ID,MarketID,MarketName,ChartTypeID,FileTitle,FileName,FilePath,UpdateTime", whereSql,
			    MarketChart_info.cID, Utils.ValI(page),
			    Utils.ValI(rows), Tn.MarketChart, "ChartTypeID", UserSessionInfo.DBConn, false));
	    }

		#endregion

		#region 商品质量管理

		/// <summary>
		/// 重要商品来源录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MajorGoodsLogResult(string pcVal, string pcItem, string page, string rows)
		{
			//string str = Utils.GetQuerySQL(lcItem, lcVal);
			//string whereSql = UserSessionInfo.MarketDataSql(false) + " AND " + MajorGoodsLog_info.cMajorGoodsTypeID +
			//                  " IN (SELECT " + MajorGoodsType_info.cMajorGoodsTypeID + " FROM " + Tn.MajorGoodsType + " WHERE " +
			//                  MajorGoodsType_info.cIsLock + "='N' AND " + UserSessionInfo.GSSystemDataSql(false) +
			//                  ")";
			string whereSql = UserSessionInfo.MarketDataSql(false);
			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
			{
		        pcVal = pcVal.Trim();
				string str = pcItem == "VarietyCategoryName"
                    ? VarietyCategory_info.cVarietyCategoryName + " like '%" + Utils.AreaToSQL(pcVal) + "%'"
					: Utils.GetQuerySQL(pcItem, pcVal); 
				whereSql += " AND " + str;
			}

			return Content(GetData.Instance.GetResult("ViewMajorGoods_New", "*", whereSql,
				MajorGoodsLog_info.cStockTime + " DESC", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}
		/// <summary>
		/// 重要商品来源查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MajorGoodsLogQryResult(string page, string rows)
		{
			string marketId = Request["MarketID"]?.Trim() ?? "",
				startTime = Request["StartTime"]?.Trim() ?? "",
				endTime = Request["EndTime"]?.Trim() ?? "",
				varietyCategoryName = Request["VarietyCategoryName"]?.Trim() ?? "",
				marketSellerId = Request["MarketSellerID"]?.Trim() ?? "";
			string whereSql = UserSessionInfo.MarketDataSql(false);
			string ts = marketSellerId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MajorGoodsLog_info.cSellerID + " =" + ts;
			else
			{
				ts = marketId;
				ts = Utils.AreaToSQL(ts);
				if (ts.Length > 0)
					whereSql += " AND " + MajorGoodsLog_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
			}
			
			ts = startTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MajorGoodsLog_info.cStockTime + " >='" + ts + "'";
			ts = endTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MajorGoodsLog_info.cStockTime + " <='" + ts + "'";
			ts = varietyCategoryName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MajorGoodsLog_info.cVarietyCategoryName + " like'%" + ts + "%'";

			return Content(GetData.Instance.GetResult("ViewMajorGoods_New", "*", whereSql,
				MajorGoodsLog_info.cStockTime + " DESC", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 不合格商品退市录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult GoodsRecallLogResult(string pcVal, string pcItem, string page, string rows)
		{
			//string str = Utils.GetQuerySQL(lcItem, lcVal);
			string whereSql = UserSessionInfo.MarketDataSql(false);

			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
			{
		        pcVal = pcVal.Trim();
				string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
			}

			return Content(GetData.Instance.GetResult("viewGoodsRecall", "*", whereSql,
				GoodsRecallLog_info.cSaleTime + " DESC", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}
		/// <summary>
		/// 不合格商品退市查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult GoodsRecallLogQryResult(string page, string rows)
		{
			string marketId = Request["MarketID"]?.Trim() ?? "",
				startTime = Request["StartTime"]?.Trim() ?? "",
				endTime = Request["EndTime"]?.Trim() ?? "",
				goodsName = Request["GoodsName"]?.Trim() ?? "",
				marketSellerId = Request["MarketSellerID"]?.Trim() ?? "";
			string whereSql = UserSessionInfo.MarketDataSql(false);
			string ts = marketId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + GoodsRecallLog_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
			ts = startTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + GoodsRecallLog_info.cSaleTime + " >='" + ts + "'";
			ts = endTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + GoodsRecallLog_info.cSaleTime + " <='" + ts + "'";
			ts = goodsName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + GoodsRecallLog_info.cGoodsName + " like'%" + ts + "%'";
			ts = marketSellerId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + GoodsRecallLog_info.cSellerID + " =" + ts;

			return Content(GetData.Instance.GetResult("ViewGoodsRecall", "*", whereSql,
				GoodsRecallLog_info.cSaleTime + " DESC", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 检测数据录入
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult CheckDataResult(string page, string rows)
		{
			string dates = DateTime.Now.AddDays(-2).ToShortDateString();

			//string str = Utils.GetQuerySQL(lcItem, lcVal);
			string whereSql = UserSessionInfo.MarketDataSql(false)+ " AND UploadTime >'" + dates + "'";

		    //if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    //{
			   // string str = Utils.GetQuerySQL(pcItem, pcVal);
			   // whereSql += " AND " + str;
		    //}

		    return Content(GetData.Instance.GetResult("ViewCheckData", "*", whereSql,
			   "UploadTime DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 检测数据查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult CheckDataQryResult(string page, string rows)
		{
			string regionId = Request["RegionID"]?.Trim() ?? "",
			 marketId = Request["MarketID"]?.Trim() ?? "",
				checkUnit = Request["CheckUnit"]?.Trim() ?? "",
				corpName = Request["CorpName"]?.Trim() ?? "",
				littleKindName = Request["LittleKindName"]?.Trim() ?? "",
				sampleName = Request["SampleName"]=="全部" ? "": Request["SampleName"],
				checkProjectTypeId = Request["CheckProjectTypeID"]?.Trim() ?? "",
				checkMethod = Request["CheckMethod"]?.Trim() ?? "",
				checkResult = Request["CheckResult"]?.Trim() ?? "",
				startTime = Request["StartTime"]?.Trim() ?? "", 
				endTime = Request["EndTime"]?.Trim() ?? "";

			string whereSql = " 1=1 ";
			string ts = regionId;
			ts = Utils.AreaToSQL(ts);
			if (marketId.Length <= 0 && ts.Length > 0 && ts.Trim()!= "100001")
				whereSql += " AND RegionID IN('" + ts + "')";
			ts = marketId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + CheckData_info.cMarketID + " IN('" + ts + "')";
			ts = checkUnit;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + CheckData_info.cCheckUnit + " IN('" + ts + "')";
			ts = checkProjectTypeId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + CheckData_info.cCheckProjectTypeID + " IN('" + ts + "')";
			ts = checkMethod;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND CheckMethodId ='" + ts + "'";
			ts = littleKindName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND Path LIKE'%" + ts + "%'";
			ts = sampleName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + CheckData_info.cSampleId + " ='" + ts + "'";
			ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + CheckData_info.cCheckTime + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
		    {
		        ts += " 23:59:59";
		        whereSql += " AND " + CheckData_info.cCheckTime + " <='" + ts + "'";
            }
			   
			ts = checkResult;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + CheckData_info.cCheckResult + " ='" + ts + "'";
			ts = corpName;
		    ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + CheckData_info.cCorpName + " like '%" + ts + "%'";

		    return Content(GetData.Instance.GetResult("ViewCheckData", "*", whereSql,
			    CheckData_info.cCheckTime + " DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		#endregion

		#region 获取图表数据

		[HttpPost]
		public ActionResult DataChartsQryResult(string chartType, string reportType)
		{
			#region 拼装lcSql查询数据loQuery
			string regionId = Request["RegionID"]?.Trim() ?? "",
					marketId = Request["MarketID"]?.Trim() ?? "",
					corpKind = Request["CorpKind"]?.Trim() ?? "",
					corpName = Request["CorpName"]?.Trim() ?? "",
					littleKindName = Request["LittleKindName"]?.Trim() ?? "",
					sampleName = Request["SampleName"]?.Trim() ?? "" ,
					checkProjectTypeId = Request["CheckProjectTypeID"]?.Trim() ?? "",
					produceUnit = Request["ProduceUnit"]?.Trim() ?? "",
			        topQty = Request["TopQty"]?.Trim() ?? "",
			        order = Request["Order"]?.Trim() ?? "",
					startTime = Request["StartTime"]?.Trim() ?? "",
					endTime = Request["EndTime"]?.Trim() ?? "";
			if (!string.IsNullOrEmpty(sampleName))
			{
				littleKindName = "";
			}

		    string top = "";
		    if (!string.IsNullOrEmpty(topQty))
		    {
		        top = " TOP " + topQty + " ";
		        order = string.IsNullOrEmpty(order) ? "" : " DESC ";
		    }
			string lcSql = "";
			string ts = regionId;
			ts = Utils.AreaToSQL(ts);
			if (marketId.Length <= 0 && ts.Length > 0)
				lcSql += " AND RegionID IN('" + ts + "')";
			ts = marketId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cMarketID + " IN('" + ts + "')";
			ts = corpKind;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cCorpKind + " IN('" + ts + "')";
			ts = checkProjectTypeId;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cCheckProjectTypeID + " IN('" + ts + "')";
			ts = littleKindName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql +=
					" AND [SampleId]  IN  ( SELECT [VarietyCategoryNo] as SampleId FROM VarietyCategory WHERE [Path]  LIKE '%" +
					ts + "%') ";
			ts = sampleName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cSampleId + " ='" + ts + "'";
			ts = startTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cCheckTime + " >='" + ts + "'";
			ts = endTime;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cCheckTime + " <='" + ts + "'";
			ts = produceUnit;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cProduceUnit + " like '%" + ts + "%'";
			ts = corpName;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				lcSql += " AND " + CheckData_info.cCorpName + " like '%" + ts + "%'";
			bool calculateHgl = false;
			string searchStrHead, searchStrRear, searchStrOrderBy="", searchStrHg="", searchStrTotal="", searchStrHgTOn="";

			
			switch (reportType.ToUpper())
			{
				// 检测数统计---------->
				case "MONTHCOUNT":
					string strDateSql = " Convert(Char(7)," + vwCheckData_info.cCheckTime + ", 111) ";
				    searchStrHead = " SELECT " + top + strDateSql + " AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " +
				                    Tn.ViewCheckData + " WHERE 1=1  ";
					searchStrRear = " GROUP BY " + strDateSql;
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order+"," + strDateSql;
					break;
				case "YEARCOUNT":
					searchStrHead = "SELECT" + top +" Year(" + vwCheckData_info.cCheckTime + ") AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " + Tn.ViewCheckData + " WHERE 1=1 ";
					searchStrRear = " GROUP BY Year(" + vwCheckData_info.cCheckTime + ") ";
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order+", Year(" + vwCheckData_info.cCheckTime + ") ";
					break;
				case "CHECKPROJECTTYPEID":
					searchStrHead = "SELECT" + top +" CheckItemName AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " + Tn.ViewCheckData + " WHERE 1=1 ";
					searchStrRear = " GROUP BY CheckItemName ";
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order;
					break;
				case "CHECKUNIT":
					searchStrHead = "SELECT " + top + vwCheckData_info.cCheckUnit + " AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " + Tn.ViewCheckData + " WHERE 1=1 ";
					searchStrRear = " GROUP BY " + vwCheckData_info.cCheckUnit;
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order;
					break;
				case "LITTLEKINDNAME":
					searchStrHead = "SELECT" + top +" [SampleName] AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " + Tn.ViewCheckData + " WHERE 1=1 ";
					searchStrRear = " GROUP BY [SampleName] ";
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order;
					break;
				case "PRODUCEUNIT":
					searchStrHead = "SELECT " + top  + vwCheckData_info.cProduceUnit + " AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " + Tn.ViewCheckData + " WHERE 1=1 ";
					searchStrRear = " GROUP BY " + vwCheckData_info.cProduceUnit;
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order;
					break;
				case "SAMPLENAME":
					searchStrHead = "SELECT " + top + vwCheckData_info.cSampleName + " AS CHART_ITEM, COUNT(*) AS CHART_VALUE FROM " + Tn.ViewCheckData + " WHERE 1=1 ";
					searchStrRear = " GROUP BY " + vwCheckData_info.cSampleName;
					searchStrOrderBy = "ORDER BY [CHART_VALUE]" + order;
					break;

				// 合格率统计---------->
				case "MONTHHGL":
					calculateHgl = true;
					searchStrHead = " [M] AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = "  CONVERT(Char(7)," + vwCheckData_info.cCheckTime + ",111) ";
					searchStrOrderBy = "ORDER BY [HG]" + order+", CHART_ITEM ";
					searchStrHg = " CONVERT(Char(7)," + vwCheckData_info.cCheckTime + ",111) [Month], COUNT(*) [HG] ";
					searchStrTotal = " CONVERT(Char(7)," + vwCheckData_info.cCheckTime + ",111) [M], COUNT(*) [Total] ";
					// 条件
					searchStrHgTOn = " H.[Month]=T.[M] ";
					break;
				case "YEARHGL":
					calculateHgl = true;
					searchStrHead = " [y] AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = " year(" + vwCheckData_info.cCheckTime + ") ";
					searchStrOrderBy = "ORDER BY [HG]" + order+", CHART_ITEM ";
					searchStrHg = " year(" + vwCheckData_info.cCheckTime + ") [y2], COUNT(*) [HG] ";
					searchStrTotal = " year(" + vwCheckData_info.cCheckTime + ") [y], COUNT(*) [Total] ";
					// 条件
					searchStrHgTOn = " H.[y2]=T.y ";
					break;
				case "CHECKPROJECTTYPEHGL":
					calculateHgl = true;
					searchStrHead = " CheckItemName AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = " CheckItemName ";
					searchStrOrderBy = "ORDER BY [HG]" + order;
					searchStrHg = " CheckItemName n2, COUNT(*) [HG] ";
					searchStrTotal = " CheckItemName, COUNT(*) [Total] ";
					// 条件
					searchStrHgTOn = " [n2]=CheckItemName ";
					break;
				case "CHECKUNITHGL":
					calculateHgl = true;
					searchStrHead = " " + vwCheckData_info.cCheckUnit + " AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = " " + vwCheckData_info.cCheckUnit + " ";
					searchStrOrderBy = "ORDER BY [HG]" + order;
					searchStrHg = " " + vwCheckData_info.cCheckUnit + " n2, COUNT(*) [HG] ";
					searchStrTotal = " " + vwCheckData_info.cCheckUnit + ", COUNT(*) [Total] ";
					// 条件
					searchStrHgTOn = " [n2]=" + vwCheckData_info.cCheckUnit + " ";
					break;
				case "LITTLEKINDNAMEHGL":
					calculateHgl = true;
					searchStrHead = " [SampleName] AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = " [SampleName] ";
					searchStrOrderBy = "ORDER BY [HG]" + order;
					searchStrHg = " [SampleName] n2, COUNT(*) [HG] ";
					searchStrTotal = " [SampleName], COUNT(*) [Total] ";
					// 条件
					searchStrHgTOn = " [n2]=[SampleName] ";
					break;
				case "SAMPLENAMEHGL":
					calculateHgl = true;
					searchStrHead = " " + vwCheckData_info.cSampleName + " AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = " " + vwCheckData_info.cSampleName + " ";
					searchStrOrderBy = "ORDER BY [HG]" + order;
					searchStrHg = " " + vwCheckData_info.cSampleName + " n2, COUNT(*) [HG] ";
					searchStrTotal = " " + vwCheckData_info.cSampleName + ", COUNT(*) [Total]";
					// 条件
					searchStrHgTOn = " [n2]=" + vwCheckData_info.cSampleName + " ";
					break;
				case "PRODUCEUNITHGL":
					calculateHgl = true;
					searchStrHead = " " + vwCheckData_info.cProduceUnit + " AS CHART_ITEM, ISNULL(CONVERT(float,[HG])/CONVERT(float,[Total]),0) AS CHART_RVALUE ,[Total] AS CHART_LVALUE ";
					searchStrRear = " " + vwCheckData_info.cProduceUnit + " ";
					searchStrOrderBy = "ORDER BY [HG]" + order;
					searchStrHg = " " + vwCheckData_info.cProduceUnit + " n2, COUNT(*) [HG] ";
					searchStrTotal = " " + vwCheckData_info.cProduceUnit + ", COUNT(*) [Total] ";
					// 条件
					searchStrHgTOn = " [n2]=" + vwCheckData_info.cProduceUnit + " ";
					break;

				default:
					searchStrHead = string.Empty;
					searchStrRear = string.Empty;
					break;
			}

			if (calculateHgl) 
			{
				string tStr = "SELECT " + top + searchStrHead + " FROM ";
				tStr += " (SELECT " + searchStrHg + " FROM " + Tn.ViewCheckData;
				tStr += " WHERE " + vwCheckData_info.cCheckResult + "='合格' " + lcSql;
				tStr += " GROUP BY " + searchStrRear + " ) H RIGHT JOIN ";
				tStr += " (SELECT " + searchStrTotal + " FROM " + Tn.ViewCheckData + " WHERE 1=1 " + lcSql;
				tStr += " GROUP BY " + searchStrRear + "  ) T ON " + searchStrHgTOn;
                lcSql = tStr;

				// 月、年统计按照时间排序
				if (searchStrOrderBy.Length > 0)
					lcSql += "  " + searchStrOrderBy;
			}
			else
			{
				lcSql = searchStrHead + " " + UserSessionInfo.MarketDataSql(true) + " " + lcSql;
				lcSql += "  " + searchStrRear;

				// 月、年统计按照时间排序
				if (searchStrOrderBy.Length > 0)
					lcSql += "  " + searchStrOrderBy;
			}

			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
			#endregion

			string strJson="";
			List<Array> listData = null;
			try
			{
				if (chartType != null)
				{
					chartType = chartType.ToUpper();

					// 将数据库返回结果转换成按列存放的格式
					ChartReportUtils.PrepareData(loQuery, ref listData);

					// 生产Json格式的返回数据
					 strJson = chartType == "PIE" ? GetData.Instance.GenOutputDataForPie(loQuery.RecCount,listData) : GetData.Instance.GenOutputData(loQuery.RecCount, listData);
				}
			}
			catch 
			{
				strJson = string.Empty;
			}
			// 处理异常或者无数据返回
			if (strJson == string.Empty)
				strJson = "{\"__totalcount\":0}";

			return Content(strJson);
		}

		#endregion

		#region 消费维权及信用管理

		/// <summary>
		/// 市场违规行为录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketViolationsListResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = MarketViolations_info.cLogDate + "> '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewMarketViolations", "*", whereSql,
				"MarketID,LogDate DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 市场违规行为查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketViolationsQryResult(string page, string rows)
		{
			string marketId = Request["MarketID"]?.Trim() ?? "",
				logType = Request["LogType"]?.Trim() ?? "",
				isRead = Request["IsRead"]?.Trim() ?? "",
				checher = Request["Checher"]?.Trim() ?? "",
				startTime = Request["StartTime"]?.Trim() ?? "",
				endTime = Request["EndTime"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketViolations_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketViolations_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketViolations_info.cLogDate + " <='" + ts + "'";
		    ts = checher;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + MarketViolations_info.cChecher + " like'%" + ts + "%'";
		    ts = logType;
		    ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0 && ts != "全部")
			    whereSql += " AND " + MarketViolations_info.cLogType + " ='" + ts + "'";
			ts = isRead;
			ts = Utils.AreaToSQL(ts);
			if (ts.Length > 0)
				whereSql += " AND " + MarketViolations_info.cIsRead + " like'%" + ts + "%'";

			return Content(GetData.Instance.GetResult("ViewMarketViolations", "*", whereSql,
			    "MarketID,LogDate DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 经营户违规行为录入
	    /// </summary>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult MarketSellerViolationsListResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = SellerViolations_info.cLogDate + ">= '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewSellerViolations", "*", whereSql,
				"SellerID,MarketID,LogDate DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 经营户违规行为查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketSellerViolationsQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
				marketSellerName = Request["MarketSellerName"]?.Trim() ?? "",
				violationTypeId = Request["ViolationTypeID"]?.Trim() ?? "",
				sellerRewardTypeId = Request["SellerRewardTypeID"]?.Trim() ?? "",
			    startTime = Request["StartTime"]?.Trim() ?? "",
			    endTime = Request["EndTime"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + SellerViolations_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + SellerViolations_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + SellerViolations_info.cLogDate + " <='" + ts + "'";
		    ts = marketSellerName;
		    ts = Utils.AreaToSQL(ts);
			whereSql += " AND MarketSellerName like'%" + ts + "%'";
			ts = violationTypeId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0 && ts != "全部")
			    whereSql += " AND " + SellerViolations_info.cViolationTypeID + " ='" + ts + "'";
		    ts = sellerRewardTypeId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0 && ts != "全部")
			    whereSql += " AND " + SellerViolations_info.cSellerRewardTypeID + " ='" + ts + "'";

			return Content(GetData.Instance.GetResult("ViewSellerViolations", "*", whereSql,
			    "MarketID,LogDate DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }


		/// <summary>
		/// 投诉信息违规行为录入
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult ConsumerComplainListResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = SellerViolations_info.cLogDate + ">= '" + SysDefault.EnterDataDate() + "' " +
		                      UserSessionInfo.MarketDataSql(true);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewConsumerComplain_New", "*", whereSql,
			    "SellerID,MarketID,LogDate DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 投诉信息违规行为查询
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult ConsumerComplainQryResult(string page, string rows)
	    {
		    string marketId = Request["MarketID"]?.Trim() ?? "",
			    marketSellerName = Request["MarketSellerName"]?.Trim() ?? "",
			    stallName = Request["StallName"]?.Trim() ?? "",
			    consumer = Request["Consumer"]?.Trim() ?? "",
			    executor = Request["Executor"]?.Trim() ?? "",
				startTime = Request["StartTime"]?.Trim() ?? "",
			    endTime = Request["EndTime"]?.Trim() ?? "";
		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + ConsumerComplain_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";
		    ts = startTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + ConsumerComplain_info.cLogDate + " >='" + ts + "'";
		    ts = endTime;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + ConsumerComplain_info.cLogDate + " <='" + ts + "'";
		    ts = marketSellerName;
		    ts = Utils.AreaToSQL(ts);
		    whereSql += " AND MarketSellerName like'%" + ts + "%'";
		    ts = stallName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0 && ts != "全部")
			    whereSql += " AND StallName like'%" + ts + "%'";
			ts = consumer;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0 && ts != "全部")
			    whereSql += " AND " + ConsumerComplain_info.cConsumer + " like'%" + ts + "%'";
		    ts = executor;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0 && ts != "全部")
			    whereSql += " AND " + ConsumerComplain_info.cExecutor + " like'%" + ts + "%'";
			return Content(GetData.Instance.GetResult("ViewConsumerComplain_New", "*", whereSql,
			    "MarketID,LogDate DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		#endregion

		#region 市场管理系统

		#region 台帐登记
		/// <summary>
		/// 商品进货验收台帐
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult StockRecvLogResult(string pcVal, string pcItem, string page, string rows)
		{
			//string str = Utils.GetQuerySQL(lcItem, lcVal);
			string whereSql = UserSessionInfo.MarketDataSql(false);

			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
			{
		        pcVal = pcVal.Trim();
				string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
			}

			return Content(GetData.Instance.GetResult("ViewStockRecvLog", "*", whereSql,
				"StockTime,SellerID,MarketID DESC", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 经营户经营行为信用状况记录台帐
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult SellerViolationLogResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewSellerViolationLog", "*", whereSql,
			    "LogDate,SellerID,MarketID DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 猪肉/活家禽 进货台帐
	    /// </summary>
	    /// <param name="id"></param>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult StockupLogResult(string id,string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    if (string.IsNullOrEmpty(id))
			    return Content("{\"total\":0,\"rows\":[]");

		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    id = id.ToLower();
		    string ts= id == "zr" ? "0" : (id == "hjq" ? "1" : "");

			whereSql += " AND " + StockupLog_info.cType +"="+ ts;
			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewStockupLog", "*", whereSql,
				"StockDate,SellerID,MarketID DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 豆制品进货台帐
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult StockupBeanLogResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewStockupBeanLog", "*", whereSql,
				"StockDate,SellerID,MarketID DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }


		/// <summary>
		/// 重要商品销售去向台帐台帐
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult SaleDestLogResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewSaleDestLog", "*", whereSql,
				"StockTime,SellerID,MarketID DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		#endregion

		#region 先行赔偿管理

	    /// <summary>
	    /// 预备金
	    /// </summary>
	    /// <param name="id"></param>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult ReserveCompensateLogResult(string id,string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    
		    string reserveChangeTypeId = "0";

			switch (id.ToUpper())
		    {
			    case "JN":
				    reserveChangeTypeId = "1";
				    break;
			    case "PF":
				    reserveChangeTypeId = "2";
				    break;
			    case "BZ":
				    reserveChangeTypeId = "3";
				    break;
			    case "TH":
				    reserveChangeTypeId = "4";
				    break;

		    }
		    string whereSql = UserSessionInfo.MarketDataSql(false) + " AND " + ReserveCompensateLog_info.cReserveChangeTypeID + " =" + reserveChangeTypeId;
			if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewReserveCompensateLog", "*", whereSql,
				"LogDate,SellerID,MarketID DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		#endregion

		#region 基础信息

		/// <summary>
		/// 供货商信息
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult SuppliersResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = " 1=1 ";//UserSessionInfo.MarketDataSql(false);
		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }
		    return Content(GetData.Instance.GetResult("ViewSuppliers", "*", whereSql,
				"HabitatName DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
	    /// <summary>
	    /// 市场人员信息
	    /// </summary>
	    /// <param name="pcVal"></param>
	    /// <param name="pcItem"></param>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult MarketOperatorsResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewMarketOperators", "*", whereSql,
			    "Name DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 摊位信息
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult StallsResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false) + " AND IsLock='N'";

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("ViewStalls", "*", whereSql,
				"Name DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
		/// <summary>
		/// 消防设施登记 信息
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult FireProtect_EquipmentResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("FireProtect_Equipment", "*", whereSql,
			    "Name DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 消防制度 信息
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult FireProtect_SystemResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("FireProtect_System", "*", whereSql,
			    "Name DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }


		/// <summary>
		/// 检测设施登记 信息
		/// </summary>
		/// <param name="pcVal"></param>
		/// <param name="pcItem"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketInspectFacilityResult(string pcVal, string pcItem, string page, string rows)
	    {
		    //string str = Utils.GetQuerySQL(lcItem, lcVal);
		    string whereSql = UserSessionInfo.MarketDataSql(false);

		    if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
		    {
		        pcVal = pcVal.Trim();
			    string str = Utils.GetQuerySQL(pcItem, pcVal);
                whereSql += " AND " + str;
		    }

		    return Content(GetData.Instance.GetResult("MarketInspectFacility", "*", whereSql,
				"RoomSize DESC", Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

		#endregion

		#endregion

		#region 用户、市场信息

		/// <summary>
		/// 新用户注册 信息
		/// </summary>
		/// <param name="isAudit"></param>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult SysRegistersResult(string isAudit, string page, string rows)
		{
			//string str = Utils.GetQuerySQL(lcItem, lcVal);
			string whereSql = SysRegisters_info.cIsAudit + " ='" + isAudit + "'";

			//if (!string.IsNullOrEmpty(pcVal) && pcVal != "undefined")
			//{
			// string str = Utils.GetQuerySQL(pcItem, pcVal);
			// whereSql += " AND " + str;
			//}

			return Content(GetData.Instance.GetResult("ViewSysRegisters", "*", whereSql,
				"ValidStartTime Desc", Utils.ValI(page),
				Utils.ValI(rows), UserSessionInfo.DBConn));
		}

		/// <summary>
		/// 获取市场证照附件信息
		/// </summary>
		/// <param name="sourceKey"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketAttachResult(string sourceKey)
		{
			string lcSql = "select * from  " + Tn.Sys_AttachFiles + " where "
						   + Sys_AttachFiles_info.cTableId + "='MarketHasWarrant' AND " + Sys_AttachFiles_info.cColumnId + "='ID' AND " + Sys_AttachFiles_info.cSourceKey + "='" + sourceKey + "' ";
			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
		}
		#endregion

		#region 消息通知 信息

		/// <summary>
		/// 公告 信息
		/// </summary>
		/// <param name="pcType"></param>
		/// <returns></returns>
		[HttpPost]
		public ActionResult BulletinResult(string pcType)
		{
			string datetime = DateTime.Now.AddMonths(SysDataLibs.AppEnv.SysSetObj.GetInt("BulletinShowTimeSpan")).ToShortDateString();
			string lcSql = "SELECT TOP 150 * FROM BulletinInfo WHERE BulletinTypeID='" + pcType + "' AND AuditFlag='1' AND UpdateTime >='" + datetime + "' ";
			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
			StringBuilder sb = new StringBuilder();
			sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
			if (loQuery.IsOpened && loQuery.RecCount > 0)
			{
				loQuery.SortBy("UpdateTime", false);
				loQuery.MoveFirst();
				DataTable dt = loQuery.CurrentTable;
				dt.Columns.Add("UserName", typeof(string));
				dt.Columns.Add("ImageStr", typeof(string));
				for (int i = 0; i < loQuery.RecCount; i++)
				{


					string lcUserSql = "SELECT * FROM " + Tn.Sys_Users + " WHERE " + Sys_Users_info.cUserID + "='" + loQuery.GetString("UserID") + "'";
					rsQuery loUser = UserSessionInfo.DBConn.OpenQuery(lcUserSql);
					if (loUser != null && loUser.IsOpened && loUser.RecCount == 1)
					{
						loUser.MoveFirst();
						dt.Rows[i]["UserName"] = loUser.GetString("Names");
					}
					string lcId = loQuery.GetString("ID");
					Sys_AttachFiles_info loAttachFile = new Sys_AttachFiles_info("BulletinInfo", "ID", lcId, UserSessionInfo.DBConn);
					string lcImg = "RICON100.GIF";
					string ext = UtilStr.UAndT(loAttachFile.FileExt);
					if (loAttachFile.FileExt.Trim().Length > 0)
					{
						if (ext == "DOC" || ext == "DOCS" || ext == "DOCX")
							lcImg = "ICON-WORD.GIF";
						else if (ext == "XLS" || ext == "XLSX")
							lcImg = "ICON-EXCEL.GIF";
						else if (ext == "TXT")
							lcImg = "ftv2doc_3.gif";
						dt.Rows[i]["ImageStr"] =
							$" <a href =\"../{loAttachFile.DownPath()}\" download=\"\" > <IMG  style=\"cursor:pointer\" title=\"下载\"  src=\"../../Images/{lcImg}\"> 下载附件</a>";
					}
					else
						dt.Rows[i]["ImageStr"] = "没有附件";
					loQuery.MoveNext();
				}
				sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
			}
			else
				sb.Append("[]");
			sb.Append("}");
			return Content(sb.ToString());
		}

	    /// <summary>
	    /// 公告 信息
	    /// </summary>
	    /// <param name="pcType"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult LawRuleResult(string pcType)
	    {
		    //string datetime = DateTime.Now.AddMonths(SysDataLibs.AppEnv.SysSetObj.GetInt("BulletinShowTimeSpan")).ToShortDateString();
		    string lcSql = "SELECT TOP 150 * FROM LawRule WHERE LawRuleTypeId='" + pcType + "' ";
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
		    StringBuilder sb = new StringBuilder();
		    sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
		    if (loQuery.IsOpened && loQuery.RecCount > 0)
		    {
			    loQuery.SortBy("UpdateTime", false);
			    loQuery.MoveFirst();
			    DataTable dt = loQuery.CurrentTable;
			    //dt.Columns.Add("UserName", typeof(string));
			    dt.Columns.Add("Title", typeof(string));
			    dt.Columns.Add("ImageStr", typeof(string));
			    for (int i = 0; i < loQuery.RecCount; i++)
			    {
					//string lcUserSql = "SELECT * FROM " + Tn.Sys_Users + " WHERE " + Sys_Users_info.cUserID + "='" + loQuery.GetString("UserID") + "'";
					//rsQuery loUser = UserSessionInfo.DBConn.OpenQuery(lcUserSql);
					//if (loUser != null && loUser.IsOpened && loUser.RecCount == 1)
					//{
					// loUser.MoveFirst();
					// dt.Rows[i]["UserName"] = loUser.GetString("Names");
					//}
					string lcTitle = loQuery.GetString("LawRuleName");
				    if (lcTitle.Length < 60)
				    {
						dt.Rows[i]["Title"] = UtilStr.Replicate("&nbsp;", 60 - lcTitle.Length);
				    }
					string lcDownUrl = loQuery.GetString("DownUrl");
					if (lcDownUrl.Trim().Length > 0)
					{
						string ext = lcDownUrl.Substring(lcDownUrl.LastIndexOf(".", StringComparison.Ordinal) + 1, lcDownUrl.Length - lcDownUrl.LastIndexOf(".", StringComparison.Ordinal) - 1);
						ext = UtilStr.UAndT(ext);
						string lcImg = "RICON100.GIF";
						if (ext == "DOC" || ext == "DOCS" || ext == "DOCX")
						    lcImg = "ICON-WORD.GIF";
					    else if (ext == "XLS" || ext == "XLSX")
						    lcImg = "ICON-EXCEL.GIF";
					    else if (ext == "TXT")
						    lcImg = "ftv2doc_3.gif";
						lcDownUrl = "../" + SysDataLibs.AppEnv.SysSetObj.GetString("UPLOADPATH") + "/" + SysDataLibs.AppEnv.SysSetObj.GetString("LawRuleDown") + "/" + lcDownUrl;
						dt.Rows[i]["ImageStr"] =
						    $" <a href =\"../{lcDownUrl}\" download=\"\"> <IMG  style=\"cursor:pointer\" title=\"下载\"  src=\"../../Images/{lcImg}\"> 下载附件</a>";
				    }
				    else
					    dt.Rows[i]["ImageStr"] = "没有附件";
				    loQuery.MoveNext();
			    }
			    sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
		    }
		    else
			    sb.Append("[]");
		    sb.Append("}");
		    return Content(sb.ToString());
	    }
        #endregion

        #region 搜索查询信息

        /// <summary>
        /// 获取市场下的摊位信息
        /// </summary>
        /// <param name="marketId"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult GetMarketStallsResult(string marketId)
        {
            string ts = Utils.AreaToSQL(marketId);//StallNo,Name,StallNo+'('+Name+')' as StallName
            string lcSql = " SELECT " + Stalls_info.cStallNo + "," +  Stalls_info.cName+ ",StallNo+'('+Name+')' as StallName FROM " + Tn.Stalls + " WHERE "+
                        (ts.Length > 0?Stalls_info.cMarketID +"='" + ts+ "'" :"1=2");
            return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
        }

        /// <summary>
        /// 根据辖区获取市场下拉框的option
        /// </summary>
        /// <param name="regionId"></param>
        /// <returns></returns>
        [HttpPost]
	    public ActionResult GetMarketSelStrResult(string regionId)
	    {
		    string ts = Utils.AreaToSQL(regionId);
		    ts = ts.Length > 0 ? " IN (" + Regions_info.GetAllRegion(UserSessionInfo, ts) + ")" : " like '%'";

		    string lcSql = " SELECT " + Markets_info.cMarketID + "," + Markets_info.cNames + " FROM " + Tn.Markets +
		                   " WHERE " +
		                   Markets_info.cRegionID + ts + " AND " + UserSessionInfo.MarketDataSql(false) + " AND IsLock=0 ";
		    return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 根据市场获取经营户下拉框的option
		/// </summary>
		/// <param name="marketId"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult GetMarketSellerSelStrResult(string marketId)
	    {
			string ts = Utils.AreaToSQL(marketId?.Trim()??UserSessionInfo.MarketId);
		    ts = ts.Length > 0 ? " IN ('" + ts + "')" : " like '%'";
			string lcSql = " SELECT " + MarketSellers_info.cSellerID + "," + MarketSellers_info.cName + " FROM " +
			                   Tn.MarketSellers + " WHERE " +
			                   MarketSellers_info.cMarketID + ts + " AND IsLock='N' AND " + UserSessionInfo.MarketDataSql(false);

			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 根据经营户获取摊位下拉框的option
		/// </summary>
		/// <param name="marketId"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult GetStallSelStrResult(string marketId)
	    {
		    //string ts = Utils.AreaToSQL(marketId?.Trim() ?? UserSessionInfo.MarketId);
		    //ts = ts.Length > 0 ? " IN ('" + ts + "')" : " like '%'";
		    string lcSql = " SELECT " + Stalls_info.cStallID + "," + Stalls_info.cName + " FROM " +
		                   Tn.Stalls + " WHERE IsLock='N' AND " + UserSessionInfo.MarketDataSql(false);

		    return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 根据摊位获取经营户下拉框的option
		/// </summary>
		/// <param name="stallId"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult GetStallMarketSelStrResult(string stallId)
	    {
			string ts = Utils.AreaToSQL(stallId?.Trim() ?? UserSessionInfo.MarketId);
		    ts = ts.Length > 0 ? " IN ('" + ts + "')" : " like '%'";
		    string lcSql = " SELECT SellerID,MarketSellerName FROM ViewMarketSellers_New WHERE StallID" + ts + " AND " + UserSessionInfo.MarketDataSql(false);

			return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 根据小类获取品种名下拉框的option
		/// </summary>
		/// <param name="littleKindName"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult GetLittleKindSelStrResult(string littleKindName)
	    {
		    string ts = Utils.AreaToSQL(littleKindName?.Trim());
		    if (string.IsNullOrEmpty(ts))
		    {
			    //return Json(new {});
			    ts = "10000";
		    }
		    string lcSql =
			    "SELECT VarietyCategoryNo, VarietyCategoryName, Depth, FatherNo FROM  VarietyCategory  WHERE( [Path] like(select Path from VarietyCategory where VarietyCategoryNo = '" +
			    ts + "')  +'%'  ) AND [IsCanChecked]='Y'  AND IsLock='N' ORDER BY [CheckCount] Desc";

			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
		    var result = GetData.Instance.GetComboTree(loQuery,"VarietyCategoryNo","FatherNo","VarietyCategoryName","VarietyCategoryNo='"+ts+"'",pcDepthVal:"2");
			return Json(result);
	    }

	    /// <summary>
	    /// 根据检测方法获取检测项目下拉框的option
	    /// </summary>
	    /// <param name="checkMethod"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult GetCheckProjectSelStrResult(string checkMethod)
	    {
		    string ts = Utils.AreaToSQL(checkMethod?.Trim());
		    string lcSql = "SELECT   c.CheckProjectTypeID, i.CheckItemName AS Name FROM dbo.CheckItem AS i RIGHT OUTER JOIN dbo.CheckProjectType AS c ON i.CheckItemId = c.CheckItemId RIGHT OUTER JOIN dbo.CheckMethod AS m ON c.CheckMethodId = m.CheckMethodId WHERE  m.CheckMethodId='" + ts + "' AND c.IsLock=0";
		    return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 根据检测项目获取标准值和单位
	    /// </summary>
	    /// <param name="checkProjectTypeId"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult GetCheckProjectInfoResult(string checkProjectTypeId)
	    {
		    string ts = Utils.AreaToSQL(checkProjectTypeId?.Trim());
		    string lcSql = " SELECT " + CheckProjectType_info.cStandardValue + "," + CheckProjectType_info.cUnit + " FROM " + Tn.CheckProjectType +
		                   " WHERE " + CheckProjectType_info.cCheckProjectTypeID + " ='" + ts + "' AND IsLock=0";
		    return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

		/// <summary>
		/// 搜索查询市场信息
		/// </summary>
		/// <param name="page"></param>
		/// <param name="rows"></param>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketSearchResult(string page, string rows)
	    {
		    string marketName = Request["MarketName"]?.Trim() ?? "",
			    regionId = Request["RegionId"]?.Trim() ?? "";

		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + Markets_info.cNames + " like '%" + ts + "%'";

		    //ts = marketId;
		    ////ts = Utils.AreaToSQL(ts);
		    ////if (ts.Length > 0)
		    //whereSql += " AND " + Markets_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";

		    //辖区
		    string ts2 = Utils.AreaToSQL(regionId.Trim());
		    ts2 = Regions_info.GetAllRegion(UserSessionInfo, ts2);
		    if (ts2.Length > 0)
			    whereSql += " AND " + Markets_info.cRegionID + " IN (" + ts2 + ")";
		    string orderSql = " MarketID DESC ," + Markets_info.cNames + " DESC";
		    return Content(GetData.Instance.GetResult(Tn.Markets, "*", whereSql, orderSql, Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 搜索查询经营户信息
	    /// </summary>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult SellerSearchResult(string page, string rows)
	    {
		    string marketSellerName = Request["MarketSellerName"]?.Trim() ?? "",
			    //regionId = Request["RegionId"]?.Trim() ?? "",
			    marketId = Request["MarketID"]?.Trim() ?? "";


		    string whereSql = UserSessionInfo.MarketDataSql(false);
		    string ts = marketSellerName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + ViewMarketSellers_info.cMarketSellerName + " like '%" + ts + "%'";

		    ts = marketId;
		    //ts = Utils.AreaToSQL(ts);
		    //if (ts.Length > 0)
		    whereSql += " AND " + ViewMarketSellers_info.cMarketID + " IN('" + ts.Replace("@|@", "','") + "')";

		    //辖区
		    //  string ts2 = Utils.AreaToSQL(regionId.Trim());
		    //  ts2 = Regions_info.GetAllRegion(UserSessionInfo, ts2);
		    //  if (ts.Length > 0)
		    //whereSql += " AND " + ViewMarketSellers_info.cRegionID + " IN (" + ts2 + ")";

		    string orderSql = " SellerID DESC ," + ViewMarketSellers_info.cStallName + " DESC";

		    return Content(GetData.Instance.GetResult(Tn.ViewMarketSellers, "*", whereSql, orderSql, Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }
	    /// <summary>
	    /// 搜索查询供货商信息
	    /// </summary>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult SupplierSearchResult(string page, string rows)
	    {
		    string habitatId = Request["HabitatID"]?.Trim() ?? "",
			    supplierName = Request["SupplierName"]?.Trim() ?? "";
		    string whereSql = " 1=1 "; //UserSessionInfo.MarketDataSql(false);
		    string ts = supplierName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + Suppliers_info.cName + " like '%" + ts + "%'";

		    ts = habitatId;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND " + Suppliers_info.cHabitatID + " IN(" + ts + ")";

		    string orderSql = Suppliers_info.cName + " DESC ," + Suppliers_info.cHabitatID + " ASC";

		    return Content(GetData.Instance.GetResult(Tn.Suppliers, "*", whereSql, orderSql, Utils.ValI(page),
			    Utils.ValI(rows), UserSessionInfo.DBConn));
	    }

	    /// <summary>
	    /// 搜索查询品种名信息
	    /// </summary>
	    /// <param name="page"></param>
	    /// <param name="rows"></param>
	    /// <returns></returns>
	    [HttpPost]
	    public ActionResult SampleNameSearchResult(string page, string rows)
	    {
			string sampleName = Request["SampleName"]?.Trim() ?? "";
		    //littleKindName = Request["LittleKindName"]?.Trim() ?? "",
		    if (sampleName == "")
		    {
			    return Content("[]");
		    }
		    string whereSql = " [IsCanChecked]='Y' "; //UserSessionInfo.MarketDataSql(false);
		    string ts = sampleName;
		    ts = Utils.AreaToSQL(ts);
		    if (ts.Length > 0)
			    whereSql += " AND VarietyCategoryName like '%" + ts + "%'";

		    //ts = littleKindName;
		    //ts = Utils.AreaToSQL(ts);
		    //if (ts.Length > 0)
			   // whereSql += " AND Path like'%" + ts + "'%";
		    string lcSql = " SELECT Path FROM VarietyCategory WHERE " + whereSql;
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
		    string lcPath = "";
		    if (loQuery.IsOpened && loQuery.RecCount > 0)
		    {
			    loQuery.MoveFirst();
			    for (int i = 0; i < loQuery.RecCount; i++)
			    {
				    lcPath += loQuery.GetString("Path") + ",";
				    loQuery.MoveNext();
			    }
		    }
		    lcSql = " select VarietyCategoryNo,VarietyCategoryName,FatherNo as _parentId,case when  (IsLeaf='Y')then 'open' else NULL END as state  from " + Tn.VarietyCategory + " where " + VarietyCategory_info.cVarietyCategoryNo +
		            " in ('" + lcPath.Replace(",", "','") + "')";
		    return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
	    }

		#endregion

		[ValidateInput(false)]
		public ActionResult PdfCreate()
		{
			string htmlStr = Request["htmlStr"];
			string filePath = AppDomain.CurrentDomain.BaseDirectory + "Downloads\\PdfTemp\\";
			if (!Directory.Exists(filePath))
				Directory.CreateDirectory(filePath);
			string fileName = DateTime.Now.ToString("HHmmssff");
			string htmlPath = filePath + fileName + ".html";
			string pdfPath = filePath + fileName + ".pdf";
			try
			{
				FileStream fileStream = new FileStream(htmlPath, FileMode.Append);
				StreamWriter streamWriter = new StreamWriter(fileStream, Encoding.UTF8);
				streamWriter.Write(htmlStr);
				streamWriter.Flush();
				streamWriter.Close();
				fileStream.Close();

				//纸张大小
				string pdf_page_size = "A4";
				PdfPageSize pageSize = (PdfPageSize)Enum.Parse(typeof(PdfPageSize),
					pdf_page_size, true);
				//纸张方向
				string pdf_orientation = "Portrait";
				PdfPageOrientation pdfOrientation =
					(PdfPageOrientation)Enum.Parse(typeof(PdfPageOrientation),
						pdf_orientation, true);

				int webPageWidth = 1024;
				try
				{
					webPageWidth = Convert.ToInt32(webPageWidth);
				}
				catch { }

				int webPageHeight = 0;
				try
				{
					webPageHeight = Convert.ToInt32(webPageHeight);
				}
				catch { }

				// instantiate a html to pdf converter object
				HtmlToPdf converter = new HtmlToPdf();

				// set converter options
				converter.Options.PdfPageSize = pageSize;
				converter.Options.PdfPageOrientation = pdfOrientation;
				converter.Options.WebPageWidth = webPageWidth;
				converter.Options.WebPageHeight = webPageHeight;

				// create a new pdf document converting an url
				PdfDocument doc = converter.ConvertUrl(htmlPath);

				// save pdf document
				doc.Save(pdfPath);

				// close pdf document
				doc.Close();



				//PdfDocument pdf = new PdfDocument();
				////load html from URL
				//var thread = new Thread(() =>
				//{
				//	pdf.LoadFromHTML(htmlPath, false, true, true);
				//	//pdf.LoadFromHTML("----" + htmlPath, false, true, true);
				//});
				////set to single thread
				//thread.SetApartmentState(ApartmentState.STA);
				//thread.Start();
				//thread.Join();
				////save to PDF document
				
				//pdf.SaveToFile(pdfPath, FileFormat.PDF);
				//pdf.Close();
				return File(pdfPath, "application/pdf");
			}
			catch (Exception e)
			{
				Console.WriteLine(e);
				return Content("System Error");
			}
			finally
			{
				//if (System.IO.File.Exists(htmlPath))
				//	System.IO.File.Delete(htmlPath);
				//if (System.IO.File.Exists(pdfPath))
				//	System.IO.File.Delete(pdfPath);
			}
			
		}
		
	}
}