/// <summary>
/// 设置商品类别状态
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="item_category_id">商品类别标识</param>
/// <param name="status">修改值</param>
/// <returns></returns>
public void SetItemCategoryStatus(LoggingSessionInfo loggingSessionInfo, string item_category_id, string status, out string res)
{
string strResult = string.Empty;
try
{
#region 停用限制判断
if (this.GetItemCategoryUsedInfo(item_category_id, out res) != 0)
{
return;
}
#endregion
//设置要改变的类别信息
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
itemCategoryInfo.Status = status;
itemCategoryInfo.Item_Category_Id = item_category_id;
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime(); //获取当前时间
//提交
itemCategoryService.SetUpdateStatus(itemCategoryInfo);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 查询商品类别信息
/// </summary>
/// <param name="loggingSessionInfo">登录信息</param>
/// <param name="item_category_code">号码</param>
/// <param name="item_category_name">名称</param>
/// <param name="pyzjm">拼音助记码</param>
/// <param name="status">状态</param>
/// <param name="maxRowCount">每页数量</param>
/// <param name="startRowIndex">开始行号</param>
/// <returns></returns>
public ItemCategoryInfo SearchItemCategoryList(string item_category_code
, string item_category_name
, string pyzjm
, string status
, int maxRowCount
, int startRowIndex
, string item_category_id)
{
Hashtable _ht = new Hashtable();
_ht.Add("item_category_code", item_category_code);
_ht.Add("item_category_name", item_category_name);
_ht.Add("pyzjm", pyzjm);
_ht.Add("status", status);
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
_ht.Add("item_category_id", item_category_id);
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
int iCount = itemCategoryService.SearchCount(_ht);
IList <ItemCategoryInfo> itemCategoryInfoList = new List <ItemCategoryInfo>();
DataSet ds = itemCategoryService.SearchInfoList(_ht);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
itemCategoryInfoList = DataTableToObject.ConvertToList <ItemCategoryInfo>(ds.Tables[0]);
}
itemCategoryInfo.ICount = iCount;
itemCategoryInfo.ItemCategoryInfoList = itemCategoryInfoList;
return(itemCategoryInfo);
}
/// <summary>
/// 保存商品类别信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemCategoryInfo"></param>
/// <returns></returns>
public bool SetItemCategoryTableInfo(LoggingSessionInfo loggingSessionInfo, ItemCategoryInfo itemCategoryInfo)
{
try
{
bool bReturn = false;
if (itemCategoryInfo != null)
{
itemCategoryInfo.Status = "1";
if (itemCategoryInfo.Create_User_Id == null || itemCategoryInfo.Create_User_Id.Equals(""))
{
itemCategoryInfo.Create_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Create_Time = GetCurrentDateTime();
}
if (itemCategoryInfo.Modify_User_Id == null || itemCategoryInfo.Modify_User_Id.Equals(""))
{
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime();
}
CPOS.BS.DataAccess.ItemCategoryService server = new DataAccess.ItemCategoryService(loggingSessionInfo);
bReturn = server.SetItemCategoryInfoInsert(itemCategoryInfo);
}
return(bReturn);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 获取单个商品类别信息
/// </summary>
/// <param name="Item_Category_Id"></param>
/// <returns></returns>
public ItemCategoryInfo GetItemCategoryById(string Item_Category_Id)
{
try
{
DataSet ds = new DataSet();
ds = itemCategoryService.GetItemCategoryById(Item_Category_Id);
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
itemCategoryInfo = DataTableToObject.ConvertToObject <ItemCategoryInfo>(ds.Tables[0].Rows[0]);
var objectImagesBLL = new ObjectImagesBLL(loggingSessionInfo);
var tmpImageList = objectImagesBLL.QueryByEntity(new ObjectImagesEntity()
{
ObjectId = Item_Category_Id
}, null);
if (tmpImageList != null && tmpImageList.Length > 0)
{
itemCategoryInfo.ImageUrl = tmpImageList[0].ImageURL;
}
}
return(itemCategoryInfo);
}
catch (Exception ex)
{
throw (ex);
}
}
public bool SetItemCategoryInfoInsert(ItemCategoryInfo itemCategoryInfo)
{
string sql = "INSERT INTO dbo.T_Item_Category "
+ " ( item_category_id , "
+ " item_category_code , "
+ " item_category_name , "
+ " pyzjm , "
+ " status , "
+ " parent_id , "
+ " create_user_id , "
+ " create_time , "
+ " modify_user_id , "
+ " modify_time , "
+ " bat_id , "
+ " if_flag , "
+ " CustomerID,DisplayIndex "
+ " ) "
+ " select '" + itemCategoryInfo.Item_Category_Id + "' item_category_id "
+ " ,'" + itemCategoryInfo.Item_Category_Code + "' item_category_code "
+ " ,'" + itemCategoryInfo.Item_Category_Name + "' item_category_name "
+ " ,'" + itemCategoryInfo.Pyzjm + "' pyzjm "
+ " ,'" + itemCategoryInfo.Status + "' status "
+ " ,'" + itemCategoryInfo.Parent_Id + "' parent_id "
+ " ,'" + itemCategoryInfo.Create_User_Id + "' create_user_id "
+ " ,'" + itemCategoryInfo.Create_Time + "' create_time "
+ " ,'" + itemCategoryInfo.Create_User_Id + "' modify_user_id "
+ " ,'" + itemCategoryInfo.Create_Time + "' modify_time "
+ " ,'" + itemCategoryInfo.bat_id + "' bat_id " //" ,null bat_id "
+ " ,'0' if_flag "
+ " ,'" + this.CurrentUserInfo.CurrentUser.customer_id + "' CustomerID "
+ " ,'" + itemCategoryInfo.DisplayIndex + "' DisplayIndex ";
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 设置商品类别状态
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="item_category_id">商品类别标识</param>
/// <param name="status">修改值</param>
/// <returns></returns>
public void SetItemCategoryDisplayIndex(LoggingSessionInfo loggingSessionInfo, string item_category_id, int displayindx)
{
string strResult = string.Empty;
try
{
#region 停用限制判断
//if (this.GetItemCategoryUsedInfo(item_category_id, out res) != 0)
//{
// return;
//}
#endregion
//设置要改变的类别信息
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
itemCategoryInfo.DisplayIndex = displayindx;
itemCategoryInfo.Item_Category_Id = item_category_id;
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime(); //获取当前时间
//提交
itemCategoryService.SetItemCategoryDisplayIndex(itemCategoryInfo);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 查询商品类别信息
/// </summary>
/// <param name="loggingSessionInfo">登录信息</param>
/// <param name="item_category_code">号码</param>
/// <param name="item_category_name">名称</param>
/// <param name="pyzjm">拼音助记码</param>
/// <param name="status">状态</param>
/// <param name="maxRowCount">每页数量</param>
/// <param name="startRowIndex">开始行号</param>
/// <returns></returns>
public ItemCategoryInfo SearchItemCategoryList(LoggingSessionInfo loggingSessionInfo
, string item_category_code
, string item_category_name
, string pyzjm
, string status
, int maxRowCount
, int startRowIndex)
{
Hashtable _ht = new Hashtable();
_ht.Add("item_category_code", item_category_code);
_ht.Add("item_category_name", item_category_name);
_ht.Add("pyzjm", pyzjm);
_ht.Add("status", status);
_ht.Add("StartRow", startRowIndex);
_ht.Add("EndRow", startRowIndex + maxRowCount);
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
int iCount = MSSqlMapper.Instance().QueryForObject <int>("ItemCategory.SearchCount", _ht);
IList <ItemCategoryInfo> itemCategoryInfoList = new List <ItemCategoryInfo>();
itemCategoryInfoList = MSSqlMapper.Instance().QueryForList <ItemCategoryInfo>("ItemCategory.Search", _ht);
itemCategoryInfo.ICount = iCount;
itemCategoryInfo.ItemCategoryInfoList = itemCategoryInfoList;
return(itemCategoryInfo);
//return MSSqlMapper.Instance().QueryForList<ItemCategoryInfo>("ItemCategory.Search", _ht);
}
/// <summary>
/// 保存商品类别信息
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemCategoryInfo"></param>
/// <returns></returns>
public bool SetItemCategoryTableInfo(LoggingSessionInfo loggingSessionInfo, ItemCategoryInfo itemCategoryInfo)
{
try
{
if (itemCategoryInfo != null)
{
itemCategoryInfo.Status = "1";
if (itemCategoryInfo.Create_User_Id == null || itemCategoryInfo.Create_User_Id.Equals(""))
{
itemCategoryInfo.Create_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Create_Time = GetCurrentDateTime();
}
if (itemCategoryInfo.Modify_User_Id == null || itemCategoryInfo.Modify_User_Id.Equals(""))
{
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime();
}
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("ItemCategory.InsertOrUpdate", itemCategoryInfo);
}
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btSave_Click(object sender, EventArgs e)
{
//btSave.Enabled = false;
var model = new ItemCategoryInfo();
model.Pyzjm = tbItemCategoryPYZJM.Text.Trim();
model.Item_Category_Code = tbItemCategoryCode.Text.Trim();
model.Item_Category_Name = tbItemCategoryName.Text.Trim();
//model.Parent_Name = selParentItemCategory.SelectedValue.Trim();
model.Parent_Id = selParentItemCategory.SelectedValue.Trim();
//string ResultInfo = itemCategoryService.SetItemCategoryInfo(loggingSessionInfo, model);
// this.Redirect(ResultInfo, InfoType.Info, this.Request.QueryString["from"] ?? "category_query.aspx");
var action = this.Request.QueryString["strDo"];
if (action == "Create") //新建
{
string ResultInfo = itemCategoryService.SetItemCategoryInfo(loggingSessionInfo, model);
this.Redirect(ResultInfo, InfoType.Info, this.Request.QueryString["from"] ?? "category_query.aspx");
}
else if (action == "Modify")//修改
{
var Item_Category_Id = this.Request.QueryString["Item_Category_Id"];
model.Item_Category_Id = Item_Category_Id;
string ResultInfo = itemCategoryService.SetItemCategoryInfo(loggingSessionInfo, model);
this.Redirect(ResultInfo, InfoType.Info, this.Request.QueryString["from"] ?? "category_query.aspx");
}
}
public void TestGetItemCategory_不存在的情况()
{
ItemCategoryFacade facade = new ItemCategoryFacade();
ItemCategoryInfo categoryInfo = facade.GetItemCategoryById("50011665");
#region 验证后置条件
Assert.IsNull(categoryInfo);
#endregion
}
/// <summary>
/// 更新Item Category表打包标识方法
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="bat_id">批次标识</param>
/// <returns></returns>
public bool SetItemCategoryIfFlagInfo(LoggingSessionInfo loggingSessionInfo, string bat_id)
{
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
itemCategoryInfo.bat_id = bat_id;
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime();
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("ItemCategory.UpdateUnDownloadIfFlag", itemCategoryInfo);
return(true);
}
/// <summary>
/// 设置打包批次号
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="bat_id">批次号</param>
/// <param name="ItemCategoryInfoList">商品集合</param>
/// <returns></returns>
public bool SetItemCategoryBatInfo(LoggingSessionInfo loggingSessionInfo, string bat_id, IList <ItemCategoryInfo> ItemCategoryInfoList)
{
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime();
itemCategoryInfo.bat_id = bat_id;
itemCategoryInfo.ItemCategoryInfoList = ItemCategoryInfoList;
cSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("ItemCategory.UpdateUnDownloadBatId", itemCategoryInfo);
return(true);
}
/// <summary>
/// 修改状态
/// </summary>
/// <param name="itemCategoryInfo"></param>
/// <returns></returns>
public bool SetUpdateStatus(ItemCategoryInfo itemCategoryInfo)
{
string sql = "update t_item_category "
+ " set status = '" + itemCategoryInfo.Status + "' "
+ " ,if_flag = '0' "
+ " ,Modify_Time = '" + itemCategoryInfo.Modify_Time + "' "
+ " ,Modify_User_Id = '" + itemCategoryInfo.Modify_User_Id + "' "
+ " where item_category_id = '" + itemCategoryInfo.Item_Category_Id + "' ;";
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// 修改顺序
/// </summary>
/// <param name="itemCategoryInfo"></param>
/// <returns></returns>
public bool SetItemCategoryDisplayIndex(ItemCategoryInfo itemCategoryInfo)
{
string sql = "update t_item_category "
+ " set DisplayIndex = '" + itemCategoryInfo.DisplayIndex + "' "
+ " ,Modify_Time = '" + itemCategoryInfo.Modify_Time + "' "
+ " ,Modify_User_Id = '" + itemCategoryInfo.Modify_User_Id + "' "
+ " where item_category_id = '" + itemCategoryInfo.Item_Category_Id + "' ;";
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
public bool SetItemCategoryInfoUpdate(ItemCategoryInfo itemCategoryInfo)
{
bool bReturn = false;
string sql = "update t_item_category set item_category_id = '" + itemCategoryInfo.Item_Category_Id + "'";
if (itemCategoryInfo != null || itemCategoryInfo.Item_Category_Code != null)
{
sql += ",item_category_code='" + itemCategoryInfo.Item_Category_Code + "'";
}
if (itemCategoryInfo != null || itemCategoryInfo.Item_Category_Name != null)
{
sql += ",item_category_name = '" + itemCategoryInfo.Item_Category_Name + "'";
}
if (itemCategoryInfo != null || itemCategoryInfo.Pyzjm != null)
{
sql += ",Pyzjm = '" + itemCategoryInfo.Pyzjm + "'";
}
if (itemCategoryInfo != null && itemCategoryInfo.DisplayIndex != null)
{
sql += ",DisplayIndex = " + itemCategoryInfo.DisplayIndex + "";
}
if (itemCategoryInfo != null || itemCategoryInfo.Status != null)
{
sql += ",Status = '" + itemCategoryInfo.Status + "'";
}
if (itemCategoryInfo != null || itemCategoryInfo.Parent_Id != null)
{
sql += ",Parent_Id = '" + itemCategoryInfo.Parent_Id + "'";
}
sql += " ,modify_user_id = '" + this.CurrentUserInfo.CurrentLoggingManager.User_Id + "' ";
sql += " ,modify_time = '" + GetCurrentDateTime() + "' ";
sql += " ,if_flag = '0' ";
sql += " where item_category_id = '" + itemCategoryInfo.Item_Category_Id + "' ";
var result = this.SQLHelper.ExecuteNonQuery(sql);
bReturn = (result > 0) ? true : false;
return(bReturn);
}
/// <summary>
/// 保存商品类别（新建或者修改）
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemCategoryInfo"></param>
/// <returns></returns>
public string SetItemCategoryInfo(LoggingSessionInfo loggingSessionInfo, ItemCategoryInfo itemCategoryInfo)
{
string strResult = string.Empty;
//事物信息
MSSqlMapper.Instance().BeginTransaction();
try
{
//处理是新建还是修改
if (itemCategoryInfo.Item_Category_Id == null || itemCategoryInfo.Item_Category_Id.Equals(""))
{
itemCategoryInfo.Item_Category_Id = NewGuid();
}
else
{
}
//1 判断组织号码是否唯一
if (!IsExistItemCategoryCode(loggingSessionInfo, itemCategoryInfo.Item_Category_Code, itemCategoryInfo.Item_Category_Id))
{
strResult = "商品类别号码已经存在。";
return(strResult);
}
//2.提交用户信息
if (!SetItemCategoryTableInfo(loggingSessionInfo, itemCategoryInfo))
{
strResult = "提交用户表失败";
return(strResult);
}
MSSqlMapper.Instance().CommitTransaction();
strResult = "保存成功!";
return(strResult);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 设置商品类别状态
/// </summary>
/// <param name="loggingSessionInfo">登录model</param>
/// <param name="item_category_id">商品类别标识</param>
/// <param name="status">修改值</param>
/// <returns></returns>
public string SetItemCategoryStatus(LoggingSessionInfo loggingSessionInfo, string item_category_id, string status)
{
string strResult = string.Empty;
try
{
//设置要改变的用户信息
ItemCategoryInfo itemCategoryInfo = new ItemCategoryInfo();
itemCategoryInfo.Status = status;
itemCategoryInfo.Item_Category_Id = item_category_id;
itemCategoryInfo.Modify_User_Id = loggingSessionInfo.CurrentUser.User_Id;
itemCategoryInfo.Modify_Time = GetCurrentDateTime(); //获取当前时间
//提交
MSSqlMapper.Instance(loggingSessionInfo.CurrentLoggingManager).Update("ItemCategory.UpdateStatus", itemCategoryInfo);
strResult = "状态修改成功.";
}
catch (Exception ex)
{
throw (ex);
}
return(strResult);
}
/// <summary>
/// 根据ID获取商品分类信息
/// </summary>
public string GetItemCategoryByID()
{
var itemCategoryService = new ItemCategoryService(CurrentUserInfo);
ItemCategoryInfo data = new ItemCategoryInfo();
string content = string.Empty;
string key = string.Empty;
if (Request("ItemCategoryId") != null && Request("ItemCategoryId") != string.Empty)
{
key = Request("ItemCategoryId").ToString().Trim();
}
data = itemCategoryService.GetItemCategoryById(key);
var jsonData = new JsonData();
jsonData.totalCount = data == null ? "0" : "1";
jsonData.data = data;
content = jsonData.ToJSON();
return(content);
}
public void TestGetItemCategory_已经存在的情况()
{
#region 验证前置条件
ItemCategory category = new ItemCategory();
category.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
category.CategoryId = "50011665";
category.Name = "测试类目";
category.ParentId = "0";
category.IsParent = true;
category.SortOrder = 1;
category.Status = "normal";
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate = manager.GetCreateSql(category);
using (DbOperator dbOperator = new DbOperator(connString))
{
dbOperator.ExecSql(sqlCreate);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
ItemCategoryInfo categoryInfo = facade.GetItemCategoryById("50011665");
#region 验证后置条件
Assert.IsNotNull(categoryInfo);
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", categoryInfo.Id);
Assert.AreEqual("50011665", categoryInfo.CategoryId);
Assert.AreEqual("测试类目", categoryInfo.Name);
Assert.AreEqual("0", categoryInfo.ParentId);
Assert.AreEqual(true, categoryInfo.IsParent);
Assert.AreEqual(1, categoryInfo.SortOrder);
Assert.AreEqual("normal", categoryInfo.Status);
#endregion
}
/// <summary>
/// 获取商品分类
/// </summary>
public string GetItemCategoryListData()
{
var form = Request("form").DeserializeJSONTo <ItemCategoryQueryEntity>();
var itemCategoryService = new ItemCategoryService(CurrentUserInfo);
ItemCategoryInfo data = new ItemCategoryInfo();
string content = string.Empty;
string item_category_code = FormatParamValue(form.item_category_code);
string item_category_name = FormatParamValue(form.item_category_name);
string pyzjm = FormatParamValue(form.pyzjm);
string item_category_status = FormatParamValue(Request("item_category_status"));
string item_category_id = FormatParamValue(Request("item_category_id"));
int maxRowCount = PageSize;
int startRowIndex = Utils.GetIntVal(Request("start"));
string key = string.Empty;
if (Request("item_category_id") != null && Request("item_category_id") != string.Empty)
{
key = Request("item_category_id").ToString().Trim();
}
data = itemCategoryService.SearchItemCategoryList(
item_category_code, item_category_name, pyzjm, item_category_status,
maxRowCount, startRowIndex, item_category_id);
var jsonData = new JsonData();
jsonData.totalCount = data.ItemCategoryInfoList.Count.ToString();
jsonData.data = data.ItemCategoryInfoList;
content = string.Format("{{\"totalCount\":{1},\"topics\":{0}}}",
data.ItemCategoryInfoList.ToJSON(),
data.ICount);
return(content);
}
/// <summary>
/// 商品分类信息
/// </summary>
public string SaveItemCategory()
{
var itemCategoryService = new ItemCategoryService(CurrentUserInfo);
ItemCategoryInfo itemCategory = new ItemCategoryInfo();
string content = string.Empty;
var responseData = new ResponseData();
string key = string.Empty;
string ItemCategoryId = string.Empty;
if (Request("itemCategorys") != null && Request("itemCategorys") != string.Empty)
{
key = Request("itemCategorys").ToString().Trim();
}
if (Request("ItemCategoryId") != null && Request("ItemCategoryId") != string.Empty)
{
ItemCategoryId = Request("ItemCategoryId").ToString().Trim();
}
itemCategory = key.DeserializeJSONTo <ItemCategoryInfo>();
if (itemCategory.Item_Category_Code == null || itemCategory.Item_Category_Code.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "类型编码不能为空";
return(responseData.ToJSON());
}
if (itemCategory.Item_Category_Name == null || itemCategory.Item_Category_Name.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "类型名称不能为空";
return(responseData.ToJSON());
}
if (itemCategory.Status == null || itemCategory.Status.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "状态不能为空";
return(responseData.ToJSON());
}
if (itemCategory.Parent_Id == null || itemCategory.Parent_Id.Trim().Length == 0)
{
responseData.success = false;
responseData.msg = "上级商品名称不能为空";
return(responseData.ToJSON());
}
itemCategory.Create_User_Id = CurrentUserInfo.CurrentUser.User_Id;
itemCategory.Create_Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
itemCategory.Create_User_Name = CurrentUserInfo.CurrentUser.User_Name;
itemCategory.CustomerID = CurrentUserInfo.CurrentUser.customer_id;
if (ItemCategoryId.Trim().Length != 0)
{
itemCategory.Item_Category_Id = ItemCategoryId;
}
bool status = true;
string message = "保存成功";
try
{
itemCategoryService.SetItemCategoryInfo(CurrentUserInfo, itemCategory);
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
responseData.success = status;
responseData.msg = message;
content = responseData.ToJSON();
return(content);
}
/// <summary>
/// 保存商品类别（新建或者修改）
/// </summary>
/// <param name="loggingSessionInfo"></param>
/// <param name="itemCategoryInfo"></param>
/// <returns></returns>
public string SetItemCategoryInfo(LoggingSessionInfo loggingSessionInfo, ItemCategoryInfo itemCategoryInfo)
{
string strResult = string.Empty;
//事物信息
//cSqlMapper.Instance().BeginTransaction();
try
{
//处理是新建还是修改
if (itemCategoryInfo.Item_Category_Id == null || itemCategoryInfo.Item_Category_Id.Equals(""))
{
//如果是新建，并且没有传值给DisplayIndex，就取他所在子类里最大的displayindex+1
if (itemCategoryInfo.DisplayIndex == null || itemCategoryInfo.DisplayIndex == 0)
{
int displayindex = 0;
//获取他的父类下的子分类的
IList <ItemCategoryInfo> list = GetItemCategoryListByParentId(itemCategoryInfo.Parent_Id).OrderByDescending(p => p.DisplayIndex).ToList();
if (list != null && list.Count() != 0)
{
int oldDisplayIndex = list[0].DisplayIndex == null?0: (int)list[0].DisplayIndex;
displayindex = oldDisplayIndex + 1;
}
itemCategoryInfo.DisplayIndex = displayindex;
}
itemCategoryInfo.Item_Category_Id = NewGuid();
//2.提交用户信息
if (!SetItemCategoryTableInfo(loggingSessionInfo, itemCategoryInfo))
{
strResult = "提交用户表失败";
return(strResult);
}
}
else
{
CPOS.BS.DataAccess.ItemCategoryService server = new DataAccess.ItemCategoryService(loggingSessionInfo);
strResult = server.SetItemCategoryInfoUpdate(itemCategoryInfo).ToString();
}
var objectImagesBLL = new ObjectImagesBLL(loggingSessionInfo);
var tmpImageList = objectImagesBLL.QueryByEntity(new ObjectImagesEntity()
{
ObjectId = itemCategoryInfo.Item_Category_Id
}, null);
if (tmpImageList != null && tmpImageList.Length > 0)
{
foreach (var tmpImageItem in tmpImageList)
{
objectImagesBLL.Delete(tmpImageItem);
}
}
if (itemCategoryInfo.ImageUrl != null && itemCategoryInfo.ImageUrl.Length > 0)
{
objectImagesBLL.Create(new ObjectImagesEntity()
{
ImageId = NewGuid(),
ObjectId = itemCategoryInfo.Item_Category_Id,
ImageURL = itemCategoryInfo.ImageUrl
});
}
strResult = "保存成功!";
return(strResult);
}
catch (Exception ex)
{
throw (ex);
}
//return "";
}
private TreeViewNode GetNodeByItemCategory(ItemCategoryInfo category)
{
return(GetNodeByItemCategory(category.Name, category.CategoryId, category.IsParent));
}
public void TestGetItemCategoryListByParent_父子数据情况()
{
#region 验证前置条件
ItemCategory category1 = new ItemCategory();
category1.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53919";
category1.CategoryId = "50011665";
category1.Name = "测试类目1";
category1.ParentId = "0";
category1.IsParent = true;
category1.SortOrder = 1;
category1.Status = "normal";
ItemCategory category2 = new ItemCategory();
category2.Id = "c2ecf0ef-dc5b-4308-9f38-047453d53929";
category2.CategoryId = "50011667";
category2.Name = "测试类目2";
category2.ParentId = "50011665";
category2.IsParent = true;
category2.SortOrder = 0;
category2.Status = "deleted";
ItemCategoryManager manager = new ItemCategoryManager();
string sqlCreate1 = manager.GetCreateSql(category1);
string sqlCreate2 = manager.GetCreateSql(category2);
using (DbOperator dbOperator = new DbOperator(connString))
{
dbOperator.ExecSql(sqlCreate1);
dbOperator.ExecSql(sqlCreate2);
}
#endregion
ItemCategoryFacade facade = new ItemCategoryFacade();
#region 验证后置条件
List <ItemCategoryInfo> list1 = facade.GetItemCategoryListByParent(string.Empty);
Assert.AreEqual(1, list1.Count);
ItemCategoryInfo categoryInfo1 = list1[0];
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53919", categoryInfo1.Id);
Assert.AreEqual("50011665", categoryInfo1.CategoryId);
Assert.AreEqual("测试类目1", categoryInfo1.Name);
Assert.AreEqual("0", categoryInfo1.ParentId);
Assert.AreEqual(true, categoryInfo1.IsParent);
Assert.AreEqual(1, categoryInfo1.SortOrder);
Assert.AreEqual("normal", categoryInfo1.Status);
List <ItemCategoryInfo> list2 = facade.GetItemCategoryListByParent("50011665");
ItemCategoryInfo categoryInfo2 = list2[0];
Assert.AreEqual("c2ecf0ef-dc5b-4308-9f38-047453d53929", categoryInfo2.Id);
Assert.AreEqual("50011667", categoryInfo2.CategoryId);
Assert.AreEqual("测试类目2", categoryInfo2.Name);
Assert.AreEqual("50011665", categoryInfo2.ParentId);
Assert.AreEqual(true, categoryInfo2.IsParent);
Assert.AreEqual(0, categoryInfo2.SortOrder);
Assert.AreEqual("deleted", categoryInfo2.Status);
#endregion
}
