/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
ProductCategorySalesStatusModel productcategorysalesstatus = new ProductCategorySalesStatusModel();
ret = DbUtil.Current.DeleteMultiple(productcategorysalesstatus, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="productcategorysalesstatus">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(ProductCategorySalesStatusModel productcategorysalesstatus, ParameterCollection pc)
{
int ret = 0;
productcategorysalesstatus.ModifiedBy = SessionUtil.Current.UserId;
productcategorysalesstatus.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(productcategorysalesstatus, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="productcategorysalesstatus">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(ProductCategorySalesStatusModel productcategorysalesstatus)
{
int ret = 0;
productcategorysalesstatus.ModifiedBy = SessionUtil.Current.UserId;
productcategorysalesstatus.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(productcategorysalesstatus);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="salesstatusid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string salesstatusid)
{
int ret = 0;
ProductCategorySalesStatusModel productcategorysalesstatus = new ProductCategorySalesStatusModel();
productcategorysalesstatus.SalesStatusId = salesstatusid;
ret = DbUtil.Current.Delete(productcategorysalesstatus);
return(ret);
}
/// <summary>
/// 新建
/// </summary>
/// <param name="productcategorysalesstatus">实体</param>
/// <returns>影响的记录行数</returns>
public int Create(ProductCategorySalesStatusModel productcategorysalesstatus)
{
int ret = 0;
productcategorysalesstatus.CreatedBy = (SessionUtil.Current == null) ? "C792D747-6B74-4A58-BB5B-D98EF420F99F" : SessionUtil.Current.UserId;
productcategorysalesstatus.CreatedOn = DateTime.Now;
productcategorysalesstatus.ModifiedBy = (SessionUtil.Current == null) ? "C792D747-6B74-4A58-BB5B-D98EF420F99F" : SessionUtil.Current.UserId;
productcategorysalesstatus.ModifiedOn = DateTime.Now;
productcategorysalesstatus.StatusCode = 0;
ret = DbUtil.Current.Create(productcategorysalesstatus);
return(ret);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <ProductCategorySalesStatusModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <ProductCategorySalesStatusModel> productcategorysalesstatuss = new List <ProductCategorySalesStatusModel>();
ProductCategorySalesStatusModel productcategorysalesstatus = new ProductCategorySalesStatusModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(productcategorysalesstatus, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
productcategorysalesstatus = new ProductCategorySalesStatusModel();
productcategorysalesstatus.ConvertFrom(dt, i);
productcategorysalesstatuss.Add(productcategorysalesstatus);
}
return(productcategorysalesstatuss);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="salesstatusid"></param>
/// <returns>实体</returns>
public ProductCategorySalesStatusModel Retrieve(string salesstatusid)
{
ProductCategorySalesStatusModel productcategorysalesstatus = new ProductCategorySalesStatusModel();
productcategorysalesstatus.SalesStatusId = salesstatusid;
DataTable dt = DbUtil.Current.Retrieve(productcategorysalesstatus);
if (dt.Rows.Count < 1)
{
return(null);
}
productcategorysalesstatus.ConvertFrom(dt);
return(productcategorysalesstatus);
}
public JsonResult DoAddProductCategorySaleStatus()
{
ProductCategorySalesStatusModel statusInfo = new ProductCategorySalesStatusModel();
statusInfo.ProductCategoryId = GetFormData("categoryId");
statusInfo.SalestatusName = GetFormData("statusName");
statusInfo.Description = GetFormData("statusDesc");
statusInfo.Status = Convert.ToInt32(GetFormData("Status"));
string message = "操作失败，请与管理员联系";
if (ProductCategorySalesStatusService.Instance.CreateProductCategorySaleStatus(statusInfo, out message))
{
return(SuccessedJson(message, "ProductCenter_ProductCategorySaleStatus", "ProductCenter_ProductCategorySaleStatus", "forward", "/productcenter/ProductCategorySaleStatus?catid=" + statusInfo.ProductCategoryId.ToString() + "&=" + DateTime.Now.ToString("yyyyMMddHHmmssfff")));
}
else
{
return(FailedJson(message));
}
}
public bool CreateProductCategorySaleStatus(ProductCategorySalesStatusModel statusInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
ProductCategoryInfoModel catInfo = ProductCategoryInfoService.Instance.GetProductCategoryInfoById(statusInfo.ProductCategoryId);
if (catInfo == null)
{
message = "操作失败，不存在产品类型信息";
return(false);
}
Dictionary <string, ProductCategorySalesStatusModel> dict = GetProductCategorySalesStatusList(catInfo.ProductCategoryId, false);
if (dict != null)
{
foreach (ProductCategorySalesStatusModel item in dict.Values)
{
if (item.SalestatusName == statusInfo.SalestatusName)
{
message = "操作失败，存在相同名称的销售状态";
return(false);
}
}
}
statusInfo.SalesStatusId = Guid.NewGuid().ToString();
statusInfo.SortOrder = (dict == null) ? 1 : dict.Count + 1;
if (Create(statusInfo) == 1)
{
GetProductCategorySalesStatusList(statusInfo.ProductCategoryId, true);
result = true;
message = "成功创建本产品类型销售状态";
}
return(result);
}
public bool UpdateProductCategorySaleStatus(ProductCategorySalesStatusModel statusInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
ProductCategoryInfoModel catInfo = ProductCategoryInfoService.Instance.GetProductCategoryInfoById(statusInfo.ProductCategoryId);
if (catInfo == null)
{
message = "操作失败，不存在产品类型信息";
return(false);
}
Dictionary <string, ProductCategorySalesStatusModel> dict = GetProductCategorySalesStatusList(catInfo.ProductCategoryId, false);
if (dict != null)
{
foreach (ProductCategorySalesStatusModel item in dict.Values)
{
if (item.SalestatusName == statusInfo.SalestatusName && item.SalesStatusId != statusInfo.SalesStatusId)
{
message = "操作失败，存在相同名称的销售状态";
return(false);
}
}
}
if (Update(statusInfo) == 1)
{
GetProductCategorySalesStatusList(statusInfo.ProductCategoryId, true);
result = true;
message = "成功更新本产品类型销售状态";
}
return(result);
}
/// <summary>
/// 创建产品型信息。
/// </summary>
/// <param name="categoryInfo"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool CreateProductCategory(ProductCategoryInfoModel categoryInfo, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
if (categoryInfo == null || string.IsNullOrEmpty(categoryInfo.CategoryName))
{
message = "缺少参数，请与管理员联系";
return(false);
}
Dictionary <string, ProductCategoryInfoModel> dict = GetProductCategoryList(false);
if (dict != null)
{
foreach (ProductCategoryInfoModel item in dict.Values)
{
if (item.CategoryName == categoryInfo.CategoryName)
{
message = "操作失败，当前存在相同的产品类型名称";
return(false);
}
}
}
CustomDataDomainModel SaleCity = CustomDataInfoService.Instance.GetCustomDataDomainModelByName("销售城市", false);
string saleCityString = null;
foreach (CustomDataValueDomainModel item in SaleCity.ValueList.Values)
{
saleCityString += item.DataValue + " ";
}
categoryInfo.ProductCategoryId = GetGuid();
categoryInfo.SortOrder = (dict == null) ? 1 : dict.Count + 1;
categoryInfo.TableName = "product_info_" + CharacterUtil.ConvertToPinyin(categoryInfo.CategoryName);
#region 创建表字段
List <FieldInfo> fieldList = new List <FieldInfo>();
FieldInfo field = new FieldInfo();
field.FieldName = "product_id";
field.FieldType = "varchar";
field.MinLength = 50;
field.MaxLength = 50;
field.IsNull = false;
field.IsPrimaryKey = true;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "product_category_id";
field.FieldType = "varchar";
field.MinLength = 50;
field.MaxLength = 50;
field.IsNull = false;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "category_group_id";
field.FieldType = "varchar";
field.MinLength = 50;
field.MaxLength = 50;
field.IsNull = false;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "item_price";
field.FieldType = "decimal";
field.MinLength = 18;
field.MaxLength = 2;
field.DefaultValue = "0";
field.IsNull = false;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "created_on";
field.FieldType = "datetime";
field.IsNull = false;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "created_by";
field.FieldType = "varchar";
field.MinLength = 50;
field.MaxLength = 50;
field.IsNull = false;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "modified_on";
field.FieldType = "datetime";
field.IsNull = true;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "modified_by";
field.FieldType = "varchar";
field.MinLength = 50;
field.MaxLength = 50;
field.IsNull = true;
field.IsPrimaryKey = false;
fieldList.Add(field);
field = new FieldInfo();
field.FieldName = "status_code";
field.FieldType = "int";
field.IsNull = true;
fieldList.Add(field);
string createTableSql = DTableUtil.GetCreateTableSQL(categoryInfo.TableName, fieldList);
#endregion
try
{
BeginTransaction();
ExecuteNonQuery(createTableSql);
if (Create(categoryInfo) == 1)
{
GetProductCategoryList(true);
#region 创建默认字段
ProductCategoryAttributesModel att = new ProductCategoryAttributesModel();
att.AttributeName = "产品代码";
att.CategoryAttributeId = GetGuid();
att.FieldMinLength = 50;
att.FieldType = "string";
att.IsDisplay = 0;
att.IsRequest = 0;
att.NodeId = 0;
att.ProductCategoryId = categoryInfo.ProductCategoryId;
att.SortOrder = 1;
att.Status = 0;
if (!ProductCategoryAttributesService.Instance.CreateProductCategoryAttribute(att, out message))
{
RollbackTransaction();
return(false);
}
ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(categoryInfo.ProductCategoryId, true);
att = new ProductCategoryAttributesModel();
att.AttributeName = "产品名称";
att.CategoryAttributeId = GetGuid();
att.FieldMinLength = 50;
att.FieldType = "string";
att.IsDisplay = 0;
att.IsRequest = 0;
att.NodeId = 0;
att.ProductCategoryId = categoryInfo.ProductCategoryId;
att.SortOrder = 2;
att.Status = 0;
if (!ProductCategoryAttributesService.Instance.CreateProductCategoryAttribute(att, out message))
{
RollbackTransaction();
return(false);
}
ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(categoryInfo.ProductCategoryId, true);
att = new ProductCategoryAttributesModel();
att.AttributeName = "销售状态";
att.CategoryAttributeId = GetGuid();
att.FieldMinLength = 50;
att.FieldType = "custom";
att.CustomValue = "已建档";
att.IsDisplay = 0;
att.IsRequest = 0;
att.NodeId = 0;
att.ProductCategoryId = categoryInfo.ProductCategoryId;
att.SortOrder = 3;
att.Status = 0;
if (!ProductCategoryAttributesService.Instance.CreateProductCategoryAttribute(att, out message))
{
RollbackTransaction();
return(false);
}
ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(categoryInfo.ProductCategoryId, true);
att = new ProductCategoryAttributesModel();
att.AttributeName = "销售城市";
att.CategoryAttributeId = GetGuid();
att.FieldMinLength = 50;
att.FieldType = "custom";
att.CustomValue = "所有";
att.IsDisplay = 0;
att.IsRequest = 0;
att.NodeId = 0;
att.ProductCategoryId = categoryInfo.ProductCategoryId;
att.SortOrder = 3;
att.Status = 0;
if (!ProductCategoryAttributesService.Instance.CreateProductCategoryAttribute(att, out message))
{
RollbackTransaction();
return(false);
}
ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(categoryInfo.ProductCategoryId, true);
att = new ProductCategoryAttributesModel();
att.AttributeName = "销售价格";
att.CategoryAttributeId = GetGuid();
att.FieldMinLength = 18;
att.FieldMaxLength = 2;
att.FieldType = "decimal";
att.CustomValue = "0";
att.IsDisplay = 0;
att.IsRequest = 0;
att.NodeId = 0;
att.ProductCategoryId = categoryInfo.ProductCategoryId;
att.SortOrder = 4;
att.Status = 0;
if (!ProductCategoryAttributesService.Instance.CreateProductCategoryAttribute(att, out message))
{
RollbackTransaction();
return(false);
}
ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(categoryInfo.ProductCategoryId, true);
#endregion
#region 创建默认的销售状态
ProductCategorySalesStatusModel saleStatus = new ProductCategorySalesStatusModel();
saleStatus.ProductCategoryId = categoryInfo.ProductCategoryId;
saleStatus.SalesStatusId = GetGuid();
saleStatus.SalestatusName = "已建档";
saleStatus.SortOrder = 1;
saleStatus.Status = 0;
if (!ProductCategorySalesStatusService.Instance.CreateProductCategorySaleStatus(saleStatus, out message))
{
RollbackTransaction();
return(false);
}
ProductCategorySalesStatusService.Instance.GetProductCategorySalesStatusList(categoryInfo.ProductCategoryId, true);
#endregion
#region 创建默认的销售城市
ProductCategorySalesStatusModel saleCityList = new ProductCategorySalesStatusModel();
saleCityList.ProductCategoryId = categoryInfo.ProductCategoryId;
saleCityList.SalesStatusId = GetGuid();
saleCityList.SalestatusName = "所有";
saleCityList.SortOrder = 1;
saleCityList.Status = 0;
if (!ProductCategorySalesStatusService.Instance.CreateProductCategorySaleStatus(saleCityList, out message))
{
RollbackTransaction();
return(false);
}
ProductCategorySalesStatusService.Instance.GetProductCategorySalesStatusList(categoryInfo.ProductCategoryId, true);
#endregion
ProductCategoryAttributesService.Instance.GetProductCategoryAttributeList(categoryInfo.ProductCategoryId, true);
GetProductCategoryList(true);
message = "成功创建产品类型信息";
result = true;
CommitTransaction();
}
else
{
RollbackTransaction();
message = "创建产品类型信息失败";
result = false;
}
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("创建产品类型异常", ex);
throw ex;
}
return(result);
}
public bool MoveUpProductCategorySaleStatus(string categoryId, string statusId, out string message)
{
bool result = false;
message = "操作失败，请与管理员联系";
Dictionary <string, ProductCategorySalesStatusModel> dict = GetProductCategorySalesStatusList(categoryId, false);
if (dict == null)
{
message = "操作失败，不存在的产品类型ID";
return(false);
}
ProductCategorySalesStatusModel currInfo = GetProductCategorySalesStatusInfoById(categoryId, statusId);
if (currInfo == null)
{
message = "操作失败，不存在的产品类型销售状态ID";
return(false);
}
if (currInfo.SortOrder == 1)
{
message = "操作失败，当前产品类型销售状态已经是最上序列";
return(false);
}
ProductCategorySalesStatusModel upInfo = null;
foreach (ProductCategorySalesStatusModel item in dict.Values)
{
if (item.SortOrder == currInfo.SortOrder - 1)
{
upInfo = item;
break;
}
}
currInfo.SortOrder = currInfo.SortOrder - 1;
upInfo.SortOrder = upInfo.SortOrder + 1;
try
{
BeginTransaction();
if (Update(currInfo) == 1 && Update(upInfo) == 1)
{
CommitTransaction();
GetProductCategorySalesStatusList(categoryId, true);
result = true;
message = "成功上移选中产品类型销售状态";
}
else
{
RollbackTransaction();
result = false;
message = "操作失败，上移选中产品类型销售状态失败";
}
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("上移选中产品类型销售状态异常", ex);
result = false;
message = "操作失败，上移选中产品类型销售状态异常";
}
return(result);
}
