/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FwjSoft.Model.MenuInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MenuInfo set ");
strSql.Append("MenuName=@MenuName,");
strSql.Append("MenuSpaceName=@MenuSpaceName,");
strSql.Append("MenuFrmName=@MenuFrmName,");
strSql.Append("MenuParentId=@MenuParentId,");
strSql.Append("MenuUse=@MenuUse,");
strSql.Append("MenuSort=@MenuSort,");
strSql.Append("MenuBig=@MenuBig,");
strSql.Append("MenuBigImage=@MenuBigImage");
strSql.Append(" where MenuId=@MenuId");
SqlParameter[] parameters =
{
new SqlParameter("@MenuName", SqlDbType.VarChar, 50),
new SqlParameter("@MenuSpaceName", SqlDbType.VarChar, 50),
new SqlParameter("@MenuFrmName", SqlDbType.VarChar, 50),
new SqlParameter("@MenuParentId", SqlDbType.Int, 4),
new SqlParameter("@MenuUse", SqlDbType.Bit, 1),
new SqlParameter("@MenuSort", SqlDbType.Int, 4),
new SqlParameter("@MenuBig", SqlDbType.Bit, 1),
new SqlParameter("@MenuBigImage", SqlDbType.Image),
new SqlParameter("@MenuId", SqlDbType.Int, 4)
};
parameters[0].Value = model.MenuName;
parameters[1].Value = model.MenuSpaceName;
parameters[2].Value = model.MenuFrmName;
parameters[3].Value = model.MenuParentId;
parameters[4].Value = model.MenuUse;
parameters[5].Value = model.MenuSort;
parameters[6].Value = model.MenuBig;
parameters[7].Value = model.MenuBigImage;
parameters[8].Value = model.MenuId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FwjSoft.Model.MenuInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MenuInfo(");
strSql.Append("MenuName,MenuSpaceName,MenuFrmName,MenuParentId,MenuUse,MenuSort,MenuBig,MenuBigImage)");
strSql.Append(" values (");
strSql.Append("@MenuName,@MenuSpaceName,@MenuFrmName,@MenuParentId,@MenuUse,@MenuSort,@MenuBig,@MenuBigImage)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MenuName", SqlDbType.VarChar, 50),
new SqlParameter("@MenuSpaceName", SqlDbType.VarChar, 50),
new SqlParameter("@MenuFrmName", SqlDbType.VarChar, 50),
new SqlParameter("@MenuParentId", SqlDbType.Int, 4),
new SqlParameter("@MenuUse", SqlDbType.Bit, 1),
new SqlParameter("@MenuSort", SqlDbType.Int, 4),
new SqlParameter("@MenuBig", SqlDbType.Bit, 1),
new SqlParameter("@MenuBigImage", SqlDbType.Image)
};
parameters[0].Value = model.MenuName;
parameters[1].Value = model.MenuSpaceName;
parameters[2].Value = model.MenuFrmName;
parameters[3].Value = model.MenuParentId;
parameters[4].Value = model.MenuUse;
parameters[5].Value = model.MenuSort;
parameters[6].Value = model.MenuBig;
parameters[7].Value = model.MenuBigImage;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FwjSoft.Model.MenuInfoModel GetModel(int MenuId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 MenuId,MenuName,MenuSpaceName,MenuFrmName,MenuParentId,MenuUse,MenuSort,MenuBig,MenuBigImage from MenuInfo ");
strSql.Append(" where MenuId=@MenuId");
SqlParameter[] parameters =
{
new SqlParameter("@MenuId", SqlDbType.Int, 4)
};
parameters[0].Value = MenuId;
FwjSoft.Model.MenuInfoModel model = new FwjSoft.Model.MenuInfoModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
