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

using SysBaseLibs;
using SysDataLibs.TableClass;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Mvc;
using Newtonsoft.Json;

namespace GSMarketSys.Controllers
{
    public class BaseInfoController : BaseController
    {
        #region StandardList
        // GET: BaseInfo
        [CheckPowerFilter]
        public ActionResult StandardList()
        {
            return View();
        }
        public ActionResult GetStandList()
        {
            string lcIsLock = Request["IsLock"];
           
            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from Standard where IsLock='"+ lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult StandListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string StandardID = Request["StandardID"];
            Standard_info lTbl = Type == "Add" ?  new Standard_info(): new Standard_info(StandardID, UserSessionInfo.DBConn) ;

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del"?"1":"0" ;
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string StandardNames = Utils.AreaToSQLcs(Request["Names"]).Trim();
            string StandardRegularValue = Utils.AreaToSQLcs(Request["RegularValue"]).Trim();
            string OvertopValue = Utils.AreaToSQLcs(Request["OvertopValue"]).Trim();
            string IsUser = Request["IsUse"];
            lTbl.IsUse = IsUser;
            lTbl.OvertopValue = OvertopValue;
            lTbl.RegularValue = StandardRegularValue;
            lTbl.Names = StandardNames;
            lTbl.IsLock = "0";
            string lcSql = "";
            if(Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region TradType
        // GET: TradType
        [CheckPowerFilter]
        public ActionResult TradeType()
        {
            return View();
        }

        public ActionResult GetTradeTypeList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "N";
            }
            string lcSql = " select * from TradeType where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult TradeTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string TradeTypeID = Request["TradeTypeID"];
            TradeType_info lTbl = Type == "Add" ? new TradeType_info() : new TradeType_info(TradeTypeID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string Name = Utils.AreaToSQLcs(Request["Name"]).Trim();
          
            lTbl.Name = Name;

            lTbl.IsLock = "N";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region MajorGoodsType
        // GET: MajorGoodsType
        [CheckPowerFilter]
        public ActionResult MajorGoodsType()
        {
            ViewBag.SelSystemID = GetData.Instance.GetSelStr(GSSystem_info.cSystemID, GSSystem_info.cSystemName, Tn.GSSystem, " IsLock = 'N' ", UserSessionInfo.DBConn);
            return View();
        }
        public ActionResult GetMajorGoodsTypeList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "N";
            }
            string lcSql = " select * from MajorGoodsType where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult MajorGoodsTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string MajorGoodsTypeID = Request["MajorGoodsTypeID"];
            MajorGoodsType_info lTbl = Type == "Add" ? new MajorGoodsType_info() : new MajorGoodsType_info(MajorGoodsTypeID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval =SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"); 
                }
                return Content(lcRetval);
            }
            string MajorGoodsName = Utils.AreaToSqlTran(Request["MajorGoodsName"]).Trim();
            string SystemID = Utils.AreaToSQLcs(Request["SystemID"]).Trim();
            string Description = Utils.AreaToSqlTran(Request["Description"]).Trim();
            lTbl.Description = Description;
            lTbl.SystemID = SystemID;
            lTbl.MajorGoodsName = MajorGoodsName;
            lTbl.IsLock = "N";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region MajorSpecials
        // GET: MajorSpecials
        [CheckPowerFilter]
        public ActionResult MajorSpecials()
        {
            return View();
        }
        public ActionResult GetMajorSpecialsList()
        {
            string lcIsLock = Request["IsLock"];
            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "N";
            }
            string lcSql = " select * from MajorSpecials where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult MajorSpecialsListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string MajorSpecialID = Utils.AreaToSQLcs(Request["MajorSpecialID"]).Trim();
            MajorSpecials_info lTbl = Type == "Add" ? new MajorSpecials_info() : new MajorSpecials_info(MajorSpecialID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string MajorSpecialName = Utils.AreaToSQLcs(Request["MajorSpecialName"]).Trim();
            string Toname = Utils.AreaToSQLcs(Request["Toname"]).Trim();
            string SortNumber = Utils.AreaToSQLcs(Request["SortNumber"]).Trim();
            lTbl.SortNumber = SortNumber;
            lTbl.Toname = Toname;
            lTbl.MajorSpecialName = MajorSpecialName;
            lTbl.MajorSpecialID = MajorSpecialID;
            lTbl.IsLock = "N";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region GSSystem
        //GET: GSSystem
        [CheckPowerFilter]
        public ActionResult GSSystem()
        {
            return View();
        }
        public ActionResult GetGSSystemList()
        {
            string lcIsLock = Request["IsLock"];
            if(string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "N";
            }
            string lcSql = " select * from GSSystem where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");
            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult GSSystemListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string SystemID = Utils.AreaToSQLcs(Request["SystemID"]).Trim();
            GSSystem_info lTbl = Type == "Add" ? new GSSystem_info() : new GSSystem_info(SystemID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"); ;
                }
                return Content(lcRetval);
            }
            string SystemName =Utils.AreaToSQLcs(Request["SystemName"]).Trim();
            string shortName = Utils.AreaToSQLcs(Request["shortName"]).Trim();
            string SysLongName = Utils.AreaToSQLcs(Request["SysLongName"]).Trim();
            string Description = Utils.AreaToSQLcs(Request["Description"]).Trim();

            lTbl.Description = Description;
            lTbl.SysLongName = SysLongName;
            lTbl.shortName = shortName;
            lTbl.SystemName = SystemName;
            lTbl.SystemID = SystemID;

            lTbl.IsLock = "N";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.SystemType = "N";
                if (SysDataLibs.AppEnv.IsExistPrKey(Tn.GSSystem, GSSystem_info.cSystemID, lTbl.SystemID, UserSessionInfo.DBConn))
                {
                    //JSComm.ShowMessage("用户ID已存在！");
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
                }
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"); ;
            }
            return Content(lcRetval);
        }
        #endregion

        #region CheckProjectTypeAndMapping
        // GET: CheckProjectTypeAndMapping
        [CheckPowerFilter]
        public ActionResult CheckProjectTypeAndMapping()
        {
	        rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT CheckItemId,ParentId,CheckItemName,Depth From CheckItem WHERE IsLock='N'");
	        var result = GetData.Instance.GetComboTree(loQuery, "CheckItemId", "ParentId", "CheckItemName", "CheckItemId=1");
	        ViewBag.CheckItem = JsonConvert.SerializeObject(result);
			//ViewBag.SelCheckProjectTypeID = GetData.Instance.GetSelStr(CheckItem_info.cCheckItemId, CheckItem_info.cCheckItemName, Tn.CheckItem, " IsLock='0' ",UserSessionInfo.DBConn);
            return View();
        }
        public ActionResult GetCheckProjectTypeAndMappingList()
        {
            string lcSql = " SELECT   m.CheckProjectTypeMappingID, m.CheckItemId, m.szCheckItemTypeLittleCode, m.szCheckItemTypeGreatCode, m.szCheckItemTypeContent, c.CheckItemName FROM dbo.CheckProjectTypeMapping AS m LEFT OUTER JOIN dbo.CheckItem AS c ON m.CheckItemId = c.CheckItemId WHERE 1=1";
            string Name = Utils.AreaToSQLcs(Request["Name"]).Trim();
            if (!string.IsNullOrEmpty(Name))
            {
                lcSql += " and c.CheckItemName like '%" + Name+"%'";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//

            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult CheckProjectTypeAndMappingListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string CheckProjectTypeMappingID = Request["CheckProjectTypeMappingID"];
            CheckProjectTypeMapping_info lTbl = Type == "Add" ? new CheckProjectTypeMapping_info() : new CheckProjectTypeMapping_info(CheckProjectTypeMappingID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.DeleteSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string CheckItemId = Request["CheckItemId"];
            string szCheckItemTypeLittleCode = Utils.AreaToSQLcs(Request["szCheckItemTypeLittleCode"]).Trim();
            string szCheckItemTypeGreatCode = Utils.AreaToSQLcs(Request["szCheckItemTypeGreatCode"]).Trim();
            string szCheckItemTypeContent = Utils.AreaToSQLcs(Request["szCheckItemTypeContent"]).Trim();

            lTbl.CheckItemId = CheckItemId;
            lTbl.szCheckItemTypeLittleCode = szCheckItemTypeLittleCode;
            lTbl.szCheckItemTypeGreatCode = szCheckItemTypeGreatCode;
            lTbl.szCheckItemTypeContent = szCheckItemTypeContent;

            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.CheckProjectTypeMappingID = RandomUtil.GetGUID();
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region SpecialsMapping
        public ActionResult SpecialsMapping()
        {
            ViewBag.SelLittltKind = GetData.Instance.GetSelStr(LittleKind_info.cLittleKindID, LittleKind_info.cName, Tn.LittleKind, " IsLock='0' ", UserSessionInfo.DBConn);
            return View();
        }
        public ActionResult GetSpecialsMappingList()
        {
            string lcSql = " select * from v_ySpecials_Mapping where 1=1 ";
            string LittleKindName = Utils.AreaToSQLcs(Request["LittleKindID"]).Trim();
            string Name = Utils.AreaToSQLcs(Request["Name"]).Trim();
            if (!string.IsNullOrEmpty(LittleKindName))
            {
                lcSql += " and LittleKindName='" + LittleKindName + "' ";
            }
            if (!string.IsNullOrEmpty(Name))
            {
                lcSql += " and Name='" + Name + "' ";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult SpecialsMappingOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string SpecialsMappingID = Request["SpecialsMappingID"];
            SpecialsMapping_info lTbl = Type == "Add" ? new SpecialsMapping_info() : new SpecialsMapping_info(SpecialsMappingID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                // lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.DeleteSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string Name = Utils.AreaToSQLcs(Request["Name"]).Trim();
            string SpecialsID = Utils.AreaToSQLcs(Request["SpecialsID"]).Trim();
            string szLittleKindCode = Utils.AreaToSQLcs(Request["szLittleKindCode"]).Trim();
            string szMappingContent = Utils.AreaToSQLcs(Request["szMappingContent"]).Trim();
            lTbl.Name = Name;
            lTbl.SpecialsID = SpecialsID;
            lTbl.szLittleKindCode = szLittleKindCode;
            lTbl.szMappingContent = szMappingContent;
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.SpecialsMappingID = RandomUtil.GetGUID();
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region Evaluation 市场经营户信用考评标准
        // GET: Evaluation
        [CheckPowerFilter]
        public ActionResult EvaluationM()
        {
            return View();
        }
        [CheckPowerFilter]
        public ActionResult EvaluationG()
        {
            return View();
        }
        public ActionResult GetEvaluationList()
        {
            //string lcIsLock = Request["IsLock"];
            string lcEvaluationType = Request["EvaluationType"];
            if (string.IsNullOrEmpty(lcEvaluationType))
            {
                return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
            }
            string lcSql = " select * from Evaluation where EvaluationType='"+ lcEvaluationType + "' and IsLock='N'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        public ActionResult GetEvaluationItemList()
        {
            string lcIsLock = Request["IsLock"];
            string lcEvaluationID = Request["EvaluationID"];
            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "N";
            }
            if (string.IsNullOrEmpty(lcEvaluationID))
            {
                return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
            }
            string lcSql = " select * from EvaluationItem where EvaluationID='" + lcEvaluationID + "' and IsLock='"+ lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult EvaluationListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string EvaluationID = Request["EvaluationID"];
            Evaluation_info lTbl = Type == "Add" ? new Evaluation_info() : new Evaluation_info(EvaluationID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string EvaluationName = Utils.AreaToSQLcs(Request["EvaluationName"]).Trim();
            string EvaluationDesc = Utils.AreaToSQLcs(Request["EvaluationDesc"]).Trim();
            string EvaluationCreateTime = Utils.AreaToSQLcs(Request["EvaluationCreateTime"]).Trim();
            string EvaluationOrg = Utils.AreaToSQLcs(Request["EvaluationOrg"]).Trim();
            string EvaluationType = Utils.AreaToSQLcs(Request["EvaluationType"]).Trim(); ;
            if (string.IsNullOrEmpty(EvaluationName))
            {
                 return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "考评名称不能为空！")); ;
            }
          
            lTbl.EvaluationOrg = EvaluationOrg;
            lTbl.EvaluationCreateTime = EvaluationCreateTime;
            lTbl.EvaluationDesc = EvaluationDesc;
            lTbl.EvaluationName = EvaluationName;
            lTbl.EvaluationType = EvaluationType;
            lTbl.IsLock = "N";
            lTbl.UserIDLastMod = UserSessionInfo.UserInfo.UserID;
            lTbl.IsUser = "Y";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.TimeCreated = DateTime.Now.ToString();
              
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        public ActionResult EvaluationItemListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string EvaluationItemID = Request["EvaluationItemID"];
            EvaluationItem_info lTbl = Type == "Add" ? new EvaluationItem_info() : new EvaluationItem_info(EvaluationItemID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string EvaluationID = Utils.AreaToSQLcs(Request["EvaluationID"]).Trim();
            string ItemIndex = Utils.AreaToSQLcs(Request["ItemIndex"]).Trim();
            string Score = Utils.AreaToSQLcs(Request["Score"]).Trim();
            string ItemContent = Utils.AreaToSQLcs(Request["ItemContent"]).Trim();
            string EvaluationNorm = Utils.AreaToSQLcs(Request["EvaluationNorm"]).Trim();
            lTbl.ItemIndex = ItemIndex;
            lTbl.EvaluationID = EvaluationID;
            lTbl.Score = Score;
            lTbl.ItemContent = ItemContent;
            lTbl.EvaluationNorm = EvaluationNorm;
            lTbl.IsLock = "N";
            lTbl.UserIDLastMod = UserSessionInfo.UserInfo.UserID;
            lTbl.TimeLastMod = DateTime.Now.ToString();
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.TimeCreated = DateTime.Now.ToString();

                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region MarketType
        // GET: MarketType
        [CheckPowerFilter]
        public ActionResult MarketType()
        {
            return View();
        }

        public ActionResult GetMarketTypeList()
        {

            string lcSql = " select * from MarketType ";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult MarketTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string MarketTypeID = Request["MarketTypeID"];
            MarketType_info lTbl = Type == "Add" ? new MarketType_info() : new MarketType_info(MarketTypeID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                // lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.DeleteSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string MarketTypeName = Utils.AreaToSQLcs(Request["MarketTypeName"]).Trim();
            lTbl.MarketTypeName = MarketTypeName;

            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region WarrantType
        // GET: WarrantType
        [CheckPowerFilter]
        public ActionResult WarrantType()
        {
            return View();
        }
        public ActionResult GetWarrantTypeList()
        {
            string lcIsLock = Request["IsLock"];
            lcIsLock = string.IsNullOrEmpty(lcIsLock) ? "0" : lcIsLock;
            string lcSql = " select * from WarrantType where IsLock = '"+ lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.CurrentTable.Columns.Add("FlagName", typeof(string));
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    loQuery.SetField("FlagName", loQuery.GetString("Flag") == "1" ? "经营户" : "市场");
                    loQuery.MoveNext();
                }
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            }

            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult WarrantTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string WarrantTypeID = Request["WarrantTypeID"];
            WarrantType_info lTbl = Type == "Add" ? new WarrantType_info() : new WarrantType_info(WarrantTypeID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"); 
                }
                return Content(lcRetval);
            }
            string Name = Request["Name"];
            string Flag = Request["Flag"];
            lTbl.Flag = Flag;
            lTbl.Name = Name;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"); 
            }
            return Content(lcRetval);
        }
        #endregion

        #region CheckProjectTypeList
        [CheckPowerFilter]
        public ActionResult CheckProjectType()
        {
	        rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT CheckItemId,ParentId,CheckItemName,Depth From CheckItem WHERE IsLock='N'");
	        var result = GetData.Instance.GetComboTree(loQuery, "CheckItemId", "ParentId", "CheckItemName", "CheckItemId=1");
			ViewBag.CheckItem= JsonConvert.SerializeObject(result);
			ViewBag.CheckMethod= GetData.Instance.GetSelStr("CheckMethodId", "CheckMethodName",
				"CheckMethod", "IsLock='N'", UserSessionInfo.DBConn);
			return View();
        }

		[HttpPost]
	    public ActionResult GetCheckItem()
	    {
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery("SELECT CheckItemId,ParentId,CheckItemName,Depth From CheckItem WHERE IsLock='N'");
		    var result= GetData.Instance.GetComboTree(loQuery, "CheckItemId", "ParentId", "CheckItemName", "CheckItemId=1");
		    return Json(result);
	    }

		
		public ActionResult GetCheckProjectTypeList()
        {
            string lcIsLock = Request["IsLock"];
            lcIsLock = string.IsNullOrEmpty(lcIsLock) ? "0" : lcIsLock;
            //string lcSql = " select * from "+Tn.CheckProjectType+" where IsLock = '" + lcIsLock + "'";
	        string lcSql = "SELECT c.CheckProjectTypeID, c.Standard, c.StandardValue, c.Unit, c.IsLock, c.CheckItemId, c.CheckMethodId, i.CheckItemName, m.CheckMethodName FROM dbo.CheckProjectType AS c LEFT OUTER JOIN dbo.CheckItem AS i ON c.CheckItemId = i.CheckItemId LEFT OUTER JOIN dbo.CheckMethod AS m ON c.CheckMethodId = m.CheckMethodId WHERE c.IsLock = '" + lcIsLock + "'";
			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
            {
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            }

            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult CheckProjectTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string CheckProjectTypeID = Request["CheckProjectTypeID"];
            CheckProjectType_info lTbl = Type == "Add" ? new CheckProjectType_info() : new CheckProjectType_info(CheckProjectTypeID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string CheckItemId = Utils.AreaToSQLcs(Request["CheckItemId"]).Trim();
            string CheckMethodId = Utils.AreaToSQLcs(Request["CheckMethodId"]).Trim();
            string Standard = Utils.AreaToSQLcs(Request["Standard"]).Trim();
            string StandardValue = Utils.AreaToSQLcs(Request["StandardValue"]).Trim();
            string Unit = Utils.AreaToSQLcs(Request["Unit"]).Trim();
            lTbl.CheckItemId = CheckItemId;
            lTbl.CheckMethodId = CheckMethodId;
            lTbl.Standard = Standard;
            lTbl.StandardValue = StandardValue;
            lTbl.Unit = Unit;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
	            lTbl.CheckProjectTypeID =
		            GetData.Instance.GetRandomNextNum(NumberType.CheckProjectTypeNo, UserSessionInfo.DBConn) + "";
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
		#endregion

		#region CheckItem
		[CheckPowerFilter]
	    public ActionResult CheckItems()
	    {
		    return View();
	    }

		public ActionResult CheckItemsList()
		{
			string lcIsLock = Request["IsLock"];

			if (string.IsNullOrEmpty(lcIsLock))
			{
				lcIsLock = "N";
			}
			string lcSql = " select [CheckItemId],[ParentId] _parentId,[CheckItemName],[Path],[Sort],[IsLock],[Depth],[Reamrk],CASE WHEN([Depth] =1) THEN 'closed' ELSE NULL END state from " + Tn.CheckItem + " where IsLock='" + lcIsLock + "' ORDER BY Sort DESC";
			rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
			StringBuilder sb = new StringBuilder();
			sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
			if (loQuery.IsOpened && loQuery.RecCount > 0)
				sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
			else
				sb.Append("[]");
			sb.Append("}");

			return Content(sb.ToString());
		}
		[CheckPowerFilter]
	    public ActionResult CheckItemsOper()
	    {
		    string lcRetval = "false";
		    string Type = Request["Type"];
		    string CheckItemId = Utils.AreaToSQLcs(Request["CheckItemId"]).Trim();
		    CheckItem_info lTbl = Type == "Add" ? new CheckItem_info() : new CheckItem_info(CheckItemId, UserSessionInfo.DBConn);

		    if (Type == "Del" || Type == "ReDel")
		    {
			    lTbl.IsLock = Type == "Del" ? "Y" : "N";
			    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue(UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()) ? "Oper_Success" : "Oper_DBError");
			    return Content(lcRetval);
		    }
		    string CheckItemName = Utils.AreaToSQLcs(Request["CheckItemName"]).Trim();
		    string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
		    string Sort = Utils.AreaToSQLcs(Request["Sort"]).Trim();
		    string ParentId = Utils.AreaToSQLcs(Request["ParentId"]).Trim();
		    string Depth = Utils.AreaToSQLcs(Request["Depth"]).Trim();
		    string Path = Utils.AreaToSQLcs(Request["Path"]).Trim();
		    if (Convert.ToInt32(Depth) >2)
		    {
				return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Error"));
			}

		    lTbl.CheckItemName = CheckItemName;
		    lTbl.Sort = Sort;
		    lTbl.Reamrk = Remark;
		    lTbl.ParentId = ParentId;
		    lTbl.Depth = Depth;

		    lTbl.IsLock = "N";
		    string lcSql = "";
		    if (Type == "Edit")
		    {
			    lTbl.Path = Path;
				lcSql = lTbl.UpdateSql();
		    }
		    else
		    {
			    lTbl.CheckItemId = GetData.Instance.GetRandomNextNum(NumberType.CheckItemNo, UserSessionInfo.DBConn) + "";
			    lTbl.Path = Path + "," + lTbl.CheckItemId;
			    lcSql = lTbl.InsertSql();
		    }

		    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue(UserSessionInfo.DBConn.ExecuteSql(lcSql) ? "Oper_Success" : "Oper_DBError");
		    return Content(lcRetval);
	    }
		

		#endregion

		#region CheckMethond
		[CheckPowerFilter]
		public ActionResult CheckMethonds()
	    {
		    return View();
	    }

	    public ActionResult CheckMethondsList()
	    {
		    string lcIsLock = Request["IsLock"];

		    if (string.IsNullOrEmpty(lcIsLock))
		    {
			    lcIsLock = "N";
		    }
		    string checkMethodName = Utils.AreaToSQLcs(Request["CheckMethodName"]).Trim();
		    string lcSql = " select * from "+Tn.CheckMethod+" where IsLock='" + lcIsLock + "' ORDER BY Sort DESC";
		    //if (!string.IsNullOrEmpty(checkMethodName))
		    //{
			   // lcSql += " and " + CheckMethod_info.cCheckMethodName + " like '%" + checkMethodName + "%'";
		    //}
		    rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
		    StringBuilder sb = new StringBuilder();
		    sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
		    if (loQuery.IsOpened && loQuery.RecCount > 0)
			    sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
		    else
			    sb.Append("[]");
		    sb.Append("}");

		    return Content(sb.ToString());
	    }
		[CheckPowerFilter]
	    public ActionResult CheckMethondsOper()
	    {
		    string lcRetval = "false";
		    string Type = Request["Type"];
		    string checkMethodId = Utils.AreaToSQLcs(Request["CheckMethodId"]).Trim();
		    CheckMethod_info lTbl = Type == "Add" ? new CheckMethod_info() : new CheckMethod_info(checkMethodId, UserSessionInfo.DBConn);

		    if (Type == "Del" || Type == "ReDel")
		    {
			    lTbl.IsLock = Type == "Del" ? "Y" : "N";
			    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue(UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()) ? "Oper_Success" : "Oper_DBError");
			    return Content(lcRetval);
		    }
		    string CheckMethodName = Utils.AreaToSQLcs(Request["CheckMethodName"]).Trim();
		    string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
		    string Sort = Utils.AreaToSQLcs(Request["Sort"]).Trim();


		    lTbl.CheckMethodName = CheckMethodName;
		    lTbl.Sort = Sort;
		    lTbl.Remark = Remark;

		    lTbl.IsLock = "N";
		    string lcSql = Type == "Edit" ? lTbl.UpdateSql() : lTbl.InsertSql();

		    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue(UserSessionInfo.DBConn.ExecuteSql(lcSql) ? "Oper_Success" : "Oper_DBError");
		    return Content(lcRetval);
	    }

		#endregion

		#region LawRuleType
		// GET: LawRuleType
		[CheckPowerFilter]
        public ActionResult LawRuleType()
        {
            return View();
        }
        public ActionResult GetLawRuleTypeList()
        {

            string lcSql = " select * from LawRuleType";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult LawRuleTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string lawruleTypeId = Request["lawruleTypeId"];
            SysDataLibs.TableClass.LawRuleType_info lTbl = Type == "Add" ? new LawRuleType_info() : new LawRuleType_info(lawruleTypeId, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                // lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.DeleteSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string lawruleType = Utils.AreaToSQLcs(Request["lawruleType"]).Trim();

            lTbl.lawruleType = lawruleType;

            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region Farms
        // GET: Farms
        [CheckPowerFilter]
        public ActionResult Farms()
        {
            ViewBag.SelSeriesType = GetData.Instance.GetSelStr(Farms_info.cSeriesType, Tn.Farms,UserSessionInfo.DBConn);
            return View();
        }


        public ActionResult GetFarmsList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string ShortNames = Utils.AreaToSQLcs(Request["ShortNames"]).Trim();
            string lcSql = " select * from Farms where IsLock='" + lcIsLock + "' ";
            if (!string.IsNullOrEmpty(ShortNames))
            {
                lcSql += " and " + Farms_info.cShortNames + " like '%" + ShortNames + "%'";

            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult FarmsListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string FarmID = Utils.AreaToSQLcs(Request["FarmID"]).Trim();
            Farms_info lTbl = Type == "Add" ? new Farms_info() : new Farms_info(FarmID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string ShortNames = Utils.AreaToSQLcs(Request["ShortNames"]).Trim();
            string LinkMan = Utils.AreaToSQLcs(Request["LinkMan"]).Trim();
            string Telephone = Utils.AreaToSQLcs(Request["Telephone"]).Trim();
            string Address = Utils.AreaToSQLcs(Request["Address"]).Trim();
            string ZIP = Utils.AreaToSQLcs(Request["ZIP"]).Trim();
            string FarmURL = Utils.AreaToSQLcs(Request["FarmURL"]).Trim();
            string Names = Utils.AreaToSQLcs(Request["Names"]).Trim();
            string RegionID = Utils.AreaToSQLcs(Request["RegionID"]).Trim();
            string IsSystem = Utils.AreaToSQLcs(Request["IsSystem"]).Trim();
            string SeriesType = Utils.AreaToSQLcs(Request["SeriesType"]).Trim();
            string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
          
            lTbl.Telephone = Telephone;
            lTbl.LinkMan = LinkMan;
            lTbl.ShortNames = ShortNames;
            lTbl.FarmID = FarmID;
            lTbl.SeriesType = SeriesType;
            lTbl.FarmURL = FarmURL;
            lTbl.IsSystem = IsSystem;
            lTbl.ZIP = ZIP;
            lTbl.Address = Address;
            lTbl.Names = Names;
            lTbl.RegionID = RegionID;
            lTbl.Remark = Remark;

            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                if (SysDataLibs.AppEnv.IsExistPrKey(Tn.Farms, Farms_info.cFarmID, lTbl.FarmID, UserSessionInfo.DBConn))
                {
                    //Response.Write("该编号已经存在！");
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
                }
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region GreatKind
        // GET: GreatKind
        [CheckPowerFilter]
        public ActionResult GreatKind()
        {
            return View();
        }

        public ActionResult GetGreatKindList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from GreatKind where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
       
        [CheckPowerFilter]
        public ActionResult GreatKindListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string GreatKindID = Request["GreatKindID"];
            GreatKind_info lTbl = Type == "Add" ? new GreatKind_info() : new GreatKind_info(GreatKindID, UserSessionInfo.DBConn);
            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string Name = Utils.AreaToSQLcs(Request["Name"]).Trim();
            string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
            lTbl.Name = Name;
            lTbl.GreatKindID = GreatKindID;
            lTbl.Remark = Remark;

            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.SortNumber = UtilStr.StrFromObj(SysDataLibs.AppEnv.GetNextSortNumber(Tn.GreatKind, GreatKind_info.cSortNumber, UserSessionInfo.DBConn));
                if (SysDataLibs.AppEnv.IsExistPrKey(Tn.GreatKind, GreatKind_info.cGreatKindID, lTbl.GreatKindID, UserSessionInfo.DBConn))
                {
                    //Response.Write("该编号已经存在！");
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
                }
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region RunningWayType
        // GET: RunningWayType
        [CheckPowerFilter]
        public ActionResult RunningWayType()
        {
            return View();
        }

        public ActionResult GetRunningWayTypeList()
        {

            string lcSql = " select * from RunningWayType";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult RunningWayTypeListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string RunningWayTypeID = Request["RunningWayTypeID"];
            SysDataLibs.TableClass.RunningWayType_info lTbl = Type == "Add" ? new RunningWayType_info() : new RunningWayType_info(RunningWayTypeID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                // lTbl.IsLock = Type == "Del" ? "Y" : "N";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.DeleteSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string Name = Request["Name"];
            lTbl.Name = Name;

            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region LittleKind
        // GET: LittleKind
        [CheckPowerFilter]
        public ActionResult LittleKind()
        {
            ViewBag.SelGreatKind = GetData.Instance.GetSelStr(GreatKind_info.cGreatKindID, GreatKind_info.cName,Tn.GreatKind," IsLock = '0' ", UserSessionInfo.DBConn);
            return View();
        }

        public ActionResult GetLittleKindList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from LittleKind where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        public ActionResult GetLittleKindByGreatKindId()
        {
            string GreatKindID = Request["GreatKindID"];
            string lcSql = " select * from LittleKind where IsLock='0' ";
            if (!string.IsNullOrEmpty(GreatKindID))
            {
                lcSql += " and " + LittleKind_info.cGreatKindID + " = '" + GreatKindID + "'";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            return Content(sb.ToString());
        }
        public ActionResult GetGreatKindIDByLittleID()
        {
            string LittleKindID = Request["LittleKindID"];
            string lcSql = " select * from LittleKind where IsLock='0' ";
            if (!string.IsNullOrEmpty(LittleKindID))
            {
                lcSql += " and " + LittleKind_info.cLittleKindID + " = '" + LittleKindID + "'";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                return Content(loQuery.GetString("GreatKindID"));
            else
                return Content("");
        }
        [CheckPowerFilter]
        public ActionResult LittleKindListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string LittleKindID = Request["LittleKindID"];
            LittleKind_info lTbl = Type == "Add" ? new LittleKind_info() : new LittleKind_info(LittleKindID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"); 
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"); 
                }
                return Content(lcRetval);
            }
            string Name = Utils.AreaToSQLcs(Request["Name"]).Trim();
            string GreatKindID = Request["GreatKindID"];
            string IsVeg = Request["IsVeg"];
            string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
            lTbl.Name = Name;
            lTbl.GreatKindID = GreatKindID;
            lTbl.LittleKindID = LittleKindID;
            lTbl.IsVeg = IsVeg;
            lTbl.Remark = Remark;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.SortNumber = UtilStr.StrFromObj(SysDataLibs.AppEnv.GetNextSortNumber(Tn.LittleKind, LittleKind_info.cSortNumber, UserSessionInfo.DBConn));
                if (SysDataLibs.AppEnv.IsExistPrKey(Tn.LittleKind, LittleKind_info.cLittleKindID, lTbl.LittleKindID, UserSessionInfo.DBConn))
                {
                    //Response.Write("该编号已经存在！");
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
                }
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region Specials
        // GET: Specials
        [CheckPowerFilter]
        public ActionResult Specials()
        {
            ViewBag.SelGreatKind = GetData.Instance.GetSelStr(GreatKind_info.cGreatKindID, GreatKind_info.cName, Tn.GreatKind, " IsLock = '0' ", UserSessionInfo.DBConn);
            return View();
        }

        public ActionResult GetSpecialsList()
        {
            string lcIsLock = Request["IsLock"];
            string lcLittleKindID = Request["LittleKindID"];
            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from Specials where IsLock='" + lcIsLock + "'";
            if (!string.IsNullOrEmpty(lcLittleKindID))
            {
                lcSql += " and " + Specials_info.cLittleKindID + " = '" + lcLittleKindID + "'";
            }
            lcSql += " order by " + Specials_info.cSortNumber + " ";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        public ActionResult GetSpecialsByLittltKind()
        {
            string lcIsLock = Request["IsLock"];
            string lcLittleKindID = Request["LittleKindID"];
            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from Specials where IsLock='" + lcIsLock + "'";
            if (!string.IsNullOrEmpty(lcLittleKindID))
            {
                lcSql += " and " + Specials_info.cLittleKindID + " = '" + lcLittleKindID + "'";
            }
            lcSql += " order by " + Specials_info.cSortNumber + " ";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult SpecialsListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string SpecialsID = Request["SpecialsID"];
            Specials_info lTbl = Type == "Add" ? new Specials_info() : new Specials_info(SpecialsID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"); 
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            if(Type == "up" || Type == "down")
            {
                bool lbUPDOWN = Type == "up" ? true : false;
                try
                {
                    SysDataLibs.AppEnv.MoveRecordSort(Tn.Specials, Specials_info.cSpecialsID, SpecialsID, Specials_info.cSortNumber, lbUPDOWN);
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
                }
                catch
                {
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
                }
            }
            string Name = Utils.AreaToSQLcs(Request["Name"]);
            string LittleKindID = Request["LittleKindID"];
            lTbl.Name = Name;
            lTbl.SpecialsID = SpecialsID;
            lTbl.LittleKindID = LittleKindID;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.SortNumber = UtilStr.StrFromObj(SysDataLibs.AppEnv.GetNextSortNumber(Tn.Specials, Specials_info.cSortNumber, UserSessionInfo.DBConn));
                if (SysDataLibs.AppEnv.IsExistPrKey(Tn.Specials, Specials_info.cSpecialsID, lTbl.SpecialsID, UserSessionInfo.DBConn))
                {
                    //'该编号已存在
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
                }
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region Habitat
        // GET: Habitat
        [CheckPowerFilter]
        public ActionResult Habitat()
        {
            return View();
        }

        public ActionResult GetHabitatList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcNames = Utils.AreaToSQLcs(Request["Names"]).Trim();
            
            string lcSql = " select * from Habitat where IsLock='" + lcIsLock + "'";
            if (!string.IsNullOrEmpty(lcNames))
            {
                lcSql += " and Names like '%" + lcNames + "%'";
            }
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult HabitatListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string HabitatID = Utils.AreaToSQLcs(Request["HabitatID"]).Trim();
            Habitat_info lTbl = Type == "Add" ? new Habitat_info() : new Habitat_info(HabitatID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string Names = Utils.AreaToSQLcs(Request["Names"]).Trim();
            string HabitatType = Request["HabitatType"];
            if (string.IsNullOrEmpty(Names))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产地名称不能为空！"));
            }
            if (string.IsNullOrEmpty(HabitatID))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产地编号不能为空！"));
            }
            lTbl.Names = Names;
            lTbl.HabitatID = HabitatID;
            //lTbl.Type = Type_IsChina;
            lTbl.Type = HabitatType;//type只能为1或者2，显示为国内国外
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lTbl.Sort = UtilStr.StrFromObj(SysDataLibs.AppEnv.GetNextSortNumber(Tn.Habitat, Habitat_info.cSort, UserSessionInfo.DBConn));
                if (SysDataLibs.AppEnv.IsExistPrKey(Tn.Habitat, Habitat_info.cHabitatID, lTbl.HabitatID, UserSessionInfo.DBConn))
                {
                    return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_IsExistKeyError"));
                }
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region Dutys
        // GET: Dutys
        [CheckPowerFilter]
        public ActionResult Dutys()
        {
            return View();
        }

        public ActionResult GetDutysList()
        {
            string lcIsLock = Request["IsLock"];
            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from Dutys where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }

        [CheckPowerFilter]
        public ActionResult DutysListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string DutyID = Utils.AreaToSQLcs(Request["DutyID"]);
            Dutys_info lTbl = Type == "Add" ? new Dutys_info() : new Dutys_info(DutyID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string Names = Utils.AreaToSQLcs(Request["Names"]).Trim();
            string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
            if (string.IsNullOrEmpty(Names))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "职务名称不能为空！"));
            }
            lTbl.Names = Names;
            lTbl.Remark = Remark;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

        #region Departments
        // GET: Departments
        [CheckPowerFilter]
        public ActionResult Departments()
        {
            return View();
        }

        public ActionResult GetDepartmentsList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from Departments where IsLock='" + lcIsLock + "'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult DepartmentsListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string DepartmentID = Request["DepartmentID"];
            Departments_info lTbl = Type == "Add" ? new Departments_info() : new Departments_info(DepartmentID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                if (UserSessionInfo.DBConn.ExecuteSql(lTbl.UpdateSql()))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }
            string Names =Utils.AreaToSQLcs(Request["Names"]).Trim();
            string Remark = Utils.AreaToSQLcs(Request["Remark"]).Trim();
            if(string.IsNullOrEmpty(Names))
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "部门名称不能为空！"));
            lTbl.Names = Names;
            lTbl.Remark = Remark;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
            }
            else
            {
                lcSql = lTbl.InsertSql();
            }
            if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
            }
            else
            {
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }

        #endregion

        #region Regions
        // GET: Regions
        [CheckPowerFilter]
        public ActionResult Regions()
        {
            return View();
        }
        private string TranRegionName(int poDepth , string poName)
        {
            string exReg = "";
            for(int i = 0; i < poDepth; i++)
            {
                exReg += "---";
            }
            exReg += poName;
            return exReg;
        }
        public ActionResult GetRegionsList()
        {
            string lcIsLock = Request["IsLock"];

            if (string.IsNullOrEmpty(lcIsLock))
            {
                lcIsLock = "0";
            }
            string lcSql = " select * from Regions where IsLock='" + lcIsLock + "' ORDER BY Sort ";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);//
            StringBuilder sb = new StringBuilder();
            sb.Append("{\"total\":" + loQuery.RecCount + ",\"rows\":");
            if (loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    loQuery.SetField("Names", TranRegionName(loQuery.GetInt("Depth"), loQuery.GetString("Names")));
                    loQuery.MoveNext();
                }
                sb.Append(loQuery.CurrentTable.ToJson("yyyy-MM-dd"));
            }
            else
                sb.Append("[]");
            sb.Append("}");

            return Content(sb.ToString());
        }
        [CheckPowerFilter]
        public ActionResult RegionsListOper()
        {
            string lcRetval = "false";
            string Type = Request["Type"];
            string RegionID = Utils.AreaToSQLcs(Request["RegionID"]).Trim();
            string FRegionID = Utils.AreaToSQLcs(Request["FRegionID"]).Trim();
            Regions_info lTbl = Type == "Add" ? new Regions_info() : new Regions_info(RegionID, UserSessionInfo.DBConn);

            if (Type == "Del" || Type == "ReDel")
            {
                lTbl.IsLock = Type == "Del" ? "1" : "0";
                lcRetval = this.DeleteRegions(RegionID,Int16.Parse(lTbl.IsLock))
					? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success")
					: SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
				return Content(lcRetval);
            }
            if (Type == "up" || Type == "down")
            {
                if (this.MoveRegion(RegionID, Type))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
                return Content(lcRetval);
            }

            string Names = Utils.AreaToSQLcs(Request["Names"]).Trim();
            string URL = Utils.AreaToSQLcs(Request["URL"]).Trim();
            lTbl.Names = Names;
            lTbl.URL = URL;
            lTbl.IsLock = "0";
            string lcSql = "";
            if (Type == "Edit")
            {
                lcSql = lTbl.UpdateSql();
                if (UserSessionInfo.DBConn.ExecuteSql(lcSql))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }
                else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
            }
            else
            {
                lTbl.RegionID = RegionID;
                lTbl.FatherRegionID = FRegionID;
                if (AddRegion(lTbl))
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success");
                }else
                {
                    lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                }
            }
            
            return Content(lcRetval);
        }
        private bool DeleteRegions(string poDeleteLine,int poIsLock)
        {
            if (UserSessionInfo != null)
            {
                SqlConnection conn = null;
                SqlCommand comm = null;
                SqlTransaction tran = null;
                SqlParameter param = null;
                try
                {
                    conn = new SqlConnection(SysBaseLibs.AppEnv.DBConnectString);
                    conn.Open();
                    tran = conn.BeginTransaction();
                    comm = new SqlCommand("Pr_deleteRegion_ByRegionID", conn);
                    comm.CommandType = CommandType.StoredProcedure;
                    // ' 将参数加到存储过程中
                    param = new SqlParameter("@" + Regions_info.cRegionID, SqlDbType.VarChar, 20);
                    param.Value = poDeleteLine;// 'RegionID
                    comm.Parameters.Add(param);

                    param = new SqlParameter("@" + Regions_info.cIsLock, SqlDbType.Int, 4);
                    param.Value = poIsLock;
                    comm.Parameters.Add(param);
                    comm.Transaction = tran;
                    comm.ExecuteNonQuery();

                    tran.Commit();
                    return true;
                }
                catch (Exception err)
                {
                    tran.Rollback();
                    return false;
                }
                finally
                {
                    comm = null;
                    if (conn != null)
                    {
                        conn.Close();
                        conn = null;
                    }
                }
            }
            return false;
        }
        //移动功能
        public bool MoveRegion(String RegionID, String way)
        {
            SqlConnection conn = null;
            SqlCommand comm = null;
            SqlTransaction tran = null;
            SqlParameter param = null;
            try
            {
                conn = new SqlConnection(SysBaseLibs.AppEnv.DBConnectString);
                conn.Open();
                tran = conn.BeginTransaction();
                comm = new SqlCommand("Pr_RegionsSort", conn);
                comm.CommandType = CommandType.StoredProcedure;
                // ' 将参数加到存储过程中
                param = new SqlParameter("@CurItem", SqlDbType.VarChar, 20);
                param.Value = RegionID;// 'RegionID
                comm.Parameters.Add(param);

                param = new SqlParameter("@way", SqlDbType.Int, 4);
                param.Value = way;
                comm.Parameters.Add(param);
                comm.Transaction = tran;
                comm.ExecuteNonQuery();

                tran.Commit();
                return true;
            }
            catch (Exception err)
            {
                tran.Rollback();
                return false;
            }
            finally
            {
                comm = null;
                if (conn != null)
                {
                    conn.Close();
                    conn = null;
                }
            }
        }
        public bool AddRegion(Regions_info reItem)
        {
            string Sql, errMsg = "";
            Regions_info lTbl1 = new Regions_info();
            Sql = " select *  from " + Tn.Regions + " where " + Regions_info.cRegionID + "='" + reItem.FatherRegionID + "'";
            if (!SysDataLibs.AppEnv.GetTableInfo(Sql, lTbl1, UserSessionInfo.DBConn, ref errMsg))
            {
                return false;
            }
            //移动排序 修改父节点

            Sql = "";
            Sql = "update " + Tn.Regions + " set " + Regions_info.cIsLeaf + "=0 where " + Regions_info.cRegionID + "='" + reItem.FatherRegionID + "'";

            Sql = Sql + "  update " + Tn.Regions + " set " + Regions_info.cSort + "=" + Regions_info.cSort + "+1  where " + Regions_info.cSort + ">" + Utils.ValI(lTbl1.Sort);

            Sql = Sql + " insert into " + Tn.Regions + " (" + Regions_info.cRegionID + "," + Regions_info.cNames + "," + Regions_info.cURL + "," + Regions_info.cFatherRegionID + "," + Regions_info.cDepth + "," + Regions_info.cIsLeaf
                    + "," + Regions_info.cSort + "," + Regions_info.cPath + "," + Regions_info.cIsLock + ") values(";
            Sql = Sql + "'" + reItem.RegionID + "',";
            Sql = Sql + "'" + reItem.Names + "',";
            Sql = Sql + "'" + reItem.URL + "',";
            Sql = Sql + "'" + reItem.FatherRegionID + "',";
            Sql = Sql + UtilStr.StrFromObj(Utils.ValI(lTbl1.Depth) + 1) + ",";
            Sql = Sql + "1" + ",";
            Sql = Sql + UtilStr.StrFromObj(Utils.ValI(lTbl1.Sort) + 1) + ",";
            Sql = Sql + "'" + lTbl1.Path + reItem.RegionID + ",',";
            Sql = Sql + reItem.IsLock + ")";

            if(UserSessionInfo.DBConn.ExcuteSqlTran(Sql))
            {
                return true;
            }else
            {
                return false;
            }

          
        }

        public ActionResult GetTreeRegion()
        {
            string lcSql = "Select " + Regions_info.cRegionID + " as id," + Regions_info.cFatherRegionID + " as parentId," + Regions_info.cNames + " as name from " + Tn.Regions +
          " where IsLock='0' order by Sort ";
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            sb.Append("[");
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
            {
                
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    string id = loQuery.GetString("id");
                    string parentId = loQuery.GetString("parentId");
                    if(id == parentId)
                    {
                        parentId = "0";
                    }
                    sb.Append("{");
                    sb.Append("\"id\":\"" + id + "\",\"parentId\":\"" + parentId + "\",\"name\":\"" + loQuery.GetString("name") + "\"");
                    sb.Append("},");
                    loQuery.MoveNext();
                }
            }
            sb.Remove(sb.Length - 1, 1);
            sb.Append("]");
            return Content(sb.ToString());
        }
        #endregion


        #region VarietyCategory
        public ActionResult VarietyCategory()
        {
            ViewBag.VarietyCategoryNode = "[" + JsonConvert.SerializeObject(GetData.Instance.GetComboTreeNode(
                                              UserSessionInfo.DBConn.OpenQuery(
                                                  " select * from " + Tn.VarietyCategory + " where " +
                                                  VarietyCategory_info.cIsLock + "='N'"),
                                              VarietyCategory_info.cVarietyCategoryNo, VarietyCategory_info.cFatherNo,
                                              VarietyCategory_info.cVarietyCategoryName,
                                              VarietyCategory_info.cVarietyCategoryNo + "='10000'")) + "]";
            return View();
        }

        public ActionResult GetVarietyCategoryNode()
        {
            //string lcName = Utils.AreaToSQLcs(Request["VarietyCategoryName"]);
            //string lcSql = " select * from " + Tn.VarietyCategory + " where " +
            //               VarietyCategory_info.cVarietyCategoryName + " like '%" + lcName + "%'";
            string lcSql = " select * from " + Tn.VarietyCategory;
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            
            loQuery?.FilterBy(VarietyCategory_info.cVarietyCategoryNo + " = '10000 '");
            ComboTree tree = new ComboTree();
            if (loQuery?.RecCount == 1)
            {
                loQuery.MoveFirst();
                tree.id = loQuery.GetString(VarietyCategory_info.cVarietyCategoryNo);
                tree.text = loQuery.GetString(VarietyCategory_info.cVarietyCategoryName);
                tree.state = "open";
                loQuery?.FilterBy("");
                tree.children = GetData.Instance.GetComboTree(loQuery, VarietyCategory_info.cVarietyCategoryNo,
                    VarietyCategory_info.cFatherNo, VarietyCategory_info.cVarietyCategoryName, VarietyCategory_info.cVarietyCategoryNo + " = '10000 '");
            }
            List<ComboTree> loComboTrees = new List<ComboTree> {tree};
            return Json(loComboTrees);
        }

        public ActionResult QueryVarietyCategoryNode()
        {
            string lcName = Utils.AreaToSQLcs(Request["VarietyCategoryName"]);
            string lcSql = " select * from " + Tn.VarietyCategory + " where " +
                           VarietyCategory_info.cVarietyCategoryName + " like '%" + lcName + "%'";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            string lcPath = "";
            if (loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    lcPath += loQuery.GetString("Path")+",";
                    loQuery.MoveNext();
                }
            }
            lcSql = " select VarietyCategoryNo,VarietyCategoryName,Sort,[IsLock],Path,FatherNo as _parentId,Depth,CountryNo,ProvincialNo,LocalNo,IsLeaf,IsMajorCost,IsMajorSrc,IsCanChecked,CheckCount,case when  (IsLeaf='Y')then 'open' else NULL END as state  from " + Tn.VarietyCategory + " where " + VarietyCategory_info.cVarietyCategoryNo +
                    " in ('" + lcPath.Replace(",", "','") + "')";
            return Content(GetData.Instance.GetResult(lcSql, UserSessionInfo.DBConn));
        }

        public ActionResult GetVarietyCategory(VarietyCategory_info poVarietyCategoryInfo)
        {
            string lcVarietyCategoryNo = Request["id"];
            if (string.IsNullOrWhiteSpace(lcVarietyCategoryNo))
            {
                lcVarietyCategoryNo = "10000";
                List<VarietyCategoryTreeModel> loCategoryTreeModels = new List<VarietyCategoryTreeModel>();
                VarietyCategory_info loRootCategoryInfo = new VarietyCategory_info("10000", UserSessionInfo.DBConn);
                VarietyCategoryTreeModel loModel = new VarietyCategoryTreeModel();
                loModel.VarietyCategoryNo = loRootCategoryInfo.VarietyCategoryNo;
                loModel.VarietyCategoryName = loRootCategoryInfo.VarietyCategoryName;
                loModel.Path = loRootCategoryInfo.Path;
                loModel.Depth = loRootCategoryInfo.Depth;
                loModel.CountryNo = loRootCategoryInfo.CountryNo;
                loModel.ProvincialNo = loRootCategoryInfo.ProvincialNo;
                loModel.LocalNo = loRootCategoryInfo.LocalNo;
                loModel.IsLeaf = loRootCategoryInfo.IsLeaf;
                loModel.IsMajorCost = loRootCategoryInfo.IsMajorCost;
                loModel.IsMajorSrc = loRootCategoryInfo.IsMajorSrc;
                loModel.IsCanChecked = loRootCategoryInfo.IsCanChecked;
                loModel.state = loModel.IsLeaf == "N" ? "open" : null;
                loModel.children = GetVarietyCategoryTreeModel(lcVarietyCategoryNo);
                loCategoryTreeModels.Add(loModel);
                return Json(loCategoryTreeModels);
            }
            return Json(GetVarietyCategoryTreeModel(lcVarietyCategoryNo));
        }

        public List<VarietyCategoryTreeModel> GetVarietyCategoryTreeModel(string poFatherNo)
        {
            List<VarietyCategoryTreeModel> loCategoryTreeModels = new List<VarietyCategoryTreeModel>();
            string lcSql =
                " select VarietyCategoryNo,VarietyCategoryName,Sort,[IsLock],Path,FatherNo,Depth,CountryNo,ProvincialNo,LocalNo,IsLeaf,IsMajorCost,IsMajorSrc,IsCanChecked,CheckCount from VarietyCategory where IsLock = 'N' AND FatherNo='"+ poFatherNo + "'  order by CheckCount desc";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            if (loQuery.IsOpened)
            {
                DataTable loDataTable = loQuery.CurrentTable;
                for (int i = 0; i < loDataTable.Rows.Count; i++)
                {
                    var row = loDataTable.Rows[i];
                    VarietyCategoryTreeModel loModel = new VarietyCategoryTreeModel();
                    loModel.VarietyCategoryNo = row["VarietyCategoryNo"].ToString();
                    loModel.VarietyCategoryName = row["VarietyCategoryName"].ToString();
                    loModel.Path = row["Path"].ToString();
                    loModel.Depth = row["Depth"].ToString();
                    loModel.CountryNo = row["CountryNo"].ToString();
                    loModel.ProvincialNo = row["ProvincialNo"].ToString();
                    loModel.LocalNo = row["LocalNo"].ToString();
                    loModel.IsLeaf = row["IsLeaf"].ToString();
                    loModel.IsMajorCost = row["IsMajorCost"].ToString();
                    loModel.IsMajorSrc = row["IsMajorSrc"].ToString();
                    loModel.IsCanChecked = row["IsCanChecked"].ToString();
                    loModel.state = loModel.IsLeaf=="N"?"closed":null;
                    loCategoryTreeModels.Add(loModel);
                }
            }
            return loCategoryTreeModels;
        }

        public List<VarietyCategoryTreeModel> GetChildCategoryTreeModels(string poFatherNo,DataTable poDataTable)
        {
            List<VarietyCategoryTreeModel> loCategoryTreeModels = new List<VarietyCategoryTreeModel>();
            for (int i = 0; i < poDataTable.Rows.Count; i++)
            {
                var row = poDataTable.Rows[i];
                if (row["FatherNo"].ToString() == poFatherNo)
                {
                    VarietyCategoryTreeModel loModel = new VarietyCategoryTreeModel();
                    loModel.VarietyCategoryNo = row["VarietyCategoryNo"].ToString();
                    loModel.VarietyCategoryName = row["VarietyCategoryName"].ToString();
                    loModel.Path = row["Path"].ToString();
                    loModel.Depth = row["Depth"].ToString();
                    loModel.CountryNo = row["CountryNo"].ToString();
                    loModel.ProvincialNo = row["ProvincialNo"].ToString();
                    loModel.LocalNo = row["LocalNo"].ToString();
                    loModel.IsLeaf = row["IsLeaf"].ToString();
                    loModel.IsMajorCost = row["IsMajorCost"].ToString();
                    loModel.IsMajorSrc = row["IsMajorSrc"].ToString();
                    loModel.IsCanChecked = row["IsCanChecked"].ToString();
                    loModel.state = loModel.IsLeaf=="N"?"closed":null ;
                    loModel.children = GetChildCategoryTreeModels(loModel.VarietyCategoryNo, poDataTable);
                    loCategoryTreeModels.Add(loModel);
                }
            }
            return loCategoryTreeModels;
        }
        public ActionResult AddVarietyCategory(VarietyCategory_info poInfo)
        {
            if (string.IsNullOrWhiteSpace(poInfo.VarietyCategoryNo) || string.IsNullOrWhiteSpace(poInfo.VarietyCategoryName))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品编号或名称不能为空！"));
            }
            if (GetData.Instance.isCheckExistObj("VarietyCategoryName", poInfo.VarietyCategoryName, Tn.VarietyCategory,
                UserSessionInfo.DBConn))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品名称已存在！"));
            }
            string lcVarietyCategoryNo = GetData.Instance.GetRandomNextNum(NumberType.VarietyCategoryNo, UserSessionInfo.DBConn) + "";
            //VarietyCategory_info poFatherInfo = new VarietyCategory_info(poInfo.VarietyCategoryNo,UserSessionInfo.DBConn);
            string lcRefreshNo = poInfo.VarietyCategoryNo;
            if (lcRefreshNo != "10000" && !VarietyCategory_info.CheckExistChildCategorys(lcRefreshNo,
                    UserSessionInfo.DBConn))
            {
                VarietyCategory_info loFatherInfo =
                    new VarietyCategory_info(lcRefreshNo, UserSessionInfo.DBConn);
                lcRefreshNo = loFatherInfo.FatherNo;
            }
            string lcRetval = "";
            try
            {
                IdCollection loSpPars = new IdCollection();
                SqlSPPar loSpPar = new SqlSPPar("FatherNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.VarietyCategoryNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("VarietyCategoryNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = lcVarietyCategoryNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("VarietyCategoryName", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.VarietyCategoryName;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("CountryNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.CountryNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("ProvincialNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.ProvincialNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("LocalNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.LocalNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("IsMajorCost", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.IsMajorCost=="on"?"Y":"N";
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("IsMajorSrc", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.IsMajorSrc == "on" ? "Y" : "N";
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("IsCanChecked", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.IsCanChecked == "on" ? "Y" : "N";
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("Result", SqlDbType.Int);
                loSpPar.IsOutput = true;
                loSpPars.Add(loSpPar);
                if (UserSessionInfo.DBConn.ExecuteStoredProc("Pr_AddVariety", loSpPars))
                {
                    if (loSpPars["Result"] != null)
                    {
                        int liResult = Convert.ToInt16(((SqlSPPar)loSpPars["Result"]).ParameterValue);
                        
                        lcRetval = liResult == 1 ? ResponseData.GetResponseInfo(true, lcRefreshNo) : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                    }
                }
                else
                {
                    lcRetval = ErrorRebackInfo.GetErrorBackInfo(false, "0", UserSessionInfo.DBConn.ErrorMsg);
                }

            }
            catch (Exception err)
            {
                ThreadLog.LogException(err);
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }

        public ActionResult UpdateVarietyCategory(VarietyCategory_info poInfo)
        {
            if (string.IsNullOrWhiteSpace(poInfo.VarietyCategoryNo) || string.IsNullOrWhiteSpace(poInfo.VarietyCategoryName))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品编号或名称不能为空！"));
            }
            //if (GetData.Instance.isCheckExistObj("VarietyCategoryName", poInfo.VarietyCategoryName, Tn.VarietyCategory,
            //    UserSessionInfo.DBConn))
            //{
            //    return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品名称已存在！"));
            //}
            VarietyCategory_info loVarietyCategoryInfo =
                new VarietyCategory_info(poInfo.VarietyCategoryNo, UserSessionInfo.DBConn)
                {
                    VarietyCategoryName = poInfo.VarietyCategoryName,
                    CountryNo = poInfo.CountryNo,
                    ProvincialNo = poInfo.ProvincialNo,
                    LocalNo = poInfo.LocalNo,
                    //IsCanChecked = poInfo.IsCanChecked == "on" ? "Y" : "N",
                    //IsMajorCost = poInfo.IsMajorCost == "on" ? "Y" : "N",
                    //IsMajorSrc = poInfo.IsMajorSrc == "on" ? "Y" : "N"
                };

            string lcRetval = UserSessionInfo.DBConn.ExcuteSqlTran(loVarietyCategoryInfo.UpdateSql())
                 ? ResponseData.GetResponseInfo(true, loVarietyCategoryInfo.FatherNo)
                 : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            return Content(lcRetval);
        }

        public ActionResult DeleteVarietyCategory(VarietyCategory_info poInfo)
        {
            if (string.IsNullOrWhiteSpace(poInfo.VarietyCategoryNo))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品编号或名称不能为空！"));
            }
            VarietyCategory_info loVarietyCategoryInfo = new VarietyCategory_info(poInfo.VarietyCategoryNo,UserSessionInfo.DBConn);
            string lcRetval = "";
            try
            {
                IdCollection loSpPars = new IdCollection();
                SqlSPPar loSpPar = new SqlSPPar("VarietyCategoryNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = poInfo.VarietyCategoryNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("Result", SqlDbType.Int);
                loSpPar.IsOutput = true;
                loSpPars.Add(loSpPar);
                if (UserSessionInfo.DBConn.ExecuteStoredProc("Pr_deleteVarietyCategory_ByVarietyCategoryNo", loSpPars))
                {
                    if (loSpPars["Result"] != null)
                    {
                        int liResult = Convert.ToInt16(((SqlSPPar)loSpPars["Result"]).ParameterValue);
                        string lcRefreshNo = loVarietyCategoryInfo.FatherNo;
                        if (lcRefreshNo != "10000"&&!VarietyCategory_info.CheckExistChildCategorys(loVarietyCategoryInfo.FatherNo,
                            UserSessionInfo.DBConn))
                        {
                            VarietyCategory_info loFatherInfo =
                                new VarietyCategory_info(lcRefreshNo, UserSessionInfo.DBConn);
                            lcRefreshNo = loFatherInfo.FatherNo;
                        }
                        lcRetval = liResult == 1 ? ResponseData.GetResponseInfo(true, lcRefreshNo) : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                    }
                }
                else
                {
                    lcRetval = ErrorRebackInfo.GetErrorBackInfo(false, "0", UserSessionInfo.DBConn.ErrorMsg);
                }
            }
            catch (Exception err)
            {
                ThreadLog.LogException(err);
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }

        public ActionResult UpdatePartakeStatus()
        {
            string key = Request["key"];
            string status = Request["status"];
            if (string.IsNullOrWhiteSpace(key))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品编号或名称不能为空！"));
            }
            try
            {
                string[] keyArr = key.Split(new[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
                string lcProperties = keyArr[0];
                string lcKeyNo = keyArr[1];
                VarietyCategory_info loCategoryInfo = new VarietyCategory_info(lcKeyNo, UserSessionInfo.DBConn);
                string lcSql = "";
                var t = loCategoryInfo.GetType();
                var p = t.GetProperty(lcProperties);
                p?.SetValue(loCategoryInfo, status);
                lcSql = loCategoryInfo.UpdateSql();
                if (status == "N"&& lcProperties == "IsCanChecked")
                {
                    lcSql = " update  VarietyCategory set " + lcProperties + " = 'N' where Path like '" +
                            loCategoryInfo.Path + "%' ";
                }
                return Content(UserSessionInfo.DBConn.ExcuteSqlTran(lcSql) ? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success") : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
            }
            catch (Exception e)
            {
                //string err = e.Message;
            }
            return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));


        }

        public ActionResult ChangeFatherNode()
        {
            string lcKeyNum = Request["VarietyCategoryNo"];
            string lcParentNum = Request["ParentNo"];
            if (string.IsNullOrEmpty(lcKeyNum) || string.IsNullOrWhiteSpace(lcParentNum))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品编号或名称不能为空！"));
            }
            if (lcKeyNum == lcParentNum)
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "不能迁移到自生节点下面！"));
            }
            VarietyCategory_info loParentCategoryInfo = new VarietyCategory_info(lcParentNum, UserSessionInfo.DBConn);
            loParentCategoryInfo.IsLeaf = "N";
            VarietyCategory_info loCategoryInfo = new VarietyCategory_info(lcKeyNum, UserSessionInfo.DBConn);
            loCategoryInfo.FatherNo = lcParentNum;
            
            DataTable loDataTable = UserSessionInfo.DBConn.OpenDataTable("select * from "+Tn.VarietyCategory+" where "+VarietyCategory_info.cPath+" like '"+loCategoryInfo.Path+"%'");
            loCategoryInfo.Path = loParentCategoryInfo.Path + "," + lcKeyNum;
            loCategoryInfo.Depth = (Convert.ToInt16(loParentCategoryInfo.Depth) + 1).ToString();
            string lcSql = GetUpdatePathSql(loDataTable, lcKeyNum, loCategoryInfo.Path, Convert.ToInt16(loCategoryInfo.Depth));
            if (UserSessionInfo.DBConn.ExcuteSqlTran(loParentCategoryInfo.UpdateSql()+";\r\n"+loCategoryInfo.UpdateSql() + ";\r\n" + lcSql))
            {
              return   Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success"));
            }
            else
            {
             return Content(SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
            }
        }

        public string GetUpdatePathSql(DataTable poDataTable,string poParentNo,string poParentPath,int poParentDepth)
        {
            string lcRetval = "";
            for (int i = 0; i < poDataTable.Rows.Count; i++)
            {
                string lcKeyNum = poDataTable.Rows[i][VarietyCategory_info.cVarietyCategoryNo].ToString();
               
                if (poDataTable.Rows[i]["FatherNo"].ToString() == poParentNo)
                {
                    lcRetval += " update VarietyCategory set " + VarietyCategory_info.cPath + " = '" + poParentPath +
                                "," + lcKeyNum + "' where " +
                                VarietyCategory_info.cVarietyCategoryNo + " = '" +
                                lcKeyNum + "' and Depth="+ (poParentDepth+1);
                    lcRetval += GetUpdatePathSql(poDataTable, lcKeyNum, poParentPath + "," + lcKeyNum, poParentDepth + 1);
                }
            }
            return lcRetval;
        }

        public ActionResult InsertData()
        {
            //StreamReader loReader = new StreamReader(Server.MapPath("~/Language/datainfo.json"),Encoding.GetEncoding("GB2312"));
            //string lcAllData = loReader.ReadToEnd();
            //dynamic modelDy =  JsonConvert.DeserializeObject<dynamic>(lcAllData);
            //string lcSql = "";
            //foreach (var model in modelDy)
            //{
            //    lcSql += " insert  into SubItems(Id,ItemCode,ItemName,SubItemCode,SubItemName,SubItemAlias,UpdateDate) values('" + model["Id"]+"','"+model
            //        ["ItemCode"] + "','"+ model["ItemName"] + "','"+ model["SubItemCode"] + "','"+ model["SubItemName"] +"','" + model["SubItemAlias"] + "','" + model["UpdateDate"] + "'); \r\n";
            //}
            List<VarietyCategory_info> loCategoryInfos = new List<VarietyCategory_info>();
            string lcSql = " select * from VarietyCategory ";
            rsQuery loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.MoveFirst();
                for (int i = 0; i < loQuery.RecCount; i++)
                {
                    VarietyCategory_info loCategoryInfo = new VarietyCategory_info()
                    {
                        VarietyCategoryNo = loQuery.GetString("VarietyCategoryNo"),
                        VarietyCategoryName = loQuery.GetString("VarietyCategoryName"),
                        LocalNo = loQuery.GetString("LocalNo"),
                        Path = loQuery.GetString("Path"),
                        Sort = loQuery.GetString("Sort"),
                        Depth = loQuery.GetString("Depth")
                    };
                    loCategoryInfos.Add(loCategoryInfo);
                    loQuery.MoveNext();
                }
            }
            lcSql = " select * from SubItems ";
            loQuery = UserSessionInfo.DBConn.OpenQuery(lcSql);
            string lcAllInsertSql = "";
            if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
            {
                loQuery.MoveFirst();
                for (int i=0;i<loQuery.RecCount;i++)
                {
                    string lcItemCode = loQuery.GetString("ItemCode");
                    var lcFarher = loCategoryInfos.FirstOrDefault(a => a.LocalNo == lcItemCode);
                    if (lcFarher == null)
                    {
                        continue;
                    }
                    VarietyCategory_info loCategoryInfo = new VarietyCategory_info()
                    {
                        
                        VarietyCategoryName = loQuery.GetString("SubItemName")
                    };
                    loCategoryInfo.VarietyCategoryNo =
                        GetData.Instance.GetRandomNextNum(NumberType.VarietyCategoryNo, UserSessionInfo.DBConn) + "";
                    loCategoryInfo.Path = lcFarher.Path + "," + loCategoryInfo.VarietyCategoryNo;
                    loCategoryInfo.FatherNo = lcFarher.VarietyCategoryNo;
                    loCategoryInfo.Sort = (Convert.ToInt16(lcFarher.Sort) + 1).ToString();
                    loCategoryInfo.Depth = (Convert.ToInt16(lcFarher.Depth) + 1).ToString();
                    loCategoryInfo.CheckCount = "0";
                    loCategoryInfo.LocalNo = loQuery.GetString("SubItemCode");
                    loCategoryInfo.IsLeaf = "Y";
                    loCategoryInfo.IsLock = "N";
                    lcAllInsertSql += loCategoryInfo.InsertSql() + ";\r\n";
                    loQuery.MoveNext();
                }
            }
            return Content(UserSessionInfo.DBConn.ExcuteSqlTran(lcAllInsertSql) ? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success") : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError"));
        }
        public ActionResult MoveVarietyCategory()
        {
            string lcVarietyCategoryNo = Request["VarietyCategoryNo"];
            string lcWay = Request["Operator"];
            if (string.IsNullOrWhiteSpace(lcVarietyCategoryNo) || string.IsNullOrWhiteSpace(lcWay))
            {
                return Content(ErrorRebackInfo.GetErrorBackInfo(false, "0", "产品编号或名称不能为空！"));
            }

            string lcRetval = "";
            try
            {
                IdCollection loSpPars = new IdCollection();
                SqlSPPar loSpPar = new SqlSPPar("CurItemNo", SqlDbType.NVarChar);
                loSpPar.ParameterValue = lcVarietyCategoryNo;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("way", SqlDbType.NVarChar);
                loSpPar.ParameterValue = lcWay;
                loSpPars.Add(loSpPar);
                loSpPar = new SqlSPPar("Result", SqlDbType.Int);
                loSpPar.IsOutput = true;
                loSpPars.Add(loSpPar);
                if (UserSessionInfo.DBConn.ExecuteStoredProc("Pr_VarietyCategorySort", loSpPars))
                {
                    if (loSpPars["Result"] != null)
                    {
                        int liResult = Convert.ToInt16(((SqlSPPar)loSpPars["Result"]).ParameterValue);
                        lcRetval = liResult == 1 ? SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_Success") : SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
                    }
                }
                else
                {
                    lcRetval = ErrorRebackInfo.GetErrorBackInfo(false, "0", UserSessionInfo.DBConn.ErrorMsg);
                }

            }
            catch (Exception err)
            {
                ThreadLog.LogException(err);
                lcRetval = SysRebackDisplayInfo.Instance.GetDisplayValue("Oper_DBError");
            }
            return Content(lcRetval);
        }
        #endregion

    }
}