private DataSet createDataSet()//返回数据库表
{
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
ds = new DataSet();
ds = tb.GetList("");
return(ds);
}
/// <summary>
/// 文章列表 文章浏览 公告栏 新闻栏
/// </summary>
/// <param name="num"></param>
public void WriteSiteMap()
{
if (!string.IsNullOrEmpty(Request.QueryString["bum_id"]))
{
Master.FindControl("Panel1").Visible = false;
System.Web.UI.HtmlControls.HtmlGenericControl div = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Panel2");
string str = div.InnerHtml;
div.Visible = true;
Style sty = new Style();
div.Style.Add(HtmlTextWriterStyle.Display, "''");
Tunnel.Model.Tunnel_SelType model = new Tunnel.Model.Tunnel_SelType();
Tunnel.BLL.SelType stBll;
Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum();
string temp = "项目经理部";
div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>"
+ "<span> > </span>"
+ "<span onmouseover='showxjb();'>" + temp + "-" + tbBll.GetModel(Convert.ToInt32(Request.QueryString["bum_id"])).b_name + "</span>"
+ "</font>";
string strsql = "select a.typename,a.typeid from tunnel_newstype a,tunnel_xjbtype b where a.bumname='项目经理部' and b.typeid in (a.typeid) group by a.typeid,a.typename";
DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql);
StringBuilder strhtml = new StringBuilder();
if (das.Tables[0].Rows.Count > 0)
{
foreach (DataRow rows in das.Tables[0].Rows)
{
string strtemp = "  <font class='titlfontson'><a href='/N_Index/xjbmenu.aspx?bum_id=" + Request.QueryString["bum_id"] + "&typeid=" + rows["typeid"].ToString() + "'>" + rows["typename"].ToString() + "</a></font> |";
strhtml.Append(strtemp);
}
}
Panel3.InnerHtml = strhtml.ToString();
}
}
private void Bind()
{
DataSet ds = new DataSet();
List <Tunnel.Model.Tunnel_bum> ListTbModel = new List <Tunnel.Model.Tunnel_bum>();
Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum();
ListTbModel = tbBll.GetModelList("");
foreach (Tunnel.Model.Tunnel_bum tbModel in ListTbModel)
{
if (tbModel.b_projectid != 0)
{
Tunnel.Data.AllProJectDataBase allData = new Tunnel.Data.AllProJectDataBase("001");//Convert.ToInt32(tbModel.b_id));
DataTable dt = new DataTable();
dt = allData.GetAllTableList("Violation_Menber", "1=1", "order by Vio_Date Desc");
ds.Tables.Add(dt.Copy());
}
}
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;//设置数据源(DataTable类型)
pds.AllowPaging = true;
//每页显示的行数
//pds.PageSize = 12;
AspNetPager1.RecordCount = pds.Count;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
Repeater1.DataSource = pds;
Repeater1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropBind();
if (string.IsNullOrEmpty(Request.QueryString["updid"]))
{
Tunnel.Common.Message.Show("非法访问！", "tunnel_dutylist.aspx");
}
else
{
did = Request.QueryString["updid"].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));
txtName.Text = tdd.d_name;
txtName2.Text = tdd.d_depict;
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
if (tb.GetModelList("b_id=" + tdd.d_flag + "").Count > 0)
{
DropDownList1.Items.FindByValue(tdd.d_flag).Selected = true;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.Params["DeleteId"]))
{
Tunnel.BLL.Tunnel_ProJectMent TPBll = new Tunnel.BLL.Tunnel_ProJectMent();
TPBll.Delete(int.Parse(Request.Params["DeleteId"]));
//Tunnel.Data.DbHelperSQL.ExecuteSql("Update Tunnel_ProJectMent Set Pro_Status=-1 Where Pro_id=" + int.Parse(Request.Params["DeleteId"]));
Tunnel.BLL.Tunnel_bum TbBll = new Tunnel.BLL.Tunnel_bum();
Tunnel.Common.Message.Show("删除成功!");
}
if (!string.IsNullOrEmpty(Request.Params["PauseId"]))
{
Tunnel.Data.DbHelperSQL.ExecuteSql("Update Tunnel_ProJectMent Set Pro_Status=1 Where Pro_id=" + int.Parse(Request.Params["PauseId"]));
Tunnel.Common.Message.Show("操作成功!");
}
if (!string.IsNullOrEmpty(Request.Params["CloseId"]))
{
Tunnel.Data.DbHelperSQL.ExecuteSql("Update Tunnel_ProJectMent Set Pro_Status=2 Where Pro_id=" + int.Parse(Request.Params["CloseId"]));
Tunnel.Common.Message.Show("操作成功!");
}
if (!string.IsNullOrEmpty(Request.Params["OpenId"]))
{
Tunnel.Data.DbHelperSQL.ExecuteSql("Update Tunnel_ProJectMent Set Pro_Status=0 Where Pro_id=" + int.Parse(Request.Params["OpenId"]));
Tunnel.Common.Message.Show("操作成功!");
}
this.Bind();
}
}
/// <summary>
/// 文章列表 文章浏览 公告栏 新闻栏
/// </summary>
/// <param name="num"></param>
public void WriteSiteMap()
{
if (!string.IsNullOrEmpty(Request.QueryString["bum_id"]))
{
Master.FindControl("Panel1").Visible = false;
System.Web.UI.HtmlControls.HtmlGenericControl div = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Panel2");
string str = div.InnerHtml;
div.Visible = true;
Style sty = new Style();
div.Style.Add(HtmlTextWriterStyle.Display, "''");
Tunnel.Model.Tunnel_SelType model = new Tunnel.Model.Tunnel_SelType();
Tunnel.BLL.SelType stBll;
Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum();
string temp = "项目经理部";
div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>"
+ "<span> > </span>"
+ "<span><a title='" + temp + "-" + tbBll.GetModel(Convert.ToInt32(Request.QueryString["bum_id"])).b_name + "' href='/N_Index/xjb2.aspx?bum_id=" + Request.QueryString["bum_id"] + "'>" + temp + "-" + tbBll.GetModel(Convert.ToInt32(Request.QueryString["bum_id"])).b_name + "</a></span>"
+ "</font>";
string strsql = "select * from tunnel_newstype where TypeID=" + Request.QueryString["typeid"];
DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql);
if (das.Tables[0].Rows.Count > 0)
{
div.InnerHtml += "<span> > </span>"
+ "<font class='titlefontson'><span>" + das.Tables[0].Rows[0]["TypeName"] + "</span></font>";
}
}
}
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 void BuMenBind()
{
Tunnel.BLL.Tunnel_bum bbll = new Tunnel.BLL.Tunnel_bum();
List <Tunnel.Model.Tunnel_bum> modelList = new List <Tunnel_bum>();
modelList = bbll.GetModelList("");
Repeater2.DataSource = modelList;
Repeater2.DataBind();
}
public void DropBind()
{
Tunnel.BLL.Tunnel_bum td = new Tunnel.BLL.Tunnel_bum();
List <Tunnel.Model.Tunnel_bum> tdlist = new List <Tunnel.Model.Tunnel_bum>();
tdlist = td.GetModelList("1=1");
for (int i = 0; i < tdlist.Count; i++)
{
DropDownList1.Items.Add(new ListItem(tdlist[i].b_name, tdlist[i].b_id.ToString()));
}
DropDownList1.Items.Insert(0, new ListItem("请选择", "0"));
}
///// <summary>
///// 翻页
///// </summary>
///// <param name="sender"></param>
///// <param name="e"></param>
//protected void MTCPager1_PageIndexChanged(object sender, EventArgs e)
//{
// cuttentPage = MTCPager1.PageIndex;
// PageBind();
//}
///// <summary>
///// 页面数据绑定
///// </summary>
//public void PageBind()
//{
// PageBase pb = new PageBase();
// pb.TblName = "Tunnel_menber";
// pb.FldName = "m_id";
// pb.ProcedureName = "pagination";
// pb.PageSize = pageSize;
// if (cuttentPage == 0)
// cuttentPage = pb.PageIndex;
// pb.PageIndex = cuttentPage;
// int count = 0;
// List<Tunnel.Model.Tunnel_menber> modelList = new List<Tunnel.Model.Tunnel_menber>();
// modelList = tbll.GetList(pb, ref count);//获取分页结果
// pb.DoCount = 1;
// tbll.GetList(pb, ref count); //获取总条数
// //数据绑定
// Repeater1.DataSource = modelList;
// Repeater1.DataBind();
// //数据分页
// MTCPager1.PageSize = pageSize;
// MTCPager1.RecordCount = count;
// MTCPager1.PageIndex = cuttentPage;
// if (count <= pb.PageSize)
// MTCPager1.Visible = false;
// else
// MTCPager1.Visible = true;
//}
#endregion
public void BuMenBind()
{
Tunnel.BLL.Tunnel_bum bbll = new Tunnel.BLL.Tunnel_bum();
List <Tunnel.Model.Tunnel_bum> modelList = new List <Tunnel_bum>();
modelList = bbll.GetModelList("");
Tunnel.Model.Tunnel_bum model = new Tunnel_bum();
model.b_id = 0;
model.b_name = "未分组";
modelList.Add(model);
Repeater2.DataSource = modelList;
Repeater2.DataBind();
}
/// <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 Page_Load(object sender, EventArgs e)
{
List <CacheItems> cList = new List <CacheItems>();
cList.Clear();
IDictionaryEnumerator dic = Cache.GetEnumerator();
while (dic.MoveNext())
{
if (dic.Value.GetType().ToString() == "Tunnel.Model.Tunnel_menber")
{
cList.Add(new CacheItems(dic.Key.ToString(), dic.Value.GetType().ToString()));
}
}
onLineUser = cList.Count;
//string aaa=Cache["TunnelLogin-CacheKey-409"].ToString();
//string strsql = "select count(m_id) as onlineuser from tunnel_menber where m_online = 1";
//DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql);
//onLineUser = Convert.ToInt32(das.Tables[0].Rows[0]["onlineuser"]);
if (!IsPostBack)
{
PageBind();
uid = ul.LoginID.ToString();
if (ul.LoginID > 0)
{
Tunnel.Model.Tunnel_menber model = ul.GetUserBean(ul.LoginID);
Tunnel.BLL.Tunnel_bum bm = new Tunnel.BLL.Tunnel_bum();
if (model != null)
{
userbum = model.m_login + " | ";
}
if (model != null && model.m_bum > 0)
{
if (bm.GetModel(model.m_bum) != null)
{
userbum += bm.GetModel(model.m_bum).b_name;
}
}
else
{
userbum += "部门未分组";
}
}
Label1.ToolTip = userbum;
}
}
public string GetBum(object o)
{
Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber();
Tunnel.Model.Tunnel_menber tmm = new Tunnel_menber();
tmm = tm.GetModel(Convert.ToInt64(o.ToString()));
string strTemp = string.Empty;
if (tmm != null)
{
Tunnel_bum tbb = new Tunnel_bum();
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
tbb = tb.GetModel(Convert.ToInt64(tmm.m_bum.ToString()));
if (tbb != null)
{
strTemp = tbb.b_name;
}
}
return(strTemp);
}
/// <summary>
/// 文章列表 文章浏览 公告栏 新闻栏
/// </summary>
/// <param name="num"></param>
public void WriteSiteMap(int num)
{
Master.FindControl("Panel1").Visible = false;
System.Web.UI.HtmlControls.HtmlGenericControl div = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Panel2");
string str = div.InnerHtml;
div.Visible = true;
Style sty = new Style();
div.Style.Add(HtmlTextWriterStyle.Display, "''");
Tunnel.Model.Tunnel_SelType model = new Tunnel_SelType();
Tunnel.BLL.SelType stBll;
Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum();
string temp = "";
switch (typeId)
{
case 1:
temp = "公司公告";
model.BumName = "";
typeId = -1;
break;
case 0:
temp = "公司新闻";
model.BumName = "";
break;
case -1:
temp = "公司公告";
model.BumName = "";
typeId = -1;
break;
}
div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>"
+ "<span> > </span>"
+ "<span><a title='" + temp + "' href='/N_Index/DataTypeList.aspx?typeid=" + typeId + "'>" + temp + "</a></span>"
+ "<span> > </span>"
+ "<span>详细信息</span>"
+ "</font>";
}
protected void Button1_Click(object sender, EventArgs e)
{
Tunnel_ProJectMent TPModel = new Tunnel_ProJectMent();
TPModel.Pro_Title = tb_Title.Text.Trim();
TPModel.Pro_Name = tb_Title0.Text.Trim();
TPModel.Pro_Manager = 0;
TPModel.Pro_StartDate = Convert.ToDateTime(tb_Title1.Text.Trim());
//人员需求计划
TPModel.Pro_ManDate = Convert.ToDateTime(tb_Title2.Text.Trim());
//合同签订计划
TPModel.Pro_ContractDate = Convert.ToDateTime(tb_Title3.Text.Trim());
//设备需求计划
TPModel.Pro_EquipmentDate = Convert.ToDateTime(tb_Title4.Text.Trim());
//材料进场计划
TPModel.Pro_MaterialDate = Convert.ToDateTime(tb_Title5.Text.Trim());
//施工方案编制计划
TPModel.Pro_PlanDate = Convert.ToDateTime(tb_Title6.Text.Trim());
//安全申报计划
TPModel.Pro_SecurityDate = Convert.ToDateTime(tb_Title7.Text.Trim());
Tunnel.BLL.Tunnel_ProJectMent TPBll = new Tunnel.BLL.Tunnel_ProJectMent();
int ReSult = TPBll.Add(TPModel);
if (ReSult > 0)
{
Tunnel_bum TbModel = new Tunnel_bum();
TbModel.b_name = tb_Title0.Text.Trim();
TbModel.b_depict = tb_Title.Text.Trim();
TbModel.b_hid = 0;
TbModel.b_projectid = ReSult;
Tunnel.BLL.Tunnel_bum TbBll = new Tunnel.BLL.Tunnel_bum();
if (TbBll.Add(TbModel) > 0)
{
Tunnel.Common.Message.Show("项目新建成功!");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Tunnel.BLL.Tunnel_bum bt = new Tunnel.BLL.Tunnel_bum();
Tunnel.BLL.Tunnel_form tf = new Tunnel.BLL.Tunnel_form();
Tunnel.Model.Tunnel_form mf = new Tunnel.Model.Tunnel_form();
Tunnel.BLL.Tunnel_formtype btf = new Tunnel.BLL.Tunnel_formtype();
Tunnel.Model.Tunnel_formtype bmf = new Tunnel.Model.Tunnel_formtype();
mf.f_name = TextBox1.Text.Trim();
mf.f_lcid = int.Parse(DropDownList2.SelectedValue);
mf.f_bum = 0;
mf.f_user = 1;
mf.f_date = DateTime.Now;
int i = tf.Name_Add(mf);
if (i > 0)
{
bmf.Form_id = i;
bmf.Form_name = TextBox1.Text.Trim();
bmf.Item_max = 0;
btf.Add(bmf);
Tunnel.Common.Message.Show("保存成功!");
}
}
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;
}
public void ListBind()
{
if (ul.JiaoSe(ul.LoginID).Equals("系统管理员"))
{
where = "";
PageBind2();
}
else
{
Tunnel.BLL.Tunnel_bum tb = new Tunnel.BLL.Tunnel_bum();
Tunnel_bum tbb = new Tunnel_bum();
tmm = tm.GetModel(Convert.ToInt64(ul.LoginID.ToString()));
if (tmm != null)
{
if (!string.IsNullOrEmpty(tmm.m_bum.ToString()))
{
tbb = tb.GetModel(Convert.ToInt64(tmm.m_bum.ToString()));
if (tbb != null)
{
List <Tunnel.Model.Tunnel_SelType> tsList = new List <Tunnel_SelType>();
Tunnel.BLL.SelType tst = new Tunnel.BLL.SelType();
tsList = tst.GetModelList("");
// bumname='" + tbb.b_name + "'
if (tsList.Count > 0)
{
for (int i = 0; i < tsList.Count; i++)
{
bhtype += tsList[i].TypeID.ToString() + "|";
}
if (bhtype.Length > 0)
{
bhtype = bhtype.Substring(0, bhtype.Length - 1);
}
}
where = "";
for (int i = 0; i < bhtype.Split('|').Length; i++)
{
if (where.Length > 0)
{
if (i == bhtype.Split('|').Length - 1)
{
where += " or typeid=" + bhtype.Split('|')[i] + ")";
}
else
{
where += " or typeid=" + bhtype.Split('|')[i] + "";
}
}
else
{
where += " (typeid=" + bhtype.Split('|')[i] + "";
}
}
PageBind2();
}
else
{
MTCPager1.RecordCount = 0;
}
}
}
}
}
/// <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;
}
}
}
/// <summary>
/// 文章列表 文章浏览 公告栏 新闻栏
/// </summary>
/// <param name="num"></param>
public void WriteSiteMap(int num)
{
Master.FindControl("Panel1").Visible = false;
System.Web.UI.HtmlControls.HtmlGenericControl div = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Panel2");
string str = div.InnerHtml;
div.Visible = true;
Style sty = new Style();
div.Style.Add(HtmlTextWriterStyle.Display, "''");
Tunnel.Model.Tunnel_SelType model = new Tunnel_SelType();
Tunnel.BLL.SelType stBll;
Tunnel.BLL.Tunnel_bum tbBll = new Tunnel.BLL.Tunnel_bum();
string temp = "";
if (typeId < 1)
{
switch (typeId)
{
case -1:
temp = "公告栏";
model.BumName = "";
break;
case 0:
temp = "公司新闻";
model.BumName = "";
break;
}
}
else
{
stBll = new Tunnel.BLL.SelType();
model = stBll.GetModel(typeId);
if (model != null)
{
temp = model.TypeName;
}
}
if (bum_id != 0)
{
div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>"
+ "<span> > </span>"
+ "<span><a title='" + model.BumName + "-" + tbBll.GetModel(bum_id).b_name + "' href='/" + model.Url + "?bum_id=" + bum_id + "'>" + model.BumName + "-" + tbBll.GetModel(bum_id).b_name + "</a></span>"
+ "<span> > </span>"
+ "<span><a title='" + temp + "' href='/N_Index/DataTypeListXJB.aspx?typeid=" + model.TypeID + "&lanmuId=0&bum_id=" + bum_id + "'>" + temp + "</a></span>"
+ "<span> > </span>"
+ "<span>详细信息</span>"
+ "</font>";
}
else
{
div.InnerHtml = "<font class='titlfontson'><span><a title='首页' href='/Index.aspx'>首页</a></span>"
+ "<span> > </span>"
+ "<span><a title='" + model.BumName + "' href='/" + model.Url + "'>" + model.BumName + "</a></span>"
+ "<span> > </span>"
+ "<span><a title='" + temp + "' href='/N_Index/DataTypeList.aspx?typeid=" + model.TypeID + "&lanmuId=0'>" + temp + "</a></span>"
+ "<span> > </span>"
+ "<span>详细信息</span>"
+ "</font>";
}
}