using SysBaseLibs;
using SysDataLibs;
using SysDataLibs.TableClass;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Mvc;

namespace GSMarketSys.Controllers
{
    public class TaizhangController : BaseController
    {
        #region TZQNameBrands  品牌管理台账 
        // GET: Taizhang
        [CheckPowerFilter]
        public ActionResult TZQNameBrands()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
            ViewBag.SelTradeType = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName, Tn.TradeType, " "+TradeType_info.cIsLock+"='N'", UserSessionInfo.DBConn);
            return View();
           
        }
        public ActionResult TZPNameBrands()
        {
            string MarketID = Request["MarketID"];
            string TradeTypeID = Request["TradeTypeID"];
            string BrandName = Utils.AreaToSQLcs(Request["BrandName"]).Trim();
            string lcSql = "";
            lcSql = "SELECT * FROM " + Tn.NameBrands + " WHERE " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(MarketID))
            {
                lcSql += " AND " + NameBrands_info.cMarketId + "='" + MarketID + "' ";
            }
            if (!string.IsNullOrEmpty(BrandName)) // 模糊查询
            {
                lcSql += " AND  " + NameBrands_info.cNameBrandName + " LIKE '%" + BrandName + "%' ";
            }
            // 经营类别
            if (!string.IsNullOrEmpty(TradeTypeID))
            {
                lcSql += " AND " + NameBrands_info.cTradeTypeID + "=" + TradeTypeID + " ";
            }
            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint)?"block":"none";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();

                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(NameBrands_info.cNameBrandName) );
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(NameBrands_info.cNBByPerson));
                    sb.Append("</td>");
                 
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(NameBrands_info.cyjzhizhao));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(NameBrands_info.cweishengxuke));
                    sb.Append("</td>");

                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region TZQMajorGoodsLog  重要商品溯源台账 
        [CheckPowerFilter]
        public ActionResult TZQMajorGoodsLog()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);
           
            ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers, 
                " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N'  ", UserSessionInfo.DBConn);
           
            ViewBag.MajorGoodsTypeID = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType, 
                " IsLock='N' AND SystemID='Farmer' AND " + UserSessionInfo.GSSystemDataSql(false), UserSessionInfo.DBConn);
         
            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPMajorGoodsLog()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string MajorGoodsTypeID = Utils.AreaToSQLcs(Request["MajorGoodsTypeID"]).Trim();
            string SellerID = Utils.AreaToSQLcs(Request["SellerID"]).Trim();
            string lcSql = "";
            lcSql = " SELECT " + ViewMajorGoods_info.cMarketName + "," + ViewMajorGoods_info.cStockTime + "," + ViewMajorGoods_info.cSupplierName + "," + ViewMajorGoods_info.cSellerName;
            lcSql += "," + ViewMajorGoods_info.cStallName + "," + ViewMajorGoods_info.cTotalCount + "," + ViewMajorGoods_info.cUnitID + "," + ViewMajorGoods_info.cQuarantineUnit + ","+MajorGoodsType_info.cMajorGoodsName;
            lcSql += " FROM " + Tn.ViewMajorGoods + "," + Tn.MajorGoodsType;
            lcSql += " WHERE " + Tn.ViewMajorGoods + "." + ViewMajorGoods_info.cMajorGoodsTypeID + "=" + Tn.MajorGoodsType + "." + MajorGoodsType_info.cMajorGoodsTypeID;
            lcSql += " AND " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(SellerID))
            {
                lcSql += " and " + ViewMajorGoods_info.cSellerID + "=" + SellerID + " ";
            }
            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and " + ViewMajorGoods_info.cStockTime + ">='" + SearchStartTime + "' and " +
                        ViewMajorGoods_info.cStockTime + "<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and " + ViewMajorGoods_info.cStockTime + "='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and " + ViewMajorGoods_info.cMarketID + "='" + MarketID + "' ";

           
            if (!string.IsNullOrEmpty(MajorGoodsTypeID))
            {
                lcSql += " AND " + Tn.ViewMajorGoods + "." + MajorGoodsLog_info.cMajorGoodsTypeID + "=" + MajorGoodsTypeID;
            }
            else
            {
                lcSql += " AND " + Tn.ViewMajorGoods + "." + MajorGoodsLog_info.cMajorGoodsTypeID + " IN ";
                lcSql += " (SELECT " + MajorGoodsType_info.cMajorGoodsTypeID + " FROM " + Tn.MajorGoodsType;
                lcSql += " WHERE " + MajorGoodsType_info.cIsLock + "='N' AND " + UserSessionInfo.GSSystemDataSql(false) + ") ";
            }

            lcSql += " Order by " + ViewMajorGoods_info.cStockTime + " desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            Decimal ldNumCount = 0;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString(ViewMajorGoods_info.cMarketName);
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime(ViewMajorGoods_info.cStockTime).ToShortDateString());
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(MajorGoodsType_info.cMajorGoodsName));
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(ViewMajorGoods_info.cSupplierName));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(ViewMajorGoods_info.cSellerName));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(ViewMajorGoods_info.cStallName));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(ViewMajorGoods_info.cTotalCount) + "" + loQuery.GetString(ViewMajorGoods_info.cUnitID));
                    sb.Append("</td>");

                    ldNumCount += loQuery.GetDecimal(ViewMajorGoods_info.cTotalCount);

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString(ViewMajorGoods_info.cQuarantineUnit));
                    sb.Append("</td>");

                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            sb.Append("<tr>");
            sb.Append("<td align='right' ColSpan='2'>");
            sb.Append("合计：");
            sb.Append("</td>");

            sb.Append("<td  ColSpan='5'>");
            sb.Append(ldNumCount + "  ");
            sb.Append("</td>");

            sb.Append("</tr>");
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region TZQGoodsRecallLog  不合格商品退市、召回情况台账 
        [CheckPowerFilter]
        public ActionResult TZQGoodsRecallLog()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
                " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N'  ", UserSessionInfo.DBConn);

            ViewBag.MajorGoodsTypeID = GetData.Instance.GetSelStr(MajorGoodsType_info.cMajorGoodsTypeID, MajorGoodsType_info.cMajorGoodsName, Tn.MajorGoodsType,
                " IsLock='N' AND SystemID='Farmer' AND " + UserSessionInfo.GSSystemDataSql(false), UserSessionInfo.DBConn);

            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPGoodsRecallLog()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string GoodsName = Utils.AreaToSQLcs(Request["GoodsName"]).Trim();
            string SellerID = Utils.AreaToSQLcs(Request["SellerID"]).Trim();

            string lcSql = "";
            lcSql = " select * from  viewGoodsRecall  where " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(GoodsName))
            {
                lcSql += " and  GoodsName='" + GoodsName + "'";
            }
            if (!string.IsNullOrEmpty(SellerID))
            {
                lcSql += " and  SellerID='" + SellerID + "'";
            }
            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and  SaleTime>='" + SearchStartTime + "' and SaleTime<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and  SaleTime='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and MarketID= '" + MarketID + "' ";

            lcSql += " Order by SaleTime desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            Decimal ldNumCount = 0;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("Names");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append((i + 1) + "");
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SellerName"));
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("StallName"));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("GoodsName"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Supplier"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("TradeMark"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("ProduceBatch"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SaleCount") + " " + loQuery.GetString("UnitID"));
                    sb.Append("</td>");

                    ldNumCount += loQuery.GetDecimal("SaleCount");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime("SaleTime").ToShortDateString());
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("RecallReason"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Result"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Executor"));
                    sb.Append("</td>");

                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            sb.Append("<tr>");
            sb.Append("<td align='right' ColSpan='3'>");
            sb.Append("不合格商品数量合计：");
            sb.Append("</td>");

            sb.Append("<td  ColSpan='9'>");
            sb.Append(ldNumCount + " 公斤 ");
            sb.Append("</td>");

            sb.Append("</tr>");
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region TZQCheckData  农贸市场检测情况台账  
        [CheckPowerFilter]
        public ActionResult TZQCheckData()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            if (!UserSessionInfo.IsMarketSysAccount)
            {
                ViewBag.SelCheckUnit = GetData.Instance.GetSelStrDistinct("ShortNames", "Names", "Farms", " IsLock=0 and IsSystem=1 AND SeriesType='1' ", UserSessionInfo.DBConn);
                //cbCheckUnit.FillDDL(" select distinct ShortNames,Names from Farms where IsLock=0 and IsSystem=1 AND SeriesType='1' ", Farms_info.cShortNames, Farms_info.cNames, _Session.DBConn, true, "", "全部");
            }
            else
            {
                ViewBag.SelCheckUnit = GetData.Instance.GetSelStrDistinct("ShortNames", "Names", "Farms", " IsLock=0 and IsSystem=1 ", UserSessionInfo.DBConn);
                //cbCheckUnit.FillDDL(" select distinct ShortNames,Names from Farms where IsLock=0 and IsSystem=1 ", Farms_info.cShortNames, Farms_info.cNames, _Session.DBConn, true, "", "全部");
            }
           
            ViewBag.SelCheckMethod = GetData.Instance.GetSelStrDistinct(CheckProjectType_info.cCheckMethod, CheckProjectType_info.cCheckMethod, Tn.CheckProjectType,
                " "+ CheckProjectType_info.cIsLock + "=0 ", UserSessionInfo.DBConn);

            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPCheckData()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string GoodsName = Utils.AreaToSQLcs(Request["GoodsName"]).Trim();
            string CheckMethod = Utils.AreaToSQLcs(Request["CheckMethod"]).Trim();
            string CheckUnit = Utils.AreaToSQLcs(Request["CheckUnit"]).Trim();

            string lcSql = "";
            lcSql = " SELECT * FROM " + Tn.vwCheckData + " WHERE " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(GoodsName))
            {
                lcSql += " and  " + vwCheckData_info.cSampleName + "='"+ GoodsName + "'";
            }
            if (!string.IsNullOrEmpty(CheckMethod))
            {
                lcSql += " and  CheckMethod='" + CheckMethod + "'";
            }
            if (!string.IsNullOrEmpty(CheckUnit))
            {
                lcSql += " and  CheckUnit='" + CheckUnit + "'";
            }
            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and  CheckTime>='" + SearchStartTime + "' and CheckTime<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and  CheckTime='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and " + vwCheckData_info.cMarketID + "= '" + MarketID + "' ";

            lcSql += " Order by " + vwCheckData_info.cUploadTime + " desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            int liNoHege = 0;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("Names");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    // 日期
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime("CheckTime").ToShortDateString());
                    sb.Append("</td>");

                    // 经销单位
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("CorpName"));
                    sb.Append("</td>");

                    // 摊位号
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    // 商品名称
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SampleName"));
                    sb.Append("</td>");

                    //检测内容
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Name") + "/" + loQuery.GetString("CheckMethod"));
                    sb.Append("</td>");
                    //批次
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //合格
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("CheckResult") == "合格" ? "是" : "");
                    sb.Append("</td>");
                    //不合格
                    sb.Append("<td align='center'>");
                    sb.Append((loQuery.GetString("CheckResult") == "合格") ? "" : "是");
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("CheckResult") == "合格" ? "" : loQuery.GetString("CheckTotal"));
                    sb.Append("</td>");

                    if (loQuery.GetString("CheckResult") == "不合格")
                    {
                        liNoHege += loQuery.GetInt("CheckTotal");
                    }

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("CheckUser"));
                    sb.Append("</td>");

                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Memo"));
                    sb.Append("</td>");

                   
                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            sb.Append("<tr>");
            sb.Append("<td align='right' ColSpan='2'>");
            sb.Append("合计：");
            sb.Append("</td>");

            sb.Append("<td  ColSpan='3'>");
            sb.Append("");
            sb.Append("</td>");

            sb.Append("<td>");
            sb.Append("");
            sb.Append("</td>");

            sb.Append("<td  ColSpan='2'>");
            sb.Append("");
            sb.Append("</td>");

            sb.Append("<td>");
            sb.Append(liNoHege + "");
            sb.Append("</td>");

            sb.Append("<td ColSpan='2'>");
            sb.Append(liNoHege + "");
            sb.Append("</td>");

            sb.Append("</tr>");
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region TZQConsumerComplain  消费者投诉台账   
        [CheckPowerFilter]
        public ActionResult TZQConsumerComplain()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
                " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName , UserSessionInfo.DBConn);

          

            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPConsumerComplain()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string SellerID = Utils.AreaToSQLcs(Request["SellerID"]).Trim();
          
            string lcSql = "";
            lcSql = " select * from  " + Tn.viewConsumerComplain + " where " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(SellerID))
            {
                lcSql += " and  " + viewConsumerComplain_info.cSellerID + "='" + SellerID + "'";
            }
           
            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and  "+ viewConsumerComplain_info.cLogDate+">='" + SearchStartTime + "' and " + viewConsumerComplain_info.cLogDate + "<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and  " + viewConsumerComplain_info.cLogDate + "='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and " + viewConsumerComplain_info.cMarketID + "='" + MarketID + "' ";

            lcSql += " Order by " + viewConsumerComplain_info.cLogDate + " desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
           
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("Names");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime("LogDate").ToShortDateString());
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SellerName"));
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("StallName"));
                    sb.Append("</td>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Content"));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("Result"));
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
              
                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }

        #endregion

        #region TZQHJQ  活家禽进货台账  
        [CheckPowerFilter]
        public ActionResult TZQHJQ()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
                " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName, UserSessionInfo.DBConn);



            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPHJQ()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string SellerID = Utils.AreaToSQLcs(Request["SellerID"]).Trim();

            string lcSql = "";
            lcSql = " select * from " + Tn.ViewMajorGoods + " where " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(SellerID))
            {
                lcSql += " and  " + ViewMajorGoods_info.cSellerID + "='" + SellerID + "'";
            }

            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and  " + ViewMajorGoods_info.cStockTime + ">='" + SearchStartTime + "' and " + ViewMajorGoods_info.cStockTime + "<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and  " + ViewMajorGoods_info.cStockTime + "='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and " + ViewMajorGoods_info.cMarketID + "='" + MarketID + "' ";

            lcSql += " and " + ViewMajorGoods_info.cMajorGoodsTypeID + "=1 ";

            lcSql += " Order by " + ViewMajorGoods_info.cStockTime + " desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            Decimal ldNumCount = 0;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("MarketName");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime("StockTime").ToShortDateString());
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SupplierName"));
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SellerName"));
                    sb.Append("</td>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("StallName"));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("TotalCount") + "" + loQuery.GetString("UnitID"));
                    sb.Append("</td>");
                    //
                    ldNumCount += loQuery.GetDecimal("TotalCount");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("QuarantineUnit"));
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //
                  
                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            sb.Append("<tr>");
            sb.Append("<td align='right' ColSpan = 2>");
            sb.Append("合计：");
            sb.Append("</td>");

            sb.Append("<td align='right' ColSpan = 5>");
            sb.Append(ldNumCount + " 只 ");
            sb.Append("</td>");

            sb.Append("</tr>");
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region TZQZhuroujinhuo  猪肉进货台账  
        [CheckPowerFilter]
        public ActionResult TZQZhuroujinhuo()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
                " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName, UserSessionInfo.DBConn);



            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPZhuroujinhuo()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string SellerID = Utils.AreaToSQLcs(Request["SellerID"]).Trim();

            string lcSql = "";
            lcSql = " select * from " + Tn.ViewMajorGoods + " where " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(SellerID))
            {
                lcSql += " and  " + ViewMajorGoods_info.cSellerID + "='" + SellerID + "'";
            }

            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and  " + ViewMajorGoods_info.cStockTime + ">='" + SearchStartTime + "' and " + ViewMajorGoods_info.cStockTime + "<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and  " + ViewMajorGoods_info.cStockTime + "='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and " + ViewMajorGoods_info.cMarketID + "='" + MarketID + "' ";
            // 农贸市场和超市的猪肉类型合并
            lcSql += " and " + ViewMajorGoods_info.cMajorGoodsTypeID + "=2 ";

            lcSql += " Order by " + ViewMajorGoods_info.cStockTime + " desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            Decimal ldNumCount = 0;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("MarketName");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime("StockTime").ToShortDateString());
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SupplierName"));
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SellerName"));
                    sb.Append("</td>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("StallName"));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("TotalCount") + "" + loQuery.GetString("UnitID"));
                    sb.Append("</td>");
                    //
                    ldNumCount += loQuery.GetDecimal("TotalCount");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("QuarantineUnit"));
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //

                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            sb.Append("<tr>");
            sb.Append("<td align='right' ColSpan = 2>");
            sb.Append("合计：");
            sb.Append("</td>");

            sb.Append("<td align='right' ColSpan = 5>");
            sb.Append(ldNumCount + " 头 ");
            sb.Append("</td>");

            sb.Append("</tr>");
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region TZQDouzhipin  豆制品进货台账   
        [CheckPowerFilter]
        public ActionResult TZQDouzhipin()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
                " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName, UserSessionInfo.DBConn);



            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
            ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToShortDateString();
            ViewBag.EndTime = DateTime.Now.ToShortDateString();
            return View();
        }
        public ActionResult TZPDouzhipin()
        {
            string MarketID = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string SearchStartTime = Utils.AreaToSQLcs(Request["SearchStartTime"]).Trim();
            string SearchEndTime = Utils.AreaToSQLcs(Request["SearchEndTime"]).Trim();
            string SellerID = Utils.AreaToSQLcs(Request["SellerID"]).Trim();

            string lcSql = "";
            lcSql = " select * from " + Tn.ViewMajorGoods + " where " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(SellerID))
            {
                lcSql += " and  " + ViewMajorGoods_info.cSellerID + "='" + SellerID + "'";
            }

            if (!string.IsNullOrEmpty(SearchStartTime))
            {
                if (!string.IsNullOrEmpty(SearchEndTime))
                {
                    lcSql += " and  " + ViewMajorGoods_info.cStockTime + ">='" + SearchStartTime + "' and " + ViewMajorGoods_info.cStockTime + "<='" + SearchEndTime + "' ";
                }
                else
                {
                    lcSql += " and  " + ViewMajorGoods_info.cStockTime + "='" + SearchStartTime + "' ";
                }
            }

            lcSql += " and " + ViewMajorGoods_info.cMarketID + "='" + MarketID + "' ";
            // 农贸市场和超市的猪肉类型合并
            lcSql += " and " + ViewMajorGoods_info.cMajorGoodsTypeID + "=3 ";

            lcSql += " Order by " + ViewMajorGoods_info.cStockTime + " desc ";

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            Decimal ldNumCount = 0;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("MarketName");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetDateTime("StockTime").ToShortDateString());
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SupplierName"));
                    sb.Append("</td>");

                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("SellerName"));
                    sb.Append("</td>");
                    // 
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("StallName"));
                    sb.Append("</td>");

                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("TotalCount") + "" + loQuery.GetString("UnitID"));
                    sb.Append("</td>");
                    //
                    ldNumCount += loQuery.GetDecimal("TotalCount");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append(loQuery.GetString("QuarantineUnit"));
                    sb.Append("</td>");
                    //
                    sb.Append("<td align='center'>");
                    sb.Append("");
                    sb.Append("</td>");
                    //

                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }
            sb.Append("<tr>");
            sb.Append("<td align='right' ColSpan = 2>");
            sb.Append("合计：");
            sb.Append("</td>");

            sb.Append("<td align='right' ColSpan = 5>");
            sb.Append(ldNumCount + " 公斤 ");
            sb.Append("</td>");

            sb.Append("</tr>");
            //ViewBag.Hid_WhereSql = lcSql;
            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        #endregion

        #region RptQSellerEvaluation  市场经营户月度信用分类评分   
        [CheckPowerFilter]
        public ActionResult RptQSellerEvaluation()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            //ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
            //    " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName, UserSessionInfo.DBConn);

            DateTime loDate = DateTime.Now;
            string lcYears = "";
            string lcStartMonths = "";
            string lcEndMonths = "";
            for (int i = 0; i > -12; i--)
            {
                lcYears += "<option value='" + loDate.AddYears(i).Year + "'>" + loDate.AddYears(i).Year + "  年" + "</option>";
                lcStartMonths += "<option value='" + loDate.AddMonths(i-1).Month + "'>" + loDate.AddMonths(i-1).Month + "  月份" + "</option>";
                lcEndMonths += "<option value='" + loDate.AddMonths(i).Month + "'>" + loDate.AddMonths(i).Month + "  月份" + "</option>";
            }

            ViewBag.SelYears = lcYears;
            ViewBag.SelStartMonths = lcStartMonths;
            ViewBag.SelEndMonths = lcEndMonths;

            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";
          
            return View();
        }
        public ActionResult RptPSellerEvaluation()
        {
            string MarketIDs = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string Year = Utils.AreaToSQLcs(Request["Year"]).Trim();
            string StartMonth = Utils.AreaToSQLcs(Request["StartMonth"]).Trim();
            string EndMonth = Utils.AreaToSQLcs(Request["EndMonth"]).Trim();
            string SellerName = Utils.AreaToSQLcs(Request["SellerName"]).Trim();
            string RegNo = Utils.AreaToSQLcs(Request["RegNo"]).Trim();

            string lcSql = "";
            lcSql = " SELECT * FROM " + Tn.vwSellerEvalRpt + " WHERE " + UserSessionInfo.MarketDataSql(false); ;
            lcSql += " AND " + vwSellerEvalRpt_info.cYear + "=" + Year;
            lcSql += " AND " + vwSellerEvalRpt_info.cMonth + ">=" + StartMonth + " AND  " + vwSellerEvalRpt_info.cMonth + " <= " + EndMonth;
           
            if (string.IsNullOrEmpty(MarketIDs))
            {
                return null;
            }
            else
            {
                lcSql += " and " + vwSellerEvalRpt_info.cMarketID + "  IN ('" + MarketIDs.Replace(",", "','") + "' )";
            }
            if (!string.IsNullOrEmpty(SellerName))
            {
                lcSql += " and  " + vwSellerEvalRpt_info.cSellerName + " like '%" + SellerName + "%' ";
            }
            if (!string.IsNullOrEmpty(RegNo))
            {
                lcSql += " and " + vwSellerEvalRpt_info.cSellerID + " in (select " + SellerHasWarrant_info.cSellerID + " from " + Tn.SellerHasWarrant;
                lcSql += " where " + SellerHasWarrant_info.cWarrantNumber + " like '%" + RegNo + "%' ";
                lcSql += " and " + SellerHasWarrant_info.cWarrantTypeID + "=4) ";
            }

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            if ((Year != null) && (StartMonth != null) && (EndMonth != null))
            {
                ViewBag.SellerEvalTitle = Year + "年" + StartMonth + "-" + EndMonth + "月" + " 市场经营户月度信用分类情况";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                _dictEvaluation = new Dictionary<string, SellerEvaluationInfo>();

                loQuery.MoveFirst();
                ViewBag.MarketName = loQuery.GetString("MarketName");
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    int liSellerId = loQuery.GetInt(vwSellerEvalRpt_info.cSellerID);
                    string strEvalYear = loQuery.GetString(vwSellerEvalRpt_info.cYear);
                    string strEvalMonth = loQuery.GetString(vwSellerEvalRpt_info.cMonth);
                    string strKey = liSellerId.ToString() + "," + strEvalYear + "," + strEvalMonth;
                    // 同一个经营户可能有多个摊位
                    if (_dictEvaluation.ContainsKey(strKey))
                    {
                        SellerEvaluationInfo info = _dictEvaluation[strKey];
                        info.StallName += ";" + loQuery.GetString(vwSellerEvalRpt_info.cStallName);
                        _dictEvaluation[strKey] = info;
                    }
                    else
                    {
                        SellerEvaluationInfo info = new SellerEvaluationInfo();
                        info.SellerId = liSellerId;
                        info.MarketName = loQuery.GetString(vwSellerEvalRpt_info.cNames);
                        info.SellerName = loQuery.GetString(vwSellerEvalRpt_info.cSellerName);
                        info.StallName = loQuery.GetString(vwSellerEvalRpt_info.cStallName);
                        info.TotalScore = loQuery.GetInt(vwSellerEvalRpt_info.cTotalScore);
                        info.Month = strEvalMonth;
                        info.RankName = SellerEvalGrade_info.GetRankByScore(info.TotalScore);

                        _dictEvaluation.Add(strKey, info);
                    }

                    loQuery.MoveNext();
                }
            }

            int j = 0;
            foreach (SellerEvaluationInfo info in _dictEvaluation.Values)
            {
                sb.Append("<tr>");

                sb.Append("<td align='left'>");
                sb.Append((j + 1) + "");
                sb.Append("</td>");


                sb.Append("<td align='left'>");
                sb.Append(info.MarketName);
                sb.Append("</td>");

                sb.Append("<td align='left'>");
                sb.Append(info.SellerName);
                sb.Append("</td>");

                sb.Append("<td align='left'>");
                sb.Append(info.StallName);
                sb.Append("</td>");

                sb.Append("<td align='left'>");
                sb.Append(info.Month.ToString());
                sb.Append("</td>");

                sb.Append("<td align='left'>");
                sb.Append(info.TotalScore.ToString());
                sb.Append("</td>");

                sb.Append("<td align='left'>");
                sb.Append(info.RankName);
                sb.Append("</td>");
               

                j++;
                sb.Append("</tr>");
            }

            ViewBag.TableMsg = sb.ToString();
            return View();
        }
        // 用于处理同一个经营户有多个摊位的情况
        protected Dictionary<string, SellerEvaluationInfo> _dictEvaluation = null;
        protected class SellerEvaluationInfo
        {
            public int SellerId;
            public string MarketName;
            public string SellerName;
            public string StallName;
            public string Month;
            public int TotalScore;
            public string RankName;
        }
        #endregion
        #region RptQSellerEvaluation  市场经营户月度信用分类评分   
        [CheckPowerFilter]
        public ActionResult RptQMarketEvaluation()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            //ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
            //    " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName, UserSessionInfo.DBConn);

            DateTime loDate = DateTime.Now;
            string lcYears = "";
            string lcStartMonths = "";
            string lcEndMonths = "";
            for (int i = 0; i > -12; i--)
            {
                lcYears += "<option value='" + loDate.AddYears(i).Year + "'>" + loDate.AddYears(i).Year + "  年" + "</option>";
                lcStartMonths += "<option value='" + loDate.AddMonths(i - 1).Month + "'>" + loDate.AddMonths(i - 1).Month + "  月份" + "</option>";
                lcEndMonths += "<option value='" + loDate.AddMonths(i).Month + "'>" + loDate.AddMonths(i).Month + "  月份" + "</option>";
            }

            ViewBag.SelYears = lcYears;
            ViewBag.SelStartMonths = lcStartMonths;
            ViewBag.SelEndMonths = lcEndMonths;

            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";

            return View();
        }
        public ActionResult RptPMarketEvaluation()
        {
            string MarketIDs = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string Year = Utils.AreaToSQLcs(Request["Year"]).Trim();
            string StartMonth = Utils.AreaToSQLcs(Request["StartMonth"]).Trim();
            string EndMonth = Utils.AreaToSQLcs(Request["EndMonth"]).Trim();
          

            
            string lcSql = " SELECT * FROM " + Tn.vwMarketEvalRpt + " WHERE " + UserSessionInfo.MarketDataSql(false);
            lcSql += " AND " + vwMarketEvalRpt_info.cYear + "=" + Year;
            lcSql += " AND " + vwMarketEvalRpt_info.cMonth + ">=" + StartMonth + " AND " + vwMarketEvalRpt_info.cMonth + "<=" + EndMonth;

            if (string.IsNullOrEmpty(MarketIDs))
            {
                return null;
            }
            else
            {
                lcSql += " and " + vwMarketEvalRpt_info.cMarketId + "  IN ('" + MarketIDs.Replace(",", "','") + "' )";
            }
           

            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
            if ((Year != null) && (StartMonth != null) && (EndMonth != null))
            {
                ViewBag.SellerEvalTitle = Year + "年" + StartMonth + "-" + EndMonth + "月" + " 市场经营户月度信用分类情况";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");

                    sb.Append("<td align='left'>");
                    sb.Append((i + 1) + "");
                    sb.Append("</td>");


                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString(vwMarketEvalRpt_info.cMarketName));
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString(vwMarketEvalRpt_info.cMarketTypeName));
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString(vwMarketEvalRpt_info.cRegionName));
                    sb.Append("</td>");

                    string lcYear = loQuery.GetString(vwMarketEvalRpt_info.cYear);
                    string lcMonth = loQuery.GetString(vwMarketEvalRpt_info.cMonth);
                    sb.Append("<td align='left'>");
                    sb.Append(lcYear + "年" + lcMonth + "月");
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    int liScore = loQuery.GetInt(vwMarketEvalRpt_info.cTotalScore);
                    sb.Append(liScore.ToString());
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    sb.Append(MarketEvalGrade_info.GetRankByScore(liScore));
                    sb.Append("</td>");
                    
                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }

            ViewBag.TableMsg = sb.ToString();
            return View();
        }

        #endregion

        #region RptQSellerEvaluation   市场经营户基本情况台帐    
        [CheckPowerFilter]
        public ActionResult TZQMarketSellers()
        {
            ViewBag.SelMarketInfo = GetData.Instance.GetSelStr(Markets_info.cMarketID, Markets_info.cNames, Tn.Markets, Markets_info.cIsLock + "='0' " + UserSessionInfo.MarketDataSql(true), UserSessionInfo.DBConn);

            //ViewBag.SelMarketSeller = GetData.Instance.GetSelStr(MarketSellers_info.cSellerID, MarketSellers_info.cName, Tn.MarketSellers,
            //    " " + UserSessionInfo.MarketDataSql(false) + " and IsLock='N' order by " + MarketSellers_info.cName, UserSessionInfo.DBConn);
            
            ViewBag.SelTradeType = GetData.Instance.GetSelStr(TradeType_info.cTradeTypeID, TradeType_info.cName, Tn.TradeType," 1=1 order by " + TradeType_info.cName, UserSessionInfo.DBConn);

            ViewBag.IsMarketSysAccount = UserSessionInfo.IsMarketSysAccount ? "0" : "1";

            return View();
        }

        // 查询经营户的工商注册号
        protected string QuerySellerRegNo(int nSellerID)
        {
            string strRet = "";

            try
            {
                string lcSql = "select " + SellerHasWarrant_info.cWarrantNumber + " from " + Tn.SellerHasWarrant +
                    " where " + SellerHasWarrant_info.cSellerID + "=" + nSellerID +
                    " and " + SellerHasWarrant_info.cWarrantTypeID + "=4";

                rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened & loQuery.RecCount > 0)
                {
                    strRet = loQuery.GetString(SellerHasWarrant_info.cWarrantNumber);
                }
            }
            catch (Exception)
            {
            }

            return strRet;
        }
        public ActionResult TZPMarketSellers()
        {
            string MarketIDs = Utils.AreaToSQLcs(Request["MarketID"]).Trim();
            string TradeTypeID = Utils.AreaToSQLcs(Request["TradeTypeID"]).Trim();
            string lcSql = "";
            lcSql = " select * from  ViewMarketSellers_New  where " + UserSessionInfo.MarketDataSql(false);
            if (!string.IsNullOrEmpty(TradeTypeID))
            {
                lcSql += " and  TradeTypeID='" + TradeTypeID + "'";
            }

            lcSql += " and MarketID= '" + MarketIDs + "' ";
            lcSql += " Order by MarketSellerName desc ";


            ViewBag.PrintVisible = UserSessionInfo.CheckPowerNotRe(PowerType.IsPrint) ? "block" : "none";
          
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            StringBuilder sb = new StringBuilder();
            if (loQuery != null && loQuery.IsOpened)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    sb.Append("<tr>");

                    sb.Append("<td align='left'>");
                    sb.Append((i + 1) + "");
                    sb.Append("</td>");


                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString("MarketSellerName"));
                    sb.Append("</td>");
                    // 注册号
                    int nSellerID = loQuery.GetInt(ViewMarketSellers_info.cSellerID);
                    sb.Append("<td align='left'>");
                    sb.Append(QuerySellerRegNo(nSellerID));
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString("Facia"));
                    sb.Append("</td>");

                  
                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString("StallName"));
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString("TradeTypeName"));
                    sb.Append("</td>");

                    int liCount = 1;
                    if (loQuery.GetString("Staff1Name").Trim().Length > 0)
                    {
                        liCount++;
                    }
                    if (loQuery.GetString("Staff2Name").Trim().Length > 0)
                    {
                        liCount++;
                    }
                    if (loQuery.GetString("Staff3Name").Trim().Length > 0)
                    {
                        liCount++;
                    }
                    sb.Append("<td align='left'>");
                    sb.Append(liCount + "");
                    sb.Append("</td>");

                    sb.Append("<td align='left'>");
                    sb.Append(loQuery.GetString("Tel"));
                    sb.Append("</td>");

                    sb.Append("</tr>");
                    loQuery.MoveNext();
                }
            }

            ViewBag.TableMsg = sb.ToString();
            return View();
        }

        #endregion
    }

}