public List <int> getUserFun(List <int> listMenuIdC)
{
string s = string.Empty;
foreach (int item in listMenuIdC)
{
s += item + ",";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
IDataParameter[] iparaFun = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuId", SqlDbType.NVarChar, 500)
};
iparaFun[0].Value = us.User.personaId;
iparaFun[1].Value = s;
List <int> listFunId = new List <int>(); //功能ID
model.funpermisson funMd = new model.funpermisson();
bll.funPermissonbll funBll = new bll.funPermissonbll();
List <model.funpermisson> listFun = funBll.getFun(iparaFun, "funSelect");
foreach (var item in listFun)
{
listFunId.Add(item.Id);
}
if (listFun.Count == 0)
{
listFunId.Add(9999);
}
us.FunId = listFunId;
return(listFunId);
}
/// <summary>
/// 获取功能名称
/// </summary>
/// <returns></returns>
public string getFunName1()
{
bll.funPermissonbll funPermissonBll = new bll.funPermissonbll();
int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["funId"].ToString());
model.funpermisson mdFunpermisson = funPermissonBll.getFunName(id);
return(mdFunpermisson.FunName);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public List <model.funpermisson> DataRowToModel(DataRowCollection rowCollection)
{
List <model.funpermisson> list = new List <model.funpermisson>();
foreach (DataRow row in rowCollection)
{
model.funpermisson modelMd = new model.funpermisson();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
modelMd.Id = int.Parse(row["Id"].ToString());
}
if (row["MenuId"] != null && row["MenuId"].ToString() != "")
{
modelMd.MenuId = int.Parse(row["MenuId"].ToString());
}
if (row["FunName"] != null)
{
modelMd.FunName = row["FunName"].ToString();
}
if (row["FunIndex"] != null && row["FunIndex"].ToString() != "")
{
modelMd.FunIndex = int.Parse(row["FunIndex"].ToString());
}
if (row["UserId"] != null && row["UserId"].ToString() != "")
{
modelMd.UserId = int.Parse(row["UserId"].ToString());
}
if (row["Def1"] != null)
{
modelMd.Def1 = row["Def1"].ToString();
}
if (row["Def2"] != null)
{
modelMd.Def2 = row["Def2"].ToString();
}
if (row["Def3"] != null)
{
modelMd.Def3 = row["Def3"].ToString();
}
if (row["Def4"] != null)
{
modelMd.Def4 = row["Def4"].ToString();
}
if (row["Def5"] != null)
{
modelMd.Def5 = row["Def5"].ToString();
}
}
list.Add(modelMd);
}
return(list);
}
/// <summary>
/// 编辑功能
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult editFun(int id, int MenuId)
{
ViewData["MenuId"] = MenuId;
bll.funPermissonbll funPermissonBll = new bll.funPermissonbll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("id", SqlDbType.Int, 4)
};
ipara[0].Value = id;
//List<model.funpermisson> list = funPermissonBll.getFun(ipara, "funpermissonEdit");
model.funpermisson funpermissonMd = new model.funpermisson();
funpermissonMd = funPermissonBll.getFun(ipara, "funpermissonEdit")[0];
//funpermissonMd = list.Where(c => c.Id == id).ToList()[0];
return(View(funpermissonMd));
}
/// <summary>
/// 删除功能
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string del(int id)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
model.funpermisson fun = (from c in context.funpermisson where c.Id == id select c).FirstOrDefault();
context.funpermisson.DeleteOnSubmit(fun);
context.SubmitChanges();
s = "删除成功！";
}
catch (Exception ex)
{
s = "删除失败！";
}
return(s);
}
/// <summary>
/// 获取功能名称
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public model.funpermisson getFunName(int id)
{
model.funpermisson mdFunpermisson = new model.funpermisson();
//model.ConnectionString md = new model.ConnectionString();
//var s = from c in md.funpermisson where c.Id == id select c;
//foreach (var item in s)
//{
// mdFunpermisson = item;
//}
//return mdFunpermisson;
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var s = from c in context.funpermisson where c.Id == id select c;
foreach (var item in s)
{
mdFunpermisson = item;
}
return(mdFunpermisson);
}
/// <summary>
/// 获取功能名称
/// </summary>
/// <param name="funId">功能ID</param>
/// <returns></returns>
public string getFunName(int funId)
{
bll.funPermissonbll funPermissonBll = new bll.funPermissonbll();
model.funpermisson mdFunpermisson = funPermissonBll.getFunName(funId);
return(mdFunpermisson.FunName);
}
