protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtusercode.Text.Trim().Length == 0) { strErr += "usercode不能为空!\\n"; } if (this.txtuseraddr.Text.Trim().Length == 0) { strErr += "useraddr不能为空!\\n"; } if (this.txtopertype.Text.Trim().Length == 0) { strErr += "opertype不能为空!\\n"; } if (this.txtoperobject.Text.Trim().Length == 0) { strErr += "operobject不能为空!\\n"; } if (this.txtopervalue.Text.Trim().Length == 0) { strErr += "opervalue不能为空!\\n"; } if (this.txtoperdesc.Text.Trim().Length == 0) { strErr += "operdesc不能为空!\\n"; } if (this.txtopertime.Text.Trim().Length == 0) { strErr += "opertime不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string usercode = this.txtusercode.Text; string useraddr = this.txtuseraddr.Text; string opertype = this.txtopertype.Text; string operobject = this.txtoperobject.Text; string opervalue = this.txtopervalue.Text; string operdesc = this.txtoperdesc.Text; string opertime = this.txtopertime.Text; Jium.Model.userlog model = new Jium.Model.userlog(); model.usercode = usercode; model.useraddr = useraddr; model.opertype = opertype; model.operobject = operobject; model.opervalue = opervalue; model.operdesc = operdesc; model.opertime = opertime; Jium.BLL.userlog bll = new Jium.BLL.userlog(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
private void ShowInfo(long id) { Jium.BLL.userlog bll = new Jium.BLL.userlog(); Jium.Model.userlog model = bll.GetModel(id); this.lblid.Text = model.id.ToString(); this.lblusercode.Text = model.usercode; this.lbluseraddr.Text = model.useraddr; this.lblopertype.Text = model.opertype; this.lbloperobject.Text = model.operobject; this.lblopervalue.Text = model.opervalue; this.lbloperdesc.Text = model.operdesc; this.lblopertime.Text = model.opertime; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Jium.Model.userlog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update userlog set "); strSql.Append("usercode=@usercode,"); strSql.Append("useraddr=@useraddr,"); strSql.Append("opertype=@opertype,"); strSql.Append("operobject=@operobject,"); strSql.Append("opervalue=@opervalue,"); strSql.Append("operdesc=@operdesc,"); strSql.Append("opertime=@opertime"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@usercode", MySqlDbType.VarChar, 40), new MySqlParameter("@useraddr", MySqlDbType.VarChar, 40), new MySqlParameter("@opertype", MySqlDbType.VarChar, 20), new MySqlParameter("@operobject", MySqlDbType.VarChar, 40), new MySqlParameter("@opervalue", MySqlDbType.VarChar, 40), new MySqlParameter("@operdesc", MySqlDbType.VarChar, 100), new MySqlParameter("@opertime", MySqlDbType.VarChar, 20), new MySqlParameter("@id", MySqlDbType.Int64, 20) }; parameters[0].Value = model.usercode; parameters[1].Value = model.useraddr; parameters[2].Value = model.opertype; parameters[3].Value = model.operobject; parameters[4].Value = model.opervalue; parameters[5].Value = model.operdesc; parameters[6].Value = model.opertime; parameters[7].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Jium.Model.userlog DataRowToModel(DataRow row) { Jium.Model.userlog model = new Jium.Model.userlog(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = long.Parse(row["id"].ToString()); } if (row["usercode"] != null) { model.usercode = row["usercode"].ToString(); } if (row["useraddr"] != null) { model.useraddr = row["useraddr"].ToString(); } if (row["opertype"] != null) { model.opertype = row["opertype"].ToString(); } if (row["operobject"] != null) { model.operobject = row["operobject"].ToString(); } if (row["opervalue"] != null) { model.opervalue = row["opervalue"].ToString(); } if (row["operdesc"] != null) { model.operdesc = row["operdesc"].ToString(); } if (row["opertime"] != null) { model.opertime = row["opertime"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Jium.Model.userlog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into userlog("); strSql.Append("usercode,useraddr,opertype,operobject,opervalue,operdesc,opertime)"); strSql.Append(" values ("); strSql.Append("@usercode,@useraddr,@opertype,@operobject,@opervalue,@operdesc,@opertime)"); MySqlParameter[] parameters = { new MySqlParameter("@usercode", MySqlDbType.VarChar, 40), new MySqlParameter("@useraddr", MySqlDbType.VarChar, 40), new MySqlParameter("@opertype", MySqlDbType.VarChar, 20), new MySqlParameter("@operobject", MySqlDbType.VarChar, 40), new MySqlParameter("@opervalue", MySqlDbType.VarChar, 40), new MySqlParameter("@operdesc", MySqlDbType.VarChar, 100), new MySqlParameter("@opertime", MySqlDbType.VarChar, 20) }; parameters[0].Value = model.usercode; parameters[1].Value = model.useraddr; parameters[2].Value = model.opertype; parameters[3].Value = model.operobject; parameters[4].Value = model.opervalue; parameters[5].Value = model.operdesc; parameters[6].Value = model.opertime; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Jium.Model.userlog GetModel(long id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,usercode,useraddr,opertype,operobject,opervalue,operdesc,opertime from userlog "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int64) }; parameters[0].Value = id; Jium.Model.userlog model = new Jium.Model.userlog(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }