/// <summary>
/// 更新任务表中的自定义集合字段(把所有自定义字段拼接成一个大字符串保存)
/// </summary>
protected void UpdateGoodsTable(string goodsId)
{
string info = "";
StarTech.DBUtility.AdoHelper ado = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance);
DataSet ds = ado.ExecuteSqlDataset("select * from T_Goods_MoreProperty where goodsId='" + this.id + "'");
DataSet dsSet = ado.ExecuteSqlDataset("select * from T_Goods_MorePropertySet");
foreach (DataRow row in ds.Tables[0].Rows)
{
DataRow[] rowsSet = dsSet.Tables[0].Select("PropertyId='" + row["PropertyId"].ToString() + "'");
if (rowsSet.Length > 0)
{
info += "{" + row["PropertyId"].ToString() + "$" + rowsSet[0]["propertyName"].ToString() + "$" + row["PropertyValue"].ToString().Replace("'", "’") + "}";
}
}
ado.ExecuteSqlNonQuery("update T_Goods_Info set MorePropertys='" + info + "' where goodsId='" + goodsId + "'");
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
GoodsTypeModel mod;
if (this.id != "" && this.id != null)
{
mod = bll.GetModel(this.id);
}
else
{
mod = new GoodsTypeModel();
}
string pPath = "";
string[] codeList = this.cSelect.hfCode.Split('|');
StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance");
if (codeList.Length < 1 || cSelect.hfCode == "")
{
mod.PCategoryId = "";
mod.CategoryLevel = 1;
mod.CategoryPath = mod.CategoryId;
}
else
{
//if(this.cSelect.categoryID)
mod.PCategoryId = codeList[codeList.Length - 1];
DataSet ds = adoHelper.ExecuteSqlDataset("select * from T_Info_Category where categoryid='" + KillSqlIn.Form_ReplaceByString(mod.PCategoryId, 20) + "';");
mod.CategoryLevel = Convert.ToInt32(ds.Tables[0].Rows[0]["CategoryLevel"].ToString()) + 1;
pPath = ds.Tables[0].Rows[0]["CategoryPath"].ToString();
}
if (pPath != "")
{
pPath += ",";
}
mod.CategoryName = this.txtMenuName.Text.Trim();
//mod.CategoryPath=
//mod.Remarks = this.txtRemarks.Text.Trim();
int orderdy = 0;
int.TryParse(this.txtSort.Text.Trim(), out orderdy);
mod.Orderby = orderdy;
mod.CategoryFlag = (this.cbIsVisible.Checked == true) ? "Course" : "Category";
if (fuImg.FileName != null && fuImg.FileName != "")
{
//mod.Url = fuImg.FileName;
string nowUrl = Guid.NewGuid().ToString();
string tzm = fuImg.FileName.Substring(fuImg.FileName.LastIndexOf("."));
string url = "/upload/Category/" + nowUrl + "" + tzm;
fuImg.SaveAs(Server.MapPath("~" + url));
mod.Url = url;
}
if (this.id != "" && this.id != null)
{
if (this.id == mod.PCategoryId)
{
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('上级分类不能选择当前分类');layer_close_refresh();</script>");
return;
}
mod.CategoryPath = pPath + mod.CategoryId;
if (bll.Update(mod))
{
LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "修改任务分类《" + mod.CategoryName + "》", "修改", "", "", HttpContext.Current.Request.Url.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>");
}
}
else
{
mod.CategoryId = IdCreator.CreateId("T_Info_Category", "CategoryId");
mod.CategoryPath = pPath + mod.CategoryId;
bll.Add(mod);
LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "添加任务分类《" + mod.CategoryName + "》;", "添加", "", "", HttpContext.Current.Request.Url.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>");
//JSUtility.ReplaceOpenerParentWindow("menuTree.aspx");
}
//ModMenu detail = new ModMenu();
//detail.menuName = this.txtMenuName.Text.Trim();
//detail.menuTarget = this.txtMenuLink.Text.Trim();
//detail.isShow = (this.cbIsVisible.Checked == true ? 1 : 0);
//detail.orderIndex = Convert.ToInt32(this.txtSort.Text.Trim());
//detail.parentMenuId = Convert.ToInt32(this.cSelect.categoryID);
//if (this._menuId != null)
//{
// int menuId = Convert.ToInt32(this._menuId);
// detail.uniqueId = menuId;
// this._menu.Update(detail);
// ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>");
//}
//else
//{
// this._menu.Add(detail);
// ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>");
// //JSUtility.ReplaceOpenerParentWindow("menuTree.aspx");
//}
}
