/// <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));
}
