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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Mvc;
using DataTransfersLibs;
using GSMarketSys.Models.Dto;
using Newtonsoft.Json;
using SysBaseLibs;
using SysDataLibs;
using SysDataLibs.TableClass;

namespace GSMarketSys.Controllers
{
    [CheckPowerFilter]
    public class MarketSystemController : BaseController
    {
		
		#region 市场基础信息（Market）
		
		/// <summary>
		/// 市场信息录入页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketsList()
		{
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
				Tn.MarketType, "MarketTypeID<>'6'", UserSessionInfo.DBConn);
			ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
			return View();
		}
		/// <summary>
		/// 市场（超市）信息录入操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketsListOper()
		{
			#region Request + new Markets_Info

			string type = Request["Type"] ?? "";
			string marketId = GetRequest("MarketID");
			string regionId = GetRequest("RegionId");
			string licenseNo = GetRequest("LicenseNo");
			string licenseName = GetRequest("LicenseName");
			string cardIndex = GetRequest("CardIndex");
			string practiseTime = GetRequest("PractiseTime");
			string area = GetRequest("Area","INT");
			string marketSellerNum = GetRequest("MarketSellerNum","INT");
			string principal = GetRequest("Principal");
			string linkMan = GetRequest("LinkMan");
			string frontForUnit = GetRequest("FrontForUnit");
			string address = GetRequest("Address");
			string name = GetRequest("Name");
			string marketTypeId = GetRequest("MarketTypeID");
			string upgrade = GetRequest("Upgrade");
			string turnover = GetRequest("Turnover","INT");
			string auditFlag = GetRequest("AuditFlag","INT");
			string telephone = GetRequest("Telephone");
			string linkTel = GetRequest("LinkTel");
			string manageUnit = GetRequest("ManageUnit");
			string remark = GetRequest("Remark");
			Markets_info marketInfo = new Markets_info
			{
				MarketID = marketId,
				RegionID = regionId,
				LicenseNo = licenseNo,
				LicenseName = licenseName,
				CardIndex = cardIndex,
				PractiseTime = practiseTime,
				Area = area,
				MarketSellerNum = marketSellerNum,
				Principal = principal,
				LinkMan = linkMan,
				FrontForUnit = frontForUnit,
				Address = address,
				Names = name,
				MarketTypeID = marketTypeId,
				Upgrade = upgrade,
				Turnover = turnover,
				AuditFlag = auditFlag,
				Telephone = telephone,
				LinkTel = linkTel,
				ManageUnit = manageUnit,
				Remark = remark,
				IsLock = "0"
			};
			#endregion

			string lcSql = "";
			switch (type)
			{
				case "Add":
					if (SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
					{
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
					}
					lcSql = marketInfo.InsertSql();
					break;
				case "Edit":
					if (!SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
					{
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_NoExistKeyError"));
					}
					lcSql = marketInfo.UpdateSql();
					break;
				case "Del":
					if (!SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
					{
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_NoExistKeyError"));
					}
					lcSql = "UPDATE Markets SET IsLock=1 WHERE MarketID='" + marketId + "'";
					break;
				case "ReDel":
					if (!SysDataLibs.AppEnv.IsExistPrKey(Tn.Markets, Markets_info.cMarketID, marketId, UserSessionInfo.DBConn))
					{
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_NoExistKeyError"));
					}
					lcSql = "UPDATE Markets SET IsLock=0 WHERE MarketID='" + marketId + "'";
					break;
			}
			if (string.IsNullOrEmpty(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
			if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		}

		/// <summary>
		/// 市场信息查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketQry()
		{

			ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
				Tn.MarketType, "MarketTypeID<>'6'", UserSessionInfo.DBConn);
			ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
			return View();
		}

		/// <summary>
		/// 市场信用评级页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketEvaluationQry()
		{
			ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "Y" : "N";
			ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
				Tn.MarketType, "MarketTypeID<>'6'", UserSessionInfo.DBConn);
			ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
			return View();
		}
		/// <summary>
		/// 市场（超市）信用评级操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketEvaluationOper()
		{
			string type = Request["CurdType"] ?? "",
				marketId = GetRequest("MarketID"),
				year = GetRequest("Year"),
				month = GetRequest("Month"),
				postValue = GetRequest("PostValue"),
				lcReturnValue = postValue.Replace("txtNum_", "");
			Array loList = UtilStr.StrToArray(lcReturnValue);
			string lcSql = "";
			switch (type)
			{
				case "Add":
					if (loList != null && loList.Length > 0)
					{
						rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(" SELECT * FROM  " + Tn.MarketEvalGrade + " WHERE  " + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND " + MarketEvalGrade_info.cYear + "='" + year + "' AND " + MarketEvalGrade_info.cMonth + "='" + month + "' ");
						if (loQuery.RecCount > 0)
						{
							
							return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsOperError"));
						}
						for (int i = 0; i < loList.Length; i++)
						{
							string lcValue = loList.GetValue(i) + "";
							string[] loStrs = lcValue.Split(',');
							string[] loIDs = loStrs[0].Split('_');
							MarketEvalGrade_info loMarketEvalGrade = new MarketEvalGrade_info
							{
								EvaluationID = loIDs[0],
								EvaluationItemID = loIDs[1],
								MarketID = marketId,
								Year = year,
								Month = month,
								Score = loStrs[1],
								ScoreDate = DateTime.Now.ToShortDateString(),
								ScoreUser = UserSessionInfo.UserInfo.Names,
								TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
								UserID = UserSessionInfo.UserInfo.UserID,
								IsSelf = UserSessionInfo.IsMarketSysAccount ? "Y" : "N"
							};

							lcSql += loMarketEvalGrade.InsertSql();
						}
					}
					break;
				case "Edit":
					if (loList != null && loList.Length > 0)
					{
						lcSql += " DELETE  " + Tn.MarketEvalGrade + " WHERE  " + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND " + MarketEvalGrade_info.cYear + "='" + year + "' AND " + MarketEvalGrade_info.cMonth + "='" + month + "' ";
						for (int i = 0; i < loList.Length; i++)
						{
							string lcValue = loList.GetValue(i) + "";
							string[] loStrs = lcValue.Split(',');
							string[] loIDs = loStrs[0].Split('_');
							MarketEvalGrade_info loMarketEvalGrade = new MarketEvalGrade_info
							{
								EvaluationID = loIDs[0],
								EvaluationItemID = loIDs[1],
								MarketID = marketId,
								Year = year,
								Month = month,
								Score = loStrs[1],
								ScoreDate = DateTime.Now.ToShortDateString(),
								ScoreUser = UserSessionInfo.UserInfo.Names,
								TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
								UserID = UserSessionInfo.UserInfo.UserID,
								IsSelf = UserSessionInfo.IsMarketSysAccount ? "Y" : "N"
							};

							lcSql += loMarketEvalGrade.InsertSql();
						}
					}
					break;

				case "Del":
					lcSql += " DELETE  " + Tn.MarketEvalGrade + " WHERE  " + MarketEvalGrade_info.cMarketID + "='" + marketId + "' AND " + MarketEvalGrade_info.cYear + "='" + year + "' AND " + MarketEvalGrade_info.cMonth + "='" + month + "' ";
					break;
			}
			if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		}

		/// <summary>
		/// 超市信息录入页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketsListCs()
		{
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
				Tn.MarketType, "MarketTypeID='6'", UserSessionInfo.DBConn);
			ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
			return View();
		}

		/// <summary>
		/// 超市信息查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketQryCs()
		{
			ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
				Tn.MarketType, "MarketTypeID='6'", UserSessionInfo.DBConn);
			ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
			return View();
		}

		/// <summary>
		/// 超市信用评级页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketEvaluationQryCs()
		{
			ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "Y" : "N";
			ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketTypeInfo = GetData.Instance.GetSelStr(MarketType_info.cMarketTypeID, MarketType_info.cMarketTypeName,
				Tn.MarketType, "MarketTypeID='6'", UserSessionInfo.DBConn);
			ViewBag.SelUpgradeInfo = GetData.Instance.GetSelStr("Upgrade", Tn.Markets, UserSessionInfo.DBConn);
			return View();
		}

		#endregion

		#region 经营户基础信息（MarketSeller）

		/// <summary>
		/// 经营户信息录入页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketSellersList()
		{
			ViewBag.SelTradeTypeInfo = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName,
				Tn.TradeType, UserSessionInfo.DBConn, false);
			ViewBag.SelRunningWayTypeInfo = GetData.Instance.GetSelStr(ApparatusType_info.cApparatusTypeID, ApparatusType_info.cName, Tn.ApparatusType, UserSessionInfo.DBConn, false);
			ViewBag.SelApparatusTypeInfo = GetData.Instance.GetSelStr(RunningWayType_info.cRunningWayTypeID, RunningWayType_info.cName, Tn.RunningWayType, UserSessionInfo.DBConn, false);
			ViewBag.SelWarrantType = GetData.Instance.GetSelStr("WarrantTypeID", "Name",
				Tn.WarrantType, "IsLock=0 AND Flag=1", UserSessionInfo.DBConn);
			ViewBag.SelWarrantStyle =
				GetData.Instance.GetSelStr("WarrantStyle", "SellerHasWarrant", UserSessionInfo.DBConn);
			ViewBag.SelStallInfo = GetData.Instance.GetSelStr(Stalls_info.cStallID, Stalls_info.cName, Tn.Stalls, UserSessionInfo.MarketDataSql(false), UserSessionInfo.DBConn);

			return View();
		}

		/// <summary>
		/// 经营户信息录入操作
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketSellersListOper()
	    {
			#region Request + new MarketSellers_Info

		    string type = GetRequest("Type"),
			    sellerId = GetRequest("SellerID"),
			    marketSellerName = GetRequest("MarketSellerName"),
			    licenseNo = GetRequest("LicenseNo"),
			    licenseName = GetRequest("LicenseName"),
			    cardIndex = GetRequest("CardIndex"),
			    gender = GetRequest("Gender"),
			    age = GetRequest("Age"),
			    idCard = GetRequest("IdCard"),
			    tel = GetRequest("Tel"),
			    enterMarketDate = GetRequest("EnterMarketDate"),
			    residenceAddress = GetRequest("ResidenceAddress"),
			    tempAddress = GetRequest("TempAddress"),
			    tradeTypeId = GetRequest("TradeTypeID"),
			    runningWayTypeId = GetRequest("RunningWayTypeID"),
			    annualStallFee = GetRequest("AnnualStallFee", "INT"),
			    facia = GetRequest("Facia"),
			    apparatusTypeId = GetRequest("ApparatusTypeID", "INT"),
			    remark = GetRequest("Remark"),
			    staff1Name = GetRequest("Staff1Name"),
			    staff1Gender = GetRequest("Staff1Gender"),
			    staff1Age = GetRequest("Staff1Age"),
			    staff1Residence = GetRequest("Staff1Residence"),
			    staff1CurrentAddr = GetRequest("Staff1CurrentAddr"),
			    staff2Name = GetRequest("Staff2Name"),
			    staff2Gender = GetRequest("Staff2Gender"),
			    staff2Age = GetRequest("Staff2Age"),
			    staff2Residence = GetRequest("Staff2Residence"),
			    staff2CurrentAddr = GetRequest("Staff2CurrentAddr"),
			    staff3Name = GetRequest("Staff3Name"),
			    staff3Gender = GetRequest("Staff3Gender"),
			    staff3Age = GetRequest("Staff3Age"),
			    staff3Residence = GetRequest("Staff3Residence"),
			    staff3CurrentAddr = GetRequest("Staff3CurrentAddr"),
			    marketId = UserSessionInfo.MarketId;
		    if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
			MarketSellers_info marketSellerInfo = new MarketSellers_info(sellerId,UserSessionInfo.DBConn)
		    {
			    MarketID = marketId,
				LicenseNo = licenseNo,
				LicenseName = licenseName,
				CardIndex = cardIndex,
				Name = Utils.AreaToSQL(marketSellerName),
			    Gender = gender,
			    Age = Utils.AreaToSQL(age),
			    IdCard = Utils.AreaToSQL(idCard),
			    Tel = Utils.AreaToSQL(tel),
			    EnterMarketDate = enterMarketDate,
			    ResidenceAddress = residenceAddress,
			    TempAddress = Utils.AreaToSQL(tempAddress),
			    TradeTypeID = tradeTypeId,
			    RunningWayTypeID = runningWayTypeId,
			    AnnualStallFee = Utils.AreaToSQL(annualStallFee),
			    AnnualManageFee = "0",
			    Score = "0",
				Facia = Utils.AreaToSQL(facia),
			    ApparatusTypeID = apparatusTypeId,
			    Remark = Utils.AreaToSQL(remark),
			    Staff1Name = Utils.AreaToSQL(staff1Name),
			    Staff1Gender = Utils.AreaToSQL(staff1Gender),
			    Staff1Age = Utils.AreaToSQL(staff1Age)==""?"0": Utils.AreaToSQL(staff1Age),
			    Staff1Residence = Utils.AreaToSQL(staff1Residence),
			    Staff1CurrentAddress = Utils.AreaToSQL(staff1CurrentAddr),
			    Staff2Name = Utils.AreaToSQL(staff2Name),
			    Staff2Gender = Utils.AreaToSQL(staff2Gender),
			    Staff2Age = Utils.AreaToSQL(staff2Age)==""?"0": Utils.AreaToSQL(staff2Age),
			    Staff2Residence = Utils.AreaToSQL(staff2Residence),
			    Staff2CurrentAddress = Utils.AreaToSQL(staff2CurrentAddr),
			    Staff3Name = Utils.AreaToSQL(staff3Name),
			    Staff3Gender = Utils.AreaToSQL(staff3Gender),
			    Staff3Age = Utils.AreaToSQL(staff3Age)==""?"0": Utils.AreaToSQL(staff3Age),
			    Staff3Residence = Utils.AreaToSQL(staff3Residence),
			    Staff3CurrentAddress = Utils.AreaToSQL(staff3CurrentAddr),
			    IsLock = "N"
		    };
			#endregion

		    
		    string lcSql = "";
		    switch (type)
		    {
			    case "Add":
				    if (CheckSellerIdCodeIsExist(marketSellerInfo.MarketID, marketSellerInfo.IdCard))
					    return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，身份证号(" +
					                   marketSellerInfo.IdCard + ")在市场中已存在！\"}");
				    if (!string.IsNullOrEmpty(marketSellerInfo.LicenseNo)&&CheckSellerLicenseNoIsExist(marketSellerInfo.MarketID, marketSellerInfo.LicenseNo))
					    return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，社会信用统一编码(" +
					                   marketSellerInfo.LicenseNo + ")在市场中已存在！\"}");
				    lcSql = marketSellerInfo.InsertSql();
					//lcSql += " SELECT @@IDENTITY AS ident ";
					break;
			    case "Edit":
				    if (CheckSellerIdCodeIsExist(marketSellerInfo.MarketID, marketSellerInfo.IdCard,
					    marketSellerInfo.SellerID))
					    return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，身份证号(" +
					                   marketSellerInfo.IdCard + ")在市场中已存在！\"}");
				    if (!string.IsNullOrEmpty(marketSellerInfo.LicenseNo)&&CheckSellerLicenseNoIsExist(marketSellerInfo.MarketID, marketSellerInfo.LicenseNo,
					    marketSellerInfo.SellerID))
					    return Content("{\"Success\":false,\"State\":0,\"ErrorInfo\":\"操作失败，社会信用统一编码(" +
					                   marketSellerInfo.LicenseNo + ")在市场中已存在！\"}");
				    lcSql = marketSellerInfo.UpdateSql();
				    break;
			    case "Del":
				    lcSql = "UPDATE MarketSellers SET IsLock='Y' WHERE SellerID='" + sellerId + "'";
					break;
                case "ReDel":
                    lcSql = "UPDATE MarketSellers SET IsLock='N' WHERE SellerID='" + sellerId + "'";
                    break;

            }

            if (string.IsNullOrEmpty(lcSql))
            {
                return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
            }
		     //   if (type == "Add")
		     //   {
			    //    try
			    //    {
			    //	    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
			    //	    string identity = loQuery.GetString("ident");
			    //	    ResultJson temp =
			    //		    SysBaseLibs.JsonHelper.Instance.Deserialize<ResultJson>(
			    //			    SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    //	    temp.ErrorInfo = identity + "|" + temp.ErrorInfo;
			    //		return Content(temp.ToJson());
			    //	}
			    //    catch 
			    //    {
			    //		return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
			    //	}
			    //}
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }

	    private bool CheckSellerIdCodeIsExist(string marketId, string identityCode,string sellerId=null)
	    {
		    bool lbRetval = false;
		    string lcSql = "SELECT top 1 * FROM  MarketSellers WHERE "+MarketSellers_info.cMarketID+" = '" + marketId + "' AND "+ MarketSellers_info.cIdCard + "='" + identityCode + "'";
		    if (!string.IsNullOrEmpty(sellerId))
		    {
			    lcSql += " AND SellerID !='" + sellerId + "'";
		    }
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
		    if (loQuery.IsOpened && loQuery.RecCount > 0)
		    {
			    lbRetval = true;
		    }
		    return lbRetval;
		}
	    private bool CheckSellerLicenseNoIsExist(string marketId, string licenseNo, string sellerId=null)
	    {
		    bool lbRetval = false;
		    string lcSql = "SELECT top 1 * FROM  MarketSellers WHERE "+MarketSellers_info.cMarketID+" = '" + marketId + "' AND "+ MarketSellers_info.cLicenseNo + "='" + licenseNo + "'";
		    if (!string.IsNullOrEmpty(sellerId))
		    {
			    lcSql += " AND SellerID !='" + sellerId + "'";
		    }
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
		    if (loQuery.IsOpened && loQuery.RecCount > 0)
		    {
			    lbRetval = true;
		    }
		    return lbRetval;
		}


	    /// <summary>
	    /// 经营户执照信息操作
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult MarketSellerWarrantOper()
	    {
		    string type = Request["Type"] ?? "",
			    sellerId = GetRequest("SellerID"),
			    id = GetRequest("ID"),
			    warrantTypeId = GetRequest("WarrantTypeID"),
			    warrantStyle = GetRequest("WarrantStyle"),
			    warrantNumber = GetRequest("WarrantNumber"),
			    validStartTime = GetRequest("ValidStartTime"),
			    validEndTime = GetRequest("ValidEndTime"),
			    fileTitle = GetRequest("FileTitle"),
			    marketId = UserSessionInfo.MarketId;
		    if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
			string lcSql ;
		    SellerHasWarrant_info sellerHasWarrant = new SellerHasWarrant_info(sellerId,UserSessionInfo.DBConn)
		    {
			    SellerID = Utils.AreaToSQL(sellerId),
			    WarrantTypeID = Utils.AreaToSQL(warrantTypeId),
			    WarrantStyle = Utils.AreaToSQL(warrantStyle),
			    WarrantNumber = Utils.AreaToSQL(warrantNumber),
			    ValidStartTime = Utils.AreaToSQL(validStartTime),
			    ValidEndTime = Utils.AreaToSQL(validEndTime)
			};
		    Sys_AttachFiles_info loAttacthFile;
			HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
		    switch (type)
		    {
				case "Add":
					try
					{
						lcSql = sellerHasWarrant.InsertSql();
						lcSql += " SELECT @@IDENTITY AS ident ";
						rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
						string identity = loQuery.GetString("ident");
						loAttacthFile = new Sys_AttachFiles_info
						{
							TableId = Tn.SellerHasWarrant,
							ColumnId = SellerHasWarrant_info.cID,
							SourceKey = identity,
							FileTitle = fileTitle,
							TimeCreated = DateTime.Now.ToShortDateString(),
							TimeLastMod = DateTime.Now.ToShortDateString(),
							UserIDLastMod = UserSessionInfo.UserInfo.UserID
						};
						if (loAttacthFile.UpdateFile(attachFile, UserSessionInfo))
							return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error_NoAttach"));
					}
					catch (Exception ex)
					{
						ThreadLog.LogException(ex);
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
					}
			    case "Edit":
					sellerHasWarrant.ID = id;
					lcSql = sellerHasWarrant.UpdateSql();
				    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
				    {
					    loAttacthFile = new Sys_AttachFiles_info(Tn.SellerHasWarrant, SellerHasWarrant_info.cID, id,
						    UserSessionInfo.DBConn)
					    {
						    TableId = Tn.SellerHasWarrant,
						    ColumnId = SellerHasWarrant_info.cID,
						    SourceKey = id,
						    FileTitle = fileTitle,
						    TimeCreated = DateTime.Now.ToShortDateString(),
						    TimeLastMod = DateTime.Now.ToShortDateString(),
						    UserIDLastMod = UserSessionInfo.UserInfo.UserID
					    };
					    string oldPath = HttpContext.Request.PhysicalApplicationPath + loAttacthFile.FilePath + "/" + loAttacthFile.FileName;
					    if (loAttacthFile.UpdateFile(attachFile, UserSessionInfo,false))
					    {
						    try
						    {
							    if (!string.IsNullOrEmpty(oldPath))
								    System.IO.File.Delete( oldPath);
						    }
						    catch (Exception e)
						    {
							    Console.WriteLine(e);
							    throw;
						    }
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						}
				    }
				    else
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
				    break;
			    case "Del":
					lcSql = "DELETE  " + Tn.SellerHasWarrant + "  WHERE " + SellerHasWarrant_info.cID + "  IN(" + id + ") ";
				    
					if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
				    {
					    loAttacthFile = new Sys_AttachFiles_info(Tn.SellerHasWarrant, SellerHasWarrant_info.cID, id,
						    UserSessionInfo.DBConn);
					    string oldPath = HttpContext.Request.PhysicalApplicationPath + loAttacthFile.FilePath + "/" + loAttacthFile.FileName;
					    if (UserSessionInfo.DBConn.ExcuteSqlTran(loAttacthFile.DeleteSql()))
					    {
							try
						    {
							    if (!string.IsNullOrEmpty(oldPath))
								    System.IO.File.Delete(oldPath);
						    }
						    catch (Exception e)
						    {
							    Console.WriteLine(e);
							    throw;
						    }
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						}
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));

					}
					else
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		    }
		    
			return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
	    }

	    /// <summary>
	    /// 经营户摊位信息操作
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult MarketSellerStallOper()
	    {
		    string sellerId = GetRequest("SellerID"),
			    stallNo = GetRequest("StallNo");
		    return Content(SellerHasStall_info.UpdateStallBySellerId(sellerId, stallNo, UserSessionInfo.DBConn) ? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success") : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
	    }

		/// <summary>
		/// 经营户信息查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketSellersQry()
		{
			ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelTradeTypeInfo = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName,
				Tn.TradeType, UserSessionInfo.DBConn, false);
			ViewBag.SelRunningWayTypeInfo = GetData.Instance.GetSelStr(ApparatusType_info.cApparatusTypeID, ApparatusType_info.cName, Tn.ApparatusType, UserSessionInfo.DBConn, false);
			ViewBag.SelApparatusTypeInfo = GetData.Instance.GetSelStr(RunningWayType_info.cRunningWayTypeID, RunningWayType_info.cName, Tn.RunningWayType, UserSessionInfo.DBConn, false);
			return View();
		}

	    /// <summary>
	    /// 经营户信用评级页面
	    /// </summary>
	    /// <returns></returns>
		public ActionResult MarketSellersEvaQry()
		{
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelTradeTypeInfo = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName,
		        Tn.TradeType, UserSessionInfo.DBConn, false);
            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "Y" : "N";
			ViewBag.IsPrint = UserSessionInfo.CheckPower(PowerType.IsPrint) ? "block" : "none";

			return View();
		}
		/// <summary>
		/// 经营户信用评级操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketSellersEvaluationOper()
	    {
		    string type = Request["CurdType"] ?? "",
			    marketId = GetRequest("MarketID"),
			    sellerId = GetRequest("SellerID"),
			    year = GetRequest("Year"),
			    month = GetRequest("Month"),
			    postValue = GetRequest("PostValue"),
			    lcReturnValue = postValue.Replace("txtNum_", "");
		    Array loList = UtilStr.StrToArray(lcReturnValue);
		    string lcSql = "";
		    switch (type)
		    {
			    case "Add":
				    if (loList != null && loList.Length > 0)
				    {
					    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(" SELECT * FROM  " + Tn.SellerEvalGrade + " WHERE  " + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND " + SellerEvalGrade_info.cYear + "='" + year + "' AND " + SellerEvalGrade_info.cMonth + "='" + month + "' ");
					    if (loQuery.RecCount > 0)
					    {
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsOperError"));
					    }
					    for (int i = 0; i < loList.Length; i++)
					    {
						    string lcValue = loList.GetValue(i) + "";
						    string[] loStrs = lcValue.Split(',');
						    string[] loIDs = loStrs[0].Split('_');
						    SellerEvalGrade_info loSellerEvalGrade = new SellerEvalGrade_info
							{
							    EvaluationID = loIDs[0],
							    EvaluationItemID = loIDs[1],
							    MarketID = marketId,
								SellerID=sellerId,
							    Year = year,
							    Month = month,
							    Score = loStrs[1],
							    ScoreDate = DateTime.Now.ToShortDateString(),
							    ScoreUser = UserSessionInfo.UserInfo.Names,
							    TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
							    UserID = UserSessionInfo.UserInfo.UserID,
						    };

						    lcSql += loSellerEvalGrade.InsertSql();
					    }
				    }
				    break;
			    case "Edit":
				    if (loList != null && loList.Length > 0)
				    {
					    lcSql += " DELETE  " + Tn.SellerEvalGrade + " WHERE  " + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND " + SellerEvalGrade_info.cYear + "='" + year + "' AND " + SellerEvalGrade_info.cMonth + "='" + month + "' ";
					    for (int i = 0; i < loList.Length; i++)
					    {
						    string lcValue = loList.GetValue(i) + "";
						    string[] loStrs = lcValue.Split(',');
						    string[] loIDs = loStrs[0].Split('_');
							SellerEvalGrade_info loSellerEvalGrade = new SellerEvalGrade_info
							{
								EvaluationID = loIDs[0],
								EvaluationItemID = loIDs[1],
								MarketID = marketId,
								SellerID = sellerId,
								Year = year,
								Month = month,
								Score = loStrs[1],
								ScoreDate = DateTime.Now.ToShortDateString(),
								ScoreUser = UserSessionInfo.UserInfo.Names,
								TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
								UserID = UserSessionInfo.UserInfo.UserID,
							};

							lcSql += loSellerEvalGrade.InsertSql();
					    }
				    }
				    break;

			    case "Del":
				    lcSql += " DELETE  " + Tn.SellerEvalGrade + " WHERE  " + SellerEvalGrade_info.cSellerID + "='" + sellerId + "' AND " + SellerEvalGrade_info.cYear + "='" + year + "' AND " + SellerEvalGrade_info.cMonth + "='" + month + "' ";
				    break;
		    }
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }

		#endregion

		#region 市场日常管理

		/// <summary>
		/// 品牌管理页面
		/// </summary>
		/// <returns></returns>
		public ActionResult NameBrandList()
		{
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			return View();
		}
		/// <summary>
		/// 品牌管理操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult NameBrandOper()
	    {
			#region Request + new NameBrands_info

			string type  = Request["Type"] ?? "",
			nameBrandId = GetRequest("NameBrandID"),
			nameBrandName = GetRequest("NameBrandName")??"",
			nbByPerson = GetRequest("NBByPerson"),
			marketManager = GetRequest("MarketManager"),
			yjzhizhao = GetRequest("yjzhizhao"),
			foodName = GetRequest("FoodName"),
			nbByPersonLinks = GetRequest("NBByPersonLinks"),
			marketId = GetRequest("MarketId"),
			pinpaizhengshu = GetRequest("pinpaizhengshu"),
			description = GetRequest("Description"),
		    greenFood = GetRequest("GreenFood") ?? "N",
			organicFood = GetRequest("OrganicFood") ?? "N",
			innocuityFood = GetRequest("InnocuityFood") ?? "N",
			weishengxuke = GetRequest("weishengxuke");

		    NameBrands_info nameBrandInfo = new NameBrands_info(nameBrandId, UserSessionInfo.DBConn)
		    {
			    NameBrandName = nameBrandName,
			    TradeTypeID = "1",
			    MarketId = marketId,
			    FoodName = foodName,
			    NBByPerson = nbByPerson,
				NBByPersonLinks=nbByPersonLinks,
			    MarketManager = marketManager,
			    GreenFood = greenFood,
			    OrganicFood = organicFood,
			    InnocuityFood = innocuityFood,
			    yjzhizhao = yjzhizhao,
			    weishengxuke = weishengxuke,
			    pinpaizhengshu = pinpaizhengshu,
			    Description = description,
			    TimeLastMod = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID,
			    IsLock = "N"
		    };
		    #endregion

		    string lcSql = "";
		    switch (type)
		    {
			    case "Add":
				    nameBrandInfo.TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
				    lcSql = nameBrandInfo.InsertSql();
					break;
			    case "Edit":
				    if (!string.IsNullOrEmpty(nameBrandId))
				    {
						nameBrandInfo.NameBrandID = nameBrandId;
					    lcSql = nameBrandInfo.UpdateSql();
					}
				    break;
				case "Del":
				    if (!string.IsNullOrEmpty(nameBrandId))
					    lcSql = "UPDATE " + Tn.NameBrands + " SET IsLock='Y' WHERE NameBrandID='" + nameBrandId + "'";
				    break;
			}
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }

		/// <summary>
		/// 主要商品价格页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketMajorQuoteList()
		{
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelMajorGoodsNameInfo = GetData.Instance.GetSelStr(VarietyCategory_info.cVarietyCategoryNo,
				VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
				VarietyCategory_info.cIsMajorCost + "='Y' AND " + VarietyCategory_info.cVarietyCategoryNo +
				"!='10000'", UserSessionInfo.DBConn);
			//var result= GetData.Instance.GetSelectList(VarietyCategory_info.cVarietyCategoryNo,
			//VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
			//	VarietyCategory_info.cIsCanChecked + "='Y' AND "+ VarietyCategory_info.cVarietyCategoryNo +"!='10000'", UserSessionInfo.DBConn);
			//ViewBag.SelMajorGoodsNameInfo =result;
			ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(MarketMajorQuote_info.cUnitID, Tn.MarketMajorQuote, UserSessionInfo.DBConn);
			
			return View();
		}
		/// <summary>
		/// 主要商品价格操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketMajorQuoteOper()
	    {
			#region Request + new MarketMajorQuote_info

		    string type = Request["Type"] ?? "",
			    marketMajorQuoteId = GetRequest("MarketMajorQuoteID"),
			    marketId = GetRequest("MarketID"),
			    majorGoodsName = GetRequest("MajorGoodsName"),
			    varietyCategoryNo = GetRequest("VarietyCategoryNo"),
			    quoteDate = GetRequest("QuoteDate"),
			    amount = GetRequest("Amount"),
			    unitId = GetRequest("UnitID"),
			    quoteHigh = GetRequest("QuoteHigh"),
			    quoteLow = GetRequest("QuoteLow"),
			    quoteAverage = GetRequest("QuoteAverage");

		    MarketMajorQuote_info majorQuoteInfo = new MarketMajorQuote_info
		    {
			    MajorGoodsName = majorGoodsName,
			    VarietyCategoryNo = varietyCategoryNo,
			    QuoteDate = quoteDate,
			    MarketID = marketId,
			    Amount = amount,
			    UnitID = unitId,
			    QuoteHigh = quoteHigh,
			    QuoteLow = quoteLow,
			    QuoteAverage = quoteAverage,
			    UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
			    UserID = UserSessionInfo.UserInfo.UserID,
		    };
		    #endregion

		    string lcSql = "";
		    switch (type)
		    {
			    case "Add":
				    majorQuoteInfo.UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
				    lcSql = majorQuoteInfo.InsertSql();
				    break;
			    case "Edit":
				    if (!string.IsNullOrEmpty(marketMajorQuoteId))
				    {
					    majorQuoteInfo.MarketMajorQuoteID = marketMajorQuoteId;
					    lcSql = majorQuoteInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(marketMajorQuoteId))
				    {
					    majorQuoteInfo.MarketMajorQuoteID = marketMajorQuoteId;
					    lcSql = majorQuoteInfo.DeleteSql();
				    }
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
	    /// 主要商品价格查询页面
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult MarketMajorQuoteQry()
	    {
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			//ViewBag.SelMajorGoodsNameInfo = GetData.Instance.GetSelStr(MajorSpecials_info.cMajorSpecialName, MajorSpecials_info.cMajorSpecialName, Tn.MajorSpecials, MajorSpecials_info.cIsLock + "='N' ", UserSessionInfo.DBConn);
		    ViewBag.SelMajorGoodsNameInfo = GetData.Instance.GetSelStr(VarietyCategory_info.cVarietyCategoryNo,
			    VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
			    VarietyCategory_info.cIsMajorCost + "='Y' AND " + VarietyCategory_info.cVarietyCategoryNo + "!='10000'", UserSessionInfo.DBConn);

			ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(MarketMajorQuote_info.cUnitID, Tn.MarketMajorQuote, UserSessionInfo.DBConn);
			return View();
	    }

		/// <summary>
		///  复称情况记录页面
		/// </summary>
		/// <returns></returns>
		public ActionResult WeightCheckLogList()
	    {
		    ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			return View();
	    }
		/// <summary>
		/// 复称情况记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult WeightCheckLogOper()
	    {
			#region Request + new WeightCheckLog_info + new Sys_AttachFiles

			string type = Request["Type"] ?? "",
			    id = GetRequest("ID"),
			    totalCount = GetRequest("TotalCount"),
			    accurateCount = GetRequest("AccurateCount"),
			    sellerId = GetRequest("SellerID"),
			    foodName = GetRequest("FoodName"),
			    result = GetRequest("Result"),
			    executor = GetRequest("Executor"),
			    logDate = GetRequest("LogDate"),
			    fileTitle = GetRequest("FileTitle"),
				marketId= UserSessionInfo.MarketId;

            string fileInfo = Request["FileInfo"];
            string fileName = Request["FileName"];
            string fileExt = Request["FileExt"];
			if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
		    //HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
			WeightCheckLog_info weightCheckLogInfo = new WeightCheckLog_info(id, UserSessionInfo.DBConn)
		    {
			    MarketID = marketId,
			    TotalCount = totalCount,
			    AccurateCount = accurateCount,
			    SellerID = sellerId,
			    FoodName = foodName,
			    Result = result,
			    Executor = executor,
			    LogDate = logDate,
			    UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
				UserID=UserSessionInfo.UserInfo.UserID
		    };
		    
			Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.WeightCheckLog, WeightCheckLog_info.cID, id,
			    UserSessionInfo.DBConn)
		    {
			    TableId = Tn.WeightCheckLog,
			    ColumnId = WeightCheckLog_info.cID,
			    SourceKey = id,
			    FileTitle = fileTitle,
			    TimeLastMod = DateTime.Now.ToShortDateString(),
			    //Description = description,
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID,
                FileName = fileName,
                FileExt = fileExt
			};

			#endregion

		    string lcSql = "", msg = "";
			
		    switch (type)
		    {
			    case "Add":
				    try
				    {
					    lcSql = weightCheckLogInfo.InsertSql();
					    lcSql += " SELECT @@IDENTITY AS ident ";
					    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
					    string identity = loQuery.GetString("ident");
					    loAttacthFile.SourceKey = identity;
					    loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
					    if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
					}
					catch
				    {
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
					}
			    case "Edit":
				    if (!string.IsNullOrEmpty(id))
				    {
					    weightCheckLogInfo.ID = id;
					    lcSql = weightCheckLogInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(id))
					    lcSql = "DELETE " + Tn.WeightCheckLog + " WHERE ID='" + id + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (type!="Add"&&UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
		    {
				if (string.IsNullOrEmpty(loAttacthFile.AttachID))
				{
					if (type == "Edit")
						type = "Add";
					if (type == "Del")
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
				}
				if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
				    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
		    }
			    
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
		/// 复称情况查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult WeightCheckLogQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);

			return View();
	    }
		
		/// <summary>
		///  消防检查记录页面
		/// </summary>
		/// <returns></returns>
		public ActionResult FireProtectInspectLogList()
	    {
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 消防检查记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult FireProtectInspectLogOper()
	    {
			#region Request + new FireProtect_InspectLog_info + new Sys_AttachFiles

			string type = Request["Type"] ?? "",
			    id = GetRequest("ID"),
				marketId = GetRequest("MarketID"),
				content = GetRequest("Content"),
				problem = GetRequest("Problem"),
				inspector = GetRequest("Inspector"),
			    result = GetRequest("Result"),
			    logDate = GetRequest("LogDate"),
			    fileTitle = GetRequest("FileTitle");
            string fileInfo = Request["FileInfo"];
            string fileName = Request["FileName"];
            string fileExt = Request["FileExt"];

			//if (string.IsNullOrEmpty(marketId))
			// return Content("操作失败！，【当前用户不能进行相关操作！】");
			//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
			FireProtect_InspectLog_info fireProtectInspectLogInfo =
			    new FireProtect_InspectLog_info(id, UserSessionInfo.DBConn)
			    {
				    MarketID = marketId,
				    Content = content,
				    Problem = problem,
				    Inspector = inspector,
				    Result = result,
				    LogDate = logDate,
				    UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
				    UserID = UserSessionInfo.UserInfo.UserID
			    };

		    Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.FireProtect_InspectLog, FireProtect_InspectLog_info.cID, id,
			    UserSessionInfo.DBConn)
		    {
			    TableId = Tn.FireProtect_InspectLog,
			    ColumnId = FireProtect_InspectLog_info.cID,
			    SourceKey = id,
			    FileTitle = fileTitle,
			    TimeLastMod = DateTime.Now.ToShortDateString(),
			    //Description = description,
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID,
                FileName = fileName,
                FileExt = fileExt
			};

		    #endregion

		    string lcSql = "",  msg = "";

		    switch (type)
		    {
			    case "Add":
				    try
				    {
					    lcSql = fireProtectInspectLogInfo.InsertSql();
					    lcSql += " SELECT @@IDENTITY AS ident ";
					    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
					    string identity = loQuery.GetString("ident");
					    loAttacthFile.SourceKey = identity;
					    loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
					    if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
					}
				    catch
				    {
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
				    }
			    case "Edit":
				    if (!string.IsNullOrEmpty(id))
				    {
					    fireProtectInspectLogInfo.ID = id;
					    lcSql = fireProtectInspectLogInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(id))
					    lcSql = "DELETE " + Tn.FireProtect_InspectLog + " WHERE ID='" + id + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
		    {
			    if (string.IsNullOrEmpty(loAttacthFile.AttachID))
			    {
					if (type == "Edit")
						type = "Add";
				    if (type == "Del")
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
				}
			    
			    if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
				    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
		    }

		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
	    /// <summary>
	    /// 消防检查查询页面
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult FireProtectInspectLogQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);

		    return View();
	    }

	    /// <summary>
	    ///  市场卫生记录页面
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult CleansingCheckLogList()
	    {
		    ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
			    Tn.AssessLevel, UserSessionInfo.DBConn,false); 
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 市场卫生记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult CleansingCheckLogOper()
	    {
			#region Request + new CleansingCheckLog_info + new Sys_AttachFiles

			string type = Request["Type"] ?? "",
			    id = GetRequest("ID"),
			    marketId = GetRequest("MarketID"),
			    assessLevelId = GetRequest("AssessLevelID"),
			    executor = GetRequest("Executor"),
			    selfCheckFlag = GetRequest("SelfCheckFlag"),
			    reason = GetRequest("Reason"),
			    logDate = GetRequest("LogDate"),
			    fileTitle = GetRequest("FileTitle");
            string fileInfo = Request["FileInfo"];
            string fileName = Request["FileName"];
            string fileExt = Request["FileExt"];

			//if (string.IsNullOrEmpty(marketId))
			// return Content("操作失败！，【当前用户不能进行相关操作！】");
			//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
			CleansingCheckLog_info cleansingCheckLogInfo =
			    new CleansingCheckLog_info(id, UserSessionInfo.DBConn)
			    {
				    MarketID = marketId,
				    AssessLevelID = assessLevelId,
				    Executor = executor,
				    SelfCheckFlag = selfCheckFlag,
				    Reason = reason,
				    LogDate = logDate,
				    UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
				    UserID = UserSessionInfo.UserInfo.UserID
			    };

		    Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.CleansingCheckLog, CleansingCheckLog_info.cID, id,
			    UserSessionInfo.DBConn)
		    {
			    TableId = Tn.CleansingCheckLog,
			    ColumnId = CleansingCheckLog_info.cID,
			    SourceKey = id,
			    FileTitle = fileTitle,
			    TimeLastMod = DateTime.Now.ToShortDateString(),
			    //Description = description,
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID,
				FileName = fileName,
				FileExt = fileExt
		    };

		    #endregion

		    string lcSql = "", msg = "";

		    switch (type)
		    {
			    case "Add":
				    try
				    {
					    lcSql = cleansingCheckLogInfo.InsertSql();
					    lcSql += " SELECT @@IDENTITY AS ident ";
					    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
					    string identity = loQuery.GetString("ident");
					    loAttacthFile.SourceKey = identity;
					    loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
					    if (GetData.Instance.AttachFileUpdate2(type, fileInfo,loAttacthFile, UserSessionInfo, ref msg))
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
				    }
				    catch
				    {
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
				    }
			    case "Edit":
				    if (!string.IsNullOrEmpty(id))
				    {
					    cleansingCheckLogInfo.ID = id;
					    lcSql = cleansingCheckLogInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(id))
					    lcSql = "DELETE " + Tn.CleansingCheckLog + " WHERE ID='" + id + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
		    {
			    if (string.IsNullOrEmpty(loAttacthFile.AttachID))
			    {
				    if (type == "Edit")
					    type = "Add";
				    if (type == "Del")
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    }

			    if (GetData.Instance.AttachFileUpdate2(type, fileInfo, loAttacthFile, UserSessionInfo, ref msg))
				    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
		    }

		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
		/// 市场卫生查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult CleansingCheckLogQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
				Tn.AssessLevel, UserSessionInfo.DBConn,false);
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);

		    return View();
	    }

	    /// <summary>
	    ///  市场值班记录页面
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult DutyLogList()
	    {
		    ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
			    Tn.AssessLevel, UserSessionInfo.DBConn, false);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 市场值班记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult DutyLogOper()
	    {
		    #region Request + new DutyLog_info

		    string type = Request["Type"] ?? "",
			    id = GetRequest("ID"),
			    watchers = GetRequest("Watchers"),
				notes = GetRequest("Notes"),
			    content = GetRequest("Content"),
			    logDate = GetRequest("LogDate"),
				marketId = UserSessionInfo.MarketId;
		    if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
			
			DutyLog_info dutyLogInfo =
			    new DutyLog_info(id, UserSessionInfo.DBConn)
			    {
				    MarketID = marketId,
				    Watchers=watchers,
					Content=content,
					Notes=notes,
				    LogDate = logDate,
				    UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
				    UserID = UserSessionInfo.UserInfo.UserID
			    };


		    #endregion

		    string lcSql = "";

		    switch (type)
		    {
			    case "Add":
				    lcSql = dutyLogInfo.InsertSql();
				    break;
				case "Edit":
				    if (!string.IsNullOrEmpty(id))
				    {
					    dutyLogInfo.ID = id;
					    lcSql = dutyLogInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(id))
					    lcSql = "DELETE " + Tn.DutyLog + " WHERE ID='" + id + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
		/// 市场值班查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult DutyLogQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelAssessLevelInfo = GetData.Instance.GetSelStr(AssessLevel_info.cAssessLevelID, AssessLevel_info.cName,
			    Tn.AssessLevel, UserSessionInfo.DBConn, false);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);

		    return View();
	    }

	    /// <summary>
	    ///  市场制度记录页面
	    /// </summary>
	    /// <returns></returns>
	    public ActionResult MarketStatuteList()
	    {
		    ViewBag.SelStatuteTypeInfo = GetData.Instance.GetSelStr(MarketStatute_info.cStatuteType, Tn.MarketStatute,  UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 市场制度记录操作
		/// </summary>
		/// <returns></returns>
		[ValidateInput(false)]
		[HttpPost]
	    public ActionResult MarketStatuteOper()
	    {
		    #region Request + new MarketStatute_info
		    string type = Request["Type"] ?? "",
			    statuteId = GetRequest("StatuteID"),
			    statuteType = GetRequest("StatuteType"),
			    statuteTitle = GetRequest("StatuteTitle"),
			    statuteContent = GetRequest("StatuteContent"),
			    marketId = UserSessionInfo.MarketId;
		    if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
		    MarketStatute_info dutyLogInfo =
			    new MarketStatute_info(statuteId, UserSessionInfo.DBConn)
			    {
				    StatuteID = statuteId,
				    StatuteType = statuteType,
				    StatuteTitle = statuteTitle,
				    StatuteContent = statuteContent,
				    MarketID = marketId,
			    };
		    #endregion

		    string lcSql = "";

		    switch (type)
		    {
			    case "Add":
				    lcSql = dutyLogInfo.InsertSql();
				    break;
			    case "Edit":
				    if (!string.IsNullOrEmpty(statuteId))
				    {
					    dutyLogInfo.StatuteID = statuteId;
					    lcSql = dutyLogInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(statuteId))
					    lcSql = "DELETE " + Tn.MarketStatute + " WHERE StatuteID='" + statuteId + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
		/// 市场制度查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketStatuteQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelStatuteTypeInfo = GetData.Instance.GetSelStr(MarketStatute_info.cStatuteType, Tn.MarketStatute, UserSessionInfo.DBConn);
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);

		    return View();
	    }

		/// <summary>
		///  市场分布和管理人员示意图页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketChartList()
		{
			ViewBag.SelChartTypeInfo = GetData.Instance.GetSelStr("ChartTypeID", "MarketChart", UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 市场分布和管理人员示意图上传
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketChartOper()
	    {
			#region Request + new MarketChart_info

			string type = Request["CurdType"],
			    id = GetRequest("ID"),
			    chartTypeId = GetRequest("ChartTypeID"),
			    fileTitle = chartTypeId == "1" ? "市场分布示意图" : "市场管理人员网络图",
			    marketId = UserSessionInfo.MarketId;
         
		    if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));

		    MarketChart_info marketChartInfo =
			    new MarketChart_info(id, UserSessionInfo.DBConn)
			    {
				    MarketID = marketId,
				    ChartTypeID = chartTypeId,
				    UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
				    UserID = UserSessionInfo.UserInfo.UserID
			    };

		    #endregion

		    string msg = "";

		    switch (type)
		    {
			    case "Add":
				    string lcSql = "SELECT ID FROM MarketChart WHERE MarketID='" + marketId + "' AND ChartTypeID='" + chartTypeId +
				                   "'";
					rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
				    if (loQuery.IsOpened && loQuery.RecCount > 0)
					    id = loQuery.CurrentTable.Rows[0]["ID"] + "";
				    Sys_AttachFiles_info loAttacthFile;
				    if (string.IsNullOrEmpty(id))
				    {
					    try
					    {
						    lcSql = marketChartInfo.InsertSql();
						    lcSql += " SELECT @@IDENTITY AS ident ";
						    loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
						    string identity = loQuery.GetString("ident");
						    loAttacthFile = new Sys_AttachFiles_info(Tn.MarketChart, MarketChart_info.cID, id,
							    UserSessionInfo.DBConn)
						    {
							    TableId = Tn.MarketChart,
							    ColumnId = MarketChart_info.cID,
							    SourceKey = identity,
							    FileTitle = fileTitle,
							    TimeLastMod = DateTime.Now.ToShortDateString(),
								//Description = description,
							    TimeCreated = DateTime.Now.ToShortDateString(),
								UserIDLastMod = UserSessionInfo.UserInfo.UserID
						    };
						    if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
							    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
					    }
					    catch
					    {
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
					    }
				    }
				    else
				    {
					    marketChartInfo.ID = id;
						lcSql = marketChartInfo.UpdateSql();
					    if (string.IsNullOrEmpty(lcSql))
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
					    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
					    {
						    loAttacthFile = new Sys_AttachFiles_info(Tn.MarketChart, MarketChart_info.cID, id,
							    UserSessionInfo.DBConn)
						    {
							    FileTitle = fileTitle,
							    TimeLastMod = DateTime.Now.ToShortDateString(),
							    //Description = description,
							    UserIDLastMod = UserSessionInfo.UserInfo.UserID
						    };
							if (!string.IsNullOrEmpty(loAttacthFile.AttachID))
							    type = "Edit";
						    if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
							    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
					    }
				    }
				    break;	
		    }
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }

	    /// <summary>
	    /// 附件相关操作
	    /// </summary>
	    /// <param name="type"></param>
	    /// <param name="tableId"></param>
	    /// <param name="columnId"></param>
	    /// <param name="sourceKey"></param>
	    /// <param name="fileTitle"></param>
	    /// <param name="description"></param>
	    /// <returns></returns>
	    public ActionResult AttachFileUpdate(string type, string tableId, string columnId, string sourceKey, string fileTitle, string description)
	    {
		    //string oldPath;
		    //HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
		    Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(tableId, columnId, sourceKey,
			    UserSessionInfo.DBConn)
		    {
			    TableId = tableId,
			    ColumnId = columnId,
			    SourceKey = sourceKey,
			    FileTitle = fileTitle,
			    TimeLastMod = DateTime.Now.ToShortDateString(),
			    Description = description,
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID
		    };
		    string msg = "";
		    GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg);
		    //return Content();
		    string lcRetval = msg.Contains("成功")
			    ? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success")
			    : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error");
		    ResultJson msgJson = SysBaseLibs.JsonHelper.Instance.Deserialize<ResultJson>(lcRetval);
		    msgJson.ErrorInfo = msg;
			return Content(msgJson.ToJson());
	    }
		#endregion

		#region 商品质量管理

		/// <summary>
		///    重要商品来源录入页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MajorGoodsLogList()
		{
			ViewBag.SelSuppliersInfo = GetData.Instance.GetSelStr(Suppliers_info.cSupplierID, Suppliers_info.cName, Tn.Suppliers, UserSessionInfo.DBConn, false);
			//ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelVarietyCategoryNameInfo = GetData.Instance.GetSelStr(VarietyCategory_info.cVarietyCategoryNo,
				VarietyCategory_info.cVarietyCategoryName, Tn.VarietyCategory,
				VarietyCategory_info.cIsMajorSrc + "='Y' AND " + VarietyCategory_info.cVarietyCategoryNo +
				"!='10000'", UserSessionInfo.DBConn);
			ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(MajorGoodsLog_info.cUnitID, Tn.MajorGoodsLog, UserSessionInfo.DBConn);
			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
				Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
				UserSessionInfo.DBConn);
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 " , UserSessionInfo.DBConn);
			return View(); 
		}
		/// <summary>
		/// 重要商品来源录入操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MajorGoodsLogOper()
		{
			#region Request + new MajorGoodsLog_info

			string type = Request["Type"] ?? "",
				id = GetRequest("ID"),
				//majorGoodsTypeId = GetRequest("MajorGoodsTypeID"),
				varietyCategoryNo = GetRequest("VarietyCategoryNo"),
				varietyCategoryName = GetRequest("VarietyCategoryName"),
				sellerId = GetRequest("SellerID"),
				totalCount = GetRequest("TotalCount"),
				supplierId = GetRequest("SupplierID"),
				quarantineUnit = GetRequest("QuarantineUnit"),
				unitId = GetRequest("UnitID"),
				stockTime = GetRequest("StockTime"),
				marketId = UserSessionInfo.MarketId;
			if (string.IsNullOrEmpty(marketId))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));

			MajorGoodsLog_info majorGoodsLogInfo =
				new MajorGoodsLog_info(id, UserSessionInfo.DBConn)
				{
					MarketID = marketId,
					MajorGoodsTypeID = "0",
					VarietyCategoryNo = varietyCategoryNo,
					VarietyCategoryName= varietyCategoryName,
					SellerID = sellerId,
					SupplierID = supplierId,
					StockTime = stockTime,
					TotalCount = totalCount,
					UnitID = unitId,
					QuarantineUnit = quarantineUnit,
					UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
					UserID = UserSessionInfo.UserInfo.UserID
				};


			#endregion

			string lcSql = "";

			switch (type)
			{
				case "Add":
					//majorGoodsLogInfo.ID=
					lcSql = majorGoodsLogInfo.InsertSql();
					break;
				case "Edit":
					if (!string.IsNullOrEmpty(id))
					{
						majorGoodsLogInfo.ID = id;
						lcSql = majorGoodsLogInfo.UpdateSql();
					}
					break;
				case "Del":
					if (!string.IsNullOrEmpty(id))
						lcSql = "DELETE " + Tn.MajorGoodsLog + " WHERE ID='" + id + "'";
					break;
			}
			if (string.IsNullOrEmpty(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
			if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		}
		/// <summary>
		/// 重要商品来源查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MajorGoodsLogQry()
		{
			//ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
				Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
				UserSessionInfo.DBConn);
			return View();
		}

		/// <summary>
		///  不合格商品退市录入页面
		/// </summary>
		/// <returns></returns>
		public ActionResult GoodsRecallLogList()
		{
			ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelUnitIDInfo = GetData.Instance.GetSelStr(GoodsRecallLog_info.cUnitID, Tn.GoodsRecallLog, UserSessionInfo.DBConn);
			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
				Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
				UserSessionInfo.DBConn);
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 ", UserSessionInfo.DBConn);
			return View();
		}
		/// <summary>
		/// 不合格商品退市录入操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult GoodsRecallLogOper()
		{
			#region Request + new GoodsRecallLog_info + new Sys_AttachFiles_info

			string type = Request["Type"] ?? "" ,
				id = GetRequest("ID"),
				goodsName = GetRequest("GoodsName"),
				supplier = GetRequest("Supplier"),
				sellerId = GetRequest("SellerID"),
				saleCount = GetRequest("SaleCount"),
				unitId = GetRequest("UnitID"),
				produceBatch = GetRequest("ProduceBatch"),
				tradeMark = GetRequest("TradeMark"),
				saleTime = GetRequest("SaleTime"),
				executor = GetRequest("Executor"),
				result = GetRequest("Result"),
				recallReason = GetRequest("RecallReason"),
				fileTitle = GetRequest("FileTitle"),
				marketId = UserSessionInfo.MarketId;
			if (string.IsNullOrEmpty(marketId))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));

			GoodsRecallLog_info goodsRecallLogInfo =
				new GoodsRecallLog_info(id, UserSessionInfo.DBConn)
				{
					MarketID = marketId,
					GoodsName=goodsName,
					Supplier=supplier,
					SellerID=sellerId,
					SaleCount=saleCount,
					UnitID=unitId,
					TradeMark=tradeMark,
					ProduceBatch=produceBatch,
					SaleTime=saleTime,
					Executor=executor,
					RecallReason=recallReason,
					Result=result,
					ModelType="",
					UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
					UserID = UserSessionInfo.UserInfo.UserID
				};
			Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.GoodsRecallLog, GoodsRecallLog_info.cID, id,
				UserSessionInfo.DBConn)
				{
					TableId = Tn.GoodsRecallLog,
					ColumnId = GoodsRecallLog_info.cID,
					SourceKey = id,
					FileTitle = fileTitle,
					TimeLastMod = DateTime.Now.ToShortDateString(),
					//Description = description,
					UserIDLastMod = UserSessionInfo.UserInfo.UserID
				};

			#endregion

			string lcSql = "", msg = "";

			switch (type)
			{
				case "Add":
					try
					{
						lcSql = goodsRecallLogInfo.InsertSql();
						lcSql += " SELECT @@IDENTITY AS ident ";
						rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
						string identity = loQuery.GetString("ident");
						if (string.IsNullOrEmpty(identity))
						{
							return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
						}
						loAttacthFile.SourceKey = identity;
						loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
						if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
							return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
					}
					catch
					{
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
					}
				case "Edit":
					if (!string.IsNullOrEmpty(id))
					{
						goodsRecallLogInfo.ID = id;
						lcSql = goodsRecallLogInfo.UpdateSql();
					}
					break;
				case "Del":
					if (!string.IsNullOrEmpty(id))
						lcSql = "DELETE " + Tn.GoodsRecallLog + " WHERE ID='" + id + "'";
					break;
			}
			if (string.IsNullOrEmpty(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
			if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			{
				if (string.IsNullOrEmpty(loAttacthFile.AttachID))
				{
					if (type == "Edit")
						type = "Add";
					if (type == "Del")
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
				}

				if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
					return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
			}

			return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		}
		/// <summary>
		/// 不合格商品退市查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult GoodsRecallLogQry()
		{
			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
				Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
				UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			ViewBag.SelMajorGoodsTypeInfo = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, MajorGoodsType_info.cIsLock + "='N' " + UserSessionInfo.GSSystemDataSql(true), UserSessionInfo.DBConn);

			return View();
		}


		/// <summary>
		///  检测数据录入页面
		/// </summary>
		/// <returns></returns>
		public ActionResult CheckDataList()
	    {
            if (UserSessionInfo.IsMarketSysAccount)
		    {
                ViewBag.IsMarketSysAccount = "0";
				ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
				    "IsLock=0 AND IsSystem=1", UserSessionInfo.DBConn);
            }
		    else
		    {
                ViewBag.IsMarketSysAccount = "1";
				ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
					"IsLock=0 AND IsSystem=1 AND SeriesType='1' ", UserSessionInfo.DBConn);
            }
            ViewBag.IsSystem = UserSessionInfo.IsSystem ? "0" : "1";
		    ViewBag.MarketID = UserSessionInfo.MarketId;
		    ViewBag.RegionID = UserSessionInfo.UserInfo.RegionID;
		    ViewBag.CheckUser = UserSessionInfo.UserInfo.UserCode;
            ViewBag.CheckUnit = SysDataLibs.AppEnv.GetTextByID("FarmID", UserSessionInfo.UserInfo.FarmID, "ShortNames", "Farms",
				UserSessionInfo.DBConn);
            ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
			    Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
			    UserSessionInfo.DBConn);
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT [RegionID],[Names],[FatherRegionID],[Depth] From Regions WHERE IsLock='0'");
            var regionResult = GetData.Instance.GetComboTree(loQuery, "RegionID", "FatherRegionID", "Names", "RegionID=861111",pcDepthVal:"2");
            ViewBag.SelRegionInfo = JsonConvert.SerializeObject(regionResult);
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
            ViewBag.SelCheckMethodInfo = GetData.Instance.GetSelStrDistinct("CheckMethodId", "CheckMethodName", "CheckMethod", "IsLock='N'", UserSessionInfo.DBConn);
            //ViewBag.SelCheckProjectTypeInfo = GetData.Instance.GetSelStr("CheckProjectTypeID", "Name", "CheckProjectType", "IsLock=0", UserSessionInfo.DBConn);
            ViewBag.SelLittleKindInfo = GetData.Instance.GetSelStr("VarietyCategoryNo", "VarietyCategoryName", "VarietyCategory", "IsLock='N' AND Depth=1 ORDER by VarietyCategoryNo", UserSessionInfo.DBConn);
            //ViewBag.SelSampleNameInfo = GetData.Instance.GetSelStr("SpecialsID", "Name", "Specials", "IsLock=0 ORDER by Name,SortNumber", UserSessionInfo.DBConn);
            ViewBag.SelCorpKindInfo = GetData.Instance.GetSelStr("Names", "Names", "CorporationType", UserSessionInfo.DBConn);
            ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 ", UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 检测数据录入操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult CheckDataOper()
	    {
		    #region Request + new CheckData_info 

	        string type = GetRequest("CurdType"),
	            id = GetRequest("ID"),
	            checkUnit = GetRequest("CheckUnit"),
	            memo = GetRequest("Memo"),
	            isSelf = GetRequest("IsSelf"),
	            marketId = GetRequest("MarketID"),
	            sendDate = GetRequest("SendDate"),
	            machineMaker = GetRequest("MachineMaker"),
	            corpKind = GetRequest("CorpKind"),
	            //corpName = GetRequest("CorpName"),
	            corpName = GetRequest("StallNo"), //被检对象和摊位号合并
			    produceUnit = GetRequest("ProduceUnit"),
			    produceDate = GetRequest("ProduceDate"),
			    clientIndexId = GetRequest("ClientIndexID"),
			    machineId = GetRequest("MachineID"),
			    checkTime = GetRequest("CheckTime"),
			    checkTotal = GetRequest("CheckTotal"),
			    checkResult = GetRequest("CheckResult"),
			    checkValue = GetRequest("CheckValue"),
			    standardValue = GetRequest("StandardValue"),
			    sampleId = GetRequest("SampleId"),
			    sampleName = GetRequest("SampleName"),
			    //littleKindName = GetRequest("LittleKindName"),
			    checkProjectTypeId = GetRequest("CheckProjectTypeID"),
			    habitatId = GetRequest("HabitatID"),
			    checkUser = GetRequest("CheckUser"),
			    stallNo = GetRequest("StallNo"),
			    licenseNo = GetRequest("LicenseNo"),
			    licenseName = GetRequest("LicenseName"),
			    idCode = GetRequest("IdCode"),
			    cardIndex = GetRequest("CardIndex");

			//if (string.IsNullOrEmpty(marketId))
			//    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));

			CheckData_info checkDataInfo = new CheckData_info(id, UserSessionInfo.DBConn)
		    {
			    MarketID = marketId,
			    CorpName = corpName,
			    CheckUnit = checkUnit,
			    CheckProjectTypeID = checkProjectTypeId,
			    CheckValue = checkValue,
			    CheckTotal = checkTotal,
			    CheckResult = checkResult,
			    CheckTime = checkTime,
			    CheckUser = checkUser,
			    SampleId = sampleId,
			    SampleName = sampleName,
			    IsSelf = isSelf,
			    SendDate = sendDate,
			    ClientIndexID = clientIndexId,
			    MachineID = machineId,
			    MachineMaker = machineMaker,
			    ProduceDate = produceDate,
			    ProduceUnit = produceUnit,
			    HabitatID = habitatId,
			    Memo = memo,
			    CheckLimit = standardValue,
			    CorpKind = corpKind,
			    UploadTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
			    UserID = UserSessionInfo.UserInfo.UserID,
				StallNo = corpName,
				LicenseNo = licenseNo,
				LicenseName = licenseName,
				IdCode = idCode,
				CardIndex = cardIndex
		    };


			#endregion
			string lcSql = "";
		    switch (type)
		    {
			    case "Add":
				    lcSql = checkDataInfo.InsertSql();
					lcSql+= " UPDATE VarietyCategory SET [CheckCount]=[CheckCount]+1 WHERE [VarietyCategoryNo]='"+ sampleId + "'";

					break;
			    case "Edit":
				    if (!string.IsNullOrEmpty(id))
				    {
					    checkDataInfo.ID = id;
					    lcSql = checkDataInfo.UpdateSql();
				    }
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
		    {
			    //添加上传接口   --- add by zhangwy  --update by Yue 2018.06.15
				if (type== "Add")
			    {
				    //CheckDataTransfersLibs.ytCheckDataUpload loytCheckDataUpload = new CheckDataTransfersLibs.ytCheckDataUpload();
				    //loytCheckDataUpload.ExcuteUploadYTThread(checkDataInfo);
					new List<CheckData_info> {checkDataInfo}.DataPush();
				}
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			}
		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		}
        //[HttpPost]
        //public ActionResult UploadCheckData()
        //{
        //    string path = "/Upload/CheckDataFile/";
        //    UploadResult uploadResult = UploadFileHelper.Instance.UploadFiles(path, "xlsx", Request, Server);
        //    string virtualPath = uploadResult.VirtualPathUrls[0].ToString();
        //    ThreadLog.LogInfo("1:"+virtualPath+"");
        //    string errorMsg = "";
        //    var dataUploadDtos = ExcelHelper2.ExcelToEntityList<CheckDataUploadDto>(new Dictionary<string, string>() { { "CheckUnit", "被检测单位" }, { "MarketID", "市场编号" }, { "StallNo", "摊位号" }, { "CheckProjectTypeID", "检测项目编号" }, { "SampleId", "品种编号" }, { "SampleName", "品种名称" }, { "CheckResult", "检测结果（合格/不合格）" }, { "UploadTime", "检测日期" }, { "CheckUser", "检测员" },  { "Memo", "备注" } },
        //        virtualPath, out errorMsg);//, { "StandardValue", "检测标准值" }, { "StandardUnit", "单位" }, { "IsSelf", "是否自检（1:是,0:否）" },  { "CheckTime", "送检日期" }, { "CheckValue", "检测值" }
        //    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("select * from "+Tn.CheckProjectType+" where IsLock=0;");
        //    List<CheckProjectType_info> typeList = new List<CheckProjectType_info>();
        //    if (loQuery != null && loQuery.IsOpened)
        //    {
        //        loQuery.MoveFirst();
        //        for (int i = 0; i < loQuery.RecCount; i++)
        //        {
        //            CheckProjectType_info loInfo = new CheckProjectType_info()
        //            {
        //                CheckProjectTypeID = loQuery.GetString("CheckProjectTypeID"),
        //                StandardValue = loQuery.GetString("StandardValue"),
        //            };
        //            typeList.Add(loInfo);
        //            loQuery.MoveNext();
        //        }
        //    }
            
        //    StringBuilder sb = new StringBuilder();
        //    int indexTmp = 1;
        //    string msg="",errormsg = "";
        //    foreach (var dto in dataUploadDtos)
        //    {
        //        if (string.IsNullOrEmpty(dto.CheckUnit) || string.IsNullOrEmpty(dto.MarketID))
        //        {
        //            errormsg = "被检单位或市场编号输入有误！";
        //        }
        //        if (dto.CheckProjectTypeID == 0||dto.UploadTime==null)
        //        {
        //            errormsg = "检测项目编号或者检测时间输入有误！";
        //        }

        //        if (string.IsNullOrEmpty(dto.SampleName) || string.IsNullOrEmpty(dto.SampleId))
        //        {
        //            errormsg = "品种编号或名称输入有误！";
        //        }
        //        if (string.IsNullOrEmpty(dto.CheckResult) || string.IsNullOrEmpty(dto.StallNo))
        //        {
        //            errormsg = "检测结果或摊位号输入有误！";
        //        }
        //        if (!string.IsNullOrEmpty(errorMsg))
        //        {
        //            msg += $"第{indexTmp}行，" + errormsg + ".\r\n";
        //            indexTmp++;
        //            continue;
        //        }
        //        var pt = dto.CheckProjectTypeID+"";
        //        CheckProjectType_info loProjectTypeInfo = typeList.FirstOrDefault(i => i.CheckProjectTypeID == pt);
        //        sb.Append(
        //            $"insert into CheckData(MarketID,CheckUnit,CheckUser,CheckProjectTypeID,SampleId,SampleName,CheckLimit,CheckValue,CheckResult,UploadTime,CheckTime,CorpName,IsSelf,CheckTotal,UserID,Memo)  VALUES ('{dto?.MarketID}','{dto?.CheckUnit}','{dto?.CheckUser}',{dto?.CheckProjectTypeID},'{dto?.SampleId}','{dto?.SampleName}',{loProjectTypeInfo?.StandardValue},{loProjectTypeInfo?.StandardValue??"0"},'{dto?.CheckResult}','{dto?.UploadTime}','{dto?.UploadTime}','{dto?.StallNo}',1,1,'{UserSessionInfo.UserInfo.UserID}','{dto?.Memo}');\r\n");
        //        indexTmp++;
        //    }

        //    bool lbRetval = false;
          
        //    if (!string.IsNullOrEmpty(sb.ToString()))
        //    {
        //        if (UserSessionInfo.DBConn.ExcuteSqlTran(sb.ToString()))
        //        {
        //            lbRetval = true;
        //        }
        //        else
        //        {
        //            msg += UserSessionInfo.DBConn.ErrorMsg;
        //        }

        //    }
        //    return Json(new { Success = lbRetval,Msg = msg });
        //}

		[HttpPost]
		public ActionResult UploadCheckData()
		{
			string path = "/Upload/CheckDataFile/";
			UploadResult uploadResult = UploadFileHelper.Instance.UploadFiles(path, "xls", Request, Server);
			string virtualPath = uploadResult.VirtualPathUrls[0].ToString();
			ThreadLog.LogInfo("1:" + virtualPath + "");
			string errorMsg = "";
			var dataUploadDtos = ExcelHelper2.ExcelToEntityList<YtCheckDataUploadDto>(new Dictionary<string, string>() { { "CheckTime", "检测日期" }, { "CheckedMarketName", "被检市场名称" }, { "CheckedUnitName", "被检单位名称" }, { "StallNumber", "摊位号" }, { "CheckedMan", "被检人姓名" }, { "CheckBigItem", "检测项目大类" }, { "CheckLittleItem", "检测项目小类" }, { "CheckBigVariety", "检测品种大类" }, { "CheckLittleVariety", "检测品种小类" }, { "CheckResult", "检测结果" } , { "CheckValue", "检测值" }, { "CheckLimit", "检测值参考范围" }, { "CheckRecord", "检测依据" }, { "CheckManufacturer", "检测厂商" }, { "CheckDevice", "检测设备" }, { "CheckMan", "检测人" }, { "CheckUnitName", "检测单位名称" } },
				virtualPath, out errorMsg);
			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("select * from SysMarketToYtMapping;");
            Dictionary<string,string> mDic = new Dictionary<string, string>();
			if (loQuery != null && loQuery.IsOpened)
			{
                loQuery.MoveFirst();
				for (int i = 0; i < loQuery.RecCount; i++)
                {
                    string lcMarketName = loQuery.GetString("MarketNameCheck");
                    string lcMarketId = loQuery.GetString("SysMarketId");
                    mDic.Add(lcMarketName,lcMarketId);
					loQuery.MoveNext();
                }
			}
            rsQuery loVarQuery = UserSessionInfo.DBConn.OpenQuery("select * from VarietyCategory;");
            Dictionary<string, string> varDic = new Dictionary<string, string>();
            if (loVarQuery != null && loVarQuery.IsOpened)
            {
                loVarQuery.MoveFirst();
                for (int i = 0; i < loVarQuery.RecCount; i++)
                {
                    string lcVarietyCategoryNo = loVarQuery.GetString("VarietyCategoryNo");
                    string lcVarietyCategoryName = loVarQuery.GetString("VarietyCategoryName");
                    varDic.Add(lcVarietyCategoryNo, lcVarietyCategoryName);
                    loVarQuery.MoveNext();
                }
            }
			StringBuilder sb = new StringBuilder();
			int indexTmp = 0;
			string msg = "", errormsg = "";
			foreach (var dto in dataUploadDtos)
            {
                errormsg = ""; indexTmp++;
				var littleVarKeyValue = varDic.FirstOrDefault(i => i.Value == dto.CheckLittleVariety);
                if (string.IsNullOrEmpty(littleVarKeyValue.Key))
                {
                    errormsg = "品种编号或名称输入有误！";
				}
                var marketKeyValue = mDic.FirstOrDefault(i => i.Key == dto.CheckedMarketName);
				if (string.IsNullOrEmpty(marketKeyValue.Value))
				{
					errormsg = "被检单位或市场编号输入有误！";
				}
			
				
				
				if (!string.IsNullOrEmpty(errormsg))
				{
					msg += $"第{indexTmp}行，" + errormsg + ".\r\n";
					continue;
				}

                string checkValue = string.IsNullOrEmpty(dto.CheckValue) ? "0" : dto.CheckValue.Replace("%","").Replace("mg/kg","");
                string checkRsult = dto.CheckResult == "阴性(未检出)" ? "合格" : "不合格";
				sb.Append(
					$"insert into CheckData(MarketID,CheckUnit,CheckUser,CheckProjectTypeID,SampleId,SampleName,CheckLimit,CheckValue,CheckResult,UploadTime,CheckTime,CorpName,IsSelf,CheckTotal,UserID,Memo,MachineID,MachineMaker)  VALUES ('{marketKeyValue.Value}','{dto.CheckUnitName}','{dto?.CheckMan}',{6},'{littleVarKeyValue.Key}','{littleVarKeyValue.Value}',{70.00},{checkValue},'{checkRsult}','{dto?.CheckTime}','{dto?.CheckTime}','{dto?.StallNumber}',1,1,'{UserSessionInfo.UserInfo.UserID}','{"t070201"}','{dto.CheckDevice}','{dto.CheckManufacturer}');\r\n");
				indexTmp++;
			}

			bool lbRetval = false;

			if (!string.IsNullOrEmpty(sb.ToString()))
			{
				if (UserSessionInfo.DBConn.ExcuteSqlTran(sb.ToString()))
				{
					this.LogInfo(sb.ToString());
					lbRetval = true;
				}
				else
				{
					msg += UserSessionInfo.DBConn.ErrorMsg;
				}

			}
			return Json(new { Success = lbRetval, Msg = msg });
		}
		/// <summary>
		/// 检测数据查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult CheckDataQry()
	    {
			if (UserSessionInfo.IsMarketSysAccount)
		    {
			    ViewBag.IsMarketSysAccount = "0";
			    ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
				    "IsLock=0 AND IsSystem=1", UserSessionInfo.DBConn);
		    }
		    else
		    {
			    ViewBag.IsMarketSysAccount = "1";
			    ViewBag.SelCheckUnitInfo = GetData.Instance.GetSelStrDistinct("Names", "Names", "Farms",
				    "IsLock=0 AND IsSystem=1 AND SeriesType='1' ", UserSessionInfo.DBConn);
		    }
		    //ViewBag.IsSystem = UserSessionInfo.IsSystem ? "0" : "1";
		    ViewBag.MarketID = UserSessionInfo.MarketId;
		    ViewBag.RegionID = UserSessionInfo.UserInfo.RegionID;
		    //ViewBag.CheckUser = UserSessionInfo.UserInfo.UserCode;
		    ViewBag.CheckUnit = SysDataLibs.AppEnv.GetTextByID("FarmID", UserSessionInfo.UserInfo.FarmID, "ShortNames", "Farms",
			    UserSessionInfo.DBConn);

		    //ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName,
			   // Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true),
			   // UserSessionInfo.DBConn);
		    //ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT [RegionID],[Names],[FatherRegionID],[Depth] From Regions WHERE IsLock='0'");
		    var regionResult = GetData.Instance.GetComboTree(loQuery, "RegionID", "FatherRegionID", "Names", "RegionID=861111", pcDepthVal: "2");
		    ViewBag.SelRegionInfo = JsonConvert.SerializeObject(regionResult);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    //ViewBag.SelCheckMethodInfo = GetData.Instance.GetSelStrDistinct("CheckMethod", "CheckMethod", "CheckProjectType", "IsLock=0", UserSessionInfo.DBConn);
		    ViewBag.SelCheckMethodInfo = GetData.Instance.GetSelStrDistinct("CheckMethodId", "CheckMethodName", "CheckMethod", "IsLock='N'", UserSessionInfo.DBConn);
			ViewBag.SelCheckProjectTypeInfo = GetData.Instance.GetSelStr("CheckProjectTypeID", "Name", "CheckProjectType", "IsLock=0", UserSessionInfo.DBConn);
		    //ViewBag.SelLittleKindInfo = GetData.Instance.GetSelStr("LittleKindID", "Name", "LittleKind", "IsLock=0 ORDER by Name", UserSessionInfo.DBConn);
		    ViewBag.SelLittleKindInfo = GetData.Instance.GetSelStr("VarietyCategoryNo", "VarietyCategoryName", "VarietyCategory", "IsLock='N' AND Depth=1 ORDER by VarietyCategoryNo", UserSessionInfo.DBConn);
			ViewBag.SelSampleNameInfo = GetData.Instance.GetSelStr("SpecialsID", "Name", "Specials", "IsLock=0 ORDER by Name,SortNumber", UserSessionInfo.DBConn);
		    ViewBag.SelCorpKindInfo = GetData.Instance.GetSelStr("Names", "Names", "CorporationType", UserSessionInfo.DBConn);
		    ViewBag.SelHabitatInfo = GetData.Instance.GetSelStr(Habitat_info.cHabitatID, Habitat_info.cNames, Tn.Habitat, "type = 1 AND islock = 0 ", UserSessionInfo.DBConn);

			return View();
	    }

		#endregion

		#region 消费维权及信用管理

		/// <summary>
		///  市场违规行为记录页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketViolationsList()
		{
			ViewBag.SelLogTypeInfo = GetData.Instance.GetSelStr(MarketViolations_info.cLogType, Tn.MarketViolations,
				UserSessionInfo.DBConn);
			ViewBag.SelResultInfo = GetData.Instance.GetSelStr(MarketViolations_info.cResult, Tn.MarketViolations,
				UserSessionInfo.DBConn);

			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 市场违规行为记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult MarketViolationsOper()
	    {
		    #region Request + new MarketViolations_info + new Sys_AttachFiles

		    string type = Request["Type"] ?? "",
			    violationsNo = GetRequest("ViolationsNo"),
			    logType = GetRequest("LogType"),
			    result = GetRequest("Result"),
			    marketId = GetRequest("MarketID"),
			    logContent = GetRequest("LogContent"),
			    checher = GetRequest("Checher"),
			    logDate = GetRequest("LogDate"),
			    fileTitle = GetRequest("FileTitle");
		    
		    //HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
		    MarketViolations_info marketViolationsInfo = new MarketViolations_info(violationsNo, UserSessionInfo.DBConn)
		    {
			    MarketID = marketId,
			    LogType = logType,
			    LogContent = logContent,
			    Checher = checher,
			    Result = result,
			    LogDate = logDate,
			    TimeLastMod = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID,
			    IsRead = "N"
		    };

		    Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.MarketViolations, MarketViolations_info.cViolationsNo, violationsNo,
			    UserSessionInfo.DBConn)
		    {
			    TableId = Tn.MarketViolations,
			    ColumnId = MarketViolations_info.cViolationsNo,
			    SourceKey = violationsNo,
			    FileTitle = fileTitle,
			    TimeLastMod = DateTime.Now.ToShortDateString(),
			    //Description = description,
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID
		    };

		    #endregion

		    string lcSql = "", msg = "";

		    switch (type)
		    {
			    case "Add":
				    try
				    {
					    marketViolationsInfo.TimeCreated = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
					    marketViolationsInfo.ViolationsNo = RandomUtil.GetGUID();
						lcSql = marketViolationsInfo.InsertSql();
					    lcSql += " SELECT @@IDENTITY AS ident ";
					    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
					    string identity = loQuery.GetString("ident");
					    loAttacthFile.SourceKey = identity;
					    loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
					    if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
				    }
				    catch
				    {
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
				    }
			    case "Edit":
				    if (!string.IsNullOrEmpty(violationsNo))
				    {
					    //marketViolationsInfo.ViolationsNo = violationsNo;
					    lcSql = marketViolationsInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(violationsNo))
					    lcSql = "DELETE " + Tn.MarketViolations + " WHERE ViolationsNo='" + violationsNo + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
		    {
			    if (string.IsNullOrEmpty(loAttacthFile.AttachID))
			    {
				    if (type == "Edit")
					    type = "Add";
				    if (type == "Del")
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    }
			    if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
				    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
		    }

		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
		/// 市场违规行为查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketViolationsQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelResultInfo = GetData.Instance.GetSelStr(MarketViolations_info.cResult, Tn.MarketViolations,
			    UserSessionInfo.DBConn);
			ViewBag.SelLogTypeInfo = GetData.Instance.GetSelStr(MarketViolations_info.cLogType, Tn.MarketViolations,
				UserSessionInfo.DBConn);
			return View();
	    }

		/// <summary>
		///  经营户违规行为记录页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketSellerViolationsList()
	    {
		    ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelViolationTypeInfo = GetData.Instance.GetSelStr(SellerViolationType_info.cViolationTypeID,
			    SellerViolationType_info.cName, Tn.SellerViolationType,"IsLock=0", UserSessionInfo.DBConn);
		    ViewBag.SelSellerRewardTypeInfo = GetData.Instance.GetSelStr(SellerRewardType_info.cSellerRewardTypeID,
			    SellerRewardType_info.cName, Tn.SellerRewardType, "IsLock=0", UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 经营户违规行为记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
		public ActionResult MarketSellerViolationsOper()
		{
			#region Request + new SellerViolations_info + new Sys_AttachFiles

			string type = Request["Type"] ?? "",
				id = GetRequest("ID"),
				violationTypeId = GetRequest("ViolationTypeID"),
				sellerRewardTypeId = GetRequest("SellerRewardTypeID"),
				marketId = GetRequest("MarketID"),
				logContent = GetRequest("LogContent"),
				logDate = GetRequest("LogDate"),
				sellerId = GetRequest("MarketSellerID"),
				fileTitle = GetRequest("FileTitle");

			//HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
			SellerViolations_info sellerViolationsInfo = new SellerViolations_info(id, UserSessionInfo.DBConn)
			{
				MarketID = marketId,
				ViolationTypeID = violationTypeId,
				LogContent = logContent,
				SellerRewardTypeID = sellerRewardTypeId,
				SellerID=sellerId,
				LogDate = logDate,
				UpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
				UserID = UserSessionInfo.UserInfo.UserID,
			};

			Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.SellerViolations, SellerViolations_info.cID, id,
				UserSessionInfo.DBConn)
			{
				TableId = Tn.SellerViolations,
				ColumnId = SellerViolations_info.cID,
				SourceKey = id,
				FileTitle = fileTitle,
				TimeLastMod = DateTime.Now.ToShortDateString(),
				//Description = description,
				UserIDLastMod = UserSessionInfo.UserInfo.UserID
			};

			#endregion

			string lcSql = "", msg = "";

			switch (type)
			{
				case "Add":
					try
					{
						lcSql = sellerViolationsInfo.InsertSql();
						lcSql += " SELECT @@IDENTITY AS ident ";
						rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
						string identity = loQuery.GetString("ident");
						loAttacthFile.SourceKey = identity;
						loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
						if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
							return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
					}
					catch
					{
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
					}
				case "Edit":
					if (!string.IsNullOrEmpty(id))
					{
						sellerViolationsInfo.ID = id;
						lcSql = sellerViolationsInfo.UpdateSql();
					}
					break;
				case "Del":
					if (!string.IsNullOrEmpty(id))
						lcSql = "DELETE " + Tn.SellerViolations + " WHERE ID='" + id + "'";
					break;
			}
			if (string.IsNullOrEmpty(lcSql))
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
			if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
			{
				if (string.IsNullOrEmpty(loAttacthFile.AttachID))
				{
					if (type == "Edit")
						type = "Add";
					if (type == "Del")
						return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
				}
				if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
					return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
			}

			return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
		}
		
		/// <summary>
		/// 经营户违规行为查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult MarketSellerViolationsQry()
	    {
			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
			ViewBag.SelViolationTypeInfo = GetData.Instance.GetSelStr(SellerViolationType_info.cViolationTypeID,
			    SellerViolationType_info.cName, Tn.SellerViolationType, UserSessionInfo.DBConn);
		    ViewBag.SelSellerRewardTypeInfo = GetData.Instance.GetSelStr(SellerRewardType_info.cSellerRewardTypeID,
			    SellerRewardType_info.cName, Tn.SellerRewardType, UserSessionInfo.DBConn);
			ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets,
			    UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
			return View();
	    }

		/// <summary>
		///  投诉信息违规行为记录页面
		/// </summary>
		/// <returns></returns>
		public ActionResult ConsumerComplainList()
	    {
		    ViewBag.SelStallInfo= GetData.Instance.GetSelStr(Stalls_info.cStallID, Stalls_info.cName, Tn.Stalls,  UserSessionInfo.MarketDataSql(false), UserSessionInfo.DBConn);

			ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    return View();
	    }
		/// <summary>
		/// 投诉信息违规行为记录操作
		/// </summary>
		/// <returns></returns>
		[HttpPost]
	    public ActionResult ConsumerComplainOper()
	    {
		    #region Request + new ConsumerComplain_info + new Sys_AttachFiles

		    string type = Request["Type"] ?? "",
			    id = GetRequest("ID"),
			    stallId = GetRequest("StallID"),
			    consumer = GetRequest("Consumer"),
			    marketId = GetRequest("MarketID"),
			    sellerId = GetRequest("MarketSellerID"),
			    content = GetRequest("Content"),
			    logDate = GetRequest("LogDate"),
			    updateTime = GetRequest("UpdateTime"),
			    executor = GetRequest("Executor"),
			    result = GetRequest("Result"),
			    fileTitle = GetRequest("FileTitle");

			
		    if (string.IsNullOrEmpty(marketId))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Auth_Error"));
		    //HttpFileCollection attachFile = System.Web.HttpContext.Current.Request.Files;
		    ConsumerComplain_info consumerComplainInfo = new ConsumerComplain_info(id, UserSessionInfo.DBConn)
		    {
			    MarketID = marketId,
			    StallID=stallId,
				Consumer=consumer,
				Content=content,
			    SellerID = sellerId,
			    Result = result,
			    Executor = executor,
			    LogDate = logDate,
			    UpdateTime = updateTime,// DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
			    UserID = UserSessionInfo.UserInfo.UserID
		    };

		    Sys_AttachFiles_info loAttacthFile = new Sys_AttachFiles_info(Tn.ConsumerComplain, ConsumerComplain_info.cID, id,
			    UserSessionInfo.DBConn)
		    {
			    TableId = Tn.ConsumerComplain,
			    ColumnId = ConsumerComplain_info.cID,
			    SourceKey = id,
			    FileTitle = fileTitle,
			    TimeLastMod = DateTime.Now.ToShortDateString(),
			    //Description = description,
			    UserIDLastMod = UserSessionInfo.UserInfo.UserID
		    };

		    #endregion

		    string lcSql = "", msg = "";

		    switch (type)
		    {
			    case "Add":
				    try
				    {
					    lcSql = consumerComplainInfo.InsertSql();
					    lcSql += " SELECT @@IDENTITY AS ident ";
					    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
					    string identity = loQuery.GetString("ident");
					    loAttacthFile.SourceKey = identity;
					    loAttacthFile.TimeCreated = DateTime.Now.ToShortDateString();
					    if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
						    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
				    }
				    catch
				    {
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DbError"));
				    }
			    case "Edit":
				    if (!string.IsNullOrEmpty(id))
				    {
					    consumerComplainInfo.ID = id;
					    lcSql = consumerComplainInfo.UpdateSql();
				    }
				    break;
			    case "Del":
				    if (!string.IsNullOrEmpty(id))
					    lcSql = "DELETE " + Tn.ConsumerComplain + " WHERE ID='" + id + "'";
				    break;
		    }
		    if (string.IsNullOrEmpty(lcSql))
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
		    if (type != "Add" && UserSessionInfo.DBConn.ExcuteSqlTran(lcSql))
		    {
			    if (string.IsNullOrEmpty(loAttacthFile.AttachID))
			    {
				    if (type == "Edit")
					    type = "Add";
				    if (type == "Del")
					    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    }
			    if (GetData.Instance.AttachFileUpdate(type, loAttacthFile, UserSessionInfo, ref msg))
				    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
			    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_AttachError"));
		    }

		    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
	    }
		/// <summary>
		///投诉信息违规行为查询页面
		/// </summary>
		/// <returns></returns>
		public ActionResult ConsumerComplainQry()
	    {
		    ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelMarketSellersInfo = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, MarketSellers_info.cIsLock + "='N' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
		    ViewBag.SelRegionInfo = GetData.Instance.GetRegionSelStr(Regions_info.cRegionID, Regions_info.cNames, Tn.Regions, UserSessionInfo.DBConn);

		    return View();
	    }
		#endregion

	    /// <summary>
	    /// 获取Requset[key]值，并ToSQL处理
	    /// </summary>
	    /// <param name="key"></param>
	    /// <param name="type"></param>
	    /// <returns></returns>
	    private string GetRequest(string key, string type = "string")
	    {
		    string lcRetval = Request[key];
		    if (type.ToLower() == "int")
			    lcRetval = GetData.Instance.SetIntDefault(lcRetval);
		    return Utils.AreaToSQLcs(lcRetval);
	    }
	}
}