public static string ReExecuteStatsData(string StatsLogId)
{
try
{
BLL_StatsLog bll = new BLL_StatsLog();
Model_StatsLog model = bll.GetModel(StatsLogId);
model.CTime = DateTime.Now;
bll.ExecuteStatsAddLog(model);
return("1");
}
catch (Exception ex)
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("10255000", "重新执行失败：" + ex.Message.ToString());
return("0");
}
}
public static string CheckCalculation(string hwId, string hwName)
{
try
{
DataTable dtHWDetail = new BLL_HomeWork().GetHWDetail(hwId).Tables[0];
//System.Threading.Thread.Sleep(10000);
hwId = hwId.Filter();
hwName = hwName.Filter();
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
#region 作业HomeWork 执行数据分析，记录日志
Model_StatsLog modelLog = new Model_StatsLog();
modelLog.StatsLogId = Guid.NewGuid().ToString();
modelLog.DataId = hwId;
modelLog.DataName = hwName;
modelLog.DataType = "1";
modelLog.LogStatus = "2";
modelLog.CTime = DateTime.Now;
modelLog.CUser = loginUser.UserId;
modelLog.GradeId = dtHWDetail.Rows[0]["GradeId"].ToString();
bool flag = new BLL_StatsLog().ExecuteStatsAddLog(modelLog);
#endregion
if (flag)
{
return("1");
}
else
{
return("0");
}
}
catch (Exception ex)
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("", "计算失败：" + ex.Message.ToString());
return("0");
}
}
public static string CheckCalculation(string rtrfId, string gradeId)
{
try
{
rtrfId = rtrfId.Filter();
gradeId = gradeId.Filter();
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
#region 试卷 执行数据分析，记录日志
Model_ResourceToResourceFolder modelRTRF = new BLL_ResourceToResourceFolder().GetModel(rtrfId);
Model_StatsLog modelLog = new Model_StatsLog();
modelLog.StatsLogId = Guid.NewGuid().ToString();
modelLog.DataId = modelRTRF.ResourceToResourceFolder_Id;
modelLog.DataName = modelRTRF.File_Name.ReplaceForFilter();
modelLog.DataType = "2";
modelLog.LogStatus = "2";
modelLog.CTime = DateTime.Now;
modelLog.CUser = loginUser.UserId;
modelLog.GradeId = gradeId;
bool flag = new BLL_StatsLog().ExecuteStatsAddLog(modelLog);
#endregion
if (flag)
{
return("1");
}
else
{
return("0");
}
}
catch (Exception ex)
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("", "计算失败：" + ex.Message.ToString());
return("0");
}
}
public static string GetDataList(string DataType, string DataName, string LogStatus, int PageIndex, int PageSize)
{
try
{
DataType = DataType.Filter();
DataName = DataName.Filter();
LogStatus = LogStatus.Filter();
string strWhere = " 1=1 ";
BLL_StatsLog bll = new BLL_StatsLog();
if (!string.IsNullOrEmpty(DataType))
{
strWhere += " and DataType='" + DataType + "' ";
}
if (!string.IsNullOrEmpty(DataName))
{
strWhere += " and DataName like '%" + DataName + "%' ";
}
if (!string.IsNullOrEmpty(LogStatus))
{
strWhere += " and LogStatus='" + LogStatus + "' ";
}
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
DataTable dt = new DataTable();
dt = bll.GetListByPage(strWhere, "CTime desc", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0];
int rCount = bll.GetRecordCount(strWhere);
List <object> listReturn = new List <object>();
int inum = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
listReturn.Add(new
{
Num = inum + PageSize * (PageIndex - 1),
StatsLogId = dt.Rows[i]["StatsLogId"].ToString(),
DataId = dt.Rows[i]["DataId"].ToString(),
DataName = dt.Rows[i]["DataName"].ToString(),
DataType = dt.Rows[i]["DataType"].ToString(),
DataTypeName = dt.Rows[i]["DataType"].ToString() == "1" ? "按日期" : "按试卷",
LogStatus = dt.Rows[i]["LogStatus"].ToString() == "1" ? "成功" : "失败",
CTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["CTime"].ToString(), "yyyy-MM-dd HH:mm:ss")
});
inum++;
}
if (dt.Rows.Count > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
bool flag = false;
Rc.Cloud.Model.Model_VSysUserRole loginUser = HttpContext.Current.Session["LoginUser"] as Rc.Cloud.Model.Model_VSysUserRole;
if (ddlType.Value == "1")
{
List <Model_HomeWork> listHW = new BLL_HomeWork().GetModelList("HomeWork_Status='1' and HomeWork_FinishTime between '"
+ txtSTime.Text.Filter() + "' and '" + txtETime.Text.Filter() + "' ");
foreach (var item in listHW)
{
#region 日期 执行数据分析，记录日志
Model_StatsLog modelLog = new Model_StatsLog();
modelLog.StatsLogId = Guid.NewGuid().ToString();
modelLog.DataId = item.HomeWork_Id;
modelLog.DataName = item.HomeWork_Name;
modelLog.DataType = "1";
modelLog.LogStatus = "2";
modelLog.CTime = DateTime.Now;
modelLog.CUser = loginUser.SysUser_ID;
flag = new BLL_StatsLog().ExecuteStatsAddLog(modelLog);
#endregion
}
}
else
{
string rtrfId = hidtxtRTRFName.Value.Trim().Filter();
if (string.IsNullOrEmpty(rtrfId))
{
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('请选择试卷名称!',{ time: 2000,icon:2},function(){});</script>");
return;
}
else
{
#region 试卷 执行数据分析，记录日志
Model_ResourceToResourceFolder modelRTRF = new BLL_ResourceToResourceFolder().GetModel(rtrfId);
Model_StatsLog modelLog = new Model_StatsLog();
modelLog.StatsLogId = Guid.NewGuid().ToString();
modelLog.DataId = modelRTRF.ResourceToResourceFolder_Id;
modelLog.DataName = txtRTRFName.Value;
modelLog.DataType = "2";
modelLog.LogStatus = "2";
modelLog.CTime = DateTime.Now;
modelLog.CUser = loginUser.SysUser_ID;
flag = new BLL_StatsLog().ExecuteStatsAddLog(modelLog);
#endregion
}
}
if (flag)
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS("10255000", "手动执行统计成功");
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('执行统计成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>");
}
else
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("10255000", "手动执行统计失败：执行SQL异常");
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('执行统计失败!',{ time: 2000,icon:2},function(){parent.loadData();parent.layer.close(index);});</script>");
}
}
catch (Exception ex)
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS("10255000", "手动执行统计失败：" + ex.Message.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('执行统计失败!',{ time: 2000,icon:2},function(){parent.loadData();parent.layer.close(index);});</script>");
}
}
