/// <summary>
/// 得到一个对象实体
/// </summary>
public Tunnel.Model.Tunnel_byingshe GetModel(int by_id)
{
SqlParameter[] parameters =
{
new SqlParameter("@by_id", SqlDbType.Int, 4)
};
parameters[0].Value = by_id;
Tunnel.Model.Tunnel_byingshe model = new Tunnel.Model.Tunnel_byingshe();
DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_byingshe_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["by_id"].ToString() != "")
{
model.by_id = int.Parse(ds.Tables[0].Rows[0]["by_id"].ToString());
}
model.by_bid = ds.Tables[0].Rows[0]["by_bid"].ToString();
model.by_list = ds.Tables[0].Rows[0]["by_list"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Tunnel.Model.Tunnel_byingshe model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@by_id", SqlDbType.Int, 4),
new SqlParameter("@by_bid", SqlDbType.VarChar, 50),
new SqlParameter("@by_list", SqlDbType.VarChar, 2000)
};
parameters[0].Value = model.by_id;
parameters[1].Value = model.by_bid;
parameters[2].Value = model.by_list;
DbHelperSQL.RunProcedure("UP_Tunnel_byingshe_Update", parameters, out rowsAffected);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_byingshe model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@by_id", SqlDbType.Int, 4),
new SqlParameter("@by_bid", SqlDbType.VarChar, 50),
new SqlParameter("@by_list", SqlDbType.VarChar, 2000)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.by_bid;
parameters[2].Value = model.by_list;
DbHelperSQL.RunProcedure("UP_Tunnel_byingshe_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);
}
