private void binSearch()
{
try
{
nPageIndex = 0;
string tiXing = cmbTiXing.SelectedValue != null?cmbTiXing.SelectedValue.ToString() : string.Empty;
string zhengWen = txtZhengWen.Text.Trim();
ShiTiSearchEntity shiTiSearchEntity = new ShiTiSearchEntity();
shiTiSearchEntity.pageIndex = nPageIndex;
shiTiSearchEntity.pageSize = nPageSize;
shiTiSearchEntity.shiJuanId = CurrentShiJuanId;
if (tiXing != string.Empty && tiXing != "全部")
{
shiTiSearchEntity.tiXing = tiXing;
}
if (zhengWen != string.Empty)
{
shiTiSearchEntity.zhengWen = zhengWen;
}
string jsonPar = JsonHelper.ToJson(shiTiSearchEntity);
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart_Search;
doSearch(realUrl, jsonPar);
}
catch (Exception ex)
{
MessageBox.Show("查询试题异常," + ex.Message);
}
}
private void dgvShiTi_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int shiTiId = Convert.ToInt32(this.dgvShiTi.CurrentRow.Cells["id"].Value);
string action = dgvShiTi.Columns[e.ColumnIndex].Name;//操作类型
switch (action)
{
case "delete":
if (MessageBox.Show("确定删除吗?", "删除提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart_Delete;
ShiTiSearchEntity shiTiSearchEntity = new ShiTiSearchEntity();
shiTiSearchEntity.shiTiId = shiTiId;
string jsonPar = JsonHelper.ToJson(shiTiSearchEntity);
doDelete(realUrl, jsonPar);
}
break;
default:
break;
}
}
catch (Exception ex)
{
MessageBox.Show("点击异常，" + ex.Message);
}
}
private void btnNext_Click(object sender, EventArgs e)
{
try
{
if ((nPageIndex + 1) >= nPageCount)
{
MessageBox.Show("已经是最后一页了");
return;
}
nPageIndex = nPageIndex + 1;
string tiXing = cmbTiXing.SelectedValue != null?cmbTiXing.SelectedValue.ToString() : string.Empty;
string zhengWen = txtZhengWen.Text.Trim();
ShiTiSearchEntity shiTiSearchEntity = new ShiTiSearchEntity();
shiTiSearchEntity.pageIndex = nPageIndex;
shiTiSearchEntity.pageSize = nPageSize;
shiTiSearchEntity.shiJuanId = CurrentShiJuanId;
if (tiXing != string.Empty && tiXing != "全部")
{
shiTiSearchEntity.tiXing = tiXing;
}
if (zhengWen != string.Empty)
{
shiTiSearchEntity.zhengWen = zhengWen;
}
string jsonPar = JsonHelper.ToJson(shiTiSearchEntity);
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart_Search;
doSearch(realUrl, jsonPar);
}
catch (Exception ex)
{
MessageBox.Show("查询后一页失败," + ex.Message);
}
}
private void txtCurrentPage_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
string strCurrentPage = txtCurrentPage.Text.Trim();
int nCurrentPage = 0;
if (!int.TryParse(strCurrentPage, out nCurrentPage))
{
return;
}
if ((nCurrentPage - 1) < 0)
{
return;
}
if (nCurrentPage > nPageCount)
{
return;
}
nPageIndex = nCurrentPage - 1;
string tiXing = cmbTiXing.SelectedValue != null?cmbTiXing.SelectedValue.ToString() : string.Empty;
string zhengWen = txtZhengWen.Text.Trim();
ShiTiSearchEntity shiTiSearchEntity = new ShiTiSearchEntity();
shiTiSearchEntity.pageIndex = nPageIndex;
shiTiSearchEntity.pageSize = nPageSize;
shiTiSearchEntity.shiJuanId = CurrentShiJuanId;
if (tiXing != string.Empty && tiXing != "全部")
{
shiTiSearchEntity.tiXing = tiXing;
}
if (zhengWen != string.Empty)
{
shiTiSearchEntity.zhengWen = zhengWen;
}
string jsonPar = JsonHelper.ToJson(shiTiSearchEntity);
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart_Search;
doSearch(realUrl, jsonPar);
}
}
catch (Exception ex)
{
MessageBox.Show("试题导航异常，" + ex.Message);
}
}
public ReturnResultEntity <List <TiXingEntity> > GetAllTiXing(ShiTiSearchEntity shiTiSearchEntity)
{
ReturnResultEntity <List <TiXingEntity> > returnMessageEntity = new ReturnResultEntity <List <TiXingEntity> >();
if (shiTiSearchEntity == null)
{
returnMessageEntity.success = false;
returnMessageEntity.errorMsg = "传入参数为null";
return(returnMessageEntity);
}
try
{
List <TiXingEntity> listTiXing = new List <TiXingEntity>();
string strSql = string.Format("select distinct ti_xing from shi_ti where shi_juan_id={0}", shiTiSearchEntity.shiJuanId);
DataTable dtTiXing = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteTable(strSql);
if (dtTiXing != null && dtTiXing.Rows.Count > 0)
{
foreach (DataRow dr in dtTiXing.Rows)
{
string tiXing = dr["ti_xing"] == DBNull.Value ? string.Empty : dr["ti_xing"].ToString();
if (string.IsNullOrEmpty(tiXing))
{
continue;
}
TiXingEntity tiXingEntity = new TiXingEntity();
tiXingEntity.tiXingName = tiXing;
tiXingEntity.tiXingValue = tiXing;
listTiXing.Add(tiXingEntity);
}
}
returnMessageEntity.success = true;
returnMessageEntity.data = listTiXing;
return(returnMessageEntity);
}catch (Exception ex)
{
returnMessageEntity.success = false;
returnMessageEntity.errorMsg = "获取题型失败," + ex.Message;
return(returnMessageEntity);
}
}
private void FrmShiTiManager_Load(object sender, EventArgs e)
{
//DataGridView不能选择
this.dgvShiTi.RowHeadersVisible = false;
//DataGridView 去除未绑定的字段
this.dgvShiTi.AutoGenerateColumns = false;
try
{
lblShiJuanName.Text = CurrentShiJuanName;
ShiTiSearchEntity shiTiSearchEntity = new ShiTiSearchEntity();
shiTiSearchEntity.shiJuanId = CurrentShiJuanId;
string jsonPar = JsonHelper.ToJson(shiTiSearchEntity);
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart_SearchTiXing;
doSearchTiXing(realUrl, jsonPar);
btnSearch_Click(sender, e);
}
catch (Exception ex)
{
MessageBox.Show("加载试题窗体异常," + ex.Message);
}
}
public ReturnResultEntity <object> DeleteShiTi(ShiTiSearchEntity shiTiSearchEntity)
{
ReturnResultEntity <object> returnResultEntity = new ReturnResultEntity <object>();
bool bSuccess = false;
try
{
string sql = string.Format("UPDATE shi_ti set is_deleted=1,u_t='{1}' where id={0}", shiTiSearchEntity.shiTiId, DateTime.Now);
int rowNum = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteNonQuery(sql);
if (rowNum > 0)
{
bSuccess = true;
}
returnResultEntity.success = bSuccess;
returnResultEntity.data = bSuccess;
return(returnResultEntity);
}
catch (Exception ex)
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "删除试题异常," + ex.Message;
return(returnResultEntity);
}
}
public ReturnResultEntity <PageResultEntity <ShiTiEntity> > GetEnableShiTiByCondition(ShiTiSearchEntity shiTiSearchEntity)
{
ReturnResultEntity <PageResultEntity <ShiTiEntity> > returnMessageEntity = new ReturnResultEntity <PageResultEntity <ShiTiEntity> >();
if (shiTiSearchEntity == null)
{
returnMessageEntity.success = false;
returnMessageEntity.errorMsg = "传入参数为null";
return(returnMessageEntity);
}
List <ShiTiEntity> listShiTi = new List <ShiTiEntity>();
int nRowCount = 0;
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" where is_deleted=0 ");
if (shiTiSearchEntity.shiTiId > 0)
{
sbWhere.Append(string.Format(" and id ={0} ", shiTiSearchEntity.shiTiId));
}
else
{
if (shiTiSearchEntity.shiJuanId > 0)
{
sbWhere.Append(string.Format(" and shi_juan_id ={0} ", shiTiSearchEntity.shiJuanId));
}
if (shiTiSearchEntity.tiXing != null && shiTiSearchEntity.tiXing != "全部")
{
sbWhere.Append(string.Format(" and ti_xing ='{0}' ", shiTiSearchEntity.tiXing));
}
if (shiTiSearchEntity.zhengWen != null)
{
sbWhere.Append(string.Format(" and zheng_wen like'%{0}%' ", shiTiSearchEntity.zhengWen));
}
}
string strSqlRowCount = "select count(1) rowCount from shi_ti " + sbWhere.ToString();
object objRowCount = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteScalar(strSqlRowCount);
if (objRowCount != null)
{
nRowCount = Convert.ToInt32(objRowCount);
}
string strLimit = string.Format(" order by id limit {0},{1}",
shiTiSearchEntity.pageIndex * shiTiSearchEntity.pageSize, shiTiSearchEntity.pageSize);
string strSql = "select *from shi_ti" + sbWhere.ToString() + strLimit;
DataTable dtShiJuan = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteTable(strSql);
if (dtShiJuan != null && dtShiJuan.Rows.Count > 0)
{
foreach (DataRow dr in dtShiJuan.Rows)
{
ShiTiEntity shiTiEntity = new ShiTiEntity();
shiTiEntity = ConvertDataRowToShiTiEntity(dr);
listShiTi.Add(shiTiEntity);
}
}
PageResultEntity <ShiTiEntity> pageResultEntity = new PageResultEntity <ShiTiEntity>();
pageResultEntity.rowCount = nRowCount;
pageResultEntity.dataList = listShiTi;
returnMessageEntity.success = true;
returnMessageEntity.data = pageResultEntity;
return(returnMessageEntity);
}
