/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MesWeb.Model.T_Menu model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@MenuID", SqlDbType.Int, 4),
new SqlParameter("@MenuParentID", SqlDbType.Int, 4),
new SqlParameter("@MenuLevel", SqlDbType.Int, 4),
new SqlParameter("@MenuSeq", SqlDbType.Int, 4),
new SqlParameter("@MenuName", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuICON", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuRemark", SqlDbType.NVarChar, 50)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.MenuParentID;
parameters[2].Value = model.MenuLevel;
parameters[3].Value = model.MenuSeq;
parameters[4].Value = model.MenuName;
parameters[5].Value = model.MenuUrl;
parameters[6].Value = model.MenuICON;
parameters[7].Value = model.MenuRemark;
DbHelperSQL.RunProcedure("T_Menu_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MesWeb.Model.T_Menu model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@MenuID", SqlDbType.Int, 4),
new SqlParameter("@MenuParentID", SqlDbType.Int, 4),
new SqlParameter("@MenuLevel", SqlDbType.Int, 4),
new SqlParameter("@MenuSeq", SqlDbType.Int, 4),
new SqlParameter("@MenuName", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuICON", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuRemark", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.MenuID;
parameters[1].Value = model.MenuParentID;
parameters[2].Value = model.MenuLevel;
parameters[3].Value = model.MenuSeq;
parameters[4].Value = model.MenuName;
parameters[5].Value = model.MenuUrl;
parameters[6].Value = model.MenuICON;
parameters[7].Value = model.MenuRemark;
DbHelperSQL.RunProcedure("T_Menu_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_Menu GetModel(int MenuID)
{
SqlParameter[] parameters =
{
new SqlParameter("@MenuID", SqlDbType.Int, 4)
};
parameters[0].Value = MenuID;
MesWeb.Model.T_Menu model = new MesWeb.Model.T_Menu();
DataSet ds = DbHelperSQL.RunProcedure("T_Menu_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public JsonResult CreateMenu(MesWeb.Model.T_Menu menu)
{
var retData = new VM_Result_Data();
var bllMenu = new MesWeb.BLL.T_Menu();
if (menu.MenuParentID == null || menu.MenuSeq == null || menu.MenuName == null)
{
return(Json(retData));
}
var parentMenu = Utils.SystemHelper.GetParentSystemMenu(new MesWeb.ViewModel.System.VM_Menu(menu));
menu.MenuLevel = parentMenu.MenuLevel + 1;
int isAddOk = bllMenu.Add(menu);
if (isAddOk != 0)
{
retData.Code = RESULT_CODE.OK;
retData.Content = "添加成功";
}
return(Json(retData));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_Menu DataRowToModel(DataRow row)
{
MesWeb.Model.T_Menu model = new MesWeb.Model.T_Menu();
if (row != null)
{
if (row["MenuID"] != null && row["MenuID"].ToString() != "")
{
model.MenuID = int.Parse(row["MenuID"].ToString());
}
if (row["MenuParentID"] != null && row["MenuParentID"].ToString() != "")
{
model.MenuParentID = int.Parse(row["MenuParentID"].ToString());
}
if (row["MenuLevel"] != null && row["MenuLevel"].ToString() != "")
{
model.MenuLevel = int.Parse(row["MenuLevel"].ToString());
}
if (row["MenuSeq"] != null && row["MenuSeq"].ToString() != "")
{
model.MenuSeq = int.Parse(row["MenuSeq"].ToString());
}
if (row["MenuName"] != null)
{
model.MenuName = row["MenuName"].ToString();
}
if (row["MenuUrl"] != null)
{
model.MenuUrl = row["MenuUrl"].ToString();
}
if (row["MenuICON"] != null)
{
model.MenuICON = row["MenuICON"].ToString();
}
if (row["MenuRemark"] != null)
{
model.MenuRemark = row["MenuRemark"].ToString();
}
}
return(model);
}
public JsonResult DeleteMenu(MesWeb.Model.T_Menu menu)
{
var retData = new VM_Result_Data();
var bllMenu = new MesWeb.BLL.T_Menu();
var subMenus = Utils.SystemHelper.GetSubSystemMenuList(new MesWeb.ViewModel.System.VM_Menu(menu));
bool isDelOk = false;
foreach (var item in subMenus)
{
isDelOk = bllMenu.Delete(item.MenuID);
if (isDelOk == false)
{
return(Json(retData));
}
}
isDelOk = bllMenu.Delete(menu.MenuID);
if (isDelOk == true)
{
retData.Code = RESULT_CODE.OK;
retData.Content = "删除成功！";
}
return(Json(retData));
}
public JsonResult EditMenu(MesWeb.Model.T_Menu menu)
{
var bllMenu = new MesWeb.BLL.T_Menu();
var retData = new VM_Result_Data();
var isExist = bllMenu.Exists(menu.MenuID);
if (isExist == false)
{
retData.Content = "该项不存在!";
return(Json(retData));
}
var isUpdated = bllMenu.Update(menu);
if (isUpdated == true)
{
retData.Content = "更新成功！";
retData.Code = RESULT_CODE.OK;
}
else
{
retData.Content = "系统错误！";
}
return(Json(retData));
}
