/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(myhouse.Model.Menus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_menus set ");
strSql.Append("mname=@mname,");
strSql.Append("murl=@murl,");
strSql.Append("mstatus=@mstatus");
strSql.Append(" where mid=@mid");
SqlParameter[] parameters =
{
new SqlParameter("@mname", SqlDbType.Char, 20),
new SqlParameter("@murl", SqlDbType.VarChar, 100),
new SqlParameter("@mstatus", SqlDbType.Int, 4),
new SqlParameter("@mid", SqlDbType.Int, 4)
};
parameters[0].Value = model.mname;
parameters[1].Value = model.murl;
parameters[2].Value = model.mstatus;
parameters[3].Value = model.mid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(myhouse.Model.Menus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_menus(");
strSql.Append("mname,murl,mstatus)");
strSql.Append(" values (");
strSql.Append("@mname,@murl,@mstatus)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@mname", SqlDbType.Char, 20),
new SqlParameter("@murl", SqlDbType.VarChar, 100),
new SqlParameter("@mstatus", SqlDbType.Int, 4)
};
parameters[0].Value = model.mname;
parameters[1].Value = model.murl;
parameters[2].Value = model.mstatus;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtmname.Text.Trim().Length == 0)
{
strErr += "mname不能为空！\\n";
}
if (this.txtmurl.Text.Trim().Length == 0)
{
strErr += "murl不能为空！\\n";
}
if (!PageValidate.IsNumber(txtmstatus.Text))
{
strErr += "mstatus格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string mname = this.txtmname.Text;
string murl = this.txtmurl.Text;
int mstatus = int.Parse(this.txtmstatus.Text);
myhouse.Model.Menus model = new myhouse.Model.Menus();
model.mname = mname;
model.murl = murl;
model.mstatus = mstatus;
myhouse.BLL.MenusService bll = new myhouse.BLL.MenusService();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
private void ShowInfo(int mid)
{
myhouse.BLL.MenusService bll = new myhouse.BLL.MenusService();
myhouse.Model.Menus model = bll.GetModel(mid);
this.lblmid.Text = model.mid.ToString();
this.lblmname.Text = model.mname;
this.lblmurl.Text = model.murl;
this.lblmstatus.Text = model.mstatus.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public myhouse.Model.Menus DataRowToModel(DataRow row)
{
myhouse.Model.Menus model = new myhouse.Model.Menus();
if (row != null)
{
if (row["mid"] != null && row["mid"].ToString() != "")
{
model.mid = int.Parse(row["mid"].ToString());
}
if (row["mname"] != null)
{
model.mname = row["mname"].ToString();
}
if (row["murl"] != null)
{
model.murl = row["murl"].ToString();
}
if (row["mstatus"] != null && row["mstatus"].ToString() != "")
{
model.mstatus = int.Parse(row["mstatus"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public myhouse.Model.Menus GetModel(int mid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 mid,mname,murl,mstatus from t_menus ");
strSql.Append(" where mid=@mid");
SqlParameter[] parameters =
{
new SqlParameter("@mid", SqlDbType.Int, 4)
};
parameters[0].Value = mid;
myhouse.Model.Menus model = new myhouse.Model.Menus();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
