/// <summary>
/// 页面初始化加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_Users"] == null)
{
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"您目前已经登录超时！请重新登录！谢谢！\");location.href='/login.aspx';</script>";
Response.Write(coutws);
return;
}
if (!Page.IsPostBack)
{
string time = this.Request.QueryString["time"].ToString();
ParseTime(time);
string changeyear = string.Empty;
if (!string.IsNullOrEmpty(year))
{
changeyear += ChangeYear(year);
}
if (!string.IsNullOrEmpty(year) && !string.IsNullOrEmpty(toyear))
{
changeyear = changeyear + "-" + ChangeYear(toyear);
}
this.lblYear.Text = changeyear;
bindDataToGV();
this.lblCount.Text = pageControl.doSql("select count(1) from dbo.USER_Users").Tables[0].Rows[0][0].ToString();
if (this.GridView1.Rows.Count == 0)
{
Response.Write("没有符合条件的数据！");
}
else
{
//导出Excel
exportExcel();
}
}
}
/// <summary>
/// 获取所属预算报告列表
/// </summary>
private void GetDDLBudget()
{
try
{
DDL_Budget.Items.Clear();
DataTable DT = new DataTable();
string sql = "SELECT ID, NAMES FROM Cash_SF_Order WHERE (Delflag = 0) AND (Status = 1) ORDER BY ADDTIME DESC ";
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
DDL_Budget.DataSource = DT;
DDL_Budget.DataTextField = "NAMES";
DDL_Budget.DataValueField = "ID";
DDL_Budget.DataBind();
}
else
{
ListItem li = new ListItem("-暂无预算报告-", "");
DDL_Budget.Items.Add(li);
//没有预算报告不能创建资金卡
Button_sumbit.Enabled = false;
tag.Text = "暂无预算报告，不能创建资金卡！";
}
}
catch
{ }
}
/// <summary>
/// 会议室列表
/// </summary>
protected void ShowListInfo()
{
try
{
DataTable dt = new DataTable();
string sql = "SELECT * FROM Project_RoomList WHERE (DELFLAG = 0)";
dt = pagecontrol.doSql(sql).Tables[0];
if (dt.Rows.Count > 0)
{
GridView1.Visible = true;
GridView1.DataSource = dt; //指定GridView1的数据是DT
GridView1.DataBind(); //将上面指定的信息绑定到GridView1上
}
else
{
GridView1.Visible = false;
Button_Check.Enabled = false;
notice.Text = "*暂无可供预订的会议室信息！";
}
}
catch
{
}
}
/// <summary>
/// 显示出当前各个按钮的数据条数
/// </summary>
/// <returns></returns>
private string countnums(LinkButton lib, string types, string condition)
{
string coutw = "";
try
{
string sqlwhere = SQLCondition_tag2(types, "0", condition);
string strSQL = "SELECT count(ID) as nums FROM FaceShowMessage WHERE " + sqlwhere;
DataTable dt = new DataTable();
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
coutw = dt.Rows[0]["nums"].ToString();
}
else
{
coutw = dtrowsHidden.Value.ToString();
}
}
catch
{
}
return(coutw);
}
/// <summary>
///
/// </summary>
/// <param name="groupname"></param>
protected void BindData()
{
try
{
DateTime dtBegin = new DateTime(Int32.Parse(txtBeginDate.Value.Split('-')[0]), Int32.Parse(txtBeginDate.Value.Split('-')[1]), Int32.Parse(txtBeginDate.Value.Split('-')[2]), 0, 0, 0);
DateTime dtEnd = new DateTime(Int32.Parse(txtEndTime.Value.Split('-')[0]), Int32.Parse(txtEndTime.Value.Split('-')[1]), Int32.Parse(txtEndTime.Value.Split('-')[2]), 23, 59, 59);
string strSQL = @"Select a.DateDay From (Select datename(yyyy, GetDateTime)+datename(mm, GetDateTime)+datename(dd, GetDateTime) as DateDay From Cash_Apply Where GetDateTime between '" + dtBegin + "' and '" + dtEnd + "') a Group By a.DateDay";
DataTable dt = new DataTable();
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
//当获取到的数据集不为空的时候，显示在GridView1中
this.DataList1.Visible = true;
this.DataList1.DataSource = dt; //指定GridView1的数据是dv
this.DataList1.DataBind(); //将上面指定的信息绑定到GridView1上
tag.Text = "";
}
else
{
this.DataList1.Visible = false;
tag.Text = "*没有符合条件的结果！";
}
}
catch
{
}
}
/// <summary>
/// 页面初始化加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string time = this.Request.QueryString["time"].ToString();
ParseTime(time);
string changeyear = string.Empty;
if (!string.IsNullOrEmpty(year))
{
changeyear += ChangeYear(year);
}
if (!string.IsNullOrEmpty(year) && !string.IsNullOrEmpty(toyear))
{
changeyear = changeyear + "-" + ChangeYear(toyear);
}
this.lblYear.Text = changeyear;
bindDataToGV();
this.lblCount.Text = pageControl.doSql("select count(1) from dbo.USER_Users").Tables[0].Rows[0][0].ToString();
if (this.GridView1.Rows.Count == 0)
{
Response.Write("没有符合条件的数据！");
}
else
{
//导出Excel
exportExcel();
}
}
}
/// <summary>
/// 获取到当前数据集中总共有多少条记录
/// </summary>
private void setRowCout()
{
try
{
DataTable DT = new DataTable();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
string sendid = "";
if (null != user_model)
{
sendid = user_model.ID;
}
else
{
sendid = "1";
}
string sqlWhere = "SELECT * FROM vProject_UserList WHERE (DELFLAG = '0') and status='1'and ProjectID='" + Session["Work_ProjectId"].ToString() + "'";
DT = pageControl.doSql(sqlWhere).Tables[0];
if (DT.Rows.Count > 0)
{
dtrowsHidden.Value = DT.Rows.Count.ToString();
}
else
{
dtrowsHidden.Value = "0";
}
}
catch
{
}
}
private void GetddlProjectID()
{
try
{
DataTable dt = new DataTable();
//string strSQL = "Select distinct(ProjectID),ProjectName From vProject_UserList Where ProjectID=" + _projectid;
string strSQL = "Select distinct(ID) as ProjectID,NAMES as ProjectName From Project_Projects Where ID=" + _projectid;
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
this.ddlProjectID.DataSource = dt;
this.ddlProjectID.DataTextField = "ProjectName";
this.ddlProjectID.DataValueField = "ProjectID";
this.ddlProjectID.DataBind();
Button_sumbit.Enabled = true;
}
else
{
Button_sumbit.Enabled = false;
}
}
catch
{
Button_sumbit.Enabled = false;
}
}
/// <summary>
/// 获取到当前数据集中总共有多少条记录
/// </summary>
/// <param name="depart">部门</param>
/// <param name="workstatus">工作状态</param>
private void setRowCout(string depart, string workstatus)
{
try
{
DataTable DT = new DataTable();
string sql = "SELECT * FROM vUSER_Users WHERE 1=1";
if (null != depart && depart != "")
{
sql = sql + " and DepartMentID like '%" + depart + "%'";
}
if (null != workstatus && workstatus != "")
{
sql = sql + " and WorkStats = '" + workstatus + "'";
}
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
dtrowsHidden.Value = DT.Rows.Count.ToString();
}
else
{
dtrowsHidden.Value = "0";
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request["id"].ToString();
foritems = Request["ForItems"].ToString();
parentid = Request["PARENTID"].ToString();
limitschoose = Request["LimitsChooseID"].ToString();
// 默认NEWS
if (String.IsNullOrEmpty(_foritems))
{
_foritems = "NEWS";
}
DataTable dt = new DataTable();
string sql = "SELECT UserID FROM News_LimitUser WHERE NewsID=" + id;
dt = pageControl.doSql(sql).Tables[0];
Session["UserID"] = dt;
mNews_News = new Dianda.Model.News_News();
mNews_News = bNews_News.GetModel(Int32.Parse(id));
this.txtNAME.Text = mNews_News.NAME;
this.FCKeditor_neirong.Value = mNews_News.CONTENTS;
GetddlPARENTID();
GetrblLimitsChoose();
BindDataList();
}
}
/// <summary>
/// 获取业务申请列表信息
/// </summary>
public void ShowApplyList(string type, string projectid)
{
try
{
HiddenField_projectid.Value = projectid;
DataTable DT = new DataTable();
string sqlWhere1 = "select * from vProject_Apply where DELFLAG=0 and ProjectID=" + projectid + " and AppType = '" + type + "' order by datetime desc";
DT = pageControl.doSql(sqlWhere1).Tables[0];
if (DT.Rows.Count > 0)
{
//当获取到的数据集不为空的时候，显示在GridView1中
GridView1.Visible = true;
GridView1.DataSource = DT; //指定GridView1的数据是DT
GridView1.DataBind(); //将上面指定的信息绑定到GridView1上
notice.Text = "";
tongji(DT);
}
else
{
GridView1.Visible = false;
notice.Text = "*没有符合条件的结果！";
Label_tongji.Text = "暂无统计信息！";
}
}
catch
{
GridView1.Visible = false;
notice.Text = "*进入业务申请列表发生错误！";
Label_tongji.Text = "暂无统计信息！";
}
if (type == "orderSignet")
{
GridView1.HeaderRow.Cells[1].Text = "预订日期";
}
if (DDL_type.SelectedValue.ToString().Equals("orderSignet"))
{
if (GridView1.Visible != false)
{
GridView1.HeaderRow.Cells[1].Text = "预订日期";
}
}
else
{
if (GridView1.Visible != false)
{
GridView1.HeaderRow.Cells[1].Text = "使用日期";
GridView1.Columns[4].Visible = false;
}
}
}
/// <summary>
/// 获取到当前数据集中总共有多少条记录
/// </summary>
/// <param name="projectname">项目名称</param>
/// <param name="leadername">项目负责人</param>
/// <param name="depart">部门</param>
/// <param name="starttime">开始时间</param>
/// <param name="endtime">结束时间</param>
private void setRowCout(string projectname, string leadername, string depart, string starttime, string endtime)
{
try
{
DataTable DT = new DataTable();
string sql = "SELECT * FROM vProject_Projects WHERE (Status=1 or Status=3 or Status=5) and DELFLAG = 0 ";
//项目名称
if (null != projectname && !projectname.Equals(""))
{
sql = sql + " AND NAMES LIKE '%" + projectname + "%' ";
}
//项目负责人
if (null != leadername && !leadername.Equals(""))
{
sql = sql + " AND ( LeaderRealName LIKE '%" + leadername + "%' OR LeaderUserName LIKE '%" + leadername + "%')";
}
//参与部门
if (null != depart && !depart.Equals(""))
{
sql = sql + " AND DepartmentNames LIKE '%" + depart + "%' ";
}
//开始时间
if (null != starttime && !starttime.Equals(""))
{
sql = sql + " AND StartTime >='" + Convert.ToDateTime(starttime) + "'";
}
//结束时间
if (null != endtime && !endtime.Equals(""))
{
sql = sql + " AND EndTime <='" + Convert.ToDateTime(endtime) + "'";
}
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
dtrowsHidden.Value = DT.Rows.Count.ToString();
}
else
{
dtrowsHidden.Value = "0";
}
}
catch
{
}
}
protected void ShowInitInfo(string ID)
{
try
{
string sql = " SELECT * FROM vCash_CardsDetail WHERE CardID='" + common.SafeString(ID) + "' order by id";
DataTable DT = new DataTable();
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
//资金卡名称
LB_Name.Text = DT.Rows[0]["CardName"].ToString();
//所属项目
LB_Project.Text = DT.Rows[0]["ProjectName"].ToString();
//持卡人
LB_Holder.Text = DT.Rows[0]["HolderRealName"].ToString();
//审批人
LB_Checker.Text = DT.Rows[0]["CheckRealName"].ToString();
//资金卡编号
LB_CardNum.Text = DT.Rows[0]["CardNum"].ToString();
//所属专项资金
LB_SpecialFundsName.Text = DT.Rows[0]["SpecialFundsName"].ToString();
//所属帐户
LB_AccountName.Text = DT.Rows[0]["AccountName"].ToString();
//所属预算报告
LB_SFOrderName.Text = "<a href='" + DT.Rows[0]["BudgetList"].ToString() + "' target='_blank'>" + DT.Rows[0]["SFOrderName"].ToString() + "</a>";
LB_Info.Text = " 可用金额调整情况：<br>" + DT.Rows[0]["TEMP0"].ToString();
DList_YSJE.DataSource = DT;
DList_YSJE.DataBind();
DList_YSJE.RepeatColumns = DT.Rows.Count;
DList_KYJE.DataSource = DT;
DList_KYJE.DataBind();
DList_KYJE.RepeatColumns = DT.Rows.Count;
DList_DQYE.DataSource = DT;
DList_DQYE.DataBind();
DList_DQYE.RepeatColumns = DT.Rows.Count;
}
else
{
LB_MSG.Text = "暂无该资金卡的相关信息！";
}
}
catch
{ }
}
/// <summary>
///
/// </summary>
/// <param name="groupname"></param>
public void BindData()
{
try
{
string strSQL = "SELECT * FROM vUSER_Users WHERE " + SQLCondition();
DataTable dt = new DataTable();
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
//当获取到的数据集不为空的时候，显示在GridView1中
GridView1.Visible = true;
GridView1.DataSource = dt; //指定GridView1的数据是dv
GridView1.DataBind(); //将上面指定的信息绑定到GridView1上
notice.Text = "";
}
else
{
GridView1.Visible = false;
notice.Text = "*没有符合条件的结果！";
}
}
catch
{
}
}
/// <summary>
/// 给指定的KEY放置值
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
private object setValue(string tableNameKEY)
{
object coutw = new object();
try
{
Dianda.COMMON.staticApp.Remove((object)tableNameKEY);//先删除
//如果tableNameKEY中包含“|”则表示有查询条件限制
string tablename = tableNameKEY;
string tiaojian = "";
if (tableNameKEY.Contains("|"))
{
string[] arrays = tableNameKEY.Split('|');
tablename = arrays[0].ToString();
tiaojian = arrays[1].ToString();
}
string sql = "select * from " + tablename + " " + tiaojian;
DataSet ds = dosqls.doSql(sql);
coutw = (object)ds;
Dianda.COMMON.staticApp.SetValue((object)tableNameKEY, coutw);
}
catch
{
}
return(coutw);
}
protected void btnReport_Click(object sender, EventArgs e)
{
DataTable DT = new DataTable();
DT = pageControl.doSql("select * from vBudget_Department_Statistical").Tables[0];
DataTable dt = DT;
this.GridView2.DataSource = dt;
this.GridView2.DataBind();
this.GridView2.Visible = true;
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("部门经费统计" + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls", Encoding.UTF8).ToString());
Response.Charset = "gb2312";
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView2.RenderControl(htmlWrite);
string strExcel = stringWrite.ToString();
//去除超链接
strExcel = Regex.Replace(strExcel, "<a (.*?)>", "", RegexOptions.Compiled);
strExcel = Regex.Replace(strExcel, "</a>", "");
Response.Write(strExcel);
Response.End();
}
private void BindData()
{
DataTable dt = new DataTable();
string sql = "Select * From vCash_Apply Where ID=" + _id;
dt = pageControl.doSql(sql).Tables[0];
if (dt.Rows.Count > 0)
{
this.lblApplierRealName.Text = dt.Rows[0]["ApplierRealName"].ToString();
this.lblApplyCount.Text = dt.Rows[0]["ApplyCount"].ToString();
this.lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString();
this.lblGetDateTime.Text = dt.Rows[0]["GetDateTime"].ToString();
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblUseFor.Text = dt.Rows[0]["UseFor"].ToString();
this.lblApplierTel.Text = dt.Rows[0]["ApplierTel"].ToString();
this.lblDATETIME.Text = dt.Rows[0]["DATETIME"].ToString();
string Statas = dt.Rows[0]["Statas"].ToString();
if (Statas == "0")
{
this.lblStatas.Text = "待审核";
}
else if (Statas == "1")
{
this.lblStatas.Text = "审核通过";
}
else if (Statas == "2")
{
this.lblStatas.Text = "<font color='red'>审核不通过</font>";
}
else if (Statas == "3")
{
this.lblStatas.Text = "审核完成";
}
}
}
/// <summary>
/// 显示印章种类
/// </summary>
protected void ShowDDLInfo()
{
try
{
DataTable dt = new DataTable();
string sql = "SELECT ID, SignetName FROM Project_SignetList WHERE DELFLAG = 0 ";
dt = pageControl.doSql(sql).Tables[0];
//ListItem li = new ListItem("-请选择-","");
//DDL_Signet.Items.Add(li);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem li1 = new ListItem(dt.Rows[i]["SignetName"].ToString(), dt.Rows[i]["ID"].ToString());
DDL_Signet.Items.Add(li1);
}
}
}
catch
{
}
}
public void BindData()
{
DataTable dt = new DataTable();
string strSQL = "Select * From vCash_Cards Where id=" + _id;
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblCardNum.Text = dt.Rows[0]["CardNum"].ToString();
this.lblCardholderRealName.Text = dt.Rows[0]["CardholderRealName"].ToString();
this.lblDepartmentName.Text = dt.Rows[0]["DepartmentName"].ToString();
this.lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString();
this.lblLimitNums.Text = dt.Rows[0]["LimitNums"].ToString();
this.lblApproverRealName.Text = dt.Rows[0]["ApproverRealName"].ToString();
this.lblStatas.Text = dt.Rows[0]["Statas"].ToString();
//这里是不是多复制了？
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
this.lblCardName.Text = dt.Rows[0]["CardName"].ToString();
}
}
/// <summary>
/// 分页显示
/// </summary>
/// <param name="pageindex">页码</param>
/// <param name="keys">搜索条件</param>
protected void ShowKcList()
{
try
{
if (Session["USERID_SYSUSER"].ToString().Length > 0)
{
DataTable DT = new DataTable();
string sqlWhere1 = "select top 6 * from DOC_transport_To where TOUSER='******' and delflag='0' order by ISREAD ASC,DATETIME DESC";
DT = PageControl.doSql(sqlWhere1).Tables[0];
if (DT.Rows.Count > 0)
{
//当获取到的数据集不为空的时候，显示在GridView1中
GridView1.Visible = true;
GridView1.DataSource = DT; //指定GridView1的数据是DT
GridView1.DataBind(); //将上面指定的信息绑定到GridView1上
notice.Text = "";
}
else
{
GridView1.Visible = false;
notice.Text = "*您暂时没有文件可以访问！";
}
}
}
catch
{
}
}
/// <summary>
/// 获取资金卡的列表
/// </summary>
private void GetddlCardName()
{
try
{
string Dtime = DateTime.Now.ToString("yyyy-MM-dd");
DataTable dt = new DataTable();
//string strSQL = "Select CardName+'['+CardNum+','+cast (LimitNums as varchar)+']' as CardName,ID From Cash_Cards Where Statas=1 and ProjectID=" + this.ddlProjectID.SelectedValue + " order by ID";
string strSQL = "select CardName+'[ 编号: '+CardNum+' , 金额:'+cast (LimitNums as varchar)+']' + case when datediff(dd,cast('" + Dtime + " 00:00:00' as datetime),isnull(endtime,''))<0 then '（已过期）' else '' end as CardName,ID from Cash_Cards where statas=1 and ProjectID= " + this.ddlProjectID.SelectedValue + " order by id";
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
this.ddlCardName.DataSource = dt;
this.ddlCardName.DataTextField = "CardName";
this.ddlCardName.DataValueField = "ID";
this.ddlCardName.DataBind();
}
else
{
this.ddlCardName.Items.Clear();
//this.ddlCardName.Items.Add(new ListItem("无资金卡", ""));
}
}
catch
{
}
}
/// <summary>
/// 返回指定ID用户的在开始时间和结束时间范围内的项目任务
/// </summary>
/// <param name="userId"></param>
/// <param name="startDay"></param>
/// <param name="endData"></param>
/// <returns></returns>
private string getProject_Plan(string userId, DateTime startDay)
{
string couw = "";
try
{
userModel = usersBll.GetModel(userId);
if (userModel != null)
{
string sql = "select * from vProject_Task where Pro_DELFLAG='0' and Pro_Status=1 and '" + startDay.ToString("yyyy-MM-dd") + "' BETWEEN CAST(CONVERT(varchar(10), StartTime, 120) + ' 00:00:00' AS datetime) AND CAST(CONVERT(varchar(10), endTime, 120) + ' 23:59:59' AS datetime) and delflag = '0' and Status <> 2 and userInfo Like '%" + userModel.REALNAME.ToString() + "(" + userModel.USERNAME.ToString() + ")" + "%' order by StartTime asc";
DataTable dt = dosql.doSql(sql).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
couw = "<task>";
for (int i = 0; i < dt.Rows.Count; i++)
{
couw = couw + "<info startTime=\"" + DateTime.Parse(dt.Rows[i]["StartTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\" endTime=\"" + DateTime.Parse(dt.Rows[i]["endTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss") + "\" url=\"/Admin/personalProjectManage/OAtask/manage.aspx?ID=" + dt.Rows[i]["ProjectID"].ToString() + "\" status=\"" + dt.Rows[i]["Status"].ToString() + "\">" + dt.Rows[i]["NAMES"].ToString() + "</info>";
}
couw = couw + "</task>";
}
}
}
catch
{
}
return(couw);
}
private void BindData(string id)
{
DataTable dt = new DataTable();
string strSQL = "Select * From vCash_Message Where ID=" + common.SafeString(id);
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
lblCardName.Text = dt.Rows[0]["CardName"].ToString();
lblCardholderRealName.Text = dt.Rows[0]["CardholderRealName"].ToString();
lblDepartmentName.Text = dt.Rows[0]["DepartmentName"].ToString();
lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString();
lblLimitNums.Text = dt.Rows[0]["LimitNums"].ToString();
lblApproverRealName.Text = dt.Rows[0]["ApproverRealName"].ToString();
lblDATETIME.Text = dt.Rows[0]["DATETIME"].ToString();
if (dt.Rows[0]["IsRead"].ToString() == "0")
{
lblIsRead.Text = "未读";
}
else
{
lblIsRead.Text = "已读";
}
lblReadTime.Text = dt.Rows[0]["ReadTime"].ToString();
lblDoUserID.Text = dt.Rows[0]["DoUserID"].ToString();
txtDoNotes.Text = dt.Rows[0]["DoNotes"].ToString();
}
}
/// <summary>
/// 获取到当前数据集中总共有多少条记录
/// </summary>
private void setRowCout(string status)
{
try
{
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
DataTable DT = new DataTable();
string sql = " SELECT * FROM vProject_Budget WHERE (BudgetList <> '') AND (BudgetList IS NOT NULL) AND (DELFLAG = 0) AND (Status = 1) ";
string role = Request["role"].ToString();
//如果是领导进入的预算管理，那么他只能看属于自己审批的项目的预算情况，如果是秘书或是财务的话，那么他们则能看到所有审批通过的预算管理情况。
if (role.Equals("manager"))
{
sql = sql + " AND (DoUserID = '" + user_model.ID + "') ";
}
sql = sql + " AND (TEMP1 = '" + status + "') ";
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
dtrowsHidden.Value = DT.Rows.Count.ToString();
}
else
{
dtrowsHidden.Value = "0";
}
}
catch
{
}
}
/// <summary>
/// 显示项目详情
/// </summary>
/// <param name="id"></param>
protected void ShowApplyInfo(string id)
{
try
{
DataTable DT = new DataTable();
string sql = "SELECT * FROM vProject_Apply_OrderSignet WHERE ID = " + id;
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
//项目名称
Label_ProjectName.Text = DT.Rows[0]["ProjectNames"].ToString();
Session["ProjectNames"] = DT.Rows[0]["ProjectNames"].ToString();
//提交申请时间
Label_DATETIME.Text = Convert.ToDateTime(DT.Rows[0]["DATETIME"].ToString()).ToString("yyyy-MM-dd hh:mm");
//用印类型
Label_SignetName.Text = DT.Rows[0]["SignetName"].ToString();
Session["SignetName"] = DT.Rows[0]["SignetName"].ToString();
//预订申请人
Label_SendUserID.Text = DT.Rows[0]["SendRealName"].ToString() + "[" + DT.Rows[0]["SendUserName"].ToString() + "]";
Session["Signet_ApplyUserName"] = "******" + DT.Rows[0]["SendRealName"].ToString() + ")";
//申请部门
Label_DepartmentID.Text = DT.Rows[0]["DepartmentName"].ToString();
//项目概要
Label_Overviews.Text = DT.Rows[0]["Overviews"].ToString();
//用印份数
Label_SignetNums.Text = DT.Rows[0]["Nums"].ToString();
Session["Signet_Nums"] = DT.Rows[0]["Nums"].ToString();
//审核意见
string DoNote = DT.Rows[0]["DoNote"].ToString();
if (null != DoNote && !DoNote.Equals(""))
{
TB_DoNote.Text = DoNote;
}
else
{
TB_DoNote.Text = "";
}
//审批状态
string status = DT.Rows[0]["Status"].ToString();
if (null != status && !status.Equals("0"))
{
RadioButtonList_Check.SelectedValue = status;
}
else
{
RadioButtonList_Check.SelectedValue = "1";
}
}
}
catch
{
}
}
/// <summary>
/// 获取到当前数据集中总共有多少条记录
/// </summary>
private void setRowCout(string status)
{
try
{
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
DataTable DT = new DataTable();
string sql = "SELECT * FROM vProject_Projects WHERE DELFLAG = 0 ";
if (null != status && !status.Equals(""))
{
if (status.Equals("9"))
{
sql = sql + " AND (ID IN (SELECT ProjectID FROM Project_ShenheList WHERE (UserID = '" + user_model.ID + "') AND (Isturn = 2) AND (Status = 0))) ";
}
else//如果查看的是待审或是不通的项目,只有在新建项目时所选择的审核人才能查看这些项目
{
sql = sql + " AND Status=" + status;
//只有在新建项目时所选择的审核人才能查看这些项目
sql = sql + " AND (DoUserID = '" + user_model.ID + "')";
}
}
else
{
sql = sql + " AND (Status=0 or Status=2)";
//只有在新建项目时所选择的审核人才能查看这些项目
sql = sql + " AND (DoUserID = '" + user_model.ID + "')";
}
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
dtrowsHidden.Value = DT.Rows.Count.ToString();
}
else
{
dtrowsHidden.Value = "0";
}
}
catch
{
}
}
/// <summary>
/// 获取到当前数据集中总共有多少条记录
/// </summary>
private void setRowCout()
{
try
{
string strSQL = "SELECT ID FROM vCash_Apply2 WHERE " + SQLCondition();
DataTable dt = new DataTable();
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
dtrowsHidden.Value = dt.Rows.Count.ToString();
}
else
{
dtrowsHidden.Value = "0";
}
}
catch
{
}
}
/// <summary>
/// 绑定年份
/// </summary>
private void bindDataToddlYear()
{
DataTable dt = pageControl.doSql("select distinct CONVERT(varchar(4) , [DATETIME], 112 ) as [year] from FaceShowMessage order by [year]").Tables[0];
this.ddlYear.DataSource = dt;
this.ddlYear.DataTextField = "year";
this.ddlYear.DataValueField = "year";
this.ddlYear.DataBind();
this.ddltoYear.DataSource = dt;
this.ddltoYear.DataTextField = "year";
this.ddltoYear.DataValueField = "year";
this.ddltoYear.DataBind();
}
private void GetddlProjectID()
{
DataTable dt = new DataTable();
string sql = "Select NAMES,ID From Project_Projects Where DELFLAG=0 and [Status]=1";//项目的状态 1表示正常运行中,0表示待审核，2表示审核不通过，3暂停，4表示草稿箱中，5表示完成
dt = pageControl.doSql(sql).Tables[0];
if (dt.Rows.Count > 0)
{
this.ddlProjectID.DataSource = dt;
this.ddlProjectID.DataTextField = "NAMES";
this.ddlProjectID.DataValueField = "ID";
this.ddlProjectID.DataBind();
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
//获得传进来的用户ID
string strId = Session["User_users"].ToString();
DataTable dt = new DataTable();
//获得选中的时间
string strdateTime = Calendar1.SelectedDate.ToString();
//通过ID获得用户在这个时间内的任务
string strsql = "select top 5 * from Personal_plan where '" + strdateTime + "' between StartTime and endTime and delflag ='0' and Status <> 2 and UserId = '" + strId + "' order by StartTime asc ";
dt = pageControl.doSql(strsql).Tables[0];
GridView_PresonProject.DataSource = dt;
GridView_PresonProject.DataBind();
}
