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)); }