public static string CancelRelationPaper(string TestPaper_Frame_Id, string TestPaper_FrameDetail_Id, string TestPaper)
{
try
{
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["loginUser"];
if (new BLL_Two_WayChecklist().GetRecordCount("ParentId='" + TestPaper_Frame_Id.Filter() + "'") > 0)
{
return("2");
}
else
{
string[] arr = TestPaper.Split(',');
string StrSql = string.Empty;
foreach (var item in arr)
{
StrSql += @" delete from TestPaper_FrameToTestpaper where TestPaper_Frame_Id='" + TestPaper_FrameDetail_Id.Filter() + "' and ResourceToResourceFolder_Id='" + item + "' ; delete from TestPaper_FrameDetailToTestQuestions where TestPaper_FrameDetail_Id='" + TestPaper_FrameDetail_Id.Filter() + "' and ResourceToResourceFolder_Id='" + item + "' ; " + string.Format("exec P_GenerateTF_Attr '{0}','{1}'", TestPaper_Frame_Id, loginUser.SysUser_ID);
}
int i = Rc.Common.DBUtility.DbHelperSQL.ExecuteSqlByTime(StrSql.ToString(), 7200);
if (i > 0)
{
return("1");
}
else
{
return("");
}
}
}
catch (Exception ex)
{
return("");
}
}
public static string DeleteCloudResource(string docId)
{
string result = "0";
try
{
#region 除数据
StringBuilder strSqlU = new StringBuilder();
strSqlU.Append("delete from ResourceToResourceFolder ");
strSqlU.AppendFormat(" where [ResourceToResourceFolder_Id]='{0}'; ", docId.Filter());
Model_VSysUserRole loginUser = HttpContext.Current.Session["LoginUser"] as Model_VSysUserRole;
StringBuilder strLog = new StringBuilder();
strLog.AppendFormat("删除文件：登录名【{0}】用户ID：【{1}】"
, loginUser.SysUser_Name, loginUser.SysUser_ID);
if (Rc.Common.DBUtility.DbHelperSQL.ExecuteSql(strSqlU.ToString()) > 0)
{
new BLL_clsAuth().AddLogFromBS("Document.aspx", strLog.ToString());
result = "1";
}
else
{
new BLL_clsAuth().AddLogErrorFromBS("Document.aspx", strLog.ToString());
}
#endregion
}
catch (Exception)
{
}
return(result);
}
public DataSet GetUserModuleFunctionBySysCode(string User_ID, string ModuleFirst, string sysCode)
{
Model_VSysUserRole role = new Model_VSysUserRole();
role = clsUtility.IsPageFlag() as Model_VSysUserRole;
StringBuilder builder = new StringBuilder();
builder.Append(" select isnull(uf.moduleid, -1) as mChecked, ");
builder.Append(" isnull(uf.functionid, -1) as fChecked, ");
builder.Append(" isnull(mf.moduleid, uf.moduleid) as moduleid, ");
builder.Append(" convert(int,isnull(mf.functionid, uf.functionid)) as functionid, ");
builder.Append(" f.FUNCTIONName ,uf.SysCode");
if (role.SysUser_ID == "1ebb1705-c073-41e8-b9ab-1ea594abd433")
{
builder.AppendFormat(" from (Select * from SysModuleFunction where SysCode='{0}') mf ", sysCode);
}
else
{
builder.AppendFormat(" from (Select MODULEID,FUNCTIONID,syscode from SysModuleFunctionUser where SysCode='{0}' and User_ID='{1}'\r\nUNION\r\n SELECT MODULEID,FUNCTIONID,syscode\r\n FROM dbo.SysModuleFunctionRole\r\n WHERE SysRole_ID IN (\r\n SELECT SysRole_ID\r\n FROM dbo.SysUserRoleRelation\r\n WHERE syscode = '{0}'\r\n AND SysUser_ID = '{1}') \r\n) mf ", sysCode, role.SysUser_ID);
}
builder.Append(" left join Sys_Function f on mf.FunctionId=f.FUNCTIONID ");
builder.AppendFormat(" full join (select * from SysModuleFunctionUser where User_ID = '{0}' and MODULEID like '{1}%' and SysCode='{2}') uf ", User_ID, ModuleFirst, sysCode);
builder.Append(" on mf.moduleid = uf.moduleid ");
builder.Append(" and mf.functionid = uf.functionid ");
builder.AppendFormat(" where isnull(mf.moduleid, uf.moduleid) like '{0}%' ", ModuleFirst);
return(DbHelperSQL.Query(builder.ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
userId = Request.QueryString["SysUser_ID"];
modelLoginUser = loginUser;
if (!IsPostBack)
{
LoadData();
}
}
protected void Page_PreInit(object sender, EventArgs e)
{
Session.Timeout = 3600;
////自动登录 只可在测试时开发此功能，此功能开放时严禁把此文件签入SVN
#if DEBUG
//UserLoginAuto.UserAutoLogin();
#endif
strPageName = GetPageName();
strPageNameAndParm = strPageName + "?" + Rc.Cloud.Web.Common.pfunction.getPageParam();
loginUser = Rc.Common.StrUtility.clsUtility.IsPageFlag(this.Page) as Model_VSysUserRole;
}
protected void Page_Load(object sender, EventArgs e)
{
Module_Id = "90102000";
if (!IsPostBack)
{
check_dict_id = Request["id"].ToString();
txtName.Text = Request["n"].ToString();
_loginUser = Rc.Common.StrUtility.clsUtility.IsPageFlag(this.Page) as Model_VSysUserRole;
txtUserName.Text = _loginUser.SysUser_LoginName;
user_id = _loginUser.SysUser_ID;
}
}
protected void ibtnLogin_Click(object sender, EventArgs e)
{
if (Session["AdminValidateCode"] == null)
{
Response.Redirect("Index.aspx");
Response.End();
}
string CheckCode = Session["AdminValidateCode"].ToString();
Session.Remove("AdminValidateCode");
if (TxtVerify.Value.ToUpper() == CheckCode)
{
string loginName = string.Empty;
string passWord = string.Empty;
loginName = txtLoginName.Value.Trim();
passWord = Rc.Common.StrUtility.DESEncryptLogin.EncryptString(psd.Value);
Model_VSysUserRole loginModel = new Model_VSysUserRole();
object obj = new BLL_VSysUserRole().GetVDoctorInfoModelByLogin(loginName, passWord);
if (obj != null)
{
loginModel = obj as Model_VSysUserRole;
DataTable dt = new BLL_SysModule().GetOwenModuleListByCacheBySysCode(loginModel.SysUser_ID, Rc.Common.StrUtility.clsUtility.ReDoStr(loginModel.SysRole_IDs, ','));
DataRow[] drs = dt.Select("isLast='1' and url<>'#'", "DefaultOrder desc");
if (drs.Count() > 0)
{
Session["LoginUser"] = loginModel;
if (Request["iurl"] != null)
{
Response.Redirect(Request["iurl"].ToString());
}
else
{
Response.Redirect("/" + drs[0]["url"].ToString());
}
}
else
{
Rc.Common.StrUtility.clsUtility.ErrorDispose(this.Page, 6, false);
}
}
else
{
Session.Clear();
ClientScript.RegisterStartupScript(this.GetType(), "login", "<script>$(function(){layer.ready(function(){layer.msg('用户名或密码错误',{icon:2})})})</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "login", "<script>$(function(){layer.ready(function(){layer.msg('验证码输入不正确',{icon:2})})})</script>");
}
}
public static string AddAttr(string Two_WayChecklist_Id, string Two_WayChecklistDetail_Id, string Type, string arrId, string arrKnowledge)
{
try
{
string sql = string.Empty;
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["loginUser"];
string temp = @"INSERT INTO [dbo].[Two_WayChecklistDetailToAttr]
([Two_WayChecklistDetailToAttr_Id]
,[Two_WayChecklist_Id]
,[Two_WayChecklistDetail_Id]
,[Attr_Type]
,[Attr_Value]
,[CreateUser]
,[CreateTime])
VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}');";
string[] ArrAttr = arrKnowledge.Filter().Split(',');
string[] ArrId = arrId.Split(',');
for (int i = 0; i < ArrAttr.Length; i++)
{
sql += string.Format(temp
, ArrId[i]
, Two_WayChecklist_Id.Filter()
, Two_WayChecklistDetail_Id.Filter()
, Type
, ArrAttr[i]
, loginUser.SysUser_ID
, DateTime.Now);
}
if (Rc.Common.DBUtility.DbHelperSQL.ExecuteSql(sql) > 0)
{
int j = Rc.Common.DBUtility.DbHelperSQL.ExecuteSqlByTime("exec [P_SelectQuestions] '" + Two_WayChecklist_Id + "','" + Two_WayChecklistDetail_Id + "'", 7200);
return(j.ToString());
}
else
{
return("0");
}
}
catch (Exception ex)
{
return("");
}
}
public static string OperateResourceAuth(string AttrEnum, string ReId, string AttrValue)
{
string temp = "0";
try
{
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
BLL_BookAttrbute bll = new BLL_BookAttrbute();
Model_BookAttrbute model = new Model_BookAttrbute();
List <Model_BookAttrbute> list = bll.GetModelList("ResourceFolder_Id='" + ReId + "' and AttrEnum='" + AttrEnum + "' ");
bool result = false;
if (list.Count != 0)
{
model = list[0];
model.AttrValue = AttrValue;
model.CreateTime = DateTime.Now;
result = bll.Update(model);
}
else
{
model.BookAttrId = Guid.NewGuid().ToString();
model.ResourceFolder_Id = ReId;
model.AttrEnum = AttrEnum;
model.AttrValue = AttrValue;
model.CreateUser = loginUser.SysUser_ID;
model.CreateTime = DateTime.Now;
result = bll.Add(model);
}
if (result)
{
temp = "1";
}
}
catch (Exception)
{
}
return(temp);
}
public static string GetCloudResource(string ResourceFolder_Id, string DocName, string tp, string strResource_Type, string strResource_Class, int PageIndex, int PageSize)
{
try
{
DocName = DocName.Filter();
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
#region 资源信息
DataTable dtRes = new DataTable();
List <object> listReturn = new List <object>();
string strSql = string.Empty;
string strSqlCount = string.Empty;
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(DocName))
{
strWhere += " and File_Name like '%" + DocName.Filter() + "%' ";
}
if (tp == "0")
{
strWhere += " and ResourceFolder_Id='" + ResourceFolder_Id.Filter() + "' ";
}
strWhere += string.Format(" and Resource_Class='{0}' and Resource_Type='{1}'", strResource_Class, strResource_Type);
strSqlCount = @"select count(*) from ResourceToResourceFolder A
INNER JOIN Resource B ON A.Resource_Id=B.Resource_Id where 1=1 " + strWhere + " ";
strSql = @"select * from (select ROW_NUMBER() over(ORDER BY A.CreateTime DESC) row,A.*,B.Resource_ContentLength from ResourceToResourceFolder A
INNER JOIN Resource B ON A.Resource_Id=B.Resource_Id where 1=1 "
+ strWhere + " ) t where row between " + ((PageIndex - 1) * PageSize + 1) + " and " + (PageIndex * PageSize) + " ";
dtRes = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
int rCount = Convert.ToInt32(Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSqlCount).ToString());
int inum = 0;
for (int i = 0; i < dtRes.Rows.Count; i++)
{
inum++;
string docName = dtRes.Rows[i]["File_Name"].ToString();
docName = pfunction.GetDocFileName(docName);
string docType = dtRes.Rows[i]["ResourceToResourceFolder_Id"].ToString();
listReturn.Add(new
{
inum = (i + 1),
docId = dtRes.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
docName = docName,
docType = dtRes.Rows[i]["File_Suffix"].ToString(),
docSize = pfunction.ConvertDocSizeUnit(dtRes.Rows[i]["Resource_ContentLength"].ToString()),
docTime = pfunction.ConvertToLongDateTime(dtRes.Rows[i]["CreateTime"].ToString())
});
}
#endregion
if (inum > 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 = "error"//ex.Message.ToString()
}));
}
}
public Model_VSysUserRole GetVDoctorInfoModelByLogin(string SysUser_LoginName, string SysUser_PassWord)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 * ");
builder.Append(",dbo.f_GetUserRoleIDs(SysUser_ID) as SysRole_IDs ");
builder.Append(",dbo.f_GetUserRoleNames(SysUser_ID) as SysRole_Names ");
builder.Append(" from SysUser ");
builder.Append(" where SysUser_Enable = 1 and SysUser_LoginName=@SysUser_LoginName and SysUser_PassWord=@SysUser_PassWord ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysUser_LoginName", SqlDbType.Char, 0x24), new SqlParameter("@SysUser_PassWord", SqlDbType.Char, 0x24) };
cmdParms[0].Value = SysUser_LoginName;
cmdParms[1].Value = SysUser_PassWord;
Model_VSysUserRole role = new Model_VSysUserRole();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if ((set.Tables[0].Rows[0]["SysUser_ID"] != null) && (set.Tables[0].Rows[0]["SysUser_ID"].ToString() != ""))
{
role.SysUser_ID = set.Tables[0].Rows[0]["SysUser_ID"].ToString();
}
if ((set.Tables[0].Rows[0]["SysUser_Name"] != null) && (set.Tables[0].Rows[0]["SysUser_Name"].ToString() != ""))
{
role.SysUser_Name = set.Tables[0].Rows[0]["SysUser_Name"].ToString();
}
if ((set.Tables[0].Rows[0]["SysRole_IDs"] != null) && (set.Tables[0].Rows[0]["SysRole_IDs"].ToString() != ""))
{
role.SysRole_IDs = set.Tables[0].Rows[0]["SysRole_IDs"].ToString();
}
if ((set.Tables[0].Rows[0]["SysRole_Names"] != null) && (set.Tables[0].Rows[0]["SysRole_Names"].ToString() != ""))
{
role.SysRole_Names = set.Tables[0].Rows[0]["SysRole_Names"].ToString();
}
if ((set.Tables[0].Rows[0]["SysUser_LoginName"] != null) && (set.Tables[0].Rows[0]["SysUser_LoginName"].ToString() != ""))
{
role.SysUser_LoginName = set.Tables[0].Rows[0]["SysUser_LoginName"].ToString();
}
if ((set.Tables[0].Rows[0]["SysUser_PassWord"] != null) && (set.Tables[0].Rows[0]["SysUser_LoginName"].ToString() != ""))
{
role.SysUser_PassWord = set.Tables[0].Rows[0]["SysUser_PassWord"].ToString();
}
if ((set.Tables[0].Rows[0]["SysUser_Tel"] != null) && (set.Tables[0].Rows[0]["SysUser_Tel"].ToString() != ""))
{
role.SysUser_Tel = set.Tables[0].Rows[0]["SysUser_Tel"].ToString();
}
if ((set.Tables[0].Rows[0]["SysDepartment_ID"] != null) && (set.Tables[0].Rows[0]["SysDepartment_ID"].ToString() != ""))
{
role.SysDepartment_ID = set.Tables[0].Rows[0]["SysDepartment_ID"].ToString();
}
if ((set.Tables[0].Rows[0]["SysUser_Enable"] != null) && (set.Tables[0].Rows[0]["SysUser_Enable"].ToString() != ""))
{
role.SysUser_Enable = new bool?(Convert.ToBoolean(set.Tables[0].Rows[0]["SysUser_Enable"]));
}
if ((set.Tables[0].Rows[0]["SysUser_Remark"] != null) && (set.Tables[0].Rows[0]["SysUser_Remark"].ToString() != ""))
{
role.SysUser_Remark = set.Tables[0].Rows[0]["SysUser_Remark"].ToString();
}
if ((set.Tables[0].Rows[0]["CreateTime"] != null) && (set.Tables[0].Rows[0]["CreateTime"].ToString() != ""))
{
role.CreateTime = new DateTime?(Convert.ToDateTime(set.Tables[0].Rows[0]["CreateTime"].ToString()));
}
if ((set.Tables[0].Rows[0]["UpdateTime"] != null) && (set.Tables[0].Rows[0]["UpdateTime"].ToString() != ""))
{
role.UpdateTime = new DateTime?(Convert.ToDateTime(set.Tables[0].Rows[0]["UpdateTime"].ToString()));
}
if ((set.Tables[0].Rows[0]["CreateUser"] != null) && (set.Tables[0].Rows[0]["CreateUser"].ToString() != ""))
{
role.CreateUser = set.Tables[0].Rows[0]["CreateUser"].ToString();
}
if ((set.Tables[0].Rows[0]["UpdateUser"] != null) && (set.Tables[0].Rows[0]["UpdateUser"].ToString() != ""))
{
role.UpdateUser = set.Tables[0].Rows[0]["UpdateUser"].ToString();
}
return(role);
}
/// <summary>
/// 验证试卷是否有效
/// </summary>
/// <param name="Two_WayChecklist_Id"></param>
/// <param name="arrRTRF"></param>
/// <param name="msg"></param>
/// <returns></returns>
private static bool VerifyTestpaper(string TestPaper_Frame_Id, string TestPaper_FrameDetail_Id, string[] arrRTRF, out string msg)
{
bool flag = true;
msg = string.Empty;
try
{
TestPaper_Frame_Id = TestPaper_Frame_Id.Filter();
TestPaper_FrameDetail_Id = TestPaper_FrameDetail_Id.Filter();
BLL_Two_WayChecklistDetail bll = new BLL_Two_WayChecklistDetail();
BLL_TestQuestions_Score bllTQScore = new BLL_TestQuestions_Score();
DataTable dtTWC_Count = new DataTable(); // 双向细目表总分、试题数量
DataTable dtTWC = new DataTable(); // 双向细目表明细
DataTable dtTQ_Count = new DataTable(); // 习题集资源总分、试题数量
DataTable dtTQScore = new DataTable(); // 习题集试题明细
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
string strSql = string.Empty;
strSql = string.Format(@"select count(1) as ICount,sum(Score) as SumScore from TestPaper_FrameDetail
where ParentId!='0' and TestPaper_FrameDetail_Id='{0}' ", TestPaper_FrameDetail_Id);
dtTWC_Count = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
DataRow drTWC_Count = dtTWC_Count.Rows[0];
int twCount = 0;
double twSumScore = 0;
int.TryParse(drTWC_Count["ICount"].ToString(), out twCount);
double.TryParse(drTWC_Count["SumScore"].ToString(), out twSumScore);
strSql = string.Empty;
strSql = string.Format(@"select t.* from TestPaper_FrameDetail t
where t.ParentId!='0' and t.TestPaper_FrameDetail_Id='{0}' order by t.TestQuestions_Num,t.CreateTime ", TestPaper_FrameDetail_Id);
dtTWC = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
foreach (var rtrfId in arrRTRF)
{
List <Model_TestPaper_FrameDetailToTestQuestions> listmodel = new List <Model_TestPaper_FrameDetailToTestQuestions>();
string strSqlTQ = string.Empty;
strSqlTQ = string.Format(@"select max(rtrf.Resource_Name) as Resource_Name,count(1) as ICount ,sum(t.TestQuestions_SumScore) as SumScore from (
select TestQuestions_SumScore,tq.ResourceToResourceFolder_Id from TestQuestions tq
where tq.TestQuestions_Type!='title' and tq.TestQuestions_Type<>'' and tq.[type]='simple' and tq.ResourceToResourceFolder_Id='{0}'
union all
select TestQuestions_SumScore,tq.ResourceToResourceFolder_Id from TestQuestions tq
where tq.Parent_Id='0' and tq.[type]='complex' and tq.ResourceToResourceFolder_Id='{0}'
) t inner join ResourceToResourceFolder rtrf on rtrf.ResourceToResourceFolder_Id=t.ResourceToResourceFolder_Id", rtrfId);
dtTQ_Count = Rc.Common.DBUtility.DbHelperSQL.Query(strSqlTQ).Tables[0];
DataRow drTQ_Count = dtTQ_Count.Rows[0];
int tqCount = 0;
double tqSumScore = 0;
int.TryParse(drTQ_Count["ICount"].ToString(), out tqCount);
double.TryParse(drTQ_Count["SumScore"].ToString(), out tqSumScore);
if (flag)
{
string strSqlScore = string.Empty;
strSqlScore = string.Format(@"select * from (
select tq.TestQuestions_Id,tq.TestQuestions_Type,tq.[type],tq.TestQuestions_Num,tq.topicNumber,tq.TestQuestions_SumScore from TestQuestions tq
where tq.TestQuestions_Type!='title' and tq.TestQuestions_Type<>'' and tq.[type]='simple' and tq.ResourceToResourceFolder_Id='{0}'
union all
select tq.TestQuestions_Id,tq.TestQuestions_Type,tq.[type],tq.TestQuestions_Num,tq.topicNumber,tq.TestQuestions_SumScore from TestQuestions tq
where tq.Parent_Id='0' and tq.[type]='complex' and tq.ResourceToResourceFolder_Id='{0}'
) t order by TestQuestions_Num ", rtrfId);
dtTQScore = Rc.Common.DBUtility.DbHelperSQL.Query(strSqlScore).Tables[0];
int row = 0;
foreach (DataRow item in dtTQScore.Rows)
{
if (flag && dtTWC.Rows[0]["TestPaper_FrameType"].ToString() == "simple" && item["type"].ToString() == "complex")
{
flag = false;
msg = string.Format("资源【{0}】第{1}题{2}与双向细目表不匹配"
, drTQ_Count["Resource_Name"].ToString().ReplaceForFilter()
, dtTQScore.Rows[row]["topicNumber"]
, "试题类型");
}
if (flag && dtTWC.Rows[0]["TestPaper_FrameType"].ToString() == "complex" && item["type"].ToString() != "complex")
{
flag = false;
msg = string.Format("资源【{0}】第{1}题{2}与双向细目表不匹配"
, drTQ_Count["Resource_Name"].ToString().ReplaceForFilter()
, dtTQScore.Rows[row]["topicNumber"]
, "试题类型");
}
double twScore = 0; // 双向细目表分值
double tqScore = 0; // 试题分值
double.TryParse(dtTWC.Rows[0]["Score"].ToString(), out twScore);
double.TryParse(item["TestQuestions_SumScore"].ToString(), out tqScore);
if (flag && twScore != tqScore)
{
flag = false;
msg = string.Format("资源【{0}】第{1}题{2}与双向细目表不匹配"
, drTQ_Count["Resource_Name"].ToString().ReplaceForFilter()
, item["topicNumber"]
, "试题分值");
}
Model_TestPaper_FrameDetailToTestQuestions model = new Model_TestPaper_FrameDetailToTestQuestions();
model.TestPaper_FrameDetailToTestQuestions_Id = Guid.NewGuid().ToString();
model.TestPaper_Frame_Id = dtTWC.Rows[0]["TestPaper_Frame_Id"].ToString();
model.TestPaper_FrameDetail_Id = dtTWC.Rows[0]["TestPaper_FrameDetail_Id"].ToString();
model.ResourceToResourceFolder_Id = rtrfId;
model.TestQuestions_Id = item["TestQuestions_Id"].ToString();
model.CreateTime = DateTime.Now;
model.CreateUser = loginUser.SysUser_ID;
listmodel.Add(model);
row++;
}
}
if (flag)
{
if (new BLL_TestPaper_FrameToTestpaper().GetRecordCount("TestPaper_Frame_Id='" + TestPaper_FrameDetail_Id + "' and ResourceToResourceFolder_Id='" + rtrfId + "'") > 0)
{
Rc.Common.DBUtility.DbHelperSQL.ExecuteSqlByTime(string.Format("exec P_GenerateTF_Attr '{0}','{1}'", TestPaper_Frame_Id, loginUser.SysUser_ID), 7200);
flag = true;
}
else
{
Rc.Model.Resources.Model_TestPaper_FrameToTestpaper model = new Rc.Model.Resources.Model_TestPaper_FrameToTestpaper();
model.CreateTime = DateTime.Now;
model.CreateUser = loginUser.SysUser_ID;
model.ResourceToResourceFolder_Id = rtrfId;
model.TestPaper_FrameToTestpaper_Id = Guid.NewGuid().ToString();
model.TestPaper_Frame_Id = TestPaper_FrameDetail_Id;
model.TestPaper_FrameToTestpaper_Type = "1";
if (new BLL_TestPaper_FrameToTestpaper().AddRelationPaper(model, listmodel) > 0)
{
Rc.Common.DBUtility.DbHelperSQL.ExecuteSqlByTime(string.Format("exec P_GenerateTF_Attr '{0}','{1}'", TestPaper_Frame_Id, loginUser.SysUser_ID), 7200);
flag = true;
}
else
{
flag = false;
msg = "关联试卷失败";
}
}
}
}
}
catch (Exception ex)
{
flag = false;
msg = ex.Message.ToString();
}
return(flag);
}
public static string GetAudioVideoBook(string BookName, string FileName, string Year, string strGradeTerm, string strSubject, string strResource_Version, int PageIndex, int PageSize)
{
try
{
BookName = BookName.Filter();
FileName = FileName.Filter();
Year = Year.Filter();
strGradeTerm = strGradeTerm.Filter();
strSubject = strSubject.Filter();
strResource_Version = strResource_Version.Filter();
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
#region 图书信息
DataTable dtBook = new DataTable();
List <object> listReturn = new List <object>();
string strSql = string.Empty;
string strSqlCount = string.Empty;
string StrWhere = " where 1=1 ";
if (!string.IsNullOrEmpty(BookName))
{
StrWhere += " and BookName like '%" + BookName.TrimEnd() + "'%";
}
if (!string.IsNullOrEmpty(FileName))
{
StrWhere += " and AudioVideoBookId in(select AudioVideoBookId from AudioVideoIntro where FileName like '%" + FileName + "%') ";
}
if (!string.IsNullOrEmpty(Year) && Year != "-1")
{
StrWhere += " and ParticularYear='" + Year + "'";
}
if (!string.IsNullOrEmpty(strGradeTerm) && strGradeTerm != "-1")
{
StrWhere += " and GradeTerm='" + strGradeTerm + "'";
}
if (!string.IsNullOrEmpty(strSubject) && strSubject != "-1")
{
StrWhere += " and Subject='" + strSubject + "'";
}
if (!string.IsNullOrEmpty(strResource_Version) && strResource_Version != "-1")
{
StrWhere += " and Resource_Version='" + strResource_Version + "'";
}
//if (loginUser.SysUser_ID != Consts.AdminID && loginUser.SysUser_ID != Consts.CAdminID)
//{
// //strWhere += " and CreateUser='******' ";
// StrWhere += " and ParticularYear in(select TaskId from SysUserTask where TaskType='NF' and SysUser_Id='" + loginUser.SysUser_ID + "') ";
// StrWhere += " and Resource_Version in(select TaskId from SysUserTask where TaskType='JCBB' and SysUser_Id='" + loginUser.SysUser_ID + "') ";
// StrWhere += " and Subject in(select TaskId from SysUserTask where TaskType='XK' and SysUser_Id='" + loginUser.SysUser_ID + "') ";
// StrWhere += " and GradeTerm in(select TaskId from SysUserTask where TaskType='NJXQ' and SysUser_Id='" + loginUser.SysUser_ID + "') ";
//}
strSqlCount = @"select count(*) from AudioVideoBook" + StrWhere + " ";
strSql = @"select * from (select ROW_NUMBER() over(ORDER BY A.CreateTime DESC) row,A.* ,cdG.D_Name GradeTermName,cdr.D_Name Resource_VersionName,cdS.D_Name SubjectName from dbo.AudioVideoBook A
left join dbo.Common_Dict cdG on cdg.Common_Dict_ID=A.GradeTerm
left join dbo.Common_Dict cdR on cdr.Common_Dict_ID=A.Resource_Version
left join dbo.Common_Dict cdS on cds.Common_Dict_ID=A.Subject"
+ StrWhere + " ) t where row between " + ((PageIndex - 1) * PageSize + 1) + " and " + (PageIndex * PageSize) + " ";
dtBook = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
int rCount = Convert.ToInt32(Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSqlCount).ToString());
int inum = 0;
for (int i = 0; i < dtBook.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
inum = (i + 1),
BookName = dtBook.Rows[i]["BookName"].ToString(),
CreateTime = pfunction.ConvertToLongDateTime(dtBook.Rows[i]["CreateTime"].ToString()),
ParticularYear = dtBook.Rows[i]["ParticularYear"].ToString(),
GradeTermName = dtBook.Rows[i]["GradeTermName"].ToString(),
Resource_VersionName = dtBook.Rows[i]["Resource_VersionName"].ToString(),
SubjectName = dtBook.Rows[i]["SubjectName"].ToString(),
AudioVideoBookId = dtBook.Rows[i]["AudioVideoBookId"].ToString(),
BookNameUrl = HttpContext.Current.Server.UrlEncode(dtBook.Rows[i]["BookName"].ToString())
});
}
#endregion
if (inum > 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 = "error"//ex.Message.ToString()
}));
}
}
public static string GetStatTest_TestRListPage(string ssubject, string struserid, int PageSize, int PageIndex)
{
try
{
PageIndex = Convert.ToInt32(PageIndex.ToString().Filter());
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
#region 资源信息
DataTable dtRes = new DataTable();
List <object> listReturn = new List <object>();
string strSql = string.Empty;
string strSqlCount = string.Empty;
string strWhere = string.Empty;
if (!string.IsNullOrEmpty(ssubject))
{
strWhere = " and ssubject='" + ssubject + "' ";
}
strWhere += " and UserId='" + struserid + "' ";
strSqlCount = @"select count(1) from StatTest_TestR A where 1=1 " + strWhere;
strSql = @"select * from (select ROW_NUMBER() over(ORDER BY SRank desc) row,A.* from StatTest_TestR A where 1=1 "
+ strWhere + " ) z where row between " + ((PageIndex - 1) * PageSize + 1) + " and " + (PageIndex * PageSize) + " ";
dtRes = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
int rCount = Convert.ToInt32(Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSqlCount).ToString());
int inum = 0;
for (int i = 0; i < dtRes.Rows.Count; i++)
{
inum++;
listReturn.Add(new
{
inum = (i + 1),
SSubjectName = dtRes.Rows[i]["SSubjectName"].ToString(),
SRank = dtRes.Rows[i]["SRank"].ToString(),
HomeWork_Name = dtRes.Rows[i]["HomeWork_Name"].ToString(),
HomeWorkDate = dtRes.Rows[i]["HomeWorkDate"].ToString(),
SAverageScore = dtRes.Rows[i]["SAverageScore"].ToString(),
});
}
#endregion
if (inum > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = rCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception)
{
return(JsonConvert.SerializeObject(new
{
err = "error"//ex.Message.ToString()
}));
}
}
public static string GetFUserList(string UserName, int PageIndex, int PageSize)
{
try
{
Model_VSysUserRole loginUser = (Model_VSysUserRole)HttpContext.Current.Session["LoginUser"];
Model_Struct_Func UserFun = new Rc.Cloud.BLL.BLL_clsAuth().GetUserFunc(loginUser.SysUser_ID, (loginUser == null ? "''" : clsUtility.ReDoStr(loginUser.SysRole_IDs, ',')), "90200300");
UserName = UserName.Filter();
string strWhere = string.Empty;
strWhere = "1=1";
if (!string.IsNullOrEmpty(UserName))
{
strWhere += " AND (UserName like '%" + UserName + "%' or TrueName like '%" + UserName + "%') ";
}
int intRecordCount = 0;
List <object> listReturn = new List <object>();
BLL_F_User bll_f_user = new BLL_F_User();
DataTable dt = bll_f_user.GetListPage(strWhere, "CreateTime DESC", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0];
intRecordCount = bll_f_user.GetRecordCount(strWhere);
foreach (DataRow item in dt.Rows)
{
string strSex = string.Empty;
switch (item["Sex"].ToString())
{
case "M":
strSex = "男";
break;
case "F":
strSex = "女";
break;
case "S":
strSex = "保密";
break;
default:
strSex = "";
break;
}
string strOperate = string.Empty;
if (UserFun.Edit)
{
strOperate += string.Format("<a href=\"javascript:changepwd('{0}');\">修改密码</a>", item["UserId"]);
strOperate += string.Format("<a href=\"javascript:Update('{0}');\">修改账号</a>", item["UserId"]);
}
if (UserFun.Select)
{
strOperate += string.Format("<a href=\"javascript:Show('{0}');\">查看</a>", item["UserId"]);
}
if (UserFun.Delete)
{
strOperate += string.Format("<a href=\"javascript:del('{0}');\">删除</a>", item["UserId"]);
}
listReturn.Add(new
{
UserName = item["UserName"].ToString(),
TrueName = item["TrueName"].ToString(),
UserPostName = item["UserPostName"].ToString(),
Sex = strSex,
Email = item["Email"].ToString(),
Mobile = item["Mobile"].ToString(),
SubjectName = item["SubjectName"].ToString(),
UserId = item["UserId"].ToString(),
Operate = strOperate
});
}
if (dt.Rows.Count > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
PageIndex = PageIndex,
PageSize = PageSize,
TotalCount = intRecordCount,
list = listReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = "error"
}));
}
}
