/// <summary>
/// 获得数据列表
/// </summary>
public List <Tunnel.Model.Tunnel_bum> DataTableToList(DataTable dt)
{
List <Tunnel.Model.Tunnel_bum> modelList = new List <Tunnel.Model.Tunnel_bum>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Tunnel.Model.Tunnel_bum model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_bum();
model.b_id = Convert.ToInt64(dt.Rows[n]["b_id"].ToString());
model.b_name = dt.Rows[n]["b_name"].ToString();
if (dt.Rows[n]["b_hid"].ToString() != "")
{
model.b_hid = int.Parse(dt.Rows[n]["b_hid"].ToString());
}
if (dt.Rows[n]["b_projectid"].ToString() != "")
{
model.b_projectid = int.Parse(dt.Rows[n]["b_projectid"].ToString());
}
model.b_depict = dt.Rows[n]["b_depict"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
did = Request.QueryString["id"].ToString();
Tunnel.BLL.Tunnel_duty td = new Tunnel.BLL.Tunnel_duty();
Tunnel.Model.Tunnel_duty tdd = new Tunnel.Model.Tunnel_duty();
tdd = td.GetModel(Convert.ToInt64(did));
Label1.Text = tdd.d_name;
Label2.Text = tdd.d_depict;
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
Tunnel.Model.Tunnel_bum tbb = new Tunnel.Model.Tunnel_bum();
List <Tunnel.Model.Tunnel_bum> tbList = new List <Tunnel.Model.Tunnel_bum>();
tbList = tb.GetModelList("b_id=" + tdd.d_flag + "");
if (tbList.Count > 0)
{
tbb = tbList[0];
Label3.Text = tbb.b_name;
}
}
}
}
public bool UpdBum()
{
bmm = bm.GetModel(Convert.ToInt64(bid));
bmm.b_name = txtname.Text.Trim();
bmm.b_depict = txtname2.Text.Trim();
bm.Update(bmm);
return(true);
}
/// <summary>
/// 得到 类型ID 和 ID
/// </summary>
public void getIdtypeId(ref int tmpId, ref int typeId)
{
if (!string.IsNullOrEmpty(Request.QueryString["uid"]))
{
tmpId = Convert.ToInt32(Request.QueryString["uid"].ToString());
tempName = "用户管理";
Tunnel.BLL.Tunnel_menber menberBLL = new Tunnel.BLL.Tunnel_menber();
Tunnel.Model.Tunnel_menber menberModel = menberBLL.GetModel(tmpId);
tempName_TypeName = menberModel.m_name;
typeId = 1;
if (!string.IsNullOrEmpty(Request.QueryString["uid"]))
{
GetUserAllPermission(int.Parse(Request.QueryString["uid"]));
}
}
if (!string.IsNullOrEmpty(Request.QueryString["jid"]))
{
tmpId = Convert.ToInt32(Request.QueryString["jid"].ToString());
tempName = "角色管理";
Tunnel.BLL.Tunnel_jiaose jiaoseBLL = new Tunnel.BLL.Tunnel_jiaose();
Tunnel.Model.Tunnel_jiaose jiaoseModel = jiaoseBLL.GetModel(tmpId);
tempName_TypeName = jiaoseModel.j_name;
this.tmpSet.Visible = false;
typeId = 2;
}
if (!string.IsNullOrEmpty(Request.QueryString["did"]))
{
tmpId = Convert.ToInt32(Request.QueryString["did"].ToString());
tempName = "职位管理";
Tunnel.BLL.Tunnel_duty dutyBLL = new Tunnel.BLL.Tunnel_duty();
Tunnel.Model.Tunnel_duty dutyModel = dutyBLL.GetModel(tmpId);
tempName_TypeName = dutyModel.d_name;
this.tmpSet.Visible = false;
typeId = 3;
}
if (!string.IsNullOrEmpty(Request.QueryString["bid"]))
{
tmpId = Convert.ToInt32(Request.QueryString["bid"].ToString());
Tunnel.BLL.Tunnel_bum bumBLL = new Tunnel.BLL.Tunnel_bum();
Tunnel.Model.Tunnel_bum bumModels = bumBLL.GetModel(tmpId);
tempName_TypeName = bumModels.b_name;
tempName = "部门管理";
this.tmpSet.Visible = false;
typeId = 4;
}
}
protected void Repeater2_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
Repeater rptSub = (Repeater)e.Item.FindControl("Repeater3");
Tunnel.Model.Tunnel_bum model = (e.Item.DataItem as Tunnel.Model.Tunnel_bum);
Tunnel.BLL.Tunnel_menber userBll = new Tunnel.BLL.Tunnel_menber();
List <Tunnel.Model.Tunnel_menber> userModelList = new List <Tunnel_menber>();
if (Convert.ToInt32(model.b_id) == 0)
{
userModelList = userBll.GetModelList(" m_bum = 0 ");
}
else
{
userModelList = userBll.GetModelList(" m_bum = " + model.b_id);
}
rptSub.DataSource = userModelList;
rptSub.DataBind();
}
public void showHtml(int d)
{
Tunnel.BLL.Tunnel_MingXing tmx = new Tunnel.BLL.Tunnel_MingXing();
Tunnel.Model.Tunnel_MingXing tmxx = new Tunnel.Model.Tunnel_MingXing();
List <Tunnel.Model.Tunnel_MingXing> tmxxList = new List <Tunnel.Model.Tunnel_MingXing>();
if (d == -1)
{
tmxxList = tmx.GetModelList(" 1=1 order by Convert(datetime,str(m_year)+'-'+str(M_moon)+'-'+'01') desc");
if (tmxxList.Count > 0)
{
d = tmxxList[0].m_id;
}
}
tmxxList = tmx.GetModelList("m_id = " + d + "");
for (int i = 0; i < tmxxList.Count; i++)
{
Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber();
Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber();
tmm = tm.GetModel(Convert.ToInt64(tmxxList[i].m_uid));
if (tmm != null)
{
name = tmm.m_name;
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
Tunnel.Model.Tunnel_bum tbb = new Tunnel.Model.Tunnel_bum();
tbb = tb.GetModel(Convert.ToInt64(tmm.m_bum));
if (tbb != null)
{
bum = tbb.b_name;
}
}
title = tmxxList[i].Title.ToString();
year = tmxxList[i].m_year.ToString();
moon = tmxxList[i].m_moon.ToString();
img = "../N_MyWork/N_Star/" + tmxxList[i].m_img;
content = tmxxList[i].m_content;
}
lblcontent.Text = content;
string dateStr = string.Empty;
string tempYear = year;
string tempMoon = moon;
string tempSql = @"
select * from (select top 4 * from (select top 4 * from tunnel_mingxing where
Convert(datetime,lTRIM(str(m_year))+'-'+ltrim(str(m_moon))+'-'+'01')
<substring(Convert(varchar,'" + year + "-" + (moon.Length == 1 ? "0" + moon : moon) + "-01" + @"',20),0,8)+'-01'
order by Convert(datetime,lTRIM(str(m_year))+'-'+ltrim(str(m_moon))+'-'+'01')
desc) as bb order by
Convert(datetime,lTRIM(str(m_year))+'-'+ltrim(str(m_moon))+'-'+'01'))
as tunnel_mingxing
union all
select * from (select top 1 * from tunnel_mingxing where
Convert(datetime,lTRIM(str(m_year))+'-'+ltrim(str(m_moon))+'-'+'01')
=substring(Convert(varchar,'" + year + "-" + (moon.Length == 1 ? "0" + moon : moon) + "-01" + @"',20),0,8)+'-01' ) as tunnel_mingxing
union all
select * from (select top 4 * from tunnel_mingxing where
Convert(datetime,lTRIM(str(m_year))+'-'+ltrim(str(m_moon))+'-'+'01')
>substring(Convert(varchar,'" + year + "-" + (moon.Length == 1 ? "0" + moon : moon) + "-01" + @"',20),0,8)+'-01' ) as tunnel_mingxing
";
DataSet ds = Tunnel.Data.DbHelperSQL.Query(tempSql);
tmxxList = tmx.DataTableToList(ds.Tables[0]);
foreach (Tunnel.Model.Tunnel_MingXing item in tmxxList)
{
if (item.m_year == Convert.ToInt32(year) && Convert.ToInt32(item.m_moon) == Convert.ToInt32(moon))
{
dateStr += "<a href=?id=" + item.m_id + "><font color=\"red\" style=\"14px\" >" + item.m_year + "-" + item.m_moon + "</font></a> ";
}
else
{
dateStr += "<a href=?id=" + item.m_id + "><font color=\"black\" style=\"12px\" >" + item.m_year + "-" + item.m_moon + "</font></a> ";
}
}
//Label1.Text = dateStr;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Tunnel.Model.Tunnel_bum model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_bum model)
{
return(dal.Add(model));
}
/// <summary>
/// 明星员工
/// </summary>
/// <param name="d"></param>
public void showHtml(int d)
{
Tunnel.BLL.Tunnel_MingXing tmx = new Tunnel.BLL.Tunnel_MingXing();
Tunnel.Model.Tunnel_MingXing tmxx = new Tunnel.Model.Tunnel_MingXing();
List <Tunnel.Model.Tunnel_MingXing> tmxxList = new List <Tunnel.Model.Tunnel_MingXing>();
if (d == -1)
{
tmxxList = tmx.GetModelList(" 1=1 order by Convert(datetime,str(m_year)+'-'+str(M_moon)+'-'+'01') desc");
if (tmxxList.Count > 0)
{
d = tmxxList[0].m_id;
}
}
tmxxList = tmx.GetModelList("m_id = " + d + "");
for (int i = 0; i < tmxxList.Count; i++)
{
Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber();
Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber();
tmm = tm.GetModel(Convert.ToInt64(tmxxList[i].m_uid));
if (tmm != null)
{
name = tmm.m_name;
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
Tunnel.Model.Tunnel_bum tbb = new Tunnel.Model.Tunnel_bum();
tbb = tb.GetModel(Convert.ToInt64(tmm.m_bum));
if (tbb != null)
{
bum = tbb.b_name;
if (!string.IsNullOrEmpty(bum))
{
if (bum.Length > 8)
{
bum = bum.Substring(0, 8);
}
}
}
Tunnel.BLL.Tunnel_duty td = new Tunnel.BLL.Tunnel_duty();
Tunnel.Model.Tunnel_duty tdd = new Tunnel.Model.Tunnel_duty();
tdd = td.GetModel(Convert.ToInt64(tmm.m_duty));
if (tdd != null)
{
duty = tdd.d_name;
}
}
year = tmxxList[i].m_year.ToString();
moon = tmxxList[i].m_moon.ToString();
img = "N_MyWork/N_Star/" + tmxxList[i].m_img;
mxId = tmxxList[i].m_id.ToString();
}
string tempYear = DateTime.Now.AddMonths(-12).Year.ToString();
string tempMoon = DateTime.Now.AddMonths(-12).Month.ToString();
tmxxList = tmx.GetModelList("m_year >= " + tempYear + " order by Convert(datetime,str(m_year)+'-'+str(M_moon)+'-'+'01') asc");
int count = 0;
foreach (Tunnel.Model.Tunnel_MingXing item in tmxxList)
{
if (item.m_moon >= Convert.ToInt32(tempMoon) || item.m_year != DateTime.Now.Year)
{
content += "<a href=?id=" + item.m_id + ">" + item.m_year + "-" + item.m_moon + "</a> ";
count++;
}
if (count > 1)
{
break;
}
}
}
