/// <summary> /// 得到一个对象实体 /// </summary> public GoodsCatsModel GetModel(int Id, int PlatType) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from HQ_Goods_Cats "); strSql.Append(" where Id=@Id and PlatType=@PlatType "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@PlatType", SqlDbType.SmallInt, 2) }; parameters[0].Value = Id; parameters[1].Value = PlatType; GoodsCatsModel model = new GoodsCatsModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 交换排序 /// </summary> /// <param name="catId">分类id</param> /// <param name="platType">平台类型</param> /// <param name="type">1:下移;2:上移</param> /// <param name="errMsg">错误信息</param> /// <returns></returns> public bool SwapPosition(int catId, int platType, int type, out string errMsg) { errMsg = ""; GoodsCatsModel current = dal.GetModel(catId, platType); GoodsCatsModel swapInfo = null; if (type == 1) { swapInfo = dal.GetNext(current.SortNum, platType, current.LevelNo); errMsg = "已到底部"; } else { swapInfo = dal.GetPrev(current.SortNum, platType, current.LevelNo); errMsg = "已到顶部"; } if (swapInfo == null) { return(false); } int curSort = current.SortNum; int swapSort = swapInfo.SortNum; current.SortNum = swapSort; swapInfo.SortNum = curSort; this.Update(current); this.Update(swapInfo); return(true); }
/// <summary> /// 递归排序 /// </summary> /// <param name="model"></param> /// <param name="allCates"></param> /// <param name="sortedListFinal"></param> private void GetNode(GoodsCatsModel model, List <GoodsCatsModel> allCates, List <GoodsCatsModel> sortedListFinal) { List <GoodsCatsModel> lstFinds = allCates.FindAll(p => p.ParentId == model.Id); foreach (GoodsCatsModel m in lstFinds) { sortedListFinal.Add(m); GetNode(m, allCates, sortedListFinal); } }
private void LoadDetail() { if (this.CurrentId > 0) { GoodsCatsModel model = GoodsCatsBLL.Instance.GetModel(this.CurrentId, this.PlatType); if (model != null) { txtCatId.Disabled = true; dllParentId.Enabled = false; txtCatId.Value = model.Id.ToString(); dllParentId.SelectedValue = model.ParentId.ToString(); txtCatName.Value = model.Name; hidCatIcon.Value = model.Icon; ddlStatus.SelectedValue = model.Status.ToString(); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(GoodsCatsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HQ_Goods_Cats set "); strSql.Append("Name=@Name,"); strSql.Append("ParentId=@ParentId,"); strSql.Append("LevelNo=@LevelNo,"); strSql.Append("Icon=@Icon,"); strSql.Append("SortNum=@SortNum,"); strSql.Append("Status=@Status"); strSql.Append(" where Id=@Id and PlatType=@PlatType "); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 50), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@LevelNo", SqlDbType.Int, 4), new SqlParameter("@Icon", SqlDbType.VarChar, 300), new SqlParameter("@SortNum", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.SmallInt, 2), new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@PlatType", SqlDbType.SmallInt, 2) }; parameters[0].Value = model.Name; parameters[1].Value = model.ParentId; parameters[2].Value = model.LevelNo; parameters[3].Value = model.Icon; parameters[4].Value = model.SortNum; parameters[5].Value = model.Status; parameters[6].Value = model.Id; parameters[7].Value = model.PlatType; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GoodsCatsModel DataRowToModel(DataRow row) { GoodsCatsModel model = new GoodsCatsModel(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["PlatType"] != null && row["PlatType"].ToString() != "") { model.PlatType = int.Parse(row["PlatType"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["ParentId"] != null && row["ParentId"].ToString() != "") { model.ParentId = int.Parse(row["ParentId"].ToString()); } if (row["LevelNo"] != null && row["LevelNo"].ToString() != "") { model.LevelNo = int.Parse(row["LevelNo"].ToString()); } if (row["Icon"] != null) { model.Icon = row["Icon"].ToString(); } if (row["SortNum"] != null && row["SortNum"].ToString() != "") { model.SortNum = int.Parse(row["SortNum"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(GoodsCatsModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HQ_Goods_Cats("); strSql.Append("Id,PlatType,Name,ParentId,LevelNo,Icon,SortNum,Status)"); strSql.Append(" values ("); strSql.Append("@Id,@PlatType,@Name,@ParentId,@LevelNo,@Icon,@SortNum,@Status)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@PlatType", SqlDbType.SmallInt, 2), new SqlParameter("@Name", SqlDbType.VarChar, 50), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@LevelNo", SqlDbType.Int, 4), new SqlParameter("@Icon", SqlDbType.VarChar, 300), new SqlParameter("@SortNum", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.SmallInt, 2) }; parameters[0].Value = model.Id; parameters[1].Value = model.PlatType; parameters[2].Value = model.Name; parameters[3].Value = model.ParentId; parameters[4].Value = model.LevelNo; parameters[5].Value = model.Icon; parameters[6].Value = model.SortNum; parameters[7].Value = model.Status; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void SaveInfo() { GoodsCatsModel model = null; if (this.CurrentId > 0) { model = GoodsCatsBLL.Instance.GetModel(this.CurrentId, this.PlatType); } else { model = new GoodsCatsModel(); } model.Id = Convert.ToInt32(txtCatId.Value); model.Icon = hidCatIcon.Value.Trim(); model.Name = txtCatName.Value.Trim(); model.ParentId = Convert.ToInt32(dllParentId.SelectedValue); model.Status = Convert.ToInt16(ddlStatus.SelectedValue); model.PlatType = this.PlatType; model.LevelNo = model.ParentId == 0 ? 1 : 2; if (this.CurrentId > 0) { GoodsCatsBLL.Instance.Update(model); MessageBoxHelper.ResponseScript(this.Page, "updateSuccessCallback();"); } else { if (GoodsCatsBLL.Instance.GetModel(model.Id, this.PlatType) != null) { MessageBoxHelper.ResponseScript(this.Page, "showError('已经存在相应id的分类');"); return; } model.SortNum = model.Id; GoodsCatsBLL.Instance.Add(model); MessageBoxHelper.ResponseScript(this.Page, "addSuccessCallback();"); } }
private void InitPttGoodsCatIcon() { string catjson = File.ReadAllText(@"D:\WorkFolder\Hot.Haoquan\HQ.WinTester\ddkcats.txt"); string iconDir = @"D:\WorkFolder\Haoquan_ResSite\resource\images\goodscat\0\"; Dictionary <int, string> dicIcon = new Dictionary <int, string>(); string regex = "\"optID\":([^,]+),\"optType\":2,\"optName\":\"[^\"]+\",\"priority\":[^,]+,\"imgUrl\":\"([^\"]+)\\?"; MatchCollection matchs = Regex.Matches(catjson, regex); //foreach (Match match in matchs) //{ // int optId = Convert.ToInt32(match.Groups[1].Value); // string remotePath = "http:" + match.Groups[2].Value; // string fileName = optId.ToString(); // this.SaveImageFromWeb(remotePath, iconDir, fileName); //} string[] files = Directory.GetFiles(iconDir); foreach (string file in files) { string name = Path.GetFileName(file); string path = string.Format("http://res.chinaswt.cn/resource/images/goodscat/0/{0}", name); string optIdStr = Path.GetFileNameWithoutExtension(file); int optId; if (int.TryParse(optIdStr, out optId)) { GoodsCatsModel catInfo = GoodsCatsBLL.Instance.GetModel(optId, (int)HQEnums.PlatformTypeOptions.拼多多); if (catInfo != null) { catInfo.Icon = path; GoodsCatsBLL.Instance.Update(catInfo); } } } MessageBox.Show("OK"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(GoodsCatsModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(GoodsCatsModel model) { return(dal.Add(model)); }