private async void doEdit(string strUrl, string strJsonPar)
{
try
{
var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json");
var response = await client.PostAsync(strUrl, stringContent);
if (response.IsSuccessStatusCode)
{
string strJsonRtn = response.Content.ReadAsStringAsync().Result;
ReturnResultEntity <object> returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <object> >(strJsonRtn);
if (returnResultEntity.success)
{
MessageBox.Show("修改密码成功");
this.Close();
}
else
{
MessageBox.Show(returnResultEntity.errorMsg);
}
}
else
{
MessageBox.Show("Post修改密码失败，调用WebApi出错了");
}
}
catch (Exception ex)
{
MessageBox.Show("Post修改密码异常，" + ex.Message);
}
}
private async void doDelete(string strUrl, string strJsonPar)
{
try
{
var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json");
var response = await client.PostAsync(strUrl, stringContent);
if (response.IsSuccessStatusCode)
{
string strJsonRtn = response.Content.ReadAsStringAsync().Result;
ReturnResultEntity <object> returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <object> >(strJsonRtn);
if (returnResultEntity != null)
{
if (returnResultEntity.success)
{
#region 重新查询
binSearch();
#endregion 重新查询
}
else
{
MessageBox.Show("删除试卷失败," + returnResultEntity.errorMsg);
}
}
}
else
{
MessageBox.Show("Post删除试卷失败，调用WebApi出错了");
}
}
catch (Exception ex)
{
MessageBox.Show("删除试卷异常，" + ex.Message);
}
}
public ReturnResultEntity <object> UpdateUser(MyUserEntity myUserPar)
{
ReturnResultEntity <object> returnResultEntity = new ReturnResultEntity <object>();
bool bSuccess = false;
try
{
string sqlOldPwd = string.Format("SELECT user_pwd from my_user where user_id={0} and is_deleted=0 limit 1",
myUserPar.userId);
object objOldPwd = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteScalar(sqlOldPwd);
if (myUserPar.userPwd != objOldPwd.ToString())
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "旧密码输入错误";
return(returnResultEntity);
}
string sql = string.Format("UPDATE my_user set user_pwd='{1}',u_t='{2}' where user_id={0}", myUserPar.userId, myUserPar.userPwdNew, 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 <ShiJuanEntity> > GetEnableShiJuanByCondition(ShiJuanSearchEntity shiJuanSearchEntity)
{
ReturnResultEntity <PageResultEntity <ShiJuanEntity> > returnMessageEntity = new ReturnResultEntity <PageResultEntity <ShiJuanEntity> >();
List <ShiJuanEntity> listShiJuan = new List <ShiJuanEntity>();
int nRowCount = 0;
StringBuilder sbWhere = new StringBuilder();
sbWhere.Append(" where is_deleted=0 ");
if (shiJuanSearchEntity.shiJuanName != null)
{
sbWhere.Append(string.Format(" and shi_juan_name like'%{0}%' ", shiJuanSearchEntity.shiJuanName));
}
if (shiJuanSearchEntity.beginTime != null)
{
sbWhere.Append(string.Format(" and c_t >='{0}' ", shiJuanSearchEntity.beginTime));
}
if (shiJuanSearchEntity.endTime != null)
{
sbWhere.Append(string.Format(" and c_t <='{0}' ", shiJuanSearchEntity.endTime));
}
string strSqlRowCount = "select count(1) rowCount from shi_juan " + 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}",
shiJuanSearchEntity.pageIndex * shiJuanSearchEntity.pageSize, shiJuanSearchEntity.pageSize);
string strSql = "select *from shi_juan" + sbWhere.ToString() + strLimit;
DataTable dtShiJuan = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteTable(strSql);
if (dtShiJuan != null && dtShiJuan.Rows.Count > 0)
{
foreach (DataRow dr in dtShiJuan.Rows)
{
int id = dr["id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["id"].ToString());
string shiJuanName = dr["shi_juan_name"] == DBNull.Value ? string.Empty : dr["shi_juan_name"].ToString();
int isDeleted = dr["is_deleted"] == DBNull.Value ? 0 : Convert.ToInt32(dr["is_deleted"].ToString());
DateTime dtCt = dr["c_t"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["c_t"].ToString());
DateTime dtUt = dr["u_t"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["u_t"].ToString());
ShiJuanEntity shiJuanEntity = new ShiJuanEntity();
shiJuanEntity.id = id;
shiJuanEntity.shiJuanName = shiJuanName;
shiJuanEntity.isDeleted = isDeleted;
shiJuanEntity.cT = dtCt;
shiJuanEntity.uT = dtUt;
listShiJuan.Add(shiJuanEntity);
}
}
PageResultEntity <ShiJuanEntity> pageResultEntity = new PageResultEntity <ShiJuanEntity>();
pageResultEntity.rowCount = nRowCount;
pageResultEntity.dataList = listShiJuan;
returnMessageEntity.success = true;
returnMessageEntity.data = pageResultEntity;
return(returnMessageEntity);
}
private async void doSearch(string strUrl, string strJsonPar)
{
try
{
List <ShiTiEntity> listShiTi = new List <ShiTiEntity>();
int nRowCount = 0;
var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json");
var response = await client.PostAsync(strUrl, stringContent);
if (response.IsSuccessStatusCode)
{
string strJsonRtn = response.Content.ReadAsStringAsync().Result;
//List < ShiJuanEntity > listShiJuan
ReturnResultEntity <PageResultEntity <ShiTiEntity> > returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <PageResultEntity <ShiTiEntity> > >(strJsonRtn);
if (returnResultEntity != null)
{
if (returnResultEntity.success)
{
PageResultEntity <ShiTiEntity> pageResultEntity = returnResultEntity.data;
listShiTi = pageResultEntity.dataList;
nRowCount = pageResultEntity.rowCount;
}
else
{
MessageBox.Show("查询失败," + returnResultEntity.errorMsg);
}
}
#region 初始化
dgvShiTi.DataSource = null;
lblAllPageNum.Text = "共0页";
lblRowNums.Text = "0道试题";
txtCurrentPage.Text = "1";
#endregion 初始化
dgvShiTi.DataSource = listShiTi.ToArray();
nPageCount = (nRowCount + (nPageSize - 1)) / nPageSize;
lblAllPageNum.Text = "共" + nPageCount.ToString() + "页";
lblRowNums.Text = nRowCount.ToString() + "道试题";
txtCurrentPage.Text = (nPageIndex + 1).ToString();
}
else
{
MessageBox.Show("Post查询全部试题失败，调用WebApi出错了");
}
}
catch (Exception ex)
{
MessageBox.Show("查询全部试题异常，" + ex.Message);
}
}
private async void doSearchTiXing(string strUrl, string strJsonPar)
{
try
{
List <TiXingEntity> listTiXing = new List <TiXingEntity>();
var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json");
var response = await client.PostAsync(strUrl, stringContent);
if (response.IsSuccessStatusCode)
{
string strJsonRtn = response.Content.ReadAsStringAsync().Result;
ReturnResultEntity <List <TiXingEntity> > returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <List <TiXingEntity> > >(strJsonRtn);
if (returnResultEntity != null)
{
if (returnResultEntity.success)
{
listTiXing = returnResultEntity.data;
}
else
{
MessageBox.Show("查询失败," + returnResultEntity.errorMsg);
}
}
}
else
{
MessageBox.Show("Post查询全部题型失败，调用WebApi出错了");
}
TiXingEntity tiXingRoot = new TiXingEntity();
tiXingRoot.tiXingName = "全部";
tiXingRoot.tiXingValue = "全部";
listTiXing.Insert(0, tiXingRoot);
cmbTiXing.DataSource = listTiXing;
cmbTiXing.DisplayMember = "tiXingName";
cmbTiXing.ValueMember = "tiXingValue";
}
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);
}
}
public ReturnResultEntity <MyUserEntity> Login(MyUserEntity myUserPar)
{
ReturnResultEntity <MyUserEntity> returnResultEntity = new ReturnResultEntity <MyUserEntity>();
try
{
if (myUserPar == null)
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "参数不能为空";
return(returnResultEntity);
}
MyUserEntity myUserRtn = null;
string sql = string.Format("SELECT * from my_user where user_name='{0}' and user_pwd='{1}' and is_deleted=0",
myUserPar.userName, myUserPar.userPwd);
DataTable dtUser = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteTable(sql);
if (dtUser != null && dtUser.Rows.Count > 0)
{
DataRow dr = dtUser.Rows[0];
myUserRtn = new MyUserEntity();
myUserRtn.userId = dr["user_id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["user_id"].ToString());
myUserRtn.userName = dr["user_name"] == DBNull.Value ? string.Empty : dr["user_name"].ToString();
myUserRtn.userPhone = dr["user_phone"] == DBNull.Value ? string.Empty : dr["user_phone"].ToString();
myUserRtn.userPwd = dr["user_pwd"] == DBNull.Value ? string.Empty : dr["user_pwd"].ToString();
myUserRtn.cT = dr["c_t"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["c_t"].ToString());
myUserRtn.uT = dr["u_t"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["u_t"].ToString());
myUserRtn.isDeleted = dr["is_deleted"] == DBNull.Value ? 0 : Convert.ToInt32(dr["is_deleted"].ToString());
}
returnResultEntity.success = true;
returnResultEntity.data = myUserRtn;
return(returnResultEntity);
}catch (Exception ex)
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "登录异常," + ex.Message;
return(returnResultEntity);
}
}
private async void doLogin(string strUrl, string strJsonPar)
{
try
{
var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json");
var response = await client.PostAsync(strUrl, stringContent);
if (response.IsSuccessStatusCode)
{
string strJsonRtn = response.Content.ReadAsStringAsync().Result;
ReturnResultEntity <MyUserEntity> returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <MyUserEntity> >(strJsonRtn);
if (returnResultEntity.success)
{
MyUserEntity myUserEntity = returnResultEntity.data;
if (myUserEntity != null)
{
FrmShiJuanManager frmShiJuanManager = new FrmShiJuanManager();
frmShiJuanManager.UserId = myUserEntity.userId;
frmShiJuanManager.UserName = myUserEntity.userName;
frmShiJuanManager.Show();
this.Hide();
}
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("Post登录失败，调用WebApi出错了");
}
}catch (Exception ex)
{
MessageBox.Show("Post登录异常，" + 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 <object> UpdateShiJuan(ShiJuanEntity shiJuanEntity)
{
ReturnResultEntity <object> returnResultEntity = new ReturnResultEntity <object>();
bool bSuccess = false;
try
{
string sql = string.Format("UPDATE shi_juan set shi_juan_name='{1}',u_t='{2}' where id={0}", shiJuanEntity.id, shiJuanEntity.shiJuanName, 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);
}
