public ActionResult BrandOpenProduct()
{
ProductStockBLL psb = new ProductStockBLL();
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]);
ViewData["myMenuId"] = menuId;
PublicHelpController ph = new PublicHelpController();
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
BrandOpenProductSaveMenuId = menuId;
if (!ph.isFunPermisson(roleId, menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
ProductHelper php = new ProductHelper();
ViewData["Vencode"] = php.GetVencodeDDlist();
return(View());
}
/// <summary>
/// 添加角色
/// </summary>
/// <returns></returns>
public string addRole()
{
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
PublicHelpController ph = new PublicHelpController();
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.addName))
{
List <model.persona> myList = new List <model.persona>();
return("您未被授权使用该功能，请重新登录或联系管理员进行处理.");
}
string s = string.Empty;
string PersonaName = Request.Form["roleName"].ToString();
string PersonaIndex = Request.Form["roleIndex"].ToString();
int UserId = 1;
bll.rolebll roleBll = new bll.rolebll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("PersonaName", SqlDbType.NVarChar, 20),
new SqlParameter("PersonaIndex", SqlDbType.NVarChar, 500),
new SqlParameter("UserId", SqlDbType.Int, 4),
};
ipara[0].Value = PersonaName;
ipara[1].Value = PersonaIndex;
ipara[2].Value = UserId;
s = roleBll.Add(ipara, "roleAdd");
return(s);
}
/// <summary>
/// 页面加载
/// </summary>
/// <returns></returns>
public ActionResult TypeConfiguration()
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]);
ViewData["myMenuId"] = menuId;
PublicHelpController ph = new PublicHelpController();
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
SvaeMenuId = menuId;
if (!ph.isFunPermisson(roleId, menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
ViewData["RoleId"] = userInfo.User.personaId.ToString();
return(View());
}
/// <summary>
/// 供应商季节
/// </summary>
/// <returns></returns>
public ActionResult VenSeason()
{
try
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = Request.QueryString["menuId"] != null?helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]) : 0;
PublicHelpController ph = new PublicHelpController();
#region 查询
if (!ph.isFunPermisson(roleId, menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
#endregion
ViewData["myMenuId"] = menuId;
return(View());
}
catch
{
return(View("../ErrorMsg/Index"));
}
}
/// <summary>
/// 显示异常信息
/// </summary>
/// <returns></returns>
public ActionResult ShowErrorlog()
{
if (Session["count"] == null)
{
Session["count"] = 20;
}
if (Session["pageIndex"] == null)
{
Session["pageIndex"] = 1;
}
bll.Errorlogbll errorlog = new bll.Errorlogbll();
int menuId = int.Parse(Request.QueryString["menuId"]);
PublicHelpController pub = new PublicHelpController();
if (!pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
ViewData["IsDelete"] = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.deleteName);
ViewData["show"] = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName);
ViewData["menuId"] = menuId;
ViewData["backups"] = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.backups);
ViewData["recover"] = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.recover);
int listCount;
int count = int.Parse(Session["count"].ToString());
List <model.errorlog> list = errorlog.GetListErrorlog(0, count, 1, out listCount, out mess);
if (mess != "")
{
return(Content(mess));
}
ViewBag.pageProCount = listCount % count == 0 ? listCount / count : listCount / count + 1;
return(View(list));
}
public ActionResult RenewalLogShow()
{
int menuId = int.Parse(Request.QueryString["menuId"]);
PublicHelpController pub = new PublicHelpController();
#region 权限查看
if (!pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.deleteName))
{
ViewData["Delete"] = "true";
}
else
{
ViewData["Delete"] = "false";
}
#endregion
bll.SystemConfigManagerbll system = new bll.SystemConfigManagerbll();
int count;
DataTable dt = system.GetProGetProductsourceUpdateLog(0, 10, "1", null, null, out count, userInfo.User.UserId);
ViewData["pageProCount"] = count % 10 == 0 ? count / 10 : count / 10 + 1;
ViewData["pageRowsCount"] = count;
ViewData["menuId"] = menuId;
bool isShowid;
dt = GetRenewalLogShow(dt, menuId, funName.selectName, out isShowid);
ViewData["IsShowId"] = isShowid;
return(View(dt));
}
/// <summary>
/// 获取有权限的字段
/// </summary>
/// <param name="roleId">角色ID</param>
/// <param name="menuId">菜单ID</param>
/// <param name="funName">功能操作</param>
/// <returns>返回sql语句（包含有权限的字段）</returns>
public string getFiledPermissonSQL(int roleId, int menuId, string funName, string tableName)
{
string sql = string.Empty;
PublicHelpController pub = new PublicHelpController();
bll.funPermissonbll funPermissonBll = new bll.funPermissonbll();
bll.personapermissonbll personapermissonBll = new bll.personapermissonbll();
int[] funIds = personapermissonBll.selectFunPersonaPermisson(roleId, menuId);
int funId = 0;
if (funIds.Length > 0)
{
for (int i = 0; i < funIds.Length; i++)
{
int myFunId = funPermissonBll.getFunName(helpcommon.ParmPerportys.GetNumParms(funIds[i])).Id;
string myFunName = funPermissonBll.getFunName(helpcommon.ParmPerportys.GetNumParms(funIds[i])).FunName;
if (!string.IsNullOrWhiteSpace(myFunName))
{
if (myFunName.Contains(funName))
{
funId = myFunId;
}
}
}
}
sql = pub.getFiledPermissonSQL(roleId, menuId, funId, tableName);
funPermissonBll = null;
personapermissonBll = null;
return(sql);
}
/// <summary>
/// 获取字段列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult allotFiledPermisson(int id, int roleId, int menuId, int funId)
{
ViewData["id"] = id;
ViewData["roleId"] = roleId;
ViewData["menuId"] = menuId;
ViewData["funId"] = funId;
PublicHelpController ph = new PublicHelpController();
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
else
{
#region 分配权限
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.fieldFPQX))
{
ViewData["fieldFPQX"] = 0;//无分配权限
}
else
{
ViewData["fieldFPQX"] = 1;//有分配权限
}
#endregion
#region 查询
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.fieldCKQX))
{
List <model.persona> myList = new List <model.persona>();
return(View("../NoPermisson/Index"));
}
#endregion
}
string filed = getFiledId(roleId, menuId, funId);
ViewData["filedIds"] = filed;
bll.tableFiledPerssionbll tableFiledPerssionBll = new bll.tableFiledPerssionbll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("tableLevel", SqlDbType.NVarChar, 20)
};
ipara[0].Value = id;
List <model.tableFiledPerssion> list = tableFiledPerssionBll.getTable(ipara, "filedSelect");
return(View(list));
}
public Dictionary <string, string> GetData(int menuId, string FunName)
{
PublicHelpController pub = new PublicHelpController();
pbxdata.bll.SystemConfigManagerbll systembll = new bll.SystemConfigManagerbll();
string[] temp = systembll.getDataName("productsource");
string[] str = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, FunName);
Dictionary <string, string> lis = new Dictionary <string, string>();
foreach (string t in temp)
{
if (str.Contains(t))
{
if (t == "SourceCode")
{
lis.Add("SourceCode", "供应商编码");
}
if (t == "sourceName")
{
lis.Add("sourceName", "供应商名称");
}
if (t == "sourcePhone")
{
lis.Add("sourcePhone", "供应商电话");
}
if (t == "SourceManage")
{
lis.Add("SourceManage", "供应商联系人");
}
if (t == "SourceLevel")
{
lis.Add("SourceLevel", "供应商等级");
}
if (t == "UserName1")
{
lis.Add("UserName1", "供应商联系人");
}
if (t == "Def2")
{
lis.Add("Def2", "更新程序路径");
}
if (t == "Def3")
{
lis.Add("Def3", "发货地");
}
if (t == "UserId")
{
lis.Add("UserId", "操作人");
}
}
}
return(lis);
}
/// <summary>
/// 返回有访问权限的菜单中的功能所拥有的字段
/// </summary>
/// <param name="roleId"></param>
/// <param name="menuId"></param>
/// <returns></returns>
public string getFiledId(int roleId, int menuId, int funId)
{
string s = string.Empty;
PublicHelpController ph = new PublicHelpController();
List <int> listFiledId = ph.getUserFiled(roleId, menuId, funId);
foreach (int item in listFiledId)
{
s += item + ",";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
return(s);
}
//
// GET: /SystemManager/
/// <summary>
/// 供应商管理
/// </summary>
/// <returns></returns>
public ActionResult ProductsourcesManager()
{
int menuId = int.Parse(Request.QueryString["menuId"]);
PublicHelpController pub = new PublicHelpController();
#region 权限查看
if (!pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.addName))
{
ViewData["Insert"] = "true";
}
else
{
ViewData["Insert"] = "false";
}
if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.updateName))
{
ViewData["menuId"] = menuId;
ViewData["Update"] = "true";
}
else
{
ViewData["Update"] = "false";
}
if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.deleteName))
{
ViewData["Delete"] = "true";
}
else
{
ViewData["Delete"] = "false";
}
if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.start))
{
ViewData["Start"] = "true";
}
else
{
ViewData["Start"] = "false";
}
#endregion
pbxdata.bll.SystemConfigManagerbll systembll = new bll.SystemConfigManagerbll();
ViewData["Head"] = GetData(menuId, funName.selectName);
List <model.productsource> list = systembll.GetProductsource(userInfo.User.Id);
return(View(list));
}
/// <summary>
/// 返回有访问权限的子菜单
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public string getMenuId(int roleId)
{
string s = string.Empty;
PublicHelpController ph = new PublicHelpController();
List <int> listMenuId = ph.getUserMenuF1(roleId);
List <int> listMenuIdC = ph.getUserMenuC1(listMenuId, roleId);
foreach (int item in listMenuIdC)
{
s += item + ",";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
return(s);
}
/// <summary>
/// 获取数据源显示字段
/// </summary>
/// <param name="FunName"></param>
/// <returns></returns>
public Dictionary <string, string> GetDataConfig(string FunName, int menuId)
{
PublicHelpController pub = new PublicHelpController();
pbxdata.bll.SystemConfigManagerbll systembll = new bll.SystemConfigManagerbll();
string[] temp = systembll.getDataName("productsourceConfig");
string[] str = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, FunName);
Dictionary <string, string> lis = new Dictionary <string, string>();
foreach (string t in temp)
{
if (str.Contains(t))
{
if (t == "Id")
{
lis.Add("Id", "编号");
}
if (t == "SourceCode")
{
lis.Add("SourceCode", "供应商编号");
}
if (t == "SourcesAddress")
{
lis.Add("SourcesAddress", "服务器地址");
}
if (t == "UserId")
{
lis.Add("UserId", "登陆名");
}
if (t == "UserPwd")
{
lis.Add("UserPwd", "密码");
}
if (t == "DataSources")
{
lis.Add("DataSources", "数据库名称");
}
if (t == "DataSourcesLevel")
{
lis.Add("DataSourcesLevel", "数据库等级");
}
if (t == "Def3")
{
lis.Add("DataSourcesLevel", "更新程序启动Ip");
}
}
}
return(lis);
}
/// <summary>
/// 返回有访问权限的菜单中的功能
/// </summary>
/// <param name="roleId"></param>
/// <param name="menuId"></param>
/// <returns></returns>
public string getFunId(int roleId, int menuId)
{
string s = string.Empty;
List <int> menuIds = new List <int>();
menuIds.Add(menuId);
PublicHelpController ph = new PublicHelpController();
List <int> listFunId = ph.getUserFun1(menuIds, roleId);
foreach (int item in listFunId)
{
s += item + ",";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
return(s);
}
/// <summary>
/// 判断权限
/// </summary>
/// <returns></returns>
public ActionResult getUsers()
{
try
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = Request.QueryString["menuId"] != null?helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]) : 0;
int id = helpcommon.ParmPerportys.GetNumParms(Request.Url.LocalPath.Replace("/Users/getUsers/", "").ToString());
PublicHelpController ph = new PublicHelpController();
#region
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
else
{
#region 查询
if (!ph.isFunPermisson(roleId, menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
#endregion
}
#endregion
ViewData["id"] = id;
ViewData["myMenuId"] = menuId;
return(View());
}
catch
{
return(View("../ErrorMsg/Index"));
}
}
//
// GET: /ItalyError/
public ActionResult ShowError()
{
int menuId = int.Parse(Request.QueryString["menuId"]);
PublicHelpController pub = new PublicHelpController();
//判断是否有该功能权限
if (!pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName))
{
return(View("../NoPermisson/Index"));
}
string[] str = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName);
bll.ItalyErrorbll bll = new bll.ItalyErrorbll();
int pageRowsCount;
DataTable dt = bll.GetItaly(null, null, null, 0, 10, out pageRowsCount);
ViewData["pageCount"] = pageRowsCount % 10 == 0 ? pageRowsCount / 10 : pageRowsCount / 10 + 1;
ViewData["pageRowsCount"] = pageRowsCount;
ViewData["menuId"] = menuId;
ChangeTableColumnName(dt, str);
return(View(dt));
}
/// <summary>
/// 供应商品牌搜索
/// </summary>
public string SearchBrandVen(string lists, string menuId, string page, string Selpages)
{
try
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
DataTable dt = new DataTable();
PublicHelpController ph = new PublicHelpController();
string[] SearchInfo = lists.Split(',');
Dictionary <string, string> Dic = new Dictionary <string, string>();
Dic.Add("BrandName", SearchInfo[0]); //--本地类别
Dic.Add("BrandNameVen", SearchInfo[1]); //--供应商类别
Dic.Add("Vencode", SearchInfo[2]); //--供应商
Dic.Add("bangd", SearchInfo[3]); //--是否绑定
string counts;
dt = brandbll.SearchBrandVen(Dic, Convert.ToInt32(page), Convert.ToInt32(Selpages), out counts);
return(GetTabBrandVen(dt, menuId) + "-*-" + counts);;
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public ActionResult PageIndexChange()
{
if (!IsIntType(Request.Form["pageIndex"]) || !IsIntType(Request.Form["pgCount"]))
{
return(Content(""));
}
int pageIndex = int.Parse(Request.Form["pageIndex"]);
int pgCount = int.Parse(Request.Form["pgCount"]);
int menuId = int.Parse(Request.Form["menuId"]);
string log = Request.Form["log"];
string beginTime = Request.Form["beginTime"];
string endTime = Request.Form["endTime"];
bll.SystemConfigManagerbll system = new bll.SystemConfigManagerbll();
int count;
DataTable dt = system.GetProGetProductsourceUpdateLog(pgCount * (pageIndex - 1), pgCount, log, beginTime, endTime, out count, userInfo.User.UserId);
bool isShowId;
dt = GetRenewalLogShow(dt, menuId, funName.selectName, out isShowId);
PublicHelpController pub = new PublicHelpController();
bool IsDelete = false;
if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.deleteName))
{
IsDelete = true;
}
string html = "";
foreach (DataRow dr in dt.Rows)
{
html += "<tr id='" + dr["编号"] + "'>";
for (int i = 0; i < dt.Columns.Count; i++)
{
if (dt.Columns[i].ColumnName == "编号")
{
if (isShowId)
{
html += "<td>";
html += dr[i];
html += "</td>";
}
}
else
{
if (dr[i].ToString().Length > 20)
{
string str = dr[i].ToString();
html += "<td class='curren' onmouseout='mouseOut(this)' onmousemove='mouseOver(this)'>";
html += str.Substring(0, 20) + "...";
html += "<div>" + str + "</div>";
}
else
{
html += "<td>";
html += dr[i];
}
html += "</td>";
}
}
if (IsDelete)
{
html += "<td><a href='#' onclick=\"onDelete('" + dr["编号"] + "')\">删除</a></td>";
}
else
{
html += "<td>无权限</td>";
}
html += "</tr>";
}
//html += "<script>$('#pageCount').html('" + (count % 10 == 0 ? count / 10 : count / 10 + 1) + "');$('#pageRowsCount').html('" + count + "'); </script>";
html += "╋" + (count % pgCount == 0 ? count / pgCount : count / pgCount + 1) + "╋" + count;
return(Content(html));
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <returns></returns>
public string getData()
{
string roleJumpId = string.Empty; //外部跳转roleId
Dictionary <string, string> dic = new Dictionary <string, string>();
if (Request.Form["id"] != null && Request.Form["id"] != "0")
{
roleJumpId = Request.Form["id"].ToString();
dic.Add("roleId", roleJumpId);
}
///查询参数
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
List <model.users> list = new List <model.users>();
StringBuilder s = new StringBuilder();
bll.usersbll usersBll = new bll.usersbll();
string[] ssName = usersBll.getDataName("users");
//DataTable dt = new DataTable();
//DataTable dt = usersBll.getData();
DataTable dt = usersBll.getData(dic);
PublicHelpController ph = new PublicHelpController();
string[] ss = ph.getFiledPermisson(roleId, menuId, funName.selectName);
#region TABLE添加
s.Append("<tr>");
s.Append("<th colspan='50' class='mytableadd'>");
s.Append("<div style='padding-top: 20px;'>");
if (ph.isFunPermisson(roleId, menuId, funName.addName))
{
s.Append("<a href='#' onclick='javascript: showDiv()' >添加</a>");
}
s.Append("</div>");
s.Append("</th>");
s.Append("<tr>");
#endregion
#region TABLE表头
s.Append("<tr>");
for (int z = 0; z < ssName.Length; z++)
{
if (ss.Contains(ssName[z]))
{
s.Append("<td>");
if (ssName[z] == "personaId")
{
s.Append("角色");
}
if (ssName[z] == "userName")
{
s.Append("用户名");
}
if (ssName[z] == "userPwd")
{
s.Append("密码");
}
if (ssName[z] == "userRealName")
{
s.Append("姓名");
}
if (ssName[z] == "userSex")
{
s.Append("性别");
}
if (ssName[z] == "UserPhone")
{
s.Append("电话");
}
if (ssName[z] == "UserAddress")
{
s.Append("地址");
}
if (ssName[z] == "UserEmail")
{
s.Append("邮箱");
}
if (ssName[z] == "userIndex")
{
s.Append("排序");
}
if (ssName[z] == "UserManage")
{
s.Append("管理");
}
if (ssName[z] == "UserId")
{
s.Append("操作人");
}
if (ssName[z] == "Def1")
{
s.Append("默认1");
}
if (ssName[z] == "Def2")
{
s.Append("默认2");
}
if (ssName[z] == "Def3")
{
s.Append("默认3");
}
if (ssName[z] == "Def4")
{
s.Append("默认4");
}
if (ssName[z] == "Def5")
{
s.Append("默认5");
}
s.Append("</td>");
}
}
s.Append("<td>编辑</td><td>删除</td>");
s.Append("</tr>");
#endregion
#region TABLE内容
for (int i = 0; i < dt.Rows.Count; i++)
{
s.Append("<tr>");
for (int j = 0; j < ss.Length; j++)
{
if (ss[j].ToLower() == "id")
{
s.Append("<td>");
s.Append("<label id='lblId'>" + dt.Rows[i][ss[j]].ToString() + "</label>");
s.Append("</td>");
}
else
{
s.Append("<td>");
s.Append(dt.Rows[i][ss[j]].ToString());
s.Append("</td>");
}
}
#region 编辑
s.Append("<td>");
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<a href='#' onclick='javascript: showDivEdit();userEdit(" + dt.Rows[i][0].ToString() + ")'>编辑</a>");
}
else
{
s.Append("<a href='#'>无编辑权限</a>");
}
s.Append("</td>");
#endregion
#region 除
s.Append("<td>");
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<a href='#' onclick='del(" + dt.Rows[i][0].ToString() + ")'>删除</a>");
}
else
{
s.Append("<a href='#'>无删除权限</a>");
}
s.Append("</td>");
#endregion
s.Append("</tr>");
}
#endregion
usersBll = null;
return(s.ToString());
}
/// <summary>
/// 更新用户
/// </summary>
/// <returns></returns>
public string updateUsers()
{
string s = string.Empty;
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
#region 密码加密
string pwd = helpcommon.PasswordHelp.encrypt(Request.Form["userPwd"]);
pwd = helpcommon.PasswordHelp.encrypt(pwd);
#endregion
var Id = helpcommon.ParmPerportys.GetNumParms(Request.Form["Id"]);
var personaId = helpcommon.ParmPerportys.GetNumParms(Request.Form["personaId"]);
var userName = Request.Form["userName"];
//var userPwd = Request.Form["userPwd"];//密码
var userPwd = pwd;//密码
var userRealName = Request.Form["userRealName"];
var userSex = helpcommon.ParmPerportys.GetNumParms(Request.Form["userSex"]);
var UserPhone = Request.Form["UserPhone"];
var UserAddress = Request.Form["UserAddress"];
var UserEmail = Request.Form["UserEmail"];
var userIndex = helpcommon.ParmPerportys.GetNumParms(Request.Form["userIndex"]);
var UserManage = helpcommon.ParmPerportys.GetNumParms(Request.Form["UserManage"]);
//var UserId = helpcommon.ParmPerportys.GetNumParms(Request.Form["UserId"]);
var Def1 = Request.Form["Def1"];
var Def2 = Request.Form["Def2"];
var Def3 = Request.Form["Def3"];
var Def4 = Request.Form["Def4"];
var Def5 = Request.Form["Def5"];
int UserId = userInfo.User.Id;
PublicHelpController ph = new PublicHelpController();
bll.usersbll usersBll = new bll.usersbll();
DataTable mytable = usersBll.getDataEdit(Id);
string[] ssName = usersBll.getDataName("users");
string[] ss = ph.getFiledPermisson(roleId, menuId, funName.updateName);
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("id", SqlDbType.Int, 4),
new SqlParameter("personaId", SqlDbType.Int, 4),
new SqlParameter("usersName", SqlDbType.NVarChar, 20),
new SqlParameter("usersPwd", SqlDbType.NVarChar, 100),
new SqlParameter("usersRealName", SqlDbType.NVarChar, 20),
new SqlParameter("usersSex", SqlDbType.Int, 4),
new SqlParameter("usersPhone", SqlDbType.NVarChar, 20),
new SqlParameter("usersAddress", SqlDbType.NVarChar, 200),
new SqlParameter("usersEmail", SqlDbType.NVarChar, 20),
new SqlParameter("usersIndex", SqlDbType.Int, 4),
new SqlParameter("usersManage", SqlDbType.Int, 4),
new SqlParameter("userId", SqlDbType.Int, 4),
new SqlParameter("Def1", SqlDbType.NVarChar, 50),
new SqlParameter("Def2", SqlDbType.NVarChar, 50),
new SqlParameter("Def3", SqlDbType.NVarChar, 50),
new SqlParameter("Def4", SqlDbType.NVarChar, 50),
new SqlParameter("Def5", SqlDbType.NVarChar, 50)
};
for (int i = 0; i < ssName.Length; i++)
{
if (ss.Contains(ssName[i]))
{
if (ssName[i] == "Id")
{
ipara[i].Value = Id;
}
if (ssName[i] == "personaId")
{
ipara[i].Value = personaId;
}
if (ssName[i] == "userName")
{
ipara[i].Value = userName;
}
if (ssName[i] == "userPwd")
{
ipara[i].Value = userPwd;
}
if (ssName[i] == "userRealName")
{
ipara[i].Value = userRealName;
}
if (ssName[i] == "userSex")
{
ipara[i].Value = userSex;
}
if (ssName[i] == "UserPhone")
{
ipara[i].Value = UserPhone;
}
if (ssName[i] == "UserAddress")
{
ipara[i].Value = UserAddress;
}
if (ssName[i] == "UserEmail")
{
ipara[i].Value = UserEmail;
}
if (ssName[i] == "userIndex")
{
ipara[i].Value = userIndex;
}
if (ssName[i] == "UserManage")
{
ipara[i].Value = UserManage;
}
if (ssName[i] == "UserId")
{
ipara[i].Value = UserId;
}
if (ssName[i] == "Def1")
{
ipara[i].Value = Def1;
}
if (ssName[i] == "Def2")
{
ipara[i].Value = Def2;
}
if (ssName[i] == "Def3")
{
ipara[i].Value = Def3;
}
if (ssName[i] == "Def4")
{
ipara[i].Value = Def4;
}
if (ssName[i] == "Def5")
{
ipara[i].Value = Def5;
}
}
else
{
ipara[i].Value = mytable.Rows[0][mytable.Columns[i].ColumnName].ToString();
}
}
s = usersBll.Update(ipara, "updateUsers");
usersBll = null;
return(s);
}
/// <summary>
/// 编辑用户
/// </summary>
/// <returns></returns>
public string editUsers()
{
StringBuilder s = new StringBuilder();
List <model.users> list = new List <model.users>();
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["id"]);
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]);
bll.usersbll usersBll = new bll.usersbll();
DataTable dt = usersBll.getDataEdit(id);
string[] ssName = usersBll.getDataName("users");
PublicHelpController ph = new PublicHelpController();
string[] ss = ph.getFiledPermisson(roleId, menuId, funName.updateName);
s.Append("<div style='float:left'>");
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < ssName.Length; j++)
{
if (ss.Contains(ssName[j]))
{
s.Append("<div style='width:250px;float:left;'>");
if (ssName[j] == "Id")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>编号:</span>");
}
if (ssName[j] == "personaId")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>角色:</span>");
}
if (ssName[j] == "userName")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>用户名:</span>");
}
if (ssName[j] == "userPwd")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>密码:</span>");
}
if (ssName[j] == "userRealName")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>姓名:</span>");
}
if (ssName[j] == "userSex")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>性别:</span>");
}
if (ssName[j] == "UserPhone")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>电话:</span>");
}
if (ssName[j] == "UserAddress")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>地址:</span>");
}
if (ssName[j] == "UserEmail")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>邮箱:</span>");
}
if (ssName[j] == "userIndex")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>排序:</span>");
}
if (ssName[j] == "UserManage")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>管理:</span>");
}
if (ssName[j] == "UserId")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>操作人:</span>");
}
if (ssName[j] == "Def1")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认1:</span>");
}
if (ssName[j] == "Def2")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认2:</span>");
}
if (ssName[j] == "Def3")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认3:</span>");
}
if (ssName[j] == "Def4")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认4:</span>");
}
if (ssName[j] == "Def5")
{
s.Append("<span style='float:left;text-align:right;width: 80px;'>默认5:</span>");
}
if (ssName[j] == "userSex")
{
#region 性别
s.Append("<span style='width:135px;display:-moz-inline-box; display:inline-block;'>");
if (dt.Rows[i][ss[j]].ToString() == "0")
{
s.Append("<input style='width:18px;' id='usersSex' name='radio1' type='radio' value='0' checked='checked' />男");
s.Append("<input style='width:18px;' id='usersSex1' name='radio1' type='radio' value='1' />女");
}
else
{
s.Append("<input style='width:18px;' id='usersSex' name='radio1' type='radio' value='0' />男");
s.Append("<input style='width:18px;' id='usersSex1' name='radio1' type='radio' value='1' checked='checked' />女");
}
s.Append("</span>");
#endregion
}
else if (ssName[j] == "personaId")
{
#region 角色
RoleHelperController RH = new RoleHelperController();
s.Append("<select id='usersRoleEdit' title='" + dt.Rows[i][ss[j]].ToString() + "'>" + RH.getRoleData() + "</select>");
#endregion
}
else if (ssName[j] == "userPwd")
{
#region 密码
s.Append("<input type='password' value='" + dt.Rows[i][ss[j]] + "' id='" + ssName[j] + "' />");
#endregion
}
else
{
s.Append("<input type='text' value='" + dt.Rows[i][ss[j]] + "' id='" + ssName[j] + "' />");
}
s.Append("</div>");
}
}
}
shopbll sbl = new shopbll();
DataTable dtShop = sbl.GetAllShop();
string[] dtPerssionshop = usersBll.GetShopAllocation(id.ToString());
s.Append("<div style='width:450px;margin:auto'>");
for (int i = 0; i < dtShop.Rows.Count; i++)
{
if (dtPerssionshop.Contains(dtShop.Rows[i]["Id"].ToString()))
{
s.Append("<label style='width: 150px;float:left;text-align:left'><input class='Check' style='width:20px;' type='checkbox' checked='checked' shopid='" + dtShop.Rows[i]["Id"] + "' />" + dtShop.Rows[i]["ShopName"] + "</label>");
}
else
{
s.Append("<label style='width: 150px;float:left;text-align:left'><input class='Check' style='width:20px;' type='checkbox' shopid='" + dtShop.Rows[i]["Id"] + "' />" + dtShop.Rows[i]["ShopName"] + "</label>");
}
}
s.Append("</div>");
s.Append("</div>");
s.Append("<div><button id='btnSave' value='保存' onclick='userSave()'>保存</button></div>");
usersBll = null;
return(s.ToString());
}
/// <summary>
/// 季节table拼接
/// </summary>
/// <param name="dt"></param>
/// <param name="FmenuId"></param>
/// <returns></returns>
public string GetData(DataTable dt, string FmenuId)
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = FmenuId == null?helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]) : helpcommon.ParmPerportys.GetNumParms(FmenuId);
StringBuilder s = new StringBuilder();
//string sql = @"select * from(select cat2 from ItalyPorductStock group by cat2) a left join producttypeVen b on a.Cat2=b.TypeNo";
//string[] ssName = attrbll.getDataName(sql);
string[] ssName = { "Cat1" };
//string[] ssName = { "Id", "BigId", "TypeNo", "TypeName", "bigtypeName" };
//DataTable dt = DbHelperSQL.Query(strsql).Tables[0];
PublicHelpController ph = new PublicHelpController();
//string[] ss = ph.getFiledPermisson(roleId, menuId, funName.selectName);
string[] ss = { "Cat1" };
#region TABLE表头
s.Append("<tr><th>编号</th>");
for (int z = 0; z < ssName.Length; z++)
{
if (ss.Contains(ssName[z]))
{
s.Append("<th>");
if (ssName[z] == "Cat1")
{
s.Append("季节名称");
}
s.Append("</th>");
}
}
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<th>编辑</th>");
}
;
#region 除
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<th>删除</th>");
}
#endregion
s.Append("</tr>");
#endregion
#region TABLE内容
if (dt.Rows.Count <= 0 || dt == null)
{
//s.Append("<tr id='noData'>");
//s.Append("<td></td>");
//s.Append("</tr>");
s.Append("***NoData***");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int n = i + 1;
s.Append("<tr><td>" + n + "</td>");
for (int j = 0; j < ssName.Length; j++)
{
if (ss.Contains(ssName[j]))
{
s.Append("<td>");
s.Append(dt.Rows[i][ssName[j]].ToString());
s.Append("</td>");
}
}
#region 编辑
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<td><a href='#' onclick='EditSeason(\"" + dt.Rows[i]["Id"].ToString() + "\",\"" + dt.Rows[i]["Cat1"].ToString() + "\")'>编辑</a></td>");
}
#endregion
#region 除
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<td><a href='#' onclick='DeleteSeason(\"" + dt.Rows[i]["Cat1"].ToString() + "\")'>删除</a></td>");
}
#endregion
s.Append("</tr>");
}
}
#endregion
return(s.ToString());
}
/// <summary>
/// 获取菜单列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult allotMenuPermisson(int id)
{
ViewData["roleId"] = id;
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]);
ViewData["menuId"] = menuId;
PublicHelpController ph = new PublicHelpController();
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
else
{
#region 功能列表
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.funList))
{
ViewData["funList"] = 0;//无功能列表权限
}
else
{
ViewData["funList"] = 1;//有功能列表权限
}
#endregion
#region 分配权限
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.menuFPQX))
{
ViewData["menuFPQX"] = 0;//无分配权限
}
else
{
ViewData["menuFPQX"] = 1;//有分配权限
}
#endregion
#region 查询
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.menuCKQX))
{
List <model.persona> myList = new List <model.persona>();
return(View("../NoPermisson/Index"));
}
#endregion
}
//string menuIdC = getMenuId(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId));
string menuIdC = getMenuId(helpcommon.ParmPerportys.GetNumParms(id));
ViewData["menuIdC"] = menuIdC;
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("menuName",SqlDbType.NVarChar,20)
};
//ipara[0].Value = "张三";
List <model.menu> list = menuBll.getMenu(ipara, "menuSelectAllC");
return(View(list));
}
/// <summary>
/// 供应商季节table拼接
/// </summary>
public string GetTabSeasonVen(DataTable dt, string FmenuId)
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = FmenuId == null?helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]) : helpcommon.ParmPerportys.GetNumParms(FmenuId);
StringBuilder s = new StringBuilder();
//string sql = @"select * from(select cat2 from ItalyPorductStock group by cat2) a left join producttypeVen b on a.Cat2=b.TypeNo";
//string[] ssName = attrbll.getDataName(sql);
string[] ssName = { "Cat1", "VenCat1", "Vencode2" };
//string[] ssName = { "Id", "BigId", "TypeNo", "TypeName", "bigtypeName" };
//DataTable dt = DbHelperSQL.Query(strsql).Tables[0];
PublicHelpController ph = new PublicHelpController();
//string[] ss = ph.getFiledPermisson(roleId, menuId, funName.selectName);
string[] ss = { "Cat1", "VenCat1", "Vencode2" };
#region TABLE表头
s.Append("<tr><th>编号</th>");
for (int z = 0; z < ssName.Length; z++)
{
if (ss.Contains(ssName[z]))
{
s.Append("<th>");
if (ssName[z] == "Cat1")
{
s.Append("季节名称");
}
if (ssName[z] == "VenCat1")
{
s.Append("供应季节名称");
}
if (ssName[z] == "Vencode2")
{
s.Append("供应商");
}
s.Append("</th>");
}
}
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<th>编辑</th>");
}
;
#region 除
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<th>删除</th>");
}
#endregion
s.Append("</tr>");
#endregion
#region TABLE内容
if (dt.Rows.Count <= 0 || dt == null)
{
s.Append("<tr><td colspan='50' style='font-size:12px; color:red; text-align:center;'>本次搜索暂无数据！</td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int n = i + 1;
s.Append("<tr><td>" + n + "</td>");
for (int j = 0; j < ssName.Length; j++)
{
if (ss.Contains(ssName[j]))
{
if (ssName[j] == "Vencode2")
{
s.Append("<td>");
s.Append(dt.Rows[i]["sourceName"].ToString());
s.Append("</td>");
}
else
{
s.Append("<td>");
s.Append(dt.Rows[i][ssName[j]].ToString());
s.Append("</td>");
}
}
}
#region 编辑
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
string itemId = dt.Rows[i]["Id"].ToString() == null || dt.Rows[i]["Id"].ToString() == "" ? "0" : dt.Rows[i]["Id"].ToString();
//string Cat = string.Empty;
//if (dt.Rows[i]["Cat"].ToString().Contains("'"))
//{
// Cat = ;
//}
//s.Append("<td><a href='#' onclick='EditAttribute(\"" + dt.Rows[i]["Id"].ToString() + "\",\"" + dt.Rows[i]["TypeName"].ToString() + "\",\"" + dt.Rows[i]["TypeNameVen"].ToString() + "\",\"" + dt.Rows[i]["Vencode"].ToString() + "\")'>编辑</a></td>");
s.Append("<td><a href='#' onclick='EditAttribute(\"" + itemId + "\",\"" + dt.Rows[i]["Cat1"].ToString() + "\",\"" + dt.Rows[i]["VenCat1"].ToString() + "\",\"" + dt.Rows[i]["Vencode2"].ToString() + "\")'>编辑</a></td>");
}
#endregion
#region 除
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
string itemId = dt.Rows[i]["Id"].ToString() == null || dt.Rows[i]["Id"].ToString() == "" ? "0" : dt.Rows[i]["Id"].ToString();
//s.Append("<td><a href='#' onclick='DeleteType(\"" + dt.Rows[i]["Id"].ToString() + "\")'>删除</a></td>");
if (itemId == "0")
{
s.Append("<td></td>");
}
else
{
s.Append("<td><a href='#' onclick='DeleteSeasonVen(\"" + itemId + "\")'>删除</a></td>");
}
}
#endregion
s.Append("</tr>");
}
}
#endregion
return(s.ToString());
}
public string GetBrandExcel()
{
string customer = userInfo.User.Id.ToString();
string[] str = new string[2];
str[0] = Request.Form["BrandName"] == null ? "" : Request.Form["BrandName"].ToString();
str[1] = Request.Form["BrandNameVen"] == null ? "" : Request.Form["BrandNameVen"].ToString();
int page = Request.Form["page"] == null ? 10 : int.Parse(Request.Form["page"].ToString());
int count = brandbll.GetBrandExcelCount(str);
int PageSum = count % page > 0 ? count / page + 1 : count / page; //页码
bool IsPage = Request.Form["isPage"] == null ? false : true; //为false 表示加载 为true则表示翻页
int Index = Request.Form["Index"] == null ? 0 : int.Parse(Request.Form["Index"].ToString());
if (IsPage == true)
{
#region 分页
switch (Index)
{
case 0: //首页
BrandPage = 0;
break;
case 1: //上一页
if (BrandPage - 1 >= 0)
{
BrandPage = BrandPage - 1;
}
else
{
BrandPage = 0;
}
break;
case 2: //跳页
int ReturnPage = Request.Form["PageReturn"] == null ? 0 : int.Parse(Request.Form["PageReturn"].ToString());
BrandPage = ReturnPage - 1;
break;
case 3: //下页
if (BrandPage + 1 <= PageSum - 1)
{
BrandPage = BrandPage + 1;
}
else
{
BrandPage = PageSum - 1;
}
break;
case 4: //末页
BrandPage = PageSum - 1;
break;
}
#endregion
}
else
{
BrandPage = 0;
}
int minid = BrandPage * page;
int maxid = BrandPage * page + page;
DataTable dt = brandbll.GetBrandExcel(str, minid, maxid);
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
//int menuId = OrderDetailsSaveMenuId;
PublicHelpController ph = new PublicHelpController();
//usersbll usb = new usersbll();
//string[] allTableName = usb.getDataName("productstockOrder");
//string[] s = ph.getFiledPermisson(roleId, menuId, funName.selectName);
StringBuilder Alltable = new StringBuilder();
Alltable.Append("<table id='StcokTable' class='mytable' style='font-size:12px;'><tr style='text-align:center;'>");
for (int i = 0; i < dt.Columns.Count; i++)
{
if (dt.Columns[i].ToString() != "Id")
{
if (dt.Columns[i].ToString() == "RowId")
{
Alltable.Append("<th>序号</th>");
}
if (dt.Columns[i].ToString() == "BrandName")
{
Alltable.Append("<th>品牌名称</th>");
}
if (dt.Columns[i].ToString() == "BrandAbridge")
{
Alltable.Append("<th>品牌缩写</th>");
}
if (dt.Columns[i].ToString() == "BrandNameVen")
{
Alltable.Append("<th>供应商品牌名称</th>");
}
if (dt.Columns[i].ToString() == "Vencode")
{
Alltable.Append("<th>来源</th>");
}
}
}
Alltable.Append("<th>操作</th>");
Alltable.Append("</tr>");
if (dt.Rows.Count <= 0 || dt == null)
{
Alltable.Append("<tr><td colspan='50' style='font-size:12px; text-align:center; color:red;'>本次搜索暂无数据！</td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Alltable.Append("<tr>");
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].ToString() != "Id")
{
Alltable.Append("<td>" + dt.Rows[i][j] + "</td>");
}
}
Alltable.Append("<td><a href='#' onclick='DeleteBrand(" + dt.Rows[i]["Id"] + ")'>删除</a></td>");
Alltable.Append("</tr>");
}
}
Alltable.Append("</table>");
int thispage = 0;
if (IsPage == true)
{
thispage = BrandPage + 1;
}
else
{
thispage = 1;
}
return(Alltable.ToString() + "❤" + PageSum + "❤" + count + "❤" + thispage);
}
public static int Savemenuid = 0; //记录菜单编号
public string GetAllProduct()
{
usersbll usb = new usersbll();
PublicHelpController ph = new PublicHelpController();
ProductStockBLL psb = new ProductStockBLL();
#region 查询条件
string orderParams = Request.Form["params"] ?? string.Empty; //参数
string[] orderParamss = helpcommon.StrSplit.StrSplitData(orderParams, ','); //参数集合
Dictionary <string, string> dic = new Dictionary <string, string>(); //搜索条件
string Style = helpcommon.StrSplit.StrSplitData(orderParamss[0], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //货号
string Scode = helpcommon.StrSplit.StrSplitData(orderParamss[1], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //款号
string PriceMin = helpcommon.StrSplit.StrSplitData(orderParamss[2], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //最小价格
string PriceMax = helpcommon.StrSplit.StrSplitData(orderParamss[3], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //最大价格
string Season = helpcommon.StrSplit.StrSplitData(orderParamss[4], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //季节
string Type = helpcommon.StrSplit.StrSplitData(orderParamss[5], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //品牌
string Brand = helpcommon.StrSplit.StrSplitData(orderParamss[6], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //最小库存
string StockMin = helpcommon.StrSplit.StrSplitData(orderParamss[7], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //最大库存
string StockMax = helpcommon.StrSplit.StrSplitData(orderParamss[8], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //最小时间
string Descript = helpcommon.StrSplit.StrSplitData(orderParamss[9], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //最大时间
string MinTime = helpcommon.StrSplit.StrSplitData(orderParamss[10], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //类别
string MaxTime = helpcommon.StrSplit.StrSplitData(orderParamss[11], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //供应商
string Vencode = helpcommon.StrSplit.StrSplitData(orderParamss[12], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //有图/无图
string ImageFile = helpcommon.StrSplit.StrSplitData(orderParamss[13], ':')[1].Replace("'", "").Replace("}", "") ?? string.Empty; //有图/无图
Scode = Scode == "\'\'" ? string.Empty : Scode;
Style = Style == "\'\'" ? string.Empty : Style;
PriceMax = PriceMax == "\'\'" ? string.Empty : PriceMax;
PriceMin = PriceMin == "\'\'" ? string.Empty : PriceMin;
Season = Season == "\'\'" ? string.Empty : Season;
Brand = Brand == "\'\'" ? string.Empty : Brand;
StockMax = StockMax == "\'\'" ? string.Empty : StockMax;
StockMin = StockMin == "\'\'" ? string.Empty : StockMin;
MinTime = MinTime == "\'\'" ? string.Empty : MinTime;
MaxTime = MaxTime == "\'\'" ? string.Empty : MaxTime;
Type = Type == "\'\'" ? string.Empty : Type;
Vencode = Vencode == "\'\'" ? string.Empty : Vencode;
ImageFile = ImageFile == "\'\'" ? string.Empty : ImageFile;
Descript = Descript == "\'\'" ? string.Empty : Descript;
dic.Add("Scode", Scode);
dic.Add("Style", Style);
dic.Add("PriceMax", PriceMax);
dic.Add("PriceMin", PriceMin);
dic.Add("Season", Season);
dic.Add("Brand", Brand);
dic.Add("StockMax", StockMax);
dic.Add("StockMin", StockMin);
dic.Add("TimeMin", MinTime);
dic.Add("TimeMax", MaxTime);
dic.Add("Type", Type);
dic.Add("Vencode", Vencode);
dic.Add("Imagefile", ImageFile);
dic.Add("Descript", Descript);
dic.Add("ShopId", ""); //店铺Id 选货处使用
dic.Add("isCheckProduct", ""); //是否为选货查询 选货处使用
dic.Add("CustomerId", userInfo.User.Id.ToString()); //用户Id
#endregion
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId); //角色ID
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]); //菜单ID
int pageIndex = Request.Form["pageIndex"] == null ? 0 : helpcommon.ParmPerportys.GetNumParms(Request.Form["pageIndex"]);
int pageSize = Request.Form["pageSize"] == null ? 10 : helpcommon.ParmPerportys.GetNumParms(Request.Form["pageSize"]);
string[] allTableName = usb.getDataName("productstock"); //当前列表所有字段
string[] s = ph.getFiledPermisson(roleId, menuId, funName.selectName); //获得当前权限字段
bool Storage = ph.isFunPermisson(roleId, menuId, funName.Storage); //入库权限
bool Marker = ph.isFunPermisson(roleId, menuId, funName.Marker); //商品标记权限（备注）
int Count = 0; //数据总个数
psb.SearchShowProductStock(dic, out Count);
int PageCount = Count % pageSize > 0 ? Count / pageSize + 1 : Count / pageSize; //数据总页数
int MinId = pageSize;
int MaxId = pageSize * (pageIndex - 1);
DataTable dt = psb.SearchShowProductStock(dic, MinId, MaxId);
#region Table表头排序
string idNuber = "";
idNuber = allTableName[0];
for (int i = 0; i < allTableName.Length; i++) //排序将款号挪到第一列
{
if (allTableName[i] == "Style")
{
string styleNuber = allTableName[i];
allTableName[0] = styleNuber;
allTableName[i] = idNuber;
}
}
string Value = "";
Value = allTableName[1];
for (int i = 0; i < allTableName.Length; i++) //排序将货号挪到第二列
{
if (allTableName[i] == "Scode")
{
string temp = allTableName[i];
allTableName[1] = Scode;
allTableName[i] = Value;
}
}
string Model = "";
Model = allTableName[2];
for (int i = 0; i < allTableName.Length; i++) //排序将型号挪到第三列
{
if (allTableName[i] == "Model")
{
string temp = allTableName[i];
allTableName[2] = Scode;
allTableName[i] = Model;
}
}
string IdNumber = "";
IdNumber = s[0];
for (int n = 0; n < s.Length; n++) //排序将款号挪到第一列
{
if (s[n] == "Style")
{
string styleNuber = s[n];
s[0] = styleNuber;
s[n] = IdNumber;
}
}
string test = "";
test = s[1];
for (int n = 0; n < s.Length; n++) //排序将货号挪到第二列
{
if (s[n] == "Scode")
{
string styleNuber = s[n];
s[1] = styleNuber;
s[n] = test;
}
}
string ModelS = "";
ModelS = s[2];
for (int n = 0; n < s.Length; n++) //排序将货号挪到第二列
{
if (s[n] == "Model")
{
string styleNuber = s[n];
s[2] = styleNuber;
s[n] = ModelS;
}
}
if (s.Contains("Imagefile"))
{
string temp = s[3];
for (int i = 0; i < s.Length; i++)
{
if (s[i] == "Imagefile")
{
s[i] = temp;
s[3] = "Imagefile";
}
}
}
#endregion
StringBuilder Alltable = new StringBuilder();
#region Table表头
Alltable.Append("<table id='StcokTable' class='mytable' style='font-size:12px;'><tr style='text-align:center;'>");
Alltable.Append("<td>序号</td>");
for (int i = 0; i < s.Length; i++)
{
if (allTableName.Contains(s[i]))
{
Alltable.Append("<th>");
if (s[i] == "Id")
{
Alltable.Append("编号");
}
if (s[i] == "Scode")
{
Alltable.Append("货号");
}
if (s[i] == "Bcode")
{
Alltable.Append("条码1");
}
if (s[i] == "Bcode2")
{
Alltable.Append("条码2");
}
if (s[i] == "Descript")
{
Alltable.Append("英文描述");
}
if (s[i] == "Cdescript")
{
Alltable.Append("中文描述");
}
if (s[i] == "Unit")
{
Alltable.Append("单位");
}
if (s[i] == "Currency")
{
Alltable.Append("货币");
}
if (s[i] == "Cat")
{
Alltable.Append("品牌");
}
if (s[i] == "Cat1")
{
Alltable.Append("季节");
}
if (s[i] == "Cat2")
{
Alltable.Append("类别");
}
if (s[i] == "Clolor")
{
Alltable.Append("颜色");
}
if (s[i] == "Size")
{
Alltable.Append("尺寸");
}
if (s[i] == "Style")
{
Alltable.Append("款号");
}
if (s[i] == "Pricea")
{
Alltable.Append("吊牌价");
}
if (s[i] == "Priceb")
{
Alltable.Append("零售价");
}
if (s[i] == "Pricec")
{
Alltable.Append("VIP价");
}
if (s[i] == "Priced")
{
Alltable.Append("批发价");
}
if (s[i] == "Pricee")
{
Alltable.Append("成本价");
}
if (s[i] == "Disca")
{
Alltable.Append("折扣1");
}
if (s[i] == "Discb")
{
Alltable.Append("折扣2");
}
if (s[i] == "Discc")
{
Alltable.Append("折扣3");
}
if (s[i] == "Discd")
{
Alltable.Append("折扣4");
}
if (s[i] == "Disce")
{
Alltable.Append("折扣5");
}
if (s[i] == "Vencode")
{
Alltable.Append("供应商");
}
if (s[i] == "Model")
{
Alltable.Append("型号");
}
if (s[i] == "Rolevel")
{
Alltable.Append("预警库存");
}
if (s[i] == "Roamt")
{
Alltable.Append("最少订货量");
}
if (s[i] == "Stopsales")
{
Alltable.Append("停售库存");
}
if (s[i] == "Loc")
{
Alltable.Append("店铺");
}
if (s[i] == "Balance")
{
Alltable.Append("供应商库存");
}
if (s[i] == "Lastgrnd")
{
Alltable.Append("交货日期");
}
if (s[i] == "Imagefile")
{
Alltable.Append("缩略图");
}
if (s[i] == "UserId")
{
Alltable.Append("操作人");
}
if (s[i] == "PrevStock")
{
Alltable.Append("上一次库存");
}
if (s[i] == "Def2")
{
Alltable.Append("是否次品");
}
if (s[i] == "Def3")
{
Alltable.Append("默认3");
}
if (s[i] == "Def4")
{
Alltable.Append("是否开放");
}
if (s[i] == "Def5")
{
Alltable.Append("默认5");
}
if (s[i] == "Def6")
{
Alltable.Append("默认6");
}
if (s[i] == "Def7")
{
Alltable.Append("默认7");
}
if (s[i] == "Def8")
{
Alltable.Append("默认8");
}
if (s[i] == "Def9")
{
Alltable.Append("默认9");
}
if (s[i] == "Def10")
{
Alltable.Append("默认10");
}
if (s[i] == "Def11")
{
Alltable.Append("默认11");
}
Alltable.Append("</th>");
}
}
Alltable.Append("<td><input type='checkbox' id='CheckAll' onchange='checkall()'/>操作</td>");
Alltable.Append("</tr>");
#endregion
#region Table内容
for (int i = 0; i < dt.Rows.Count; i++)
{
Alltable.Append("<tr>");
Alltable.Append("<td>" + (i + pageSize * (pageIndex - 1) + 1) + "</td>");
int DefCountBalance = psb.GetDefctiveRemarkBalanceCount(psb.SelectVenNameByVencode(dt.Rows[i]["Vencode"].ToString()), dt.Rows[i]["Scode"].ToString());
for (int j = 0; j < s.Length; j++)
{
if (allTableName.Contains(s[j]))
{
if (s[j] == "Imagefile")
{
if (dt.Rows[i]["ImagePath"] != null && dt.Rows[i]["ImagePath"].ToString() != "")
{
Alltable.Append("<td>");
Alltable.Append("<img style='height:50px;width:50px;' onerror='errorImg(this)' src='" + dt.Rows[i]["ImagePath"] + "' />");
Alltable.Append("</td>");
}
else
{
Alltable.Append("<td>");
Alltable.Append("");
Alltable.Append("</td>");
}
}
else if (s[j] == "Def2")
{
string IsState = dt.Rows[i]["Def2"] == null ? "0" : dt.Rows[i]["Def2"].ToString();
if (IsState == "1")
{
Alltable.Append("<td>");
Alltable.Append("是");
Alltable.Append("</td>");
}
else
{
Alltable.Append("<td>");
Alltable.Append("否");
Alltable.Append("</td>");
}
}
else if (s[j] == "Balance")
{
int scount = int.Parse(dt.Rows[i]["Balance"].ToString()) - DefCountBalance;
Alltable.Append("<td>");
Alltable.Append(scount);
Alltable.Append("</td>");
}
else if (s[j] == "Def4")
{
string def4 = dt.Rows[i]["Def4"] == null ? "2" : dt.Rows[i]["Def4"].ToString();
if (def4 != "1")
{
Alltable.Append("<td>");
Alltable.Append("已开放");
Alltable.Append("</td>");
}
else
{
Alltable.Append("<td>");
Alltable.Append("未开放");
Alltable.Append("</td>");
}
}
else
{
Alltable.Append("<td>");
Alltable.Append(dt.Rows[i][s[j]]);
Alltable.Append("</td>");
}
}
}
Alltable.Append("<td>");
Alltable.Append("<input type='checkbox' class='check' vencode=\"" + dt.Rows[i]["Vencode"].ToString() + "\" title=\"" + dt.Rows[i]["Scode"] + "\"/>");
Alltable.Append("</td>");
Alltable.Append("</tr>");
}
Alltable.Append("</table>");
#endregion
#region 分页
Alltable.Append("-----");
Alltable.Append(PageCount + "-----" + Count);
#endregion
return(Alltable.ToString());
}
/// <summary>
/// 品牌表数据
/// </summary>
/// <param name="dt"></param>
/// <param name="FmenuId"></param>
/// <returns></returns>
public string getDataBrand(DataTable dt, string FmenuId)
{
int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId);
int menuId = FmenuId == null?helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]) : helpcommon.ParmPerportys.GetNumParms(FmenuId);
StringBuilder s = new StringBuilder();
PublicHelpController ph = new PublicHelpController();
#region TABLE表头
s.Append("<tr><th>编号</th>");
s.Append("<th>品牌名</th>");
s.Append("<th>品牌缩写</th>");
s.Append("<th>淘宝品牌</th>");
s.Append("<th>淘宝Vid</th>");
s.Append("<th>品牌归属地</th>");
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<th>编辑</th>");
}
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<th>删除</th>");
}
s.Append("</tr>");
#endregion
#region TABLE内容
if (dt.Rows.Count <= 0 || dt == null)
{
s.Append("<tr><td colspan='50' style='font-size:12px; color:red; text-align:center;'>本次搜索暂无数据！</td></tr>");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int n = i + 1;
s.Append("<tr><td>" + n + "</td>");
s.Append("<td>" + dt.Rows[i]["BrandName"] + "</td>");
s.Append("<td>" + dt.Rows[i]["BrandAbridge"] + "</td>");
s.Append("<td>" + dt.Rows[i]["TBBrandName"] + "</td>");
s.Append("<td>" + dt.Rows[i]["Def1"] + "</td>");
s.Append("<td>" + dt.Rows[i]["Def2"] + "</td>");
#region 编辑
if (ph.isFunPermisson(roleId, menuId, funName.updateName))
{
s.Append("<td><a href='#' onclick='Edit(\"" + dt.Rows[i]["BrandName"] + "\",\"" + dt.Rows[i]["BrandAbridge"] + "\",\"" + dt.Rows[i]["Def1"] + "\",\"" + dt.Rows[i]["Def2"] + "\")'>编辑</a></td>");
}
#endregion
#region 除
if (ph.isFunPermisson(roleId, menuId, funName.deleteName))
{
s.Append("<td><a href='#' onclick='Delete(\"" + dt.Rows[i]["BrandName"] + "\",\"" + dt.Rows[i]["BrandAbridge"] + "\")'>删除</a></td>");
}
#endregion
s.Append("</tr>");
}
}
#endregion
return(s.ToString());
}
public ActionResult PageIndexChange()
{
string[] str = new string[10];//查询条件
int ii;
if (!int.TryParse(Request.Form["pageIndex"], out ii) || !int.TryParse(Request.Form["pgCount"], out ii))
{
return(Content(""));
}
int pageIndex = int.Parse(Request.Form["pageIndex"]);
int pgCount = int.Parse(Request.Form["pgCount"]);
str[0] = Request.Form["beginTime"] == null ? "" : Request.Form["beginTime"]; //开始时间
if (string.IsNullOrWhiteSpace(Request.Form["endTime"])) //结束时间
{
str[1] = "";
}
else
{
str[1] = Request.Form["endTime"] + " 23:59:59";
}
DateTime?createTime;
if (str[0] == "")
{
createTime = null;
}
else
{
createTime = DateTime.Parse(str[0]);
}
DateTime?createTime1;
if (str[1] == "")
{
createTime1 = null;
}
else
{
createTime1 = DateTime.Parse(str[1]);
}
str[2] = Request.Form["Italy"] == null ? "" : Request.Form["Italy"];//数据源code
str[3] = Request.Form["menuId"] == null ? "" : Request.Form["menuId"];
bll.ItalyErrorbll bll = new bll.ItalyErrorbll();
Exception ex;
int pageRowsCount;
//获取显示的字段列表
PublicHelpController pub = new PublicHelpController();
string[] strr = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), int.Parse(str[3]), funName.selectName);
DataTable table = bll.GetItaly(str[2], createTime, createTime1, pgCount * (pageIndex - 1), pgCount, out pageRowsCount);
ChangeTableColumnName(table, strr);
//DataTable table = bll.GetProductOrder(pgCount * (pageIndex - 1), pgCount, str, out ex);
string html = "";
foreach (DataRow dr in table.Rows)
{
html += "<tr>";
for (int i = 0; i < table.Columns.Count; i++)
{
html += "<td>";
html += dr[i];
html += "</td>";
}
html += "</tr>";
}
//html += "<script>$('#pageCount').html('" + (count % 10 == 0 ? count / 10 : count / 10 + 1) + "');$('#pageRowsCount').html('" + count + "'); </script>";
html += "╋" + (pageRowsCount % pgCount == 0 ? pageRowsCount / pgCount : pageRowsCount / pgCount + 1) + "╋" + pageRowsCount;
ViewData["menuId"] = str[3];
return(Content(html));
}
public ActionResult PageIndexChange(FormCollection fr, string Id)
{
string mess = "";
Errorlogbll errorlogbll = new Errorlogbll();
List <model.errorlog> li = null;
int operation = int.Parse(fr["operation"]); //显示错误信息的类型
int menuId = int.Parse(Request.Form["menuId"]);
int count = int.Parse(Session["count"].ToString()); //分页单页面数据个数
//int pageIndex = int.Parse(Session["pageIndex"]!=null?Session["pageIndex"].ToString():"1");
int listCount = 0;
string[] str = Id.Split('-');
PublicHelpController pub = new PublicHelpController();
string[] strr = pub.getFiledPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.selectName);
bool IsDelete = pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), menuId, funName.deleteName);
int pageIndex = int.Parse(str[1]);
li = errorlogbll.GetListErrorlog(0, 0, operation, out listCount, out mess);
switch (str[0])
{
case "1":
pageIndex = 1;
break;
case "2":
pageIndex = pageIndex - 1;
break;
case "3":
pageIndex = pageIndex + 1;
break;
case "4":
pageIndex = pageIndex = listCount % count > 0 ? listCount / count + 1 : listCount / count;
break;
case "5":
pageIndex = int.Parse(str[1]);
break;
}
if (pageIndex < 1)
{
return(Content(""));
}
else if (pageIndex > (listCount % count > 0 ? listCount / count + 1 : listCount / count))
{
return(Content(""));
}
else
{
Session["pageIndex"] = pageIndex;
}
li = errorlogbll.GetListErrorlog(count * (pageIndex - 1), count, operation, out listCount, out mess);
ViewBag.pageCount = listCount % count > 0 ? listCount / count + 1 : listCount / count;
string html = "";
int i = count * (pageIndex - 1) + 1;
foreach (model.errorlog err in li)
{
html += "<tr id='" + err.Id + "'><td>" + (i++) + "</td>";
if (strr.Contains("ErrorMsg"))
{
if (err.ErrorMsg.Length > 30)
{
html += "<td onmousemove='mouseOver(this)' class='curren' onmouseout='mouseOut(this)'>" + err.ErrorMsg.Substring(0, 30) + "...<div><p>" + err.ErrorMsg + "</p></div></td>";
}
else
{
html += "<td>" + err.ErrorMsg + "</td>";
}
}
if (strr.Contains("errorSrc"))
{
if (err.errorSrc.Length > 30)
{
html += "<td onmousemove='mouseOver(this)' class='curren' onmouseout='mouseOut(this)'>" + err.errorSrc.Substring(0, 30) + "...<div><p>" + err.errorSrc + "</p></div></td>";
}
else
{
html += "<td>" + err.errorSrc + "</td>";
}
}
if (strr.Contains("errorMsgDetails"))
{
if (err.errorMsgDetails.Length > 30)
{
html += "<td onmousemove='mouseOver(this)' class='curren' onmouseout='mouseOut(this)'>" + err.errorMsgDetails.Substring(0, 30) + "...<div><p>" + err.errorMsgDetails + "</p></div></td>";
}
else
{
html += "<td>" + err.errorMsgDetails + "</td>";
}
}
if (strr.Contains("UserId"))
{
html += "<td>" + err.UserId + "</td>";
}
if (strr.Contains("errorTime"))
{
html += "<td>" + (err.errorTime != null ? err.errorTime.ToString() : "") + "</td>";
}
if (IsDelete)
{
html += " <td><a href='#' onclick='IsYesUpdate('" + err.Id + "')'>删除</a></td>";
}
else
{
html += " <td>无权限</td>";
}
html += "</tr>";
//@Html.ActionLink("修改", "UpdateCustom/" + cus.Id)
//@Html.ActionLink("删除", "DeleteCustom/" + cus.Id)
}
return(Content(html + "+++" + (listCount % count > 0 ? listCount / count + 1 : listCount / count)));
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <returns></returns>
public ActionResult getRole()
{
#region
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]);
PublicHelpController ph = new PublicHelpController();
ViewData["menuId"] = menuId;
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
else
{
#region 添加(1有权限，0无权限)
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.addName))
{
ViewData["addName"] = 0;//无添加权限
}
else
{
ViewData["addName"] = 1;//有添加权限
}
#endregion
#region 编辑(1有权限，0无权限)
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.updateName))
{
ViewData["updateName"] = 0;//无编辑权限
}
else
{
ViewData["updateName"] = 1;//有编辑权限
}
#endregion
#region 菜单分配权限(1有权限，0无权限)
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.menuList))
{
ViewData["menuList"] = 0;//无菜单分配权限
}
else
{
ViewData["menuList"] = 1;//有菜单分配权限
}
#endregion
#region 用户管理(1有权限，0无权限)
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.userList))
{
ViewData["userList"] = 0;//无用户管理权限
}
else
{
ViewData["userList"] = 1;//有用户管理权限
}
#endregion
#region 查询
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.selectName))
{
List <model.persona> myList = new List <model.persona>();
return(View("../NoPermisson/Index"));
}
#endregion
}
#endregion
bll.rolebll roleBll = new bll.rolebll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("menuName",SqlDbType.NVarChar,20)
};
//ipara[0].Value = "张三";
List <model.persona> list = roleBll.getRole(ipara, "roleSelect");
return(View(list));
}
