protected void ShowInitInfo(string ID)
{
try
{
string sql = " SELECT * FROM vBudget_Todo_List WHERE id='" + 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]["BudgetName"].ToString();
//项目负责人
//LB_Managers.Text = DT.Rows[0]["ManagerIds"].ToString();
//审批人
LB_Approver.Text = DT.Rows[0]["Approver"].ToString();
//预算经费编号
LB_BudgetCode.Text = DT.Rows[0]["Code"].ToString();
//预算经费
LB_LimitNumbers.Text = DT.Rows[0]["Balance"].ToString();
//总余额
LB_YEBalance.Text = DT.Rows[0]["KYBalance"].ToString();
//预算开始时间
LB_StartTime.Text = DT.Rows[0]["StartTime"].ToString();
//预算结束时间
LB_EndTime.Text = DT.Rows[0]["EndTime"].ToString();
//项目负责人
LB_Managers.Text = userExt.GetUserRealNamesByIds(DT.Rows[0]["ManagerIds"].ToString(), ',');
//所属部门
LB_Department.Text = userGroupExt.GetGroupNamesByIds(DT.Rows[0]["DepartmentIds"].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 (Exception e)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
string urls = Request.Url.AbsoluteUri.ToString();
if (urls.Contains("isshownews=1"))
{
if (!IsPostBack)
{
string id = Request["id"].ToString();
if (String.IsNullOrEmpty(id))
{
this.Label_NAME.Text = "信息已经被删除！";
return;
}
DataTable dt = new DataTable();
string strSQL = "Select ID From News_News WHERE DELFLAG=0 and ID=" + id;
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count < 1)
{
this.Label_NAME.Text = "信息已经被删除！";
return;
}
BindData(id);
UpdateData(id);
}
}
else
{
urls = urls + "&isshownews=1";
Response.Redirect(urls);
}
}
protected void Read_Data(string _id)
{
try
{
DataTable dt = new DataTable();
string strSQL = "Select * From vBudget_Todo_List Where id=" + common.SafeString(_id);
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
lblBudgetName.Text = "《" + dt.Rows[0]["BudgetName"].ToString() + "》的预算经费信息";
lblBudgetCode.Text = dt.Rows[0]["Code"].ToString();
lblApprover.Text = dt.Rows[0]["Approver"].ToString();
lblBalance.Text = dt.Rows[0]["Balance"].ToString();
lblManager.Text = userExt.GetUserRealNamesByIds(dt.Rows[0]["ManagerIds"].ToString(), ',');
lblDepartment.Text = userGroupExt.GetGroupNamesByIds(dt.Rows[0]["DepartmentIds"].ToString());
string startTime = string.IsNullOrEmpty(dt.Rows[0]["StartTime"].ToString()) ? "" : DateTime.Parse(dt.Rows[0]["StartTime"].ToString()).ToLongDateString();
string endTime = string.IsNullOrEmpty(dt.Rows[0]["EndTime"].ToString()) ? "" : DateTime.Parse(dt.Rows[0]["EndTime"].ToString()).ToLongDateString();
lblStartEndDate.Text = string.Format("{0} - {1}", startTime, endTime);
}
}
catch
{
}
}
protected void ShowInitInfo(string ID)
{
try
{
string sql = " SELECT * FROM vBudget_Department_List WHERE id='" + 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]["BudgetName"].ToString();
//所属项目
LB_ParentBudget.Text = DT.Rows[0]["ParentBudgetName"].ToString();
//项目负责人
LB_Managers.Text = DT.Rows[0]["ManagerIds"].ToString();
//审批人
LB_Approver.Text = DT.Rows[0]["Approver"].ToString();
//预算经费编号
LB_BudgetCode.Text = DT.Rows[0]["Code"].ToString();
//预算经费
LB_LimitNumbers.Text = DT.Rows[0]["Balance"].ToString();
//总余额
LB_YEBalance.Text = DT.Rows[0]["KYBalance"].ToString();
//预算开始时间
LB_StartTime.Text = DT.Rows[0]["StartTime"].ToString();
//预算结束时间
LB_EndTime.Text = DT.Rows[0]["EndTime"].ToString();
//项目负责人
LB_Managers.Text = userExt.GetUserRealNamesByIds(DT.Rows[0]["ManagerIds"].ToString(), ',');
//所属部门
//LB_Department.Text = userGroupExt.GetGroupNamesByIds(DT.Rows[0]["DepartmentIds"].ToString());
}
else
{
LB_MSG.Text = "暂无该预算的相关信息！";
}
}
catch (Exception e)
{
}
}
/// <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>
/// <returns></returns>
private DataTable GetDocument_File_Config()
{
DataTable dt = new DataTable();
try
{
string sql = "SELECT ID, FileType, TypeIcon, FileSize FROM Document_File_Config order by FileType";
dt = pc.doSql(sql).Tables[0];
}
catch
{
}
return(dt);
}
protected void Read_Data(string _id)
{
try
{
DataTable dt = new DataTable();
string strSQL = "Select * From vBudget_Department_List Where id=" + common.SafeString(_id);
dt = pageControl.doSql(strSQL).Tables[0];
if (dt.Rows.Count > 0)
{
lblBudgetName.Text = "《" + dt.Rows[0]["BudgetName"].ToString() + "》的预算经费信息";
lblBudgetCode.Text = dt.Rows[0]["Code"].ToString();
//lblCardholderRealName.Text = dt.Rows[0]["CardholderRealName"].ToString();
//lblDepartmentName.Text = dt.Rows[0]["DepartmentName"].ToString();
if (null != dt.Rows[0]["ParentBudgetName"] && !dt.Rows[0]["ParentBudgetName"].ToString().Equals(""))
{
lblParentBudget.Text = dt.Rows[0]["ParentBudgetName"].ToString();
}
else
{
lblParentBudget.Text = "暂无所属项目";
}
lblBalance.Text = dt.Rows[0]["Balance"].ToString();
lblManager.Text = userExt.GetUserRealNamesByIds(dt.Rows[0]["ManagerIds"].ToString(), ',');
lblDepartment.Text = userGroupExt.GetGroupNamesByIds(dt.Rows[0]["DepartmentIds"].ToString());
string startTime = string.IsNullOrEmpty(dt.Rows[0]["StartTime"].ToString()) ? "" : DateTime.Parse(dt.Rows[0]["StartTime"].ToString()).ToLongDateString();
string endTime = string.IsNullOrEmpty(dt.Rows[0]["EndTime"].ToString()) ? "" : DateTime.Parse(dt.Rows[0]["EndTime"].ToString()).ToLongDateString();
lblStartEndDate.Text = string.Format("{0} - {1}", startTime, endTime);
//所属专项资金
//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>
private void setRowCout()
{
try
{
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
DataTable DT = new DataTable();
string sql = "select * from vBudget_Child_List where CHARINDEX('{0}', ManagerIDs)> 0 or CHARINDEX('{1}', ParentManagerIDs)> 0";
sql = string.Format(sql, user_model.ID, 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>
/// <param name="groupname"></param>
protected void BindData()
{
try
{
// string sql = "SELECT DepartMentID,DepartName FROM vUSER_Users WHERE DELFLAG=0 and DepartMentID='" + mUSER_Users.DepartMentID + "' Group By DepartMentID,DepartName";
string strSQL = "SELECT * FROM News_Columns WHERE " + SQLCondition();
DataTable dt = new DataTable();
dt = pageControl.doSql(strSQL).Tables[0];
//string sql = "";
//if (groupname.Equals("部门"))
//{
// sql = "SELECT * FROM vUser_Groups_DepartMent ";//vUser_Groups_DepartMent为视图
//}
//else if (groupname.Equals("岗位"))
//{
// sql = "SELECT * FROM vUser_Groups_Station ";//vUser_Groups_Station为视图
//}
//dt = PageControl.doSql(sql).Tables[0];
/** 以下做的目的是显示同部门或同岗位的人员合并信息*/
//DataTable Newdt = dt;
//if (null != dt)
//{
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// //部门或岗位的ID
// string ID1 = dt.Rows[i]["ID"].ToString();
// //人员名称
// string NAME1 = dt.Rows[i]["REALNAME"].ToString();
// //人员ID
// string UserID1 = dt.Rows[i]["userid"].ToString();
// //删除标记
// string delflag1 = dt.Rows[i]["delflag"].ToString();
// //该部门或是该岗位的人数
// int menbernum = 0;
// if (!NAME1.Equals(""))
// {
// menbernum = 1;
// dt.Rows[i]["REALNAME"] = "<a href='show.aspx?userid=" + UserID1 + "' target='_self' rel='gb_page_center[726,400]'>" + dt.Rows[i]["REALNAME"] + "</a>";
// }
// if (delflag1.Equals("0"))
// {
// for (int j = 0; j < Newdt.Rows.Count; j++)
// {
// //自己不需要和本条记录对比
// if (i != j)
// {
// //部门或岗位的ID
// string ID2 = Newdt.Rows[j]["ID"].ToString();
// //删除标记
// string delflag2 = Newdt.Rows[j]["delflag"].ToString();
// if (delflag2.Equals("0"))
// {
// //如果部门或岗位相同,则将这二条记录的人员合在一条中
// if (ID2.Equals(ID1))
// {
// //人员名称
// string NAME2 = Newdt.Rows[j]["REALNAME"].ToString();
// //人员ID
// string UserID2 = Newdt.Rows[j]["userid"].ToString();
// if (NAME1.Equals(""))
// {
// dt.Rows[i]["REALNAME"] = dt.Rows[i]["REALNAME"] + "<a href='show.aspx?userid=" + UserID2 + "' target='_self' rel='gb_page_center[726,400]'>" + NAME2 + "</a>";
// }
// else
// {
// dt.Rows[i]["REALNAME"] = dt.Rows[i]["REALNAME"] + "；" + "<a href='show.aspx?userid=" + UserID2 + "' target='_self' rel='gb_page_center[726,400]'>" + NAME2 + "</a>";
// }
// dt.Rows[j]["delflag"] = "1";
// Newdt.Rows[j]["delflag"] = "1";
// menbernum = menbernum + 1;
// }
// }
// }
// }
// //借用dt中的"ISMOREN"来装一下该部门的人员数
// dt.Rows[i]["ISMOREN"] = menbernum;
// }
// }
//}
/** 以上做的目的是显示同部门或同岗位的人员合并信息*/
DataView dv = dt.DefaultView;
dv.RowFilter = "delflag='0'";
if (dv.Count > 0)
{
//当获取到的数据集不为空的时候，显示在GridView1中
GridView1.Visible = true;
GridView1.DataSource = dv; //指定GridView1的数据是dv
GridView1.DataBind(); //将上面指定的信息绑定到GridView1上
notice.Text = "";
}
else
{
GridView1.Visible = false;
//Button_modify.Enabled = false;
//Button_delete.Enabled = false;
notice.Text = "*没有符合条件的结果！";
}
}
catch
{
}
}
