public int Upd_ESurveyApp(T_OA_REQUIRE info)
{
try
{
EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal();
return(employeeSurveyViewDal.Upd_ESurveyApp(info));
}
catch (Exception ex)
{
Tracer.Debug("调查申请EmployeeSurveyViewBll-Upd_ESurveyApp" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(-1);
}
}
/// <summary>
/// 增加员工调查申请表
/// </summary>
/// <param name="userID"></param>
/// <param name="postID"></param>
/// <param name="companyID"></param>
/// <param name="departmentID"></param>
/// <returns></returns>
public bool EmployeeSurveyAppAdd(T_OA_REQUIRE key)
{
using (EmployeeSurveyViewDal appDal = new EmployeeSurveyViewDal())
{
if ((appDal != null) && (appDal.Add_ESurveyApp(key) == 1))
{
return(true);
}
else
{
return(false);
}
}
}
public IQueryable <V_EmployeeSurveySubject> GetSubjectViewListByMasterID(string masterId)
{
EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal();
var s = from subject in employeeSurveyViewDal.GetSubjectList()
where subject.REQUIREMASTERID == masterId
join ans in employeeSurveyViewDal.GetAnswerList() on new { subject.REQUIREMASTERID, subject.SUBJECTID } equals new { ans.REQUIREMASTERID, ans.SUBJECTID } into answer
select new V_EmployeeSurveySubject {
SubjectInfo = subject, AnswerList = answer
};
if (s.Count() > 0)
{
return(s);
}
return(null);
}
//更新方案 新
public int Upd_ESurvey(T_OA_REQUIREMASTER survey, List <V_EmployeeSurveySubject> addLst, List <V_EmployeeSurveySubject> updLst)
{
try
{
//masterBll.BeginTransaction();
//更新方案
EmployeeSurveyViewDal esvDal = new EmployeeSurveyViewDal();
if (esvDal.UpdateRequireMaster(survey) == -1)
{
masterBll.RollbackTransaction();
return(-1);
}
foreach (V_EmployeeSurveySubject i in addLst)
{
//添加 题目 答案
if (subjectViewBll.AddEmployeeSurveySubjectView(i) < 1)
{
masterBll.RollbackTransaction();
return(-1);
}
}
foreach (V_EmployeeSurveySubject i in updLst)
{
//更新题目
if (esvDal.UpdateSurveySubject(i.SubjectInfo) < 1)
{
masterBll.RollbackTransaction();
return(-1);
}
//更新答案
if (UpdataAnswerList(i.SubjectInfo, i.AnswerList.ToList()) < 1)
{
masterBll.RollbackTransaction();
return(-1);
}
}
masterBll.CommitTransaction();
return(1);
}
catch (Exception ex)
{
Tracer.Debug("调查方案EmployeeSurveyViewBll-Upd_ESurvey" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(-1);
}
}
public int AddEmployeeSurveysView(V_EmployeeSurvey employeeSurveyView)
{
try
{
using (EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal())
{
if (employeeSurveyViewDal.AddEmployeeSurveyView(employeeSurveyView) == -1)
{
return(-1);
}
return(1);
}
}
catch (Exception ex)
{
Tracer.Debug("调查方案EmployeeSurveyViewBll-AddEmployeeSurveysView" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(-1);
}
}
//参与调查时用 ||平台审核进入时用
public IQueryable <V_EmployeeSurvey> Get_ESurvey(string requireMasterID)
{
EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal();
var vanswer = (from answ in employeeSurveyViewDal.GetAnswerList() orderby answ.CODE ascending select answ);
var m = from master in employeeSurveyViewDal.GetMasterList()
join sub in
(from subject in employeeSurveyViewDal.GetSubjectList()
join ans in vanswer
on new { subject.REQUIREMASTERID, subject.SUBJECTID } equals new { ans.REQUIREMASTERID, ans.SUBJECTID } into answer
orderby subject.SUBJECTID ascending
select new V_EmployeeSurveySubject {
SubjectInfo = subject, AnswerList = answer
}
)
on master.REQUIREMASTERID equals sub.SubjectInfo.REQUIREMASTERID into subject
where master.REQUIREMASTERID == requireMasterID
select new V_EmployeeSurvey {
RequireMaster = master, SubjectViewList = subject
};
// m = m.Where(ent => ent.RequireMaster.REQUIREMASTERID == requireMasterID);
return(m);
}
//审核通过的调查方案
public IQueryable <V_EmployeeSurvey> Get_ESurveyChecked(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string userId, List <string> guidStringList, string checkState)
{
EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal();
DateTime d = DateTime.Parse(paras[0].ToString()).Date;
DateTime d2 = DateTime.Parse(paras[1].ToString()).AddDays(1);
var m = from master in employeeSurveyViewDal.GetMasterList()
join sub in
(from subject in employeeSurveyViewDal.GetSubjectList()
join ans in
(from answ in employeeSurveyViewDal.GetAnswerList() orderby answ.CREATEDATE select answ)
on new { subject.REQUIREMASTERID, subject.SUBJECTID } equals new { ans.REQUIREMASTERID, ans.SUBJECTID } into answer
select new V_EmployeeSurveySubject {
SubjectInfo = subject, AnswerList = answer
}
)
on master.REQUIREMASTERID equals sub.SubjectInfo.REQUIREMASTERID into subject
select new V_EmployeeSurvey {
RequireMaster = master, SubjectViewList = subject
};
m = m.Where(ent => ent.RequireMaster.CHECKSTATE == checkState && ent.RequireMaster.CREATEDATE >= d && ent.RequireMaster.CREATEDATE < d2);
return(m);
}
//EmployeeSurveyViewDal esvDal = new EmployeeSurveyViewDal();
//更新方案 旧
public int UpdateEmployeeSurveyView(V_EmployeeSurvey infoView)
{
try
{
EmployeeSurveyViewDal esvDal = new EmployeeSurveyViewDal();
masterBll.BeginTransaction();
if (esvDal.UpdateRequireMaster(infoView.RequireMaster) == -1)
{
masterBll.RollbackTransaction();
return(-1);
}
//题目 添加、更新
List <V_EmployeeSurveySubject> subjectViewList = GetSubjectViewListByMasterID(infoView.RequireMaster.REQUIREMASTERID).ToList();
//////删除
IEnumerable <V_EmployeeSurveySubject> lstsub = infoView.SubjectViewList;
foreach (V_EmployeeSurveySubject i in lstsub)
{
bool isAdd = true;
foreach (V_EmployeeSurveySubject v in subjectViewList)
{
if (i.SubjectInfo.REQUIREDETAIL2ID == v.SubjectInfo.REQUIREDETAIL2ID)
{
isAdd = false;
}
break;
}
if (isAdd)
{ //添加 题目 答案
if (subjectViewBll.AddEmployeeSurveySubjectView(i) < 1)
{
masterBll.RollbackTransaction();
return(-1);
}
}
else
{
//更新题目
if (esvDal.UpdateSurveySubject(i.SubjectInfo) < 1)
{
masterBll.RollbackTransaction();
return(-1);
}
//更新答案
if (UpdataAnswerList(i.SubjectInfo, i.AnswerList.ToList()) < 1)
{
masterBll.RollbackTransaction();
return(-1);
}
}
}
masterBll.CommitTransaction();
return(1);
}
catch (Exception ex)
{
Tracer.Debug("调查方案EmployeeSurveyViewBll-UpdateEmployeeSurveyView" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(-1);
}
}
