public void DelData()
{
string idlist = Parameters["pparm"];
OEQuestionBiz biz = new OEQuestionBiz();
ErrorEntity ErrInfo = new ErrorEntity();
biz.Delete(idlist, out ErrInfo);
Response.Write(ErrInfo.ToJson());
}
protected void Page_Load(object sender, EventArgs e)
{
item = new HQOnlineExam.ML.OEQuestion();
if (!Page.IsPostBack)
{
string _id = Parameters["qid"];
OEQuestionBiz biz = new OEQuestionBiz();
item = biz.Select(_id);
List<OEQuestionItem> lists = new List<OEQuestionItem>();
OEQuestionItemBiz ibiz = new OEQuestionItemBiz();
lists = ibiz.Select(_id);
AddDatasource("itemlists", lists);
}
}
public void GetChoosenList()
{
string _paperid = Parameters["ppaperid"];
string _detailid = Parameters["pdetailid"];
List<HQOnlineExam.ML.OEQuestion> lists = new List<HQOnlineExam.ML.OEQuestion>();
NameValueCollection where = new NameValueCollection();
where.Add("condition", "(FQuestionStatus = '1') and (FQuestionId in (select FQuestionId from t_oe_choosequestion where FPaperId = " + _paperid + " and FDetailId = " + _detailid + "))");
OEQuestionBiz biz = new OEQuestionBiz();
lists = biz.Select(where);
if (lists.Count > 0)
{
Response.Write(Utils.ConvertToJson(lists));
}
else
{
Response.Write("NULL");
}
}
public void SaveQuestion()
{
string _contentclassid = Parameters["pcontentclassid"];
string _questionbank = Parameters["pquestionbank"];
string _questionid = Parameters["pquestionid"];
string _questiontitile = Parameters["pquestiontitle"];
string _questiontype = Parameters["pquestiontype"];
string _questiondiffculty = Parameters["pquestiondifficulty"];
string _keyword = Parameters["pkeyword"];
string _desc = Parameters["pdesc"];
string _analysis = Parameters["panalysis"];
ErrorEntity ErrInfo = new ErrorEntity();
OEQuestionBiz biz = new OEQuestionBiz();
HQOnlineExam.ML.OEQuestion item = new HQOnlineExam.ML.OEQuestion();
SysUser useritem = new SysUser();
useritem = GetUserInfo();
item.AUserId = useritem.FUserId;
item.AUserName = useritem.FUserName;
item.FQuestionId = Convert.ToInt64(_questionid);
item.FQBankId = Convert.ToInt64(_questionbank);
item.FQuestionTitle = _questiontitile;
item.FQuestionType = _questiontype;
item.FQuestionDifficulty = _questiondiffculty;
item.FKeyWord = _keyword;
item.FQuestionDesc = _desc;
item.FQuestionAnalysis = _analysis;
item.FQuestionStatus = "1";
if (string.IsNullOrEmpty(_questionid) || _questionid == "0")
{
biz.Insert(item, out ErrInfo);
}
else
{
biz.Update(item, out ErrInfo);
}
Response.Write(ErrInfo.ToJson());
}
public void GetGridData()
{
string _searchcontent = "";
string _sortname = "";
string _sortdirection = "";
string _pagenumber = "";
string _pagesize = "";
_searchcontent = Parameters["psearchcontent"];
_sortname = Parameters["psortname"];
if (!string.IsNullOrEmpty(_sortname))
{
sSortName = _sortname;
}
_sortdirection = Parameters["psortdirection"];
if (!string.IsNullOrEmpty(_sortdirection))
{
sSortDirection = _sortdirection;
}
_pagenumber = Parameters["ppagenumber"];
if (!string.IsNullOrEmpty(_pagenumber))
{
sPageIndex = Convert.ToInt32(_pagenumber);
}
_pagesize = Parameters["ppagesize"];
if (!string.IsNullOrEmpty(_pagesize))
{
sPageSize = Convert.ToInt32(_pagesize);
}
string _qbankid = Parameters["pqbankid"];
string _tilte = Parameters["ptitle"];
string _type = Parameters["ptype"];
string _diffculty = Parameters["pdifficulty"];
string _keyword = Parameters["pkeyword"];
string _desc = Parameters["pdesc"];
List<HQOnlineExam.ML.OEQuestion> lists = new List<HQOnlineExam.ML.OEQuestion>();
OEQuestionBiz biz = new OEQuestionBiz();
string _searchtext = _searchcontent;
string wheresql = "(FQBankId = " + _qbankid + ") and (FQuestionStatus <> '0') ";
if (!string.IsNullOrEmpty(_tilte))
{
wheresql += " and (FQuestionTilte like '%" + _tilte + "%') ";
}
if (!string.IsNullOrEmpty(_type))
{
wheresql += " and (FQuestionType = '" + _type + "')";
}
if (!string.IsNullOrEmpty(_diffculty))
{
wheresql += " and (FQuestionDifficulty = '" + _diffculty + "')";
}
if (!string.IsNullOrEmpty(_keyword))
{
string _k = _keyword.Trim();
string[] k;
k = _k.Split(' ');
string _sql = "";
for (int i = 0; i < k.Length; i++)
{
if (!string.IsNullOrEmpty(_sql))
{
_sql += " or ";
}
if (!string.IsNullOrEmpty(k[i].Trim()))
{
_sql += " ( FKeyWord like '%" + k[i].Trim() + "%') ";
}
}
if (!string.IsNullOrEmpty(_sql))
{
wheresql += " and (" + _sql + ") ";
}
}
if (!string.IsNullOrEmpty(_desc))
{
wheresql += " and (FQuestionDesc like '%" + _desc + "%') ";
}
NameValueCollection where = new NameValueCollection();
where.Add("condition", wheresql);
NameValueCollection orderby = new NameValueCollection();
orderby.Add(_sortname, _sortdirection);
Int32 totalcount = 0;
lists = biz.Select(where, orderby, Convert.ToInt32(sPageIndex), Convert.ToInt32(sPageSize), out totalcount);
string datasource = Utils.GetRepeaterDatasource(lists, sPageIndex, sPageSize, totalcount);
Response.Write(datasource);
}
public void UpdateStatus()
{
string _id = Parameters["pid"];
string _flag = Parameters["pflag"];
OEQuestionBiz biz = new OEQuestionBiz();
ErrorEntity ErrInfo = new ErrorEntity();
biz.UpdateStatus(_id, _flag, out ErrInfo);
Response.Write(ErrInfo.ToJson());
}
public Int32 Insert(OEQuestionItem item, out ErrorEntity ErrInfo)
{
//Error Judge Define
if (item.FQuestionId == 0)
{
ErrInfo = new ErrorEntity("QI010001", "归属题目ID不能为空!");
return -1;
}
if (string.IsNullOrEmpty(item.FItemContent))
{
ErrInfo = new ErrorEntity("QI010002", "题目答案内容不能为空!");
return -1;
}
if (string.IsNullOrEmpty(item.FItemFlag))
{
item.FItemFlag = "0";
}
//判断题型
NameValueCollection where = new NameValueCollection();
where.Add("FQuestionId", item.FQuestionId.ToString());
List<OEQuestionItem> itemlists = new List<OEQuestionItem>();
itemlists = Select(where);
if (itemlists.Count > 0)
{
OEQuestion qitem = new OEQuestion();
OEQuestionBiz biz = new OEQuestionBiz();
qitem = biz.Select(item.FQuestionId.ToString());
if (qitem.FQuestionType == "0")
{
if(itemlists.Count > 1)
{
ErrInfo = new ErrorEntity("QI010003", "判断题型只能有2个备选答案!");
return -1;
}
}
if (qitem.FQuestionType == "1")
{
if (item.FItemFlag == "1")
{
if (itemlists.Where(p => p.FItemFlag == "1").ToList<OEQuestionItem>().Count > 0)
{
ErrInfo = new ErrorEntity("QI010004", "单选题只能有一个正确答案!");
return -1;
}
}
}
}
item.FItemId = GenerateItemId(item.FQuestionId.ToString());
NameValueCollection parameters = new NameValueCollection();
parameters.Add("FQuestionId", item.FQuestionId.ToString());
parameters.Add("FItemId", item.FItemId.ToString());
parameters.Add("FItemContent", item.FItemContent);
parameters.Add("FItemFlag", item.FItemFlag);
return Insert(parameters, out ErrInfo);
}
public int UpdateRight(string _qid, string _itemid, out ErrorEntity ErrInfo )
{
OEQuestionBiz biz = new OEQuestionBiz();
OEQuestion item = new OEQuestion();
item = biz.Select(_qid);
string _type = item.FQuestionType;
switch (_type)
{
case "1": //判断题
NameValueCollection parameters = new NameValueCollection();
parameters.Add("FItemFlag", "0");
NameValueCollection where = new NameValueCollection();
where.Add("FQuestionId", _qid);
Update(parameters, where, out ErrInfo);
parameters.Clear();
parameters.Add("FItemFlag", "1");
where.Add("FItemId", _itemid);
return Update(parameters, where, out ErrInfo);
case "2":
NameValueCollection parameters1 = new NameValueCollection();
parameters1.Add("FItemFlag", "0");
NameValueCollection where1 = new NameValueCollection();
where1.Add("FQuestionId", _qid);
Update(parameters1, where1, out ErrInfo);
parameters1.Clear();
parameters1.Add("FItemFlag", "1");
where1.Add("FItemId", _itemid);
return Update(parameters1, where1, out ErrInfo);
default:
NameValueCollection parameters2 = new NameValueCollection();
NameValueCollection where2 = new NameValueCollection();
parameters2.Add("FItemFlag", "1");
where2.Add("FQuestionId", _qid);
where2.Add("FItemId", _itemid);
return Update(parameters2, where2, out ErrInfo);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string _id = Parameters["qid"];
item = new HQOnlineExam.ML.OEQuestion();
OEQuestionBiz biz = new OEQuestionBiz();
item = biz.Select(_id);
List<OEQuestionBank> lists = new List<OEQuestionBank>();
OEQuestionBankBiz QBbiz = new OEQuestionBankBiz();
NameValueCollection where = new NameValueCollection();
where.Add("FContentClassId",item.FContentClassId.ToString());
NameValueCollection orderby = new NameValueCollection();
orderby.Add("FQBankCode","asc");
lists = QBbiz.Select(where, orderby);
AddDatasource("QBankList", lists);
}
}
public void GetQuestionList()
{
string _bank = Parameters["pbank"];
string _title = Parameters["ptitle"];
string _keyword = Parameters["pkeyword"];
string _chkpoint = Parameters["ppoint"];
string _paperid = Parameters["ppaperid"];
string _detailid = Parameters["pdetailid"];
string wheresql = "(FQuestionId not in (select FQuestionId from t_oe_choosequestion where FPaperId = " + _paperid + "))";
wheresql += " and (FQuestionStatus = '1')";
wheresql += " and (FQuestionDifficulty in (select FDifficulty from t_oe_paperdetailset where FPaperId = " + _paperid + " and FDetailSetId = " + _detailid + "))";
wheresql += " and (FQuestionType in (select FQuestionType from t_oe_paperdetailset where FPaperId = " + _paperid + " and FDetailSetId = " + _detailid + "))";
if (string.IsNullOrEmpty(_bank))
{
wheresql += " and (FQbankId in (select FQBankId from t_oe_combinebank where FPaperId = " + _paperid + "))";
}
else
{
wheresql += " and (FQBankId = " + _bank + ")";
}
if (!string.IsNullOrEmpty(_title))
{
wheresql += " and (FQuestionTitle like '%" + _title + "%')";
}
if (!string.IsNullOrEmpty(_keyword))
{
string _k = _keyword.Trim();
string[] k;
k = _k.Split(' ');
string _sql = "";
for (int i = 0; i < k.Length; i++)
{
if (!string.IsNullOrEmpty(_sql))
{
_sql += " or ";
}
if (!string.IsNullOrEmpty(k[i].Trim()))
{
_sql += " ( FKeyWord like '%" + k[i].Trim() + "%') ";
}
}
if (!string.IsNullOrEmpty(_sql))
{
wheresql += " and (" + _sql + ") ";
}
}
if (!string.IsNullOrEmpty(_chkpoint))
{
wheresql += " and (FQuestionDesc like '%" + _chkpoint + "%')";
}
List<HQOnlineExam.ML.OEQuestion> lists = new List<HQOnlineExam.ML.OEQuestion>();
OEQuestionBiz biz = new OEQuestionBiz();
NameValueCollection where = new NameValueCollection();
where.Add("condition",wheresql);
lists = biz.Select(where);
if (lists.Count > 0)
{
Response.Write(Utils.ConvertToJson(lists));
}
else
{
Response.Write("NULL");
}
}
public void GetQTypeCount()
{
OEQuestionBiz biz = new OEQuestionBiz();
NameValueCollection where = new NameValueCollection();
string _type = Parameters["ptype"];
string _banklist = Parameters["pidlist"];
where.Add("condition", "(FQuestionType = '" + _type + "') and (FQBankId in (" + _banklist + "))");
Int64 result = biz.SelectCount(where);
Response.Write(result.ToString());
}