/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_uyingshe GetModel(int uy_id) { SqlParameter[] parameters = { new SqlParameter("@uy_id", SqlDbType.Int, 4) }; parameters[0].Value = uy_id; Tunnel.Model.Tunnel_uyingshe model = new Tunnel.Model.Tunnel_uyingshe(); DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_uyingshe_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["uy_id"].ToString() != "") { model.uy_id = int.Parse(ds.Tables[0].Rows[0]["uy_id"].ToString()); } model.uy_uid = ds.Tables[0].Rows[0]["uy_uid"].ToString(); model.uy_list = ds.Tables[0].Rows[0]["uy_list"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Tunnel.Model.Tunnel_uyingshe model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@uy_id", SqlDbType.Int, 4), new SqlParameter("@uy_uid", SqlDbType.VarChar, 50), new SqlParameter("@uy_list", SqlDbType.VarChar, 2000) }; parameters[0].Value = model.uy_id; parameters[1].Value = model.uy_uid; parameters[2].Value = model.uy_list; DbHelperSQL.RunProcedure("UP_Tunnel_uyingshe_Update", parameters, out rowsAffected); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_uyingshe model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@uy_id", SqlDbType.Int, 4), new SqlParameter("@uy_uid", SqlDbType.VarChar, 50), new SqlParameter("@uy_list", SqlDbType.VarChar, 2000) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.uy_uid; parameters[2].Value = model.uy_list; DbHelperSQL.RunProcedure("UP_Tunnel_uyingshe_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }
/// <summary> /// 查看是否有权限 /// </summary> /// <param name="userID">用户ID</param> /// <param name="XreqestStr">小类</param> /// <param name="BreqestStr">大类</param> /// <returns>true有权限</returns> public static bool IfHasPrimision(string userID, string XreqestStr, string BreqestStr, bool IfRead) { string tmpUid = string.Empty; string tmpBid = string.Empty; string tmpDid = string.Empty; string tmpJid = string.Empty; Tunnel.BLL.Tunnel_menber tm = new Tunnel_menber(); Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber(); List <Tunnel.Model.Tunnel_menber> tmlist = new List <Tunnel.Model.Tunnel_menber>(); Tunnel.BLL.Tunnel_jiaose tj = new Tunnel_jiaose(); Tunnel.Model.Tunnel_jiaose tjj = new Tunnel.Model.Tunnel_jiaose(); Tunnel.BLL.Tunnel_quanxian qx = new Tunnel_quanxian(); Tunnel.Model.Tunnel_quanxian qxx = new Tunnel.Model.Tunnel_quanxian(); List <Tunnel.Model.Tunnel_quanxian> qxlist = new List <Tunnel.Model.Tunnel_quanxian>(); Tunnel.BLL.Tunnel_yingshe tyj = new Tunnel_yingshe(); Tunnel.Model.Tunnel_yingshe tyjj = new Tunnel.Model.Tunnel_yingshe(); List <Tunnel.Model.Tunnel_yingshe> tyjlist = new List <Tunnel.Model.Tunnel_yingshe>(); Tunnel.BLL.Tunnel_uyingshe tyu = new Tunnel_uyingshe(); Tunnel.Model.Tunnel_uyingshe tyuu = new Tunnel.Model.Tunnel_uyingshe(); List <Tunnel.Model.Tunnel_uyingshe> tyulist = new List <Tunnel.Model.Tunnel_uyingshe>(); Tunnel.BLL.Tunnel_byingshe tyb = new Tunnel_byingshe(); Tunnel.Model.Tunnel_byingshe tybb = new Tunnel.Model.Tunnel_byingshe(); List <Tunnel.Model.Tunnel_byingshe> tyblist = new List <Tunnel.Model.Tunnel_byingshe>(); Tunnel.BLL.Tunnel_dyingshe tyd = new Tunnel_dyingshe(); Tunnel.Model.Tunnel_dyingshe tydd = new Tunnel.Model.Tunnel_dyingshe(); List <Tunnel.Model.Tunnel_dyingshe> tydlist = new List <Tunnel.Model.Tunnel_dyingshe>(); UserLogin ul = new UserLogin(); bool b = false; string qxStr = string.Empty; tmm = tm.GetModel(Convert.ToInt64(userID)); tmpBid = tmm.m_bum.ToString(); tmpJid = tmm.m_jiao.ToString(); tmpDid = tmm.m_duty.ToString(); tmpUid = userID; tyulist = tyu.GetModelList("uy_uid='" + tmpUid + "'"); if (tyulist.Count > 0) { if (tyulist[0].uy_list.Length > 0) { qxStr += tyulist[0].uy_list + "|"; } } tyjlist = tyj.GetModelList("y_jsid=" + tmpJid + ""); if (tyjlist.Count > 0) { if (tyjlist[0].y_qxlist.Length > 0) { qxStr += tyjlist[0].y_qxlist + "|"; } } tyblist = tyb.GetModelList("by_bid='" + tmpBid + "'"); if (tyblist.Count > 0) { if (tyblist[0].by_list.Length > 0) { qxStr += tyblist[0].by_list + "|"; } } tydlist = tyd.GetModelList("dy_did='" + tmpDid + "'"); if (tydlist.Count > 0) { if (tydlist[0].dy_list.Length > 0) { qxStr += tydlist[0].dy_list + "|"; } } if (qxStr.Length > 0) { qxStr = qxStr.Substring(0, qxStr.Length - 1); } if (userID != "1" && ul.JiaoSe(int.Parse(userID)) != "系统管理员") { if (IfRead) { if (tmpJid != "0") { if (ul.JiaoSe(int.Parse(userID)) == "总经理") { b = true; } } } if (!string.IsNullOrEmpty(qxStr)) { qxlist = qx.GetModelList("q_name='" + XreqestStr + "' and q_mark='" + BreqestStr + "'"); if (qxlist.Count > 0) { foreach (string item in qxStr.Split('|')) { if (qxlist[0].q_id.ToString().Equals(item.ToString())) { b = true; } } } } } else { b = true; } return(b); }