//-----------
public string GetDate()
{
string stime, etime = "";
B_User_UnitWeek.GetWeekSE(Convert.ToDateTime(Eval("CDate")), out stime, out etime);
return(Convert.ToDateTime(stime).ToString("yyyy/MM/dd--") + Convert.ToDateTime(etime).ToString("MM/dd"));
}
//仅用于分红提成
private DataTable SelForUnitByTime(string time = "")
{
string stime, etime;
B_User_UnitWeek.GetWeekSE(DataConvert.CDate(time), out stime, out etime);
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("stime", stime), new SqlParameter("etime", etime) };
string fields = "A.UserID,A.UserName,A.ParentUserID,A.GroupID,A.HoneyName,B.AMount";
string sql = "Select " + fields + " FROM ZL_User AS A LEFT JOIN"
+ " (SELECT UserID,Sum(Unit)AS AMount FROM " + modelBll.TbName + " WHERE 1=1 ";
if (!string.IsNullOrEmpty(time))
{
sql += " AND CDate BetWeen @stime AND @etime";
}
sql += " AND UserID>0 GROUP BY UserID)B ON A.UserID=B.UserID";
return(SqlHelper.ExecuteTable(CommandType.Text, sql, sp));
}
