/// <summary>
/// 获取交流专区实体
/// </summary>
/// <param name="Id">主键编号</param>
/// <returns>交流专区实体</returns>
public EyouSoft.Model.PersonalCenterStructure.WorkPlan GetModel(int Id, string us)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
var obj = dcDal.WorkPlan.FirstOrDefault(item => item.PlanId == Id && item.IsDelete == "0");
if (obj != null)
{
return(new EyouSoft.Model.PersonalCenterStructure.WorkPlan()
{
ActualDate = obj.ActualDate.HasValue ? obj.ActualDate.Value : DateTime.MaxValue,
CompanyId = obj.CompanyId,
CreateTime = obj.CreateTime,
DepartmentComment = obj.DepartmentComment,
Description = obj.Description,
ExpectedDate = obj.ExpectedDate.HasValue ? obj.ExpectedDate.Value : DateTime.MaxValue,
FilePath = obj.FilePath,
LastTime = obj.LastTime.HasValue ? obj.LastTime.Value : DateTime.MaxValue,
ManagerComment = obj.ManagerComment,
OperatorId = obj.OperatorId,
OperatorName = obj.OperatorName,
PlanId = obj.PlanId,
Remark = obj.Remark,
Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.PlanCheckState) int.Parse(obj.Status.ToString()),
Title = obj.Title,
AcceptList = (from accept in obj.WorkPlanAcceptList where accept.PlanId == Id select new EyouSoft.Model.PersonalCenterStructure.WorkPlanAccept()
{
AccetpId = accept.AccetpId,
PlanId = accept.PlanId,
AccetpName = GetAcceptName(accept.AccetpId)
}).ToList(),
PlanNO = obj.PlanNO
});
}
return(null);
}
/// <summary>
/// 获取工作汇报实体
/// </summary>
/// <param name="Id">主键编号</param>
/// <returns>工作汇报实体</returns>
public EyouSoft.Model.PersonalCenterStructure.WorkReport GetModel(int Id)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
var obj = dcDal.WorkReport.FirstOrDefault(item => item.ReportId == Id && item.IsDelete == "0");
if (obj != null)
{
return(new EyouSoft.Model.PersonalCenterStructure.WorkReport()
{
CheckerId = obj.CheckerId.HasValue?obj.CheckerId.Value:0,
CheckTime = obj.CheckTime.HasValue?obj.CheckTime.Value:DateTime.MaxValue,
Comment = obj.Comment,
CompanyId = obj.CompanyId,
DepartmentId = obj.DepartmentId,
Description = obj.Description,
FilePath = obj.FilePath,
OperatorId = obj.OperatorId,
OperatorName = obj.OperatorName,
ReportId = obj.ReportId,
ReportingTime = obj.ReportingTime,
Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState) int.Parse(obj.Status.ToString()),
Title = obj.Title,
DepartmentName = GetDepartName(obj.DepartmentId)
});
}
return(null);
}
/// <summary>
/// 设置审核状态
/// </summary>
/// <param name="Id">主键编号</param>
/// <param name="Status">状态</param>
/// <param name="CheckRemark">审核备注</param>
/// <returns>true:成功 false:失败</returns>
public bool SetChecked(int Id, EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState Status, string CheckRemark)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
EyouSoft.Data.WorkReport obj = dcDal.WorkReport.FirstOrDefault(item => item.ReportId == Id);
if (obj != null)
{
obj.ReportId = Id;
obj.Status = (byte)Status;
obj.CheckTime = DateTime.Now;
obj.Comment = CheckRemark;
dcDal.SubmitChanges();
}
return(dcDal.ChangeConflicts.Count == 0 ? true : false);
}
/// <summary>
/// 判断是否已经有用户已经使用该职务
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="DutyId">职务编号</param>
/// <returns></returns>
public bool IsHasBeenUsed(int CompanyId, int DutyId)
{
bool IsTrue = false;
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
EyouSoft.Data.PersonnelInfo DataModel = dcDal.PersonnelInfo.FirstOrDefault(item =>
item.CompanyId == CompanyId && item.DutyId == DutyId
);
if (DataModel != null)
{
IsTrue = true;
}
return(IsTrue);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="RoleId">角色ID</param>
/// <returns></returns>
public bool Delete(int CompanyId, params int[] RoleId)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
bool IsTrue = false;
IEnumerable <EyouSoft.Data.SysRoleManage> SysRoleLists = (from item in dcDal.SysRoleManage
where item.CompanyId == CompanyId && RoleId.Contains(item.Id)
select item);
dcDal.SysRoleManage.DeleteAllOnSubmit <EyouSoft.Data.SysRoleManage>(SysRoleLists);
dcDal.SubmitChanges();
IsTrue = true;
SysRoleLists = null;
return(IsTrue);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">工作汇报实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Update(EyouSoft.Model.PersonalCenterStructure.WorkReport model)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
EyouSoft.Data.WorkReport obj = dcDal.WorkReport.FirstOrDefault(item => item.ReportId == model.ReportId);
if (obj != null)
{
obj.CompanyId = model.CompanyId;
obj.DepartmentId = model.DepartmentId;
obj.Description = model.Description;
obj.FilePath = model.FilePath;
obj.ReportId = model.ReportId;
obj.Status = (byte)model.Status;
obj.Title = model.Title;
dcDal.SubmitChanges();
}
return(dcDal.ChangeConflicts.Count == 0 ? true : false);
}
/// <summary>
/// 获取交流专区实体
/// </summary>
/// <param name="Id">主键编号</param>
/// <returns>交流专区实体</returns>
public EyouSoft.Model.PersonalCenterStructure.WorkExchange GetModel(int Id)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
var obj = dcDal.WorkExchange.FirstOrDefault(item => item.ExchangeId == Id && item.IsDelete == "0");
if (obj == null || obj.ExchangeId == 0)
{
return(null);
}
return(new EyouSoft.Model.PersonalCenterStructure.WorkExchange()
{
Clicks = obj.Clicks,
CompanyId = obj.CompanyId,
CreateTime = obj.CreateTime,
Description = obj.Description,
ExchangeId = obj.ExchangeId,
IsAnonymous = obj.IsAnonymous == "1" ? true : false,
IsDelete = obj.IsDelete == "1" ? true : false,
OperatorId = obj.OperatorId,
OperatorName = obj.OperatorName,
Replys = obj.Replys,
Title = obj.Title,
AcceptList = (from accept in obj.WorkExchangeAcceptList
select new EyouSoft.Model.PersonalCenterStructure.WorkExchangeAccept()
{
AcceptId = accept.AcceptId,
AcceptType = (EyouSoft.Model.EnumType.PersonalCenterStructure.AcceptType) int.Parse(accept.AcceptType.ToString()),
ExchangeId = accept.ExchangeId,
AcceptName = GetAcceptName(accept.AcceptId, (EyouSoft.Model.EnumType.PersonalCenterStructure.AcceptType) int.Parse(accept.AcceptType.ToString()))
}).ToList(),
ReplyList = (from reply in obj.WorkExchangeReplyList select new EyouSoft.Model.PersonalCenterStructure.WorkExchangeReply()
{
Description = reply.Description,
ExchangeId = reply.ExchangeId.HasValue?reply.ExchangeId.Value:0,
IsAnonymous = reply.IsAnonymous == "1"?true:false,
IsDelete = reply.IsDelete == "1"?true:false,
OperatorId = reply.OperatorId.HasValue?reply.OperatorId.Value:0,
OperatorName = reply.OperatorName,
ReplyId = reply.ReplyId,
ReplyTime = reply.ReplyTime
}).ToList()
});
}
/// <summary>
/// 获取角色信息实体
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="Id">角色编号</param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.SysRoleManage GetModel(int CompanyId, int Id)
{
EyouSoft.Model.CompanyStructure.SysRoleManage model = null;
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
EyouSoft.Data.SysRoleManage DataModel = dcDal.SysRoleManage.FirstOrDefault(item =>
item.CompanyId == CompanyId && item.Id == Id
);
if (DataModel != null)
{
model = new EyouSoft.Model.CompanyStructure.SysRoleManage()
{
Id = DataModel.Id,
RoleName = DataModel.RoleName,
RoleChilds = DataModel.RoleChilds
};
}
DataModel = null;
return(model);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model">角色信息实体</param>
/// <returns></returns>
public bool Add(EyouSoft.Model.CompanyStructure.SysRoleManage model)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
bool IsTrue = false;
EyouSoft.Data.SysRoleManage DataModel = new EyouSoft.Data.SysRoleManage()
{
CompanyId = model.CompanyId,
RoleChilds = model.RoleChilds.Trim(),
RoleName = model.RoleName,
IsDelete = "0"
};
dcDal.SysRoleManage.InsertOnSubmit(DataModel);
dcDal.SubmitChanges();
if (dcDal.ChangeConflicts.Count == 0)
{
IsTrue = true;
}
DataModel = null;
return(IsTrue);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">工作汇报实体</param>
/// <returns>true:成功 false:失败</returns>
public bool Add(EyouSoft.Model.PersonalCenterStructure.WorkReport model)
{
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
EyouSoft.Data.WorkReport obj = new EyouSoft.Data.WorkReport()
{
CompanyId = model.CompanyId,
DepartmentId = model.DepartmentId,
Description = model.Description,
FilePath = model.FilePath,
OperatorId = model.OperatorId,
OperatorName = model.OperatorName,
Status = (byte)model.Status,
Title = model.Title,
ReportingTime = model.ReportingTime,
CheckerId = 0,
IsDelete = "0"
};
dcDal.WorkReport.InsertOnSubmit(obj);
dcDal.SubmitChanges();
return(dcDal.ChangeConflicts.Count == 0 ? true : false);
}
/// <summary>
/// 构造函数
/// </summary>
public FixedAsset()
{
_db = this.SystemStore;
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
}
/// <summary>
/// 构造函数
/// </summary>
public PersonDocument()
{
_db = this.SystemStore;
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
}
/// <summary>
/// 构造函数
/// </summary>
public SysRoleManage()
{
_db = this.SystemStore;
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
}
/// <summary>
/// 构造函数
/// </summary>
public SoldStatistic()
{
_db = this.SystemStore;
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
}
/// <summary>
/// 构造函数
/// </summary>
public RuleInfo()
{
_db = this.SystemStore;
dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
}
public News()
{
this._db = base.SystemStore;
this.dcDal = new EyouSoft.Data.EyouSoftTBL(this._db.ConnectionString);
}
/// <summary>
/// 构造函数
/// </summary>
public WorkReport()
{
_db = this.SystemStore;
dcDal = new EyouSoft.Data.EyouSoftTBL(this.SystemStore.ConnectionString);
}
