/// <summary> /// 更新一条数据 /// </summary> public bool Update(yinxiang.Model.yx_functionuser_new model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update yx_functionuser_new set "); strSql.Append("username=@username,"); strSql.Append("functionname=@functionname"); strSql.Append(" where userid=@userid and FUNCTIONID=@FUNCTIONID "); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.VarChar, 100), new SqlParameter("@functionname", SqlDbType.VarChar, 50), new SqlParameter("@userid", SqlDbType.VarChar, 50), new SqlParameter("@FUNCTIONID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.username; parameters[1].Value = model.functionname; parameters[2].Value = model.userid; parameters[3].Value = model.FUNCTIONID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(yinxiang.Model.yx_functionuser_new model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into yx_functionuser_new("); strSql.Append("userid,username,FUNCTIONID,functionname)"); strSql.Append(" values ("); strSql.Append("@userid,@username,@FUNCTIONID,@functionname)"); SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.VarChar, 50), new SqlParameter("@username", SqlDbType.VarChar, 100), new SqlParameter("@FUNCTIONID", SqlDbType.VarChar, 50), new SqlParameter("@functionname", SqlDbType.VarChar, 50) }; parameters[0].Value = model.userid; parameters[1].Value = model.username; parameters[2].Value = model.FUNCTIONID; parameters[3].Value = model.functionname; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public yinxiang.Model.yx_functionuser_new GetModel(string userid, string FUNCTIONID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 userid,username,FUNCTIONID,functionname from yx_functionuser_new "); strSql.Append(" where userid=@userid and FUNCTIONID=@FUNCTIONID "); SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.VarChar, 50), new SqlParameter("@FUNCTIONID", SqlDbType.VarChar, 50) }; parameters[0].Value = userid; parameters[1].Value = FUNCTIONID; yinxiang.Model.yx_functionuser_new model = new yinxiang.Model.yx_functionuser_new(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtusername.Text.Trim().Length == 0) { strErr += "username不能为空!\\n"; } if (this.txtfunctionname.Text.Trim().Length == 0) { strErr += "functionname不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string userid = this.lbluserid.Text; string username = this.txtusername.Text; string FUNCTIONID = this.lblFUNCTIONID.Text; string functionname = this.txtfunctionname.Text; yinxiang.Model.yx_functionuser_new model = new yinxiang.Model.yx_functionuser_new(); model.userid = userid; model.username = username; model.FUNCTIONID = FUNCTIONID; model.functionname = functionname; yinxiang.BLL.yx_functionuser_new bll = new yinxiang.BLL.yx_functionuser_new(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo(string userid, string FUNCTIONID) { yinxiang.BLL.yx_functionuser_new bll = new yinxiang.BLL.yx_functionuser_new(); yinxiang.Model.yx_functionuser_new model = bll.GetModel(userid, FUNCTIONID); this.lbluserid.Text = model.userid; this.lblusername.Text = model.username; this.lblFUNCTIONID.Text = model.FUNCTIONID; this.lblfunctionname.Text = model.functionname; }
/// <summary> /// 得到一个对象实体 /// </summary> public yinxiang.Model.yx_functionuser_new DataRowToModel(DataRow row) { yinxiang.Model.yx_functionuser_new model = new yinxiang.Model.yx_functionuser_new(); if (row != null) { if (row["userid"] != null) { model.userid = row["userid"].ToString(); } if (row["username"] != null) { model.username = row["username"].ToString(); } if (row["FUNCTIONID"] != null) { model.FUNCTIONID = row["FUNCTIONID"].ToString(); } if (row["functionname"] != null) { model.functionname = row["functionname"].ToString(); } } return(model); }