public string getDateInfo(string userId, string startDay1, string endData1)
{
string couw = "";
try
{
DateTime startDay = DateTime.Parse(startDay1);
DateTime endData = DateTime.Parse(endData1);
//用户的计划包括个人计划和项目任务，而且数据
userId = commons.RequestSafeString(userId, 50);
startDay = DateTime.Parse(startDay.ToString("yyyy-MM-dd") + " 00:00:00");
endData = DateTime.Parse(endData.ToString("yyyy-MM-dd") + " 23:59:59");
DateTime s = DateTime.Parse(startDay.ToString("yyyy-MM-dd"));
DateTime e = DateTime.Parse(endData.ToString("yyyy-MM-dd"));
int i = int.Parse(commons.DateDiff(s, e));
if (i >= 0)
{
for (int j = 0; j <= i; j++)
{
DateTime s1 = DateTime.Parse(s.AddDays(j).ToString("yyyy-MM-dd") + " 00:00:00");
//DateTime e1 = DateTime.Parse(s.AddDays(j).ToString("yyyy-MM-dd") + " 23:59:59");
couw = couw + "<day date=\"" + s.AddDays(j).ToString("yyyy-MM-dd") + "\">";
couw = couw + getPersonal_Plan(userId, s1);
couw = couw + getProject_Plan(userId, s1);
couw = couw + "</day>";
}
}
}
catch
{
}
return(couw);
}
/// <summary>
/// 根据用户组的ID，获取到当个用户组的
/// </summary>
/// <param name="groupid"></param>
/// <returns></returns>
private DataTable getRolesSig(string groupid)
{
DataTable coutw = new DataTable();
try
{
groupid = common.RequestSafeString(groupid, 50);
mugroups = bugroups.GetModel(groupid);
if (mugroups != null)
{
//根据找到的用户组，找出所有的权限点
string rolelist = mugroups.ROLE.ToString();
string sqlin = "";
string sql = "";
if (rolelist.Contains(","))
{
sqlin = common.makeSqlIn(rolelist, ',');
sql = "select ID,Roles,Types,upRoles from vUSER_Role where DELFLAG='0' AND ID in " + sqlin;
coutw = pageControl.doSql(sql).Tables[0];
}
else
{
if (rolelist.Length > 0)
{
sql = "select ID,Roles,Types,upRoles from vUSER_Role where DELFLAG='0' AND ID='" + rolelist + "'";
coutw = pageControl.doSql(sql).Tables[0];
}
}
}
}
catch
{
}
return(coutw);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// 默认NEWS
if (String.IsNullOrEmpty(_foritems))
{
_foritems = "NEWS";
}
if (Request.Params["PARENTID"] != null && !String.IsNullOrEmpty(Request["PARENTID"]))
{
_parentid = common.RequestSafeString(Request["PARENTID"], 50);
}
if (_parentid == "3")
{
_foritems = "DEPARTMENT";
}
else if (_parentid == "4" || _parentid == "5")
{
_foritems = "NEWS";
}
GetddlPARENTID();
GetrblLimitsChoose();
BindDataList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = common.RequestSafeString(Request["id"].ToString(), 50);
BindData(id);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Params["id"] != null && !String.IsNullOrEmpty(Request["id"]))
{
_id = common.RequestSafeString(Request["id"], 50);
}
BindData();
}
}
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 (!IsPostBack)
{
string id = common.RequestSafeString(Request["id"].ToString(), 50);
BindData(id);
}
}
/// <summary>
/// 按项目筛选触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DropDownList_myProject_change(object sender, EventArgs e)
{
try
{
string oldsession = Session["Work_ProjectId"].ToString();
string projectid = commons.RequestSafeString(DropDownList_myProject.SelectedValue.ToString(), 50);
Session["Work_ProjectId"] = projectid;
setProjectStatusName(projectid);//设置项目的状态
string urls = Request.RawUrl;
//项目任务
if (urls.Contains("/Admin/personalProjectManage/OAtask/"))
{
urls = "/Admin/personalProjectManage/OAtask/manage.aspx";
}//项目经费
else if (urls.Contains("/Admin/personalProjectManage/OACashApply/"))
{
urls = "/Admin/personalProjectManage/OACashApply/manageCashApply.aspx";
}//项目资源
else if (urls.Contains("/Admin/personalProjectManage/OAapply/"))
{
urls = "/Admin/personalProjectManage/OAapply/manage.aspx";
}//项目消息
else if (urls.Contains("/Admin/personalProjectManage/OANews/"))
{
urls = "/Admin/personalProjectManage/OANews/manage.aspx";
}//项目文档
else if (urls.Contains("/Admin/DocumentManage/"))
{
urls = "/Admin/DocumentManage/manage.aspx";
}//人员分配
else if (urls.Contains("/Admin/personalProjectManage/OADepartMent/"))
{
urls = "/Admin/personalProjectManage/OADepartMent/manage.aspx";
}
Response.Redirect(urls);
// Response.Redirect("/Admin/personalProjectManage/OAtask/manage.aspx");
}
catch
{
}
}
/// <summary>
/// 根据条件构建数据
/// </summary>
/// <param name="groupname"></param>
protected void BindData(string status)
{
try
{
ddlStatas.SelectedValue = status;
string projectid = common.RequestSafeString(HiddenField_projectid.Value.ToString(), 50);
string strSQL = "SELECT * FROM vCash_Apply WHERE projectid='" + projectid + "' and statas='" + status + "' order by getdatetime desc";
DataTable dt = new DataTable();
dt = pageControl.doSql(strSQL).Tables[0];
HiddenField_totals.Value = "0";
mProject = bProject.GetModel(int.Parse(projectid));
if (dt.Rows.Count > 0)
{
GridView1.Visible = true;
GridView1.DataSource = dt; //指定GridView1的数据是dv
GridView1.DataBind(); //将上面指定的信息绑定到GridView1上
notice.Text = "";
tag.Text = "总计: " + HiddenField_totals.Value.ToString() + " 元";
Label_tongji.Text = mProject.NAMES.ToString() + " 的预计经费为: " + mProject.CashTotal.ToString() + "元<br/>共 " + dt.Rows.Count.ToString() + " 条记录！<br/>总计 " + HiddenField_totals.Value.ToString() + " 元";
}
else
{
GridView1.Visible = false;
notice.Text = "*没有符合条件的结果！";
tag.Text = "";
Label_tongji.Text = "暂无统计信息！";
}
}
catch
{
tag.Text = "";
Label_tongji.Text = "暂无统计信息！";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Button_sumbit.Visible = true;
id = common.RequestSafeString(Request["id"].ToString(), 50);
//获取所属预算报告列表信息
GetDDLBudget();
//获取所属部门的列表信息
GetddlDepartmentID();
//获取持卡人的列表信息
GetddlCardholderID();
//获取所属项目的列表信息
GetddlProjectID();
//获取审批人的列表信息
GetddlApprover();
ShowInitInfo(id);
/*设置模板页中的管理值*/
(Master.FindControl("Label_navigation") as Label).Text = "管理 > 财务管理 > 资金卡";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//设置项目状态
if (Request.QueryString["status"] == null)
{
DDL_Status.SelectedValue = "";
}
else
{
DDL_Status.SelectedValue = Request.QueryString["status"].ToString();
}
//项目ID
string projectid = Request["ID"];
if (projectid != null && projectid != "")//如果项目的ID存在，则做切换
{
projectid = commons.RequestSafeString(projectid.ToString(), 50);
Session["Work_ProjectId"] = projectid;
}
Session["Session_Project_linkshow"] = "LinkButton_task";//定义过来后要显示任务的按钮
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
//判断此项目的项目负责人是否为现在操作的人员（因为操作人员可分为“项目负责人”和“项目参与人员”）
//如果不是项目负责人在操作，则不能进行新增，编辑，删除的相关操作
string sql = " SELECT LeaderID,SendUserID FROM Project_Projects where ID= " + Session["Work_ProjectId"];
DataTable DT_leaderID = new DataTable();
DT_leaderID = pageControl.doSql(sql).Tables[0];
if (DT_leaderID.Rows.Count > 0)
{
string LeaderID = DT_leaderID.Rows[0]["LeaderID"].ToString();
string SendUserID = DT_leaderID.Rows[0]["SendUserID"].ToString();
if (!LeaderID.Equals(user_model.ID) && !SendUserID.Equals(user_model.ID))//说明不是项目负责人
{
Button_add.Visible = false;
Button_modify.Visible = false;
Button_delete.Visible = false;
//这里设这个session是为了“设为已完成”，“设为进行中”，“设为延期”三个功能用的
//因为项目负责人进行以上三个功能操作时只需要改变相应任务中的status即可
//而项目参与人员则必须同时修改掉UserIDs中对应着自己的ID号的status
Session["isProjectLeader"] = false;
}
else
{
Session["isProjectLeader"] = true;
}
}
//以上
string pageindex = null;//这里是为分页服务的
pageindex = Request["pageindex"];
string count = dtrowsHidden.Value.ToString();
if (count.Length == 0)
{
setRowCout();//获取当前状态下有多少条数据记录，为分页提供页数和全部条数服务
count = dtrowsHidden.Value.ToString();
}
else
{
count = "0";
}
int countint = int.Parse(count);
if (pageindex == null || pageindex == "")
{
pageindex = "1";
}
int pageindex_int = int.Parse(pageindex);
ShowTaskList(pageindex_int);
//设置模板页中的管理值
(Master.FindControl("Label_navigation") as Label).Text = "项目 > 我的项目 > 任务管理 > 任务列表 ";
//设置模板页中的管理值
//if (null != Request["status"])
//{
// for (int i = 0; i < DDL_Status.Items.Count; i++)
// {
// if (DDL_Status.Items[i].Value.ToString().Equals(Request["status"].ToString()))
// {
// DDL_Status.Items[i].Selected = true;
// }
// }
//}
//项目状态
bool Project_Status = BProject_Status.ProjectStatus(Session["Work_ProjectId"].ToString());
//根据项目状态设置页面按钮状态
if (Project_Status == false)
{
Button_add.Enabled = Project_Status;
Button_modify.Enabled = Project_Status;
Button_delete.Enabled = Project_Status;
Button_setfinish.Enabled = Project_Status;
Button_setpostpone.Enabled = Project_Status;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Params["PARENTID"] != null && !String.IsNullOrEmpty(Request["PARENTID"]))
{
_parentid = common.RequestSafeString(Request["PARENTID"], 50);
}
if (Request.Params["status"] != null && !String.IsNullOrEmpty(Request["status"]))
{
_boxtype = Request["status"];
}
else
{
if (Request.Params["PARENTID"].ToString().Equals("5"))
{
_boxtype = "1";
}
else
{
_boxtype = "2";
}
}
//GetddlMailBox();
string count = dtrowsHidden.Value.ToString();
if (count.Length == 0)
{
if (_boxtype == "1")
{
setRowCout1();//发件箱
}
else
{
setRowCout();//获取当前状态下有多少条数据记录，为分页提供页数和全部条数服务
}
count = dtrowsHidden.Value.ToString();
}
else
{
count = "0";
}
int countint = int.Parse(count);
string pageindex = null;//这里是为分页服务的
if (pageindex == null || pageindex == "")
{
pageindex = "1";
}
int pageindex_int = int.Parse(pageindex);
if (_boxtype == "1")
{
this.Button_add.Visible = true;
this.Button_modify.Visible = true;
BindData1(pageindex_int);//发件箱
}
else
{
this.Button_add.Visible = false;
this.Button_modify.Visible = false;
BindData(pageindex_int);//收件箱
}
}
}
