public void Insert(List <WR_Attachment> attachments)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
db.WR_Attachment.InsertAllOnSubmit(attachments);
db.SubmitChanges();
}
}
public void Insert(WR_Rule model)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
db.WR_Rule.InsertOnSubmit(model);
db.SubmitChanges();
}
}
public void DeleteByRuleId(int ruleId)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
var items = db.WR_Attachment.Where(p => p.Record_Status == 0 && p.Rule_ID == ruleId);
foreach (var item in items)
{
db.WR_Attachment.DeleteOnSubmit(item);
}
db.SubmitChanges();
}
}
public void Delete(int id)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
WR_Attachment obj = db.WR_Attachment.Where(p => p.ID == id && p.Record_Status == 0).FirstOrDefault();
if (obj != null)
{
db.WR_Attachment.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
}
public void Delete(string type, int id, string createdBy)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
WR_Focus model = db.WR_Focus.Where(p => p.Record_Status == 0 && p.Rule_ID == id && p.Created_By == createdBy).FirstOrDefault();
if (model != null)
{
db.WR_Focus.DeleteOnSubmit(model);
db.SubmitChanges();
}
}
}
public void Insert(WR_Focus model)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
bool flag = db.WR_Focus.Where(p => p.Record_Status == 0 && p.Rule_ID == model.Rule_ID && p.Created_By == model.Created_By).Any();
if (!flag)
{
db.WR_Focus.InsertOnSubmit(model);
db.SubmitChanges();
}
}
}
public void Update(WR_Rule model)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
WR_Rule obj = db.WR_Rule.Where(p => p.ID == model.ID && p.Record_Status == 0).FirstOrDefault();
if (obj != null)
{
obj.Modified_By = model.Modified_By;
obj.Modified_By_Name = model.Modified_By_Name;
obj.Modified_On = model.Modified_On;
obj.Publish_Date = model.Publish_Date;
obj.Category_ID = model.Category_ID;
obj.Title = model.Title;
obj.Summary = model.Summary;
db.SubmitChanges();
}
}
}
public void UpdateRecordStatus(WR_Rule model)
{
using (WorkFlowRuleDataContext db = new WorkFlowRuleDataContext())
{
WR_Rule obj = db.WR_Rule.Where(p => p.ID == model.ID && p.Record_Status == 0).FirstOrDefault();
if (obj != null)
{
obj.Modified_By = model.Modified_By;
obj.Modified_By_Name = model.Modified_By_Name;
obj.Modified_On = model.Modified_On;
obj.Record_Status = model.Record_Status;
//删除收藏记录
var items = db.WR_Focus.Where(p => p.Record_Status == 0 && p.Rule_ID == model.ID);
foreach (var item in items)
{
db.WR_Focus.DeleteOnSubmit(item);
}
db.SubmitChanges();
}
}
}