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 loComboTrees = new List {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 loCategoryTreeModels = new List(); 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 GetVarietyCategoryTreeModel(string poFatherNo) { List loCategoryTreeModels = new List(); 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 GetChildCategoryTreeModels(string poFatherNo,DataTable poDataTable) { List loCategoryTreeModels = new List(); 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(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 loCategoryInfos = new List(); 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 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 } }