/// <summary> /// 更新一条数据 /// </summary> public bool Update(WalleProject.Model.t_integratingrecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_integratingrecord set "); strSql.Append("int_date=@int_date,"); strSql.Append("int_integral=@int_integral,"); strSql.Append("int_way=@int_way,"); strSql.Append("int_u_ID=@int_u_ID"); strSql.Append(" where int_ID=@int_ID"); MySqlParameter[] parameters = { new MySqlParameter("@int_date", MySqlDbType.DateTime), new MySqlParameter("@int_integral", MySqlDbType.Int32, 10), new MySqlParameter("@int_way", MySqlDbType.VarChar, 10), new MySqlParameter("@int_u_ID", MySqlDbType.Int32, 10), new MySqlParameter("@int_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.int_date; parameters[1].Value = model.int_integral; parameters[2].Value = model.int_way; parameters[3].Value = model.int_u_ID; parameters[4].Value = model.int_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WalleProject.Model.t_integratingrecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_integratingrecord("); strSql.Append("int_date,int_integral,int_way,int_u_ID)"); strSql.Append(" values ("); strSql.Append("@int_date,@int_integral,@int_way,@int_u_ID)"); MySqlParameter[] parameters = { new MySqlParameter("@int_date", MySqlDbType.DateTime), new MySqlParameter("@int_integral", MySqlDbType.Int32, 10), new MySqlParameter("@int_way", MySqlDbType.VarChar, 10), new MySqlParameter("@int_u_ID", MySqlDbType.Int32, 10) }; parameters[0].Value = model.int_date; parameters[1].Value = model.int_integral; parameters[2].Value = model.int_way; parameters[3].Value = model.int_u_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_integratingrecord DataRowToModel(DataRow row) { WalleProject.Model.t_integratingrecord model = new WalleProject.Model.t_integratingrecord(); if (row != null) { if (row["int_ID"] != null && row["int_ID"].ToString() != "") { model.int_ID = int.Parse(row["int_ID"].ToString()); } if (row["int_date"] != null && row["int_date"].ToString() != "") { model.int_date = DateTime.Parse(row["int_date"].ToString()); } if (row["int_integral"] != null && row["int_integral"].ToString() != "") { model.int_integral = int.Parse(row["int_integral"].ToString()); } if (row["int_way"] != null) { model.int_way = row["int_way"].ToString(); } if (row["int_u_ID"] != null && row["int_u_ID"].ToString() != "") { model.int_u_ID = int.Parse(row["int_u_ID"].ToString()); } } return(model); }
private void ShowInfo(int int_ID) { WalleProject.BLL.t_integratingrecord bll = new WalleProject.BLL.t_integratingrecord(); WalleProject.Model.t_integratingrecord model = bll.GetModel(int_ID); this.lblint_ID.Text = model.int_ID.ToString(); this.txtint_date.Text = model.int_date.ToString(); this.txtint_integral.Text = model.int_integral.ToString(); this.txtint_way.Text = model.int_way; this.txtint_u_ID.Text = model.int_u_ID.ToString(); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtint_date.Text)) { strErr += "int_date格式错误!\\n"; } if (!PageValidate.IsNumber(txtint_integral.Text)) { strErr += "int_integral格式错误!\\n"; } if (this.txtint_way.Text.Trim().Length == 0) { strErr += "int_way不能为空!\\n"; } if (!PageValidate.IsNumber(txtint_u_ID.Text)) { strErr += "int_u_ID格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int int_ID = int.Parse(this.lblint_ID.Text); DateTime int_date = DateTime.Parse(this.txtint_date.Text); int int_integral = int.Parse(this.txtint_integral.Text); string int_way = this.txtint_way.Text; int int_u_ID = int.Parse(this.txtint_u_ID.Text); WalleProject.Model.t_integratingrecord model = new WalleProject.Model.t_integratingrecord(); model.int_ID = int_ID; model.int_date = int_date; model.int_integral = int_integral; model.int_way = int_way; model.int_u_ID = int_u_ID; WalleProject.BLL.t_integratingrecord bll = new WalleProject.BLL.t_integratingrecord(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public WalleProject.Model.t_integratingrecord GetModel(int int_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select int_ID,int_date,int_integral,int_way,int_u_ID from t_integratingrecord "); strSql.Append(" where int_ID=@int_ID"); MySqlParameter[] parameters = { new MySqlParameter("@int_ID", MySqlDbType.Int32) }; parameters[0].Value = int_ID; WalleProject.Model.t_integratingrecord model = new WalleProject.Model.t_integratingrecord(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }