/// <summary>
/// 查询作业
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static T_Zy GetZy(int id)
{
T_Zy model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString),
"select Id, UserId, ZyName, CourseId, SubjectId, CreateDate, Ip, IMEI, MobileBrand, SystemType, Browser, OpenDate, DueDate, Type, Status from T_Zy where Id = @Id",
"@Id".ToInt32InPara(id)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_Zy>(dr);
}
}
return(model);
}
/// <summary>
/// 获取作业信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static dto_Zy GetZy(int id)
{
dto_Zy tempresult = null;
string key = RedisHelper.GetEasyZyRedisKey(CacheCatalog.Zy, id.ToString());
using (var client = RedisHelper.Instance.GetRedisClient(CacheCatalog.Zy.ToString()))
{
if (client != null)
{
tempresult = client.Get <dto_Zy>(key);
if (tempresult == null)
{
T_Zy z = B_Zy.GetZy(id);
string subName = "";
Subjects.TryGetValue(z.SubjectId, out subName);
tempresult = new dto_Zy()
{
Id = z.Id,
UserId = z.UserId,
ZyName = z.ZyName,
Type = z.Type,
CourseId = z.CourseId,
SubjectId = z.SubjectId,
CreateDate = z.CreateDate,
OpenDate = z.OpenDate,
DueDate = z.DueDate,
OpenDateStr = z.OpenDate.ToString("yyyy-MM-dd HH:mm:ss"),
DueDateStr = z.DueDate.ToString("yyyy-MM-dd HH:mm:ss"),
SubjectName = subName,
TypeName = z.Type == 0 ? "题库" : "自传",
Status = z.Status
};
if (tempresult != null)
{
client.Set(key, tempresult, ts);
}
}
}
}
return(tempresult);
}
/// <summary>
/// 新建作业
/// </summary>
/// <param name="zy"></param>
/// <returns></returns>
public static int Create(T_Zy zy)
{
object o = MySqlHelper.ExecuteScalar(Util.GetConnectString(ZyConnString),
"insert into T_Zy(UserId, ZyName, CourseId, SubjectId, CreateDate, Ip, IMEI, MobileBrand, SystemType, Browser, OpenDate, DueDate, Type, Status) values (@UserId, @ZyName, @CourseId, @SubjectId, @CreateDate, @Ip, @IMEI, @MobileBrand, @SystemType, @Browser, @OpenDate, @DueDate, @Type, @Status); select last_insert_id();",
"@UserId".ToInt32InPara(zy.UserId),
"@ZyName".ToVarCharInPara(zy.ZyName),
"@CourseId".ToInt32InPara(zy.CourseId),
"@SubjectId".ToInt32InPara(zy.SubjectId),
"@CreateDate".ToDateTimeInPara(zy.CreateDate),
"@Ip".ToVarCharInPara(zy.Ip),
"@IMEI".ToVarCharInPara(zy.IMEI),
"@MobileBrand".ToVarCharInPara(zy.MobileBrand),
"@SystemType".ToVarCharInPara(zy.SystemType),
"@Browser".ToVarCharInPara(zy.Browser),
"@OpenDate".ToDateTimeInPara(zy.OpenDate),
"@DueDate".ToDateTimeInPara(zy.DueDate),
"@Type".ToInt32InPara(zy.Type),
"@Status".ToInt32InPara(zy.Status)
);
return(o == null ? 0 : int.Parse(o.ToString()));
}
/// <summary>
/// 保存作业
/// </summary>
/// <param name="zyName"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="questions"></param>
/// <returns></returns>
public JsonResult SaveZy(int courseId, string zyName, string startDate, string endDate, string questions)
{
#region 参数验证
dto_AjaxJsonResult <string> result = new dto_AjaxJsonResult <string>();
if (zyName.Length > 30)
{
result.code = AjaxResultCodeEnum.Error;
result.message = "作业名称不能超过30个字！";
return(Json(result));
}
DateTime OpenDate, DueDate;
if (!DateTime.TryParse(startDate, out OpenDate) || !DateTime.TryParse(endDate, out DueDate))
{
result.code = AjaxResultCodeEnum.Error;
result.message = "开始时间和结束时间都要设置！";
return(Json(result));
}
if (OpenDate > DueDate)
{
result.code = AjaxResultCodeEnum.Error;
result.message = "开始时间不能大于结束时间！";
return(Json(result));
}
if (string.IsNullOrEmpty(questions))
{
result.code = AjaxResultCodeEnum.Error;
result.message = "试题不能为空！";
return(Json(result));
}
#endregion
int subjectId = 0;
Const.CourseSubjectMapping.TryGetValue(courseId, out subjectId);
//保存作业信息
T_Zy zy = new T_Zy()
{
UserId = UserId,
ZyName = zyName,
OpenDate = OpenDate,
DueDate = DueDate,
Type = 0,
CourseId = courseId,
SubjectId = subjectId,
CreateDate = DateTime.Now,
Ip = ClientUtil.Ip,
IMEI = ClientUtil.IMEI,
MobileBrand = ClientUtil.MobileBrand,
SystemType = Request.Browser.Platform.ToString(),
Browser = Request.Browser.Browser.ToString(),
Status = 0
};
int id = B_Zy.Create(zy);
//保存作业试题信息
string[] qs = questions.Split(',');
if (id > 0)
{
SaveZyQuestions(courseId, id, qs);
}
//修改试题使用次数
IncreaseQuesUsageTimes(courseId, qs);
result.code = AjaxResultCodeEnum.Success;
result.message = "";
return(Json(result));
}
