public bool Delete(Stuinfo stu, out string msg)
{
int result = dal.Delete(stu, out msg);
if (result > 0)
{
return(true);
}
return(false);
}
public bool IsLoginSuccess(Stuinfo stu, out string msg)
{
int result = dal.Islogin(stu, out msg);
if (result > 0)
{
return(true);
}
return(false);
}
public bool IsUpdateSucces(Stuinfo stu, out string msg)
{
int result = dal.UpDateStuInfo(stu, out msg);
if (result > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 提交按键功能
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
Stuinfo stu = new Stuinfo();
#region 是否有修改
stu.SNO = txtSNO.Text;
stu.Pwd = txtPwd.Text;
stu.StuName = txtStuName.Text;
if (Convert.ToInt32(txtAge.Text) <= 35 && Convert.ToInt32(txtAge.Text) > 1)
{
stu.Age = Convert.ToInt32(txtAge.Text);
}
else
{
MessageBox.Show("你输入的年龄不符合规则,请重新输入");
txtAge.Focus();
return;
}
if (rboMan.Checked == true)
{
stu.Sex = "男";
}
else
if (rboWoman.Checked == true)
{
stu.Sex = "女";
}
stu.Address = txtAddress.Text;
#endregion
bool result = bll.IsUpdateSucces(stu, out msg);
if (msg != "")
{
MessageBox.Show(msg);
}
if (result)
{
MessageBox.Show("编辑成功");
BindData();
frmStuinfoManage frm = new frmStuinfoManage();
frm.Show();
this.Close();
}
else
{
MessageBox.Show("填入的数据有误，请核对过后重新输入");
}
}
public Stuinfo GetStuInfo(Stuinfo stu, out string msg)
{
Stuinfo[] list = dal.GetStuInfoList(stu, false, out msg);
if (list != null)
{
Stuinfo s = list[0];
return(s);
}
return(null);
}
/// <summary>
/// 删除按键功能
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDel_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("是否确认删除", "删除提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2);
if (dr == System.Windows.Forms.DialogResult.Yes)
{
Stuinfo s = new Stuinfo();
s.SNO = dgvStuinfo.SelectedRows[0].Cells["SNO"].Value.ToString();
bool result = bll.Delete(s, out msg);
MessageBox.Show("删除成功");
BindData();
}
}
public ActionResult EditModel(Stuinfo stu)
{
string sql = "UPDATE STUINFO set Name=:Name,Sex=:Sex,Age=:Age,Email=:Email,CId=:CId,AddTime=:AddTime where ID=:ID";
using (OracleConnection conn = DapperFactory.CrateOracleConnection())
{
if (conn.Execute(sql, stu) < 0)
{
ViewBag.Msg = "修改失败！";
}
return(RedirectToAction("Index"));
}
}
public int Islogin(Stuinfo stu, out string msg)
{
StringBuilder sb = new StringBuilder();
sb.Append("select count(1) from stuInfo where 1=1");
SqlParameter sqsno = new SqlParameter("@sno", stu.SNO);
SqlParameter sqpwd = new SqlParameter("@pwd", stu.Pwd);
SqlParameter[] sqlist = { sqsno, sqpwd };
return(Convert.ToInt32(sh.ExecuteScalar(sb.ToString(), sqlist, out msg)));
}
/// <summary>
/// 删除一条选中信息
/// </summary>
/// <param name="stu"></param>
/// <param name="msg"></param>
/// <returns></returns>
public int Delete(Stuinfo stu, out string msg)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from stuinfo where ");
if (!string.IsNullOrEmpty(stu.SNO))
{
sb.AppendFormat(" sno = '{0}'", stu.SNO);
}
int result = sh.ExecuteNonquery(sb.ToString(), out msg);
return(result);
}
/// <summary>
/// 获取学生信息
/// </summary>
/// <param name="stu"></param>
/// <param name="isLike"></param>
/// <param name="msg"></param>
/// <returns></returns>
public Stuinfo[] GetStuInfoList(Stuinfo stu, bool isLike, out string msg)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from stuinfo where 1=1 ");
if (isLike)
{
//不显示admin这一行的值
sb.Append(" and sno <> 'admin' ");
if (!string.IsNullOrEmpty(stu.SNO))
{
sb.AppendFormat(" and sno like '%{0}%'", stu.SNO);
}
}
else
{
sb.AppendFormat("and sno = '{0}'", stu.SNO);
}
if (!string.IsNullOrEmpty(stu.StuName))
{
sb.AppendFormat(" and stuname like '%{0}%'", stu.StuName);
}
DataTable dt = sh.ExecuteDataAdapter(sb.ToString(), out msg);
if (dt != null && dt.Rows.Count > 0)
{
Stuinfo[] list = new Stuinfo[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
Stuinfo s = new Stuinfo();
s.SNO = dt.Rows[i]["SNO"].ToString();
s.Pwd = dt.Rows[i]["pwd"].ToString();
s.StuName = dt.Rows[i]["StuName"].ToString();
s.Sex = dt.Rows[i]["Sex"].ToString();
s.Age = dt.Rows[i]["Age"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i]["Age"]);
s.Address = dt.Rows[i]["Address"] == DBNull.Value ? "" : dt.Rows[i]["Address"].ToString();
s.Role = dt.Rows[i]["Role"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i]["Role"]);
s.BirthDay = dt.Rows[i]["BirthDay"] == DBNull.Value ? DateTime.Now.AddYears(-150) : Convert.ToDateTime(dt.Rows[i]["BirthDay"]);
list[i] = s;
}
return(list);
}
return(null);
}
/// <summary>
/// 双击修改事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvStuinfo_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
//赋值
Stuinfo s = new Stuinfo();
s.SNO = dgvStuinfo.SelectedRows[0].Cells["SNO"].Value.ToString();
s.Pwd = dgvStuinfo.SelectedRows[0].Cells["Pwd"].Value.ToString();
s.StuName = dgvStuinfo.SelectedRows[0].Cells["StuName"].Value.ToString();
s.Sex = dgvStuinfo.SelectedRows[0].Cells["Sex"].Value.ToString();
s.Age = dgvStuinfo.SelectedRows[0].Cells["Age"].Value == DBNull.Value ? 0 : Convert.ToInt32(dgvStuinfo.SelectedRows[0].Cells["Age"].Value);
s.Address = dgvStuinfo.SelectedRows[0].Cells["Address"].Value == DBNull.Value ? "" : dgvStuinfo.SelectedRows[0].Cells["Address"].Value.ToString();
frmStuEdit stu = new frmStuEdit(s);
stu.Show();
}
/// <summary>
/// 登录管理
/// </summary>
/// <param name="stu"></param>
/// <param name="msg"></param>
public void IsLogin(Stuinfo stu, out string msg)
{
bool result = bll.IsLoginSuccess(stu, out msg);
if (msg != "")
{
MessageBox.Show("msg");
}
if (result)
{
//管理员登录
if (rboadminlogin.Checked)
{
if (frmMain == null)
{
frmMain = new frmAdminMain(this);
}
frmMain.CloseALLChildForm();
frmMain.Show();
}
//学生登录
if (rboStuLogin.Checked)
{
if (stu.SNO != "admin")
{
frmStuMain frm = new frmStuMain(stu.SNO);
frm.Show();
}
else
{
MessageBox.Show("请输入学生账号！");
txtAccount.Text = "";
txtPwd.Text = "";
return;
}
}
this.Hide();
}
else
{
MessageBox.Show("您输入的账号或密码错误，请重新输入");
}
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindData()
{
Stuinfo stu = new Stuinfo();
stu.SNO = txtSNO.Text;
stu.StuName = txtStuname.Text;
Stuinfo[] list = bll.GetStuInfoList(stu, out msg);
//error message
if (msg != "")
{
MessageBox.Show(msg);
}
if (list == null)
{
list = new Stuinfo[0];
}
dgvStuinfo.DataSource = list;
}
public int update_stuinfo(Stuinfo stu1)
{
conn.Open();
comm = new SqlCommand("stuinfo_update", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@stu_id", stu1.Stu_id);
comm.Parameters.AddWithValue("@stu_name", stu1.stu_name);
comm.Parameters.AddWithValue("@stu_sex", stu1.stu_sex);
comm.Parameters.AddWithValue("@stu_nation", stu1.stu_nation);
comm.Parameters.AddWithValue("@stu_birrhday", stu1.stu_birrhday);
comm.Parameters.AddWithValue("@stu_rutime", stu1.stu_rutime);
comm.Parameters.AddWithValue("@stu_class", stu1.stu_class);
comm.Parameters.AddWithValue("@stu_home", stu1.stu_home);
comm.Parameters.AddWithValue("@stu_else", stu1.stu_else);
int result = comm.ExecuteNonQuery();
conn.Close();
return(result);
}
/// <summary>
/// 提交已编辑学生信息
/// </summary>
/// <param name="stu"></param>
/// <param name="msg"></param>
/// <returns></returns>
public int UpDateStuInfo(Stuinfo stu, out string msg)
{
StringBuilder sb = new StringBuilder();
sb.Append("update stuinfo set ");
#region 插入数据
if (!string.IsNullOrEmpty(stu.Pwd))
{
sb.AppendFormat(" pwd = '{0}',", stu.Pwd);
}
if (!string.IsNullOrEmpty(stu.StuName))
{
sb.AppendFormat(" StuName = '{0}',", stu.StuName);
}
if (!string.IsNullOrEmpty(stu.Age.ToString()))
{
sb.AppendFormat(" Age = '{0}',", stu.Age);
}
if (!string.IsNullOrEmpty(stu.Sex))
{
sb.AppendFormat(" Sex = '{0}',", stu.Sex);
}
if (!string.IsNullOrEmpty(stu.Address))
{
sb.AppendFormat(" Address = '{0}',", stu.Address);
}
if (!string.IsNullOrEmpty(stu.BirthDay.ToString()))
{
sb.AppendFormat(" BirthDay = '{0}',", stu.BirthDay);
}
sb.Remove(sb.Length - 1, 1);
#endregion
if (!string.IsNullOrEmpty(stu.SNO))
{
sb.AppendFormat(" where sno = '{0}' ", stu.SNO);
}
int result = sh.ExecuteNonquery(sb.ToString(), out msg);
return(result);
}
/// <summary>
/// 获取信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnGetStuInfo_Click(object sender, EventArgs e)
{
if (txtSNO.Text == "")
{
MessageBox.Show("请输入学号");
txtSNO.Focus();
return;
}
Stuinfo stu = new Stuinfo();
stu.SNO = txtSNO.Text;
txtSNO.Enabled = false;
Stuinfo s = bll.GetStuInfo(stu, out msg);
if (s != null) //
{
txtSNO.Text = s.SNO;
txtStuName.Text = s.StuName;
txtPwd.Text = s.Pwd;
txtAge.Text = s.Age.ToString();
if (s.Sex == "男")
{
rboMan.Checked = true;
}
else
if (s.Sex == "女")
{
rboWoman.Checked = true;
}
txtAddress.Text = s.Address;
}
else
{
MessageBox.Show("该学号不存在");
Clear();
}
}
public void Login()
{
if (!CheckTxTControl())
{
return;
}
Stuinfo stu = new Stuinfo();
stu.SNO = txtAccount.Text;
stu.Pwd = txtPwd.Text;
//管理员登陆
if (rboadminlogin.Checked)
{
IsLogin(stu, out msg);
}
//学生登陆
if (rboStuLogin.Checked)
{
IsLogin(stu, out msg);
}
}
/// <summary>
/// 添加操作
/// </summary>
/// <param name="stuinfo"></param>
/// <returns></returns>
public ActionResult AddStuinfo(Stuinfo stuinfo)
{
if (ModelState.IsValid)
{
string sql = "insert into Stuinfo(Name,Sex,Age,Email,CId,AddTime) VALUES(:Name,:Sex,:Age,:Email,:CId,:AddTime)";
using (OracleConnection conn = DapperFactory.CrateOracleConnection())
{
stuinfo.AddTime = DateTime.Now;
if (conn.Execute(sql, stuinfo) > 0)
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.Msg = "添加失败！";
return(View(stuinfo));
}
}
}
else
{
return(HttpNotFound());
}
}
/// <summary>
/// 提交执行增删改的数据
/// </summary>
/// <param name="sc"></param>
/// <param name="op">0-删除，1-添加，2-修改</param>
/// <param name="msg"></param>
/// <returns></returns>
public int StuEdit(Stuinfo stu, int op, out string msg)
{
StringBuilder sb = new StringBuilder();
switch (op)
{
case 0:
sb.AppendFormat("delete from Stuinfo where SNO={0}", stu.SNO);
break;
case 1:
sb.AppendFormat("insert into Stuinfo values('{0}',", stu.SNO);
sb.AppendFormat("{0},", stu.Age);
sb.AppendFormat("{0},", stu.StuName);
sb.AppendFormat("{0},", stu.Sex);
sb.AppendFormat("{0},", stu.Address);
sb.AppendFormat("{0},)", stu.BirthDay);
break;
case 2:
sb.AppendFormat("update Stuinfo set Age = '{0}' ", stu.Age);
sb.AppendFormat(" and StuName = '{0}'", stu.StuName);
sb.AppendFormat("and Address = '{0}'", stu.Address);
sb.AppendFormat("and BirthDay = '{0}'", stu.BirthDay);
sb.AppendFormat(" where sno = '{0}'", stu.SNO);
break;
default:
msg = "输入的操作无法识别";
return(0);
}
return(sh.ExecuteNonquery(sb.ToString(), out msg));
}
public Stuinfo[] GetStuInfoList(Stuinfo stu, out string msg)
{
Stuinfo[] list = dal.GetStuInfoList(stu, true, out msg);
return(list);
}
public frmStuEdit(Stuinfo stu)
{
InitializeComponent();
s = stu;
}
