public bool DeleteByIds(string propIds, TagsTypeEntity TagsTypeEn)
{
string sql = "update Tags set ";
sql += " isdelete=1 ";
sql += " ,LastUpdateBy='" + TagsTypeEn.LastUpdateBy + "' ";
sql += " ,LastUpdateTime='" + TagsTypeEn.LastUpdateTime + "' ";
sql += " where TypeId='" + TagsTypeEn.TypeId + "'";
sql += " and TagsId not in (" + propIds + ") ";
this.SQLHelper.ExecuteNonQuery(sql);
return(true);
}
/// <summary>
/// GetList
/// </summary>
/// <param name="entity">entity</param>
/// <param name="Page">分页页码。从0开始</param>
/// <param name="PageSize">每页的数量。未指定时默认为15</param>
/// <returns></returns>
public IList <TagsTypeEntity> GetList(TagsTypeEntity entity, int Page, int PageSize)
{
if (PageSize <= 0)
{
PageSize = 15;
}
IList <TagsTypeEntity> list = new List <TagsTypeEntity>();
DataSet ds = new DataSet();
ds = _currentDAO.GetList(entity, Page, PageSize);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
list = DataTableToObject.ConvertToList <TagsTypeEntity>(ds.Tables[0]);
}
return(list);
}
/// <summary>
/// 删除
/// </summary>
public string DeleteTagsType(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <DeleteTagsTypeRP> >();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rd = new DeleteTagsTypeRD();//返回值
var TypeId = rp.Parameters.TypeId;
if (string.IsNullOrEmpty(TypeId))
{
throw new APIException("缺少参数【TypeId】或参数值为空")
{
ErrorCode = 135
};
}
TagsTypeBLL TagsTypeBLL = new TagsTypeBLL(loggingSessionInfo);
TagsTypeEntity TagsTypeEn = TagsTypeBLL.GetByID(TypeId);
if (TagsTypeEn == null)
{
throw new APIException("没有找到对应的标签类型")
{
ErrorCode = 135
};
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
//查看标签是否已经被使用
DataSet ds = TagsTypeBLL.HasUse(TypeId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
rsp.ResultCode = 310;
rsp.Message = "该标签类型下面的标签已经被使用";
return(rsp.ToJSON());
}
//虚拟删除标签类型和下面的标签
TagsTypeBLL.DeleteTagsType(TypeId);
return(rsp.ToJSON());
}
/// <summary>
///
/// </summary>
public string GetTagsTypeData()
{
var billService = new TagsTypeBLL(new SessionManager().CurrentUserLoginInfo);
var queryEntity = new TagsTypeEntity();
queryEntity.CustomerId = CurrentUserInfo.CurrentUser.customer_id;
var list = billService.GetList(queryEntity, 0, 100);
string content = string.Empty;
var jsonData = new JsonData();
jsonData.totalCount = list.Count.ToString();
jsonData.data = list;
content = jsonData.ToJSON();
return(content);
}
public void Update(TagsTypeEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(TagsTypeEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(TagsTypeEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(TagsTypeEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <TagsTypeEntity> PagedQueryByEntity(TagsTypeEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public TagsTypeEntity[] QueryByEntity(TagsTypeEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(TagsTypeEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void Update(TagsTypeEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(TagsTypeEntity pEntity)
{
Update(pEntity, true);
}
/// <summary>
/// 根据id删除信息
/// </summary>
/// <param name="propIds"></param>
/// <param name="propInfo"></param>
/// <returns></returns>
public bool DeleteByIds(string propIds, TagsTypeEntity TagsTypeEn)
{
return(this._currentDAO.DeleteByIds(propIds, TagsTypeEn));
}
/// <summary>
/// GetListCount
/// </summary>
/// <param name="entity">entity</param>
public int GetListCount(TagsTypeEntity entity)
{
return(_currentDAO.GetListCount(entity));
}
public string SaveTagsType(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <SaveTagsTypeRP> >();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rd = new SaveTagsTypeRD();//返回值
var _TagsTypeInfo = rp.Parameters.TagsTypeInfo;
if (string.IsNullOrEmpty(_TagsTypeInfo.TypeName))
{
throw new APIException("缺少参数【TypeName】或参数值为空")
{
ErrorCode = 135
};
}
TagsTypeEntity TagsTypeEn = new TagsTypeEntity();
bool isNew = false;
if (string.IsNullOrEmpty(_TagsTypeInfo.TypeId))
{
_TagsTypeInfo.TypeId = Guid.NewGuid().ToString();
isNew = true;
}
TagsTypeEn.TypeId = _TagsTypeInfo.TypeId;
TagsTypeEn.TypeName = _TagsTypeInfo.TypeName;
TagsTypeEn.LastUpdateBy = loggingSessionInfo.UserID;
TagsTypeEn.LastUpdateTime = DateTime.Now;
TagsTypeEn.IsDelete = 0;
string error = "";
//service.SaveProp(propInfo, ref error);
TagsTypeBLL TagsTypeBLL = new TagsTypeBLL(loggingSessionInfo);
if (isNew)
{
TagsTypeEn.CreateBy = loggingSessionInfo.UserID;
TagsTypeEn.CreateTime = DateTime.Now;
TagsTypeBLL.Create(TagsTypeEn);
}
else
{
TagsTypeBLL.Update(TagsTypeEn, false);
}
TagsBLL TagsBLL = new TagsBLL(loggingSessionInfo);
if (!isNew)//不是新的
{
string propIds = "";
foreach (var itemInfo in _TagsTypeInfo.TagsList)//数组，更新数据
{
if (!string.IsNullOrEmpty(itemInfo.TagsId))
{
if (propIds != "")
{
propIds += ",";
}
propIds += "'" + itemInfo.TagsId + "'";
}
}
//删除不在这个里面的
if (!string.IsNullOrEmpty(propIds))
{
TagsBLL.DeleteByIds(propIds, TagsTypeEn);
}
}
foreach (var itemInfo in _TagsTypeInfo.TagsList)//数组，更新数据
{
TagsEntity TagsEn = new TagsEntity();
TagsEn.TagsName = itemInfo.TagsName;
TagsEn.TagsDesc = itemInfo.TagsName;
TagsEn.LastUpdateBy = rp.UserID;
TagsEn.LastUpdateTime = DateTime.Now;
TagsEn.IsDelete = 0;
TagsEn.CustomerId = loggingSessionInfo.ClientID;
TagsEn.TypeId = TagsTypeEn.TypeId;
if (string.IsNullOrEmpty(itemInfo.TagsId))
{
TagsEn.TagsId = Guid.NewGuid().ToString();
TagsEn.CreateBy = rp.UserID;
TagsEn.CreateTime = DateTime.Now;
TagsBLL.Create(TagsEn);
}
else
{
TagsEn.TagsId = itemInfo.TagsId;
TagsBLL.Update(TagsEn, false);
}
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
