/// <summary>
/// 批量添加
/// </summary>
public bool Add(long articleID, List <long> articleTypeIDList, XCLCMS.Data.Model.Custom.ContextModel context = null)
{
if (null == articleTypeIDList || articleTypeIDList.Count == 0)
{
return(true);
}
articleTypeIDList = articleTypeIDList.Distinct().ToList();
DateTime dtNow = DateTime.Now;
var lst = new List <XCLCMS.Data.Model.ArticleType>();
articleTypeIDList.ForEach(id =>
{
var model = new XCLCMS.Data.Model.ArticleType();
if (null != context)
{
model.CreaterID = context.UserInfoID;
model.CreaterName = context.UserName;
model.UpdaterID = context.UserInfoID;
model.UpdaterName = context.UserName;
}
model.CreateTime = dtNow;
model.UpdateTime = dtNow;
model.FK_TypeID = id;
model.FK_ArticleID = articleID;
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString();
lst.Add(model);
});
return(this.Add(lst));
}
/// <summary>
/// 批量删除
/// </summary>
public bool Delete(List <long> idLst, XCLCMS.Data.Model.Custom.ContextModel context)
{
if (null == idLst || idLst.Count == 0)
{
return(true);
}
DateTime dtNow = DateTime.Now;
using (var scope = new TransactionScope())
{
foreach (var id in idLst)
{
var model = this.GetModel(id);
if (null == model)
{
continue;
}
//删除当前记录
model.UpdaterID = context.UserInfoID;
model.UpdaterName = context.UserName;
model.UpdateTime = dtNow;
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.D.ToString();
if (!this.Update(model))
{
return(false);
}
//更新子记录的parentid为0
var subLst = this.GetListByParentID(id);
if (null != subLst && subLst.Count > 0)
{
foreach (var subModel in subLst)
{
subModel.ParentID = 0;
subModel.UpdaterID = context.UserInfoID;
subModel.UpdaterName = context.UserName;
subModel.UpdateTime = dtNow;
if (!this.Update(subModel))
{
return(false);
}
}
}
}
scope.Complete();
}
return(true);
}
/// <summary>
/// 批量删除商户数据
/// </summary>
public bool Delete(List <long> idLst, XCLCMS.Data.Model.Custom.ContextModel context)
{
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("sp_Merchant_Del");
dbCommand.Parameters.Add(new SqlParameter("@MerchantID", SqlDbType.Structured)
{
TypeName = "TVP_IDTable",
Direction = ParameterDirection.Input,
Value = XCLNetTools.DataSource.DataTableHelper.ToSingleColumnDataTable <long, long>(idLst)
});
dbCommand.Parameters.Add(new SqlParameter("@Context", SqlDbType.Structured)
{
TypeName = "TVP_Context",
Direction = ParameterDirection.Input,
Value = XCLNetTools.DataSource.DataTableHelper.ToDataTable(new List <XCLCMS.Data.Model.Custom.ContextModel>()
{
context
})
});
db.AddOutParameter(dbCommand, "ResultCode", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "ResultMessage", DbType.String, 1000);
db.ExecuteNonQuery(dbCommand);
var result = XCLCMS.Data.DAL.Common.Common.GetProcedureResult(dbCommand.Parameters);
if (result.IsSuccess)
{
return(true);
}
else
{
throw new Exception(result.ResultMessage);
}
}
/// <summary>
/// 批量添加（先删再加）
/// </summary>
public bool Add(XCLCMS.Data.CommonHelper.EnumType.ObjectTypeEnum objectType, long objectID, List <long> ProductIDList, XCLCMS.Data.Model.Custom.ContextModel context = null)
{
return(dal.Add(objectType, objectID, ProductIDList, context));
}
/// <summary>
/// 批量添加（先删再加）
/// </summary>
public bool Add(XCLCMS.Data.CommonHelper.EnumType.ObjectTypeEnum objectType, long objectID, List <long> tagIDList, XCLCMS.Data.Model.Custom.ContextModel context = null)
{
var dtNow = DateTime.Now;
if (null == tagIDList || tagIDList.Count == 0)
{
return(true);
}
tagIDList = tagIDList.Distinct().ToList();
if (!this.Delete(objectType, objectID))
{
return(false);
}
tagIDList.ForEach(id =>
{
var model = new XCLCMS.Data.Model.ObjectTag();
if (null != context)
{
model.CreaterID = context.UserInfoID;
model.CreaterName = context.UserName;
model.UpdaterID = context.UserInfoID;
model.UpdaterName = context.UserName;
}
model.CreateTime = dtNow;
model.UpdateTime = dtNow;
model.FK_TagsID = id;
model.FK_ObjectID = objectID;
model.ObjectType = objectType.ToString();
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString();
this.Add(model);
});
return(true);
}
/// <summary>
/// 批量添加（先删再加）
/// </summary>
public bool Add(XCLCMS.Data.CommonHelper.EnumType.ObjectTypeEnum objectType, long objectID, List <long> attachmentIDList, XCLCMS.Data.Model.Custom.ContextModel context = null)
{
if (null == attachmentIDList || attachmentIDList.Count == 0)
{
return(true);
}
attachmentIDList = attachmentIDList.Distinct().ToList();
if (!this.Delete(CommonHelper.EnumType.ObjectTypeEnum.ART, objectID))
{
return(false);
}
DateTime dtNow = DateTime.Now;
var lst = new List <XCLCMS.Data.Model.ObjectAttachment>();
attachmentIDList.ForEach(id =>
{
var model = new XCLCMS.Data.Model.ObjectAttachment();
if (null != context)
{
model.CreaterID = context.UserInfoID;
model.CreaterName = context.UserName;
model.UpdaterID = context.UserInfoID;
model.UpdaterName = context.UserName;
}
model.CreateTime = dtNow;
model.UpdateTime = dtNow;
model.FK_AttachmentID = id;
model.FK_ObjectID = objectID;
model.ObjectType = objectType.ToString();
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString();
lst.Add(model);
});
return(this.Add(lst));
}
/// <summary>
/// 批量添加
/// </summary>
public bool Add(long articleID, List <long> articleTypeIDList, XCLCMS.Data.Model.Custom.ContextModel context = null)
{
return(dal.Add(articleID, articleTypeIDList, context));
}
/// <summary>
/// 批量添加
/// </summary>
public bool Add(long keyValueInfoID, List <long> keyValueInfoTypeIDList, XCLCMS.Data.Model.Custom.ContextModel context = null)
{
return(dal.Add(keyValueInfoID, keyValueInfoTypeIDList, context));
}
/// <summary>
/// 批量删除商户数据
/// </summary>
public bool Delete(List <long> idLst, XCLCMS.Data.Model.Custom.ContextModel context)
{
return(dal.Delete(idLst, context));
}