/// <summary>
/// 构造查询条件
/// </summary>
/// <returns></returns>
protected string SQLCondition()
{
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" 1=1 ");
sbSql.Append(" and IsRead=" + common.SafeString(this.ddlIsRead.SelectedValue));
//sbSql.Append("ORDER BY ID ");
return(sbSql.ToString());
}
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request["ID"] != null)
{
apply_model = apply_bll.GetModel(int.Parse(com.SafeString(Request["ID"])));
if (apply_model.Status != 0)
{
ListItem ls = new ListItem();
ls.Value = "2";
ls.Text = "已撤销";
RadioButtonList_Check.Items.Add(ls);
Button_sumbit.Visible = true;
}
}
//业务申请ID
string ID = Request["ID"];
ShowApplyInfo(ID);
//设置模板页中的管理值
(Master.FindControl("Label_navigation") as Label).Text = "管理 > 会议室管理 > 会议室审批 ";
//设置模板页中的管理值
}
}
protected void Read_Data(string _id)
{
try
{
DataTable dt = new DataTable();
string strSQL = "Select * From vCash_Cards Where id=" + common.SafeString(_id);
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
lblCardName.Text = "《" + dt.Rows[0]["CardName"].ToString() + "》的资金卡信息";
lblCardNum.Text = dt.Rows[0]["CardNum"].ToString();
lblCardholderRealName.Text = dt.Rows[0]["CardholderRealName"].ToString();
lblDepartmentName.Text = dt.Rows[0]["DepartmentName"].ToString();
if (null != dt.Rows[0]["ProjectName"] && !dt.Rows[0]["ProjectName"].ToString().Equals(""))
{
lblProjectName.Text = dt.Rows[0]["ProjectName"].ToString();
}
else
{
lblProjectName.Text = "暂无所属项目";
}
lblLimitNums.Text = dt.Rows[0]["LimitNums"].ToString();
lblApproverRealName.Text = dt.Rows[0]["ApproverRealName"].ToString();
lblStatas.Text = dt.Rows[0]["Statas"].ToString();
Label_Time.Text = string.IsNullOrEmpty(dt.Rows[0]["EndTime"].ToString()) ? "" : DateTime.Parse(dt.Rows[0]["EndTime"].ToString()).ToLongDateString();
//所属专项资金
LB_SpecialFundsName.Text = dt.Rows[0]["SpecialFundsName"].ToString();
//所属预算报告
LB_SFOrderName.Text = "<a href='" + dt.Rows[0]["BudgetList"].ToString() + "' target='_blank'>" + dt.Rows[0]["SFOrderName"].ToString() + "</a>";
}
}
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='" + common.SafeString(projectid) + "' and statas='" + common.SafeString(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 ImageButton_login_Click(object sender, ImageClickEventArgs e)
{
try
{
Session["isDepartment"] = "个人";
string TextBox_username_1 = TextBox_username.Text.ToString();
string TextBox_pwd_1 = TextBox_pwd.Text.ToString();
COMMON.common commonse = new Dianda.COMMON.common();
string username = commonse.SafeString(TextBox_username_1);
string pwd = commonse.SafeString(TextBox_pwd_1);
List <Model.USER_Users> muserlist = bUser.GetModelList(" USERNAME='******' and PASSWORD='******' and DELFLAG=0");
if (muserlist.Count > 0)
{
//说明登录成功
mUser = muserlist[0];
//设置Session["USER_Users"]中的TEMP4为用户的当前默认部门（为了在部门首页上做部门的切换使用）。
string departments = mUser.DepartMentID.ToString();
if (departments.Contains(","))
{
string[] dearray = departments.Split(',');
mUser.TEMP4 = dearray[0].ToString();
}
else
{
mUser.TEMP4 = departments;
}
Session["USER_Users"] = mUser;
Session["LoginID"] = mUser.ID.ToString();
//*************************如果登陆成功，需要获取该登陆者负责或参与的项目, modify by wangjh on 2010-11-02 begin
Web.Admin.personalProjectManage.MakeProjectSession makeprojectsession = new Dianda.Web.Admin.personalProjectManage.MakeProjectSession();
makeprojectsession.getMyProjectList(this);
// //负责的项目
// //string sql1 = " SELECT ID,NAMES FROM vProject_Projects WHERE LeaderID='" + mUser.ID + "' and DELFLAG=0 and (Status=1 or Status=3 or Status=5) ";
// string sql1 = " SELECT ID,NAMES,DELFLAG,Status FROM vProject_Projects WHERE LeaderID='" + mUser.ID + "' and (Status=1 or Status=3 or Status=5) ";
// //由于在我的项目中需要添加一个已删除的项目，所以在加载项目时也需要将删除的显示出来，故作以上修改（and DELFLAG=0 删除了）
// DataTable dt1 = pageControl.doSql(sql1).Tables[0];
// //参与的项目
//// string sql2 = " SELECT ID,NAMES FROM vProject_Projects WHERE DELFLAG=0 and id in(select Projectid from Project_UserList where userid='" + mUser.ID + "' and status='1') ";
// string sql2 = " SELECT ID,NAMES,DELFLAG,Status FROM vProject_Projects WHERE id in(select Projectid from Project_UserList where userid='" + mUser.ID + "' and status='1') ";
// //由于在我的项目中需要添加一个已删除的项目，所以在加载项目时也需要将删除的显示出来，故作以上修改（DELFLAG=0 and 删除了）
// DataTable dt2 = pageControl.doSql(sql2).Tables[0];
// //合并两个相同结构的DATATABLE
// DataTable Newdt = common.CombineTheSameDatatable(dt1,dt2);
// //将一个DATATABLE中的重复项去除掉
// if (null != Newdt)
// {
// Newdt = common.makeDistinceTable(Newdt, "ID");
// Session["Project_Projects"] = Newdt;
// }
//*************************如果登陆成功，需要获取该登陆者负责或参与的项目, modify by wangjh on 2010-11-02 end
//写日志
BLL.SYS_LogsExt bslog = new Dianda.BLL.SYS_LogsExt();
bslog.addlogs(mUser.REALNAME.ToString() + "(" + mUser.USERNAME.ToString() + ")", "登录系统", "登录系统:成功");
//写日志
//根据用户的用户组来生成用户的权限数据
///构造用户的全部权限
DataTable sessionData = sessionPower(mUser.ID.ToString());
string[] arrays = getPowerSession(sessionData, mUser.ID.ToString());
mUserPower.specialRole = arrays[3].ToString();
mUserPower.buttomID = arrays[2].ToString();
mUserPower.menuRole = arrays[1].ToString();
mUserPower.pageurl = arrays[0].ToString();
mUserPower.userid = mUser.ID.ToString();
mUserPower.isYinLeader = arrays[4].ToString(); //"0";//表示该用户是用印管理的领导（根据特定的权限点来判断该用户是否是领导）
Session["Session_Power"] = mUserPower;
//付全文 2013-4-16 消息权限
string strSql = "select roles from user_role where name='消息-取消通知公告' and Types='菜单权限' and delflag =0";
DataTable dt = pageControl.doSql(strSql).Tables[0];
string roles = null;
foreach (DataRow row in dt.Rows)
{
roles = row["roles"].ToString();
}
Session["Session_Role"] = roles;
///构造用户的全部权限
string url = "/Admin/person_Index.aspx";
string coutws = "<script language=\"javascript\" type=\"text/javascript\">location.href='" + url + "';</script>";
Response.Write(coutws);
}
else
{
//登录失败
Session["USER_Users"] = "";
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"登录失败，请核实您的用户名和密码\");location.href='login.aspx';</script>";
Response.Write(coutws);
}
}
catch
{
//登录失败
Session["USER_Users"] = "";
string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"登录失败，请核实您的用户名和密码\");location.href='login.aspx';</script>";
Response.Write(coutws);
}
}
/// <summary>
/// 构造查询条件
/// </summary>
/// <returns></returns>
protected string SQLCondition_tag(string types, string condition)
{
//1-全部、2-审批提醒、3-项目任务、4-共享文档、5-申请反馈、
//6-通知公告、7-个人消息、8-项目消息、9-部门消息、10-历史消息
//放入回收站
//Image del_image = (Image)GridView1.Rows[].Cells[].FindControl("del_image");
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" 1=1 ");
string strNewsType = types;
if (strNewsType == "1")
{
//1-全部
sbSql.Append(" ");
mUserPower = (Model.userPower)Session["Session_Power"];
if (mUserPower.specialRole.Contains("or"))
{
sbSql.Append(" and (" + mUserPower.specialRole.ToString() + " or Receive='" + ((Model.USER_Users)Session["USER_Users"]).ID + "') ");
}
else
{
sbSql.Append(" AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
}
// searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "2")
{
//2-审批提醒
mUserPower = (Model.userPower)Session["Session_Power"];
if (mUserPower.specialRole.Contains("or"))
{
sbSql.Append(" and " + mUserPower.specialRole.ToString() + "");
}
else
{
sbSql.Append(" and IsRead='3'");
}
//searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "3")
{
//3-项目任务
sbSql.Append("and NewsType='项目任务' AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
// searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "4")
{
//4-共享文档
sbSql.Append(" and NewsType='共享文档' AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
// searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "5")
{
//5-申请反馈、
sbSql.Append(" and (NewsType='申请情况' or NewsType='项目审核' or NewsType='经费预约反馈') AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
// searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "6")
{
//6-通知公告、
sbSql.Append("and NewsType='通知公告' AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
// searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "789")
{
//7-个人消息、
sbSql.Append(" and (NewsType='个人消息' or NewsType='项目消息' or NewsType='部门消息') AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
// searchrtable.Visible = false;//搜索的功能不显示
}
if (strNewsType == "10")
{
//10-历史消息、
sbSql.Append(" ");
mUserPower = (Model.userPower)Session["Session_Power"];
if (Session["starttime_session"] == null)//没有搜索条件时
{
if (mUserPower.specialRole.Contains("or"))
{
sbSql.Append(" and (" + mUserPower.specialRole.ToString() + " or Receive='" + ((Model.USER_Users)Session["USER_Users"]).ID + "') ");
}
else
{
sbSql.Append(" AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "'");
}
}
//else//有搜索条件时
//{
// DateTime starttimes = DateTime.Parse(Session["starttime_session"].ToString());
// DateTime endtimes = DateTime.Parse(Session["endtime_session"].ToString()).AddDays(1);
// if (mUserPower.specialRole.Contains("or"))
// {
// sbSql.Append(" and (" + mUserPower.specialRole.ToString() + " or Receive='" + ((Model.USER_Users)Session["USER_Users"]).ID + "') and DATETIME>='" + starttimes + "' and DATETIME<='" + endtimes + "'");
// }
// else
// {
// sbSql.Append(" AND Receive ='" + ((Model.USER_Users)Session["USER_Users"]).ID + "' and DATETIME>='" + starttimes + "' and DATETIME<='" + endtimes + "'");
// }
//}
}
if (Session["starttime_session"] != null && DropDownList1.SelectedValue != "time")//有搜索条件时
{
DateTime starttimes = DateTime.Parse(Session["starttime_session"].ToString());
DateTime endtimes = DateTime.Parse(Session["endtime_session"].ToString()).AddDays(1);
COMMON.common com = new Dianda.COMMON.common();
sbSql.Append("and DATETIME>='" + starttimes + "' and DATETIME<='" + endtimes + "'" + "and URLS like '%" + com.SafeString(Keyword.Text) + "%'");
sbSql.Append("and DELFLAG=1");//现在搜索的都是放入回收站的消息
}
else
{
sbSql.Append("and DELFLAG=0");
}
if (!string.IsNullOrEmpty(condition))
{
sbSql.Append(" and NewsType <> '" + condition + "'");
}
return(sbSql.ToString());
}
