/// <summary>
/// 点击新增按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_add_onclick(object sender, EventArgs e)
{
mProject_Projects = new Dianda.Model.Project_Projects();
mProject_Projects = bProject_Projects.GetModel(Int32.Parse(_projectid));
Response.Redirect("add.aspx?&pageindex=" + pageindexHidden.Value + "&status=" + _boxtype.ToString() + "&parentname=" + mProject_Projects.NAMES);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow) //判断是否是DataRow，以防止鼠标经过Header也有效果
{
e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#BCE2F9'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e");
//HiddenField hid = (HiddenField)e.Row.FindControl("Hid_ID");
//部门或岗位的ID
string ID = DataBinder.Eval(e.Row.DataItem, "ID").ToString();
//hid.Value = ID;
string PARENTID = DataBinder.Eval(e.Row.DataItem, "PARENTID").ToString();
string ForItems = DataBinder.Eval(e.Row.DataItem, "ForItems").ToString();
string ItemsID = DataBinder.Eval(e.Row.DataItem, "ItemsID").ToString();
mNews_Columns = new Dianda.Model.News_Columns();
mNews_Columns = bNews_Columns.GetModel(Int32.Parse(PARENTID));
if (mNews_Columns != null)
{
e.Row.Cells[1].Text = mNews_Columns.NAME;
}
else
{
e.Row.Cells[1].Text = "";
}
if (ForItems == "DEPARTMENT")
{
e.Row.Cells[2].Text = "部门信息栏目";
mUSER_Groups = new Dianda.Model.USER_Groups();
mUSER_Groups = bUSER_Groups.GetModel(ItemsID);
if (mUSER_Groups != null)
{
e.Row.Cells[3].Text = mUSER_Groups.NAME;
}
}
if (ForItems == "PROJECT")
{
e.Row.Cells[2].Text = "项目信息栏目";
mProject_Projects = new Dianda.Model.Project_Projects();
mProject_Projects = bProject_Projects.GetModel(Int32.Parse(ItemsID));
if (mProject_Projects != null)
{
e.Row.Cells[3].Text = mProject_Projects.NAMES;
}
}
if (ForItems == "NEWS")
{
e.Row.Cells[2].Text = "普通信息栏目";
}
}
}
catch
{
}
}
/// <summary>
/// 根据项目的ID获取到当前项目的状态名称
/// </summary>
/// <param name="projectid"></param>
/// <returns></returns>
public string getProjectStautsName(string projectid)
{
string coutw = "垃圾箱中";
try
{
projectid = commonss.RequestSafeString(projectid, 50);
mProjcet = bProject.GetModel(int.Parse(projectid));
if (mProjcet.DELFLAG == 1)
{
coutw = "已删除";
}
else
{
if (mProjcet.Status == 1)
{
coutw = "运行中";
}
else if (mProjcet.Status == 0)
{
coutw = "待审核";
}
else if (mProjcet.Status == 2)
{
coutw = "审核不通过";
}
else if (mProjcet.Status == 3)
{
coutw = "暂停中";
}
else if (mProjcet.Status == 4)
{
coutw = "草稿箱中";
}
else if (mProjcet.Status == 5)
{
coutw = "已完成";
}
else
{
coutw = "垃圾箱中";
}
}
}
catch
{
coutw = "项目异常";
}
return(coutw);
}
protected string SQLCondition1()//信息发布箱
{
mProject_Projects = new Dianda.Model.Project_Projects();
mProject_Projects = bProject_Projects.GetModel(Int32.Parse(_projectid));
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" 1=1 ");
if (_boxtype == "1")//信息发布
{
sbSql.Append(" AND WRITER ='" + ((Model.USER_Users)Session["USER_Users"]).USERNAME + "' ");
}
sbSql.Append(" AND PARENTNAME='" + mProject_Projects.NAMES + "'");
//sbSql.Append("ORDER BY ID ");
return(sbSql.ToString());
}
/// <summary>
/// 显示资金卡下拉列表
/// </summary>
/// <param name="CashflagID"></param>
protected void SetDDL_CashCardID()
{
DataTable dt3 = new DataTable();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
project_model = project_bll.GetModel(int.Parse(Request["ID"].ToString()));
string sql2 = " SELECT ID,ProjectID, CardNum, CardName, LimitNums FROM Cash_Cards " +
" WHERE (ProjectID IS NULL OR ProjectID = '' OR ProjectID = '" + project_model.ID + "') " +
" AND (CardholderID = '" + project_model.SendUserID + "') " +
" AND Statas = 1 ";
dt3 = pageControl.doSql(sql2).Tables[0];
if (dt3.Rows.Count > 0)
{
DDL_CashCardID.Enabled = true;
DDL_CashCardID.Items.Clear();
for (int j = 0; j < dt3.Rows.Count; j++)
{
string projectid = dt3.Rows[j]["ProjectID"].ToString();
string ID = dt3.Rows[j]["ID"].ToString();
string CardNum = dt3.Rows[j]["CardNum"].ToString();
string CardName = dt3.Rows[j]["CardName"].ToString();
string LimitNums = dt3.Rows[j]["LimitNums"].ToString();
string showinfo = CardName + "[" + CardNum + "," + LimitNums + "]";
ListItem li = new ListItem(showinfo, ID);
DDL_CashCardID.Items.Add(li);
if (projectid.Equals(project_model.ID.ToString()))
{
li.Selected = true;
}
}
}
else
{
DDL_CashCardID.Items.Clear();
ListItem li = new ListItem("暂无可选资金卡", "");
DDL_CashCardID.Items.Add(li);
DDL_CashCardID.Enabled = false;
// Button_applyfor.Enabled = false;
}
}
/// <summary>
/// 根据项目的ID获取到当前项目下的一些功能按钮是否可以使用
/// false表示不可用，true表示可以用
/// </summary>
/// <param name="projectid"></param>
/// <returns></returns>
public bool ProjectStatus(string projectid)
{
bool coutw = false;
try
{
projectid = commonss.RequestSafeString(projectid, 50);
mProjcet = bProject.GetModel(int.Parse(projectid));
if (mProjcet.Status == 1 && mProjcet.DELFLAG == 0)
{
coutw = true;
}
}
catch
{
coutw = false;
}
return(coutw);
}
/// <summary>
/// 按部门将所有的用户呈现，并且将已经选择的用户selectUser在列表上显示出来
/// </summary>
/// <param name="selectUser"></param>
public void showDepartment(string projectId)
{
try
{
//获取到部门ID
mProjects = bProjects.GetModel(int.Parse(projectId));
//通过方法 用逗号把部门ID分开
string strdepartmentId = commonId.makeSqlIn(mProjects.DepartmentID, ',');
//查询出部门中status =1 并且delflag=0 的用户
string sql = "SELECT * FROM vProject_UserList WHERE (DELFLAG = '0') and status='1'and ProjectID='" + projectId + "' ORDER BY DepartMentID";
DataTable dt1 = pagedosql.doSql(sql).Tables[0];
//通过部门ID 查看部门里有多少人员
string[] strdepartmentId_arr = mProjects.DepartmentID.Split(',');
string strsql = "";
for (int i = 0; i < strdepartmentId_arr.Length; i++)
{
if (strsql == "")
{
strsql = "select id,realName,userName,'" + strdepartmentId_arr[i] + "' departmentid from USER_Users where departmentid like '%" + strdepartmentId_arr[i] + "%'";
}
else
{
strsql += " union select id,realName,userName,'" + strdepartmentId_arr[i] + "'departmentid from USER_Users where departmentid like '%" + strdepartmentId_arr[i] + "%'";
}
}
DataTable dt = pagedosql.doSql(strsql).Tables[0];
//Session["temp_UserAllUser_session"] = dt;
//Session["temp_SelectUser_session"] = dt1;
//查询出传进来的部门ID
DataTable dt2 = new DataTable();
dt2 = bug.GetList(" TAGS='部门' and DELFLAG='0' and id in " + strdepartmentId + " order by ISMOREN").Tables[0];
shareForUser1.showDepartment(dt1, dt, dt2);
}
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 = "暂无统计信息！";
}
}
/// <summary>
/// 按部门将所有的用户呈现，并且将已经选择的用户selectUser在列表上显示出来
/// </summary>
/// <param name="selectUser"></param>
public void showDepartment(string projectId)
{
try
{
//获取到部门ID
mProjects = bProjects.GetModel(int.Parse(projectId));
//通过方法 用逗号把部门ID分开
string strdepartmentId = commonId.makeSqlIn(mProjects.DepartmentID, ',');
//查询出部门中status =1 并且delflag=0 的用户
string sql = "SELECT * FROM vProject_UserList WHERE (DELFLAG = '0') and status='1'and ProjectID='" + projectId + "' ORDER BY DepartMentID";
DataTable dt1 = pagedosql.doSql(sql).Tables[0];
if (dt1.Rows.Count > 0)
{
Label_tongji.Text = "此项目中共有参与人员 " + dt1.Rows.Count.ToString() + " 人";
}
else
{
Label_tongji.Text = "此项目中没有参与人员";
}
//通过部门ID 查看部门里有多少人员
string[] strdepartmentId_arr = mProjects.DepartmentID.Split(',');
string strsql = "";
for (int i = 0; i < strdepartmentId_arr.Length; i++)
{
if (strsql == "")
{
strsql = "select id,realName,userName,'" + strdepartmentId_arr[i] + "' departmentid from USER_Users where departmentid like '%" + strdepartmentId_arr[i] + "%'";
}
else
{
strsql += " union select id,realName,userName,'" + strdepartmentId_arr[i] + "'departmentid from USER_Users where departmentid like '%" + strdepartmentId_arr[i] + "%'";
}
}
//string strsql = "select id,realName,userName,departmentid from USER_Users where departmentid in " + strdepartmentId;
DataTable dt = pagedosql.doSql(strsql).Tables[0];
Session["temp_UserAllUser_session"] = dt;
Session["temp_SelectUser_session"] = dt1;
//查询出传进来的部门ID
DataTable dt2 = new DataTable();
dt2 = bug.GetList(" TAGS='部门' and DELFLAG='0' and id in " + strdepartmentId + " order by ISMOREN").Tables[0];
if (dt.Rows.Count > 0)
{
GridView_grouplist.DataSource = dt2;
GridView_grouplist.DataBind();
GridView_grouplist.Visible = true;
}
else
{
GridView_grouplist.Visible = false;
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
showDepartment(Session["Work_ProjectId"].ToString());
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);
BindData(pageindex_int);
//设置模板页中的管理值
(Master.FindControl("Label_navigation") as Label).Text = "项目 > 我的项目 > 人员分配";
//设置模板页中的管理值
CheckboxShowUser.Visible = false;
DDL_COLUMN.Visible = false;
Tr_3.Visible = false;
ShowUser.Visible = true;
mUser = (Model.USER_Users)Session["USER_Users"]; //实例化
mProjects = bProjects.GetModel(int.Parse(Session["Work_ProjectId"].ToString())); //得到项目ID
if (mUser.ID == mProjects.LeaderID || mUser.ID == mProjects.SendUserID.ToString())
{
Button1.Visible = true;
Button2.Visible = true;
if (mUser.ID == mProjects.SendUserID.ToString())
{
Button3.Visible = true;
}
else
{
Button3.Visible = false;
}
}
else
{
Button1.Visible = false;
Button2.Visible = false;
Button3.Visible = false;
}
//项目状态
bool Project_Status = BProject_Status.ProjectStatus(Session["Work_ProjectId"].ToString());
//根据项目状态设置页面按钮状态
if (Project_Status == false)
{
Button1.Enabled = Project_Status;
Button2.Enabled = Project_Status;
Button3.Enabled = Project_Status;
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// 点击确定触发事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_onclick(object sender, EventArgs e)
{
try
{
//项目ID
string projectid = Request["ID"];
project_model = project_bll.GetModel(int.Parse(projectid.ToString()));
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
string checkvalue = RadioButtonList_Check.SelectedValue.ToString();
string flag = "";
string urls = ""; //接受审核通过和不通过的地址：审核通过，到项目文档中，审核不通过到只做提示
if (checkvalue.Equals("1")) //表示审核通过
{
flag = "审核通过";
//预算表单的审核状态
project_model.TEMP1 = "1";
//如果审核通过将上传的预算表单保存到项目的目录中
string sql = "SELECT ID FROM Document_Folder WHERE (ProjectID = '" + projectid + "') AND (UpID = 38) and delflag='0'";
DataTable dt = pageControl.doSql(sql).Tables[0];
if (dt.Rows.Count > 0)
{
string id = dt.Rows[0]["ID"].ToString();
//如果审核通过将上传的预算表单保存到项目的目录中
if (null != project_model.BudgetList && !(project_model.BudgetList.ToString().Equals("")))
{
setAttachmentsToDocument(user_model.ID, id, project_model.BudgetList.ToString());
}
}
//选择资金卡
DataSet ds1 = cashmessage_bll.GetList(" ProjectID = " + project_model.ID);
DataSet ds2 = card_bll.GetList(" ProjectID = " + project_model.ID);
if (RB_CashCardID.Checked == true)//如果选择的是资金卡则设为资金卡的ID；
{
//如果在资金卡中以前本身就有该项目的。。则要将原来的该项目的资金卡的项目ID设空
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
Model.Cash_Cards card_model1 = new Dianda.Model.Cash_Cards();
BLL.Cash_Cards card_bll1 = new Dianda.BLL.Cash_Cards();
string id = ds2.Tables[0].Rows[i]["ID"].ToString();
card_model1 = card_bll1.GetModel(int.Parse(id));
card_model1.ProjectID = null;
card_bll1.Update(card_model1);
}
}
//资金卡ID
string cashcardid = DDL_CashCardID.SelectedValue.ToString();
card_model = card_bll.GetModel(int.Parse(cashcardid));
//将资金卡表中的项目ID改成当前项目
card_model.ProjectID = int.Parse(projectid);
card_bll.Update(card_model);
}
else//如果选择的是新建资金卡则设为0,并且需要向cash_message表中加一条记录
{
project_model.CashCardID = 0;
//如果原来就有记录,则修改
if (ds1.Tables[0].Rows.Count > 0)
{
//ID
string cashid = ds1.Tables[0].Rows[0]["ID"].ToString();
cashmessage_model = cashmessage_bll.GetModel(int.Parse(cashid));
//资金卡初始金额
cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text);
//新建备注说明
cashmessage_model.Notes = TB_Notes.Text.ToString();
cashmessage_bll.Update(cashmessage_model);
}
else
{
//资金卡名称(暂时写的留空)
cashmessage_model.CardName = "";
//持卡人
cashmessage_model.CardholderID = project_model.SendUserID.ToString();
//项目的ID
cashmessage_model.ProjectID = project_model.ID;
//初始金额
cashmessage_model.LimitNums = Convert.ToDecimal(TB_LimitNums.Text.ToString());
//填写的时间
cashmessage_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString());
//发出这个消息的用户的ID
cashmessage_model.SendUserID = user_model.ID;
//备注说明
cashmessage_model.Notes = TB_Notes.Text.ToString();
//是否已经阅读
cashmessage_model.IsRead = 0;
//消息的状态
cashmessage_model.Status = 1;
Session["Cash_Message_temps"] = cashmessage_model;
//向信息表中添加一条新建资金卡的记录
cashmessage_bll.Add(cashmessage_model);
}
}
BLL.Document_Folder bllFolder = new Dianda.BLL.Document_Folder();
List <Model.Document_Folder> folderlist = bllFolder.GetModelList("UpID='38' and Types='public' and ProjectID='" + projectid + "' and delflag='0'");
if (folderlist.Count > 0)
{
urls = "<a href='/Admin/DocumentManage/manage.aspx?CID=" + folderlist[0].COLUMNSPATH.ToString() + "&tp=1' target='_self' title='预算表单审核：审核时间" + DateTime.Now.ToString() + "'>" + project_model.NAMES.ToString() + " 预算表单 " + flag + "</a>";
}
else
{
urls = project_model.NAMES.ToString() + " 预算表单 " + flag;
}
}
else
{
flag = "审核不通过";
//预算表单的审核状态
project_model.TEMP1 = "2";
urls = project_model.NAMES.ToString() + " 预算表单 " + flag;
}
project_bll.Update(project_model);
//给业务申请者发信息
Model.FaceShowMessage mFaceShowMessage = new Dianda.Model.FaceShowMessage();
BLL.FaceShowMessage bFaceShowMessage = new Dianda.BLL.FaceShowMessage();
mFaceShowMessage.DATETIME = DateTime.Now;
mFaceShowMessage.FromTable = "申请情况";
mFaceShowMessage.IsRead = 0;
mFaceShowMessage.NewsID = null;
mFaceShowMessage.NewsType = "申请情况";
mFaceShowMessage.ReadTime = null;
mFaceShowMessage.DELFLAG = 0;
mFaceShowMessage.ProjectID = project_model.ID;
mFaceShowMessage.Receive = project_model.SendUserID.ToString();//当前项目的创建人的ID
mFaceShowMessage.URLS = urls;
//mFaceShowMessage.URLS = "<a href='/Admin/budgetManage/manage.aspx?role=manager&Status=" + project_model.TEMP1 + "' target='_self' title='预算表单审核：审核时间" + DateTime.Now.ToString() + "'>" + project_model.NAMES.ToString() + " 预算表单 " + flag + "</a>";
bFaceShowMessage.Add(mFaceShowMessage);
//给业务申请者发信息
ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功！现在进入列表页面');javascript:location='manage.aspx?pageindex=" + Request["pageindex"] + "&Status=" + Request["Status"] + "&role=manager';</script>", false);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "预算管理", project_model.NAMES + " 预约表单" + flag);
//添加操作日志
}
catch
{
}
}
