public DataTable GetProjList(string KeyWorl = "")
{
return(sp.ExecuteReturnDataTable(CommandType.Text, "SELECT mppm.FCode ,mppm.FBillNO ,mppm.FWeek ,mppm.FProCode ,mpi.FName AS FProName ," +
" mppm.FLastBill ,mppm.FStarDate ,mppm.FEndDate ,mu.FName AS FUserName ," +
" mppm.FThisWorkContent, mppm.FNextWorkPlan, mppm2.FThisWorkContent AS FThisWeekGoal,mppm.FCheckFlag " +
" FROM dbo.MY_ProjProgressMain AS mppm " +
" LEFT JOIN dbo.MY_ProjProgressMain AS mppm2 ON mppm2.FCode = mppm.FCode AND mppm.FLastBill = mppm2.FBillNO AND mppm2.FCancelFlag = 0 " +
" LEFT JOIN dbo.MY_ProjInfo AS mpi ON mpi.FProCode=mppm.FProCode " +
" LEFT JOIN dbo.MY_User AS mu ON mu.FCode=mppm.FCode " +
" mppm.FCancelFlag=0 ", null));
}
public DataTable GetProjList(string dtStarDate, string dtEndDate)
{
string strCmd = " SELECT mncp.FID,mncp.FWeek ,mncp.FStarDate ,mncp.FEndDate ,mncp.FPlanContent ,mncp.FFinshInfo ,mncp.FCheckFlag" +
" FROM dbo.MY_NeedCheckProject AS mncp " +
" WHERE mncp.FCancelFlag = 0 AND mncp.FStarDate >= @StarDate AND mncp.FEndDate <= @EndDate";
SqlParameter[] para = { new SqlParameter("@StarDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime) };
para[0].Value = DateTime.Parse(string.IsNullOrWhiteSpace(dtStarDate) == true?DateTime.Now.AddDays(-7).ToShortDateString():dtStarDate);
para[1].Value = DateTime.Parse(string.IsNullOrWhiteSpace(dtEndDate) == true ? DateTime.Now.AddDays(-7).ToShortDateString() : dtEndDate);
return(sqlHelpService.ExecuteReturnDataTable(CommandType.Text, strCmd, para));
}
public DataTable GetProjList(string dtStar, string dtEnd, string KeyWorld = "")
{
SqlParameter[] para = { new SqlParameter("@FKeyWorld", SqlDbType.VarChar),
new SqlParameter("@FStarDate", SqlDbType.DateTime),
new SqlParameter("@FEndDate", SqlDbType.DateTime) };
para[0].Value = string.IsNullOrWhiteSpace(KeyWorld) == true?"":KeyWorld;
para[1].Value = DateTime.Parse(string.IsNullOrEmpty(dtStar) == true?DateTime.Now.AddDays(-7).ToShortDateString():dtStar);
para[2].Value = DateTime.Parse(string.IsNullOrEmpty(dtEnd) == true ? DateTime.Now.ToShortDateString() : dtEnd);
return(sp.ExecuteReturnDataTable(CommandType.Text, "SELECT mppm.FCode ,mppm.FBillNO ,mppm.FWeek ,mppm.FProCode ,mpi.FName AS FProName ," +
" mppm.FLastBill ,mppm.FStarDate ,mppm.FEndDate ,mu.FName AS FUserName ," +
" mppm.FThisWorkContent, mppm.FNextWorkPlan, mppm2.FThisWorkContent AS FThisWeekGoal,mppm.FCheckFlag " +
" FROM dbo.MY_ProjProgressMain AS mppm " +
" LEFT JOIN dbo.MY_ProjProgressMain AS mppm2 ON mppm2.FCode = mppm.FCode AND mppm.FLastBill = mppm2.FBillNO AND mppm2.FCancelFlag = 0 " +
" LEFT JOIN dbo.MY_ProjInfo AS mpi ON mpi.FProCode=mppm.FProCode " +
" LEFT JOIN dbo.MY_User AS mu ON mu.FCode=mppm.FCode " +
" WHERE mppm.FCancelFlag=0 AND (mpi.FName LIKE '%'+@FKeyWorld+'%' OR mu.FName LIKE '%'+@FKeyWorld+'%')" +
" AND mppm.FStarDate>=@FStarDate AND mppm.FEndDate<=@FEndDate", para));
}
/// <summary>
/// 获取人员信息
/// </summary>
/// <returns></returns>
public DataTable GetPersonList()
{
return(sp.ExecuteReturnDataTable(CommandType.Text, "SELECT mu.FCode ,mu.FName FROM dbo.MY_User AS mu WHERE mu.FCancelFlag = 0", null));
}