private void BindGrid8()
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
StringBuilder cmdTxt = new StringBuilder();
StringBuilder QUERYS = new StringBuilder();
cmdTxt.AppendFormat(@"
SELECT
[ID]
,[KINDS]
,[NAMES]
,[MOQS]
,[INDAYS]
,[COMMENTS]
FROM [TKBUSINESS].[dbo].[TBPURMOQ]
WHERE [KINDS]=@KINDS
ORDER BY [ID]
");
m_db.AddParameter("@KINDS", "鐵盒");
//m_db.AddParameter("@EDATE", EDATE);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt.ToString()));
Grid8.DataSource = dt;
Grid8.DataBind();
}
protected void TriggerBox1_TriggerClick(object sender, EventArgs e)
{
//填充grid
DataSet ds = bll.查询部门();
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid8.DataSource = source;//DataTable
Grid8.DataBind();
Window5.Hidden = false;
}
private void BindGrid8(string SDATE, string EDATE)
{
string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @"
SELECT ORDERS,USER_ID,USER_NAME,USER_ACCOUNT,SALES,COMS,NOTES,CONVERT(decimal(16,2),(CONVERT(decimal(16,2),COMS)/CONVERT(decimal(16,2),SALES))*100) AS 'PCTS'
FROM (
SELECT [ORDERS],[USER_ID],[USER_NAME],[USER_ACCOUNT]
,(SELECT COUNT(DISTINCT [COMPANY_ID]) FROM [HJ_BM_DB].[dbo].[tb_COMPANY] WHERE [STATUS]='1' AND [OWNER_ID]=[USER_ID]) AS 'SALES'
,(SELECT COUNT(DISTINCT [tb_NOTE].[COMPANY_ID]) FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_COMPANY] WHERE [STATUS]='1' AND [tb_NOTE].COMPANY_ID=[tb_COMPANY].COMPANY_ID AND [OWNER_ID]=[USER_ID] AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE) AS 'COMS'
,(SELECT COUNT([tb_NOTE].[COMPANY_ID]) FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_COMPANY] WHERE [STATUS]='1' AND [tb_NOTE].COMPANY_ID=[tb_COMPANY].COMPANY_ID AND [OWNER_ID]=[USER_ID] AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE) AS 'NOTES'
FROM [HJ_BM_DB].[dbo].[COPSALES]
) AS TEMP
ORDER BY [ORDERS]
";
//DateTime SD = Convert.ToDateTime(SDATE);
//SD = SD.AddDays(7);
//DateTime ED = Convert.ToDateTime(EDATE);
//ED = ED.AddDays(7);
DateTime FirstDay = DateTime.Now.AddDays(-DateTime.Now.Day + 1);
DateTime LastDay = DateTime.Now.AddMonths(1).AddDays(-DateTime.Now.AddMonths(1).Day);
string SSDATE = FirstDay.ToString("yyyy/MM/dd");
string EEDATE = LastDay.ToString("yyyy/MM/dd");
m_db.AddParameter("@SDATE", SSDATE);
m_db.AddParameter("@EDATE", EEDATE);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt));
Grid8.DataSource = dt;
Grid8.DataBind();
}
private void LoadPayrollDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrievePayrollDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[2].Rows.Count > 0) // Current Month Payroll data/Status
{
DataTable _DataTable = _DataList.Tables[2];
Grid8.DataSource = _DataTable;
Grid8.DataBind();
}
else
{
Grid8.DataSource = null;
Grid8.DataBind();
}
if (_DataList.Tables[3].Rows.Count > 0) // Historical data for payroll
{
DataTable _DataTable = _DataList.Tables[3];
Grid9.DataSource = _DataTable;
Grid9.DataBind();
}
else
{
Grid9.DataSource = null;
Grid9.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}
protected void gridCallBack_Callback(object sender, CallBackEventArgs e)
{
hfMessage.Value = "";
int n = OrgList.SelectedIndex;
try
{
if (e.Parameters[0] != "")
{
if (e.Parameters[1] == "Up")
{
UpData(e.Parameters[0]);
}
else if (e.Parameters[1] == "Down")
{
DownData(e.Parameters[0]);
}
else
{
DeleteData(e.Parameters[0]);
}
}
else if (e.Parameters[0] == "")
{
BindGrid(n);
}
if (n == 0)
{
Grid1.RenderControl(e.Output);
}
else if (n == 1)
{
Grid2.RenderControl(e.Output);
}
else if (n == 2)
{
Grid3.RenderControl(e.Output);
}
else if (n == 3)
{
Grid4.RenderControl(e.Output);
}
else if (n == 4)
{
Grid5.RenderControl(e.Output);
}
else if (n == 5)
{
Grid6.RenderControl(e.Output);
}
else if (n == 6)
{
Grid7.RenderControl(e.Output);
}
else if (n == 7)
{
Grid8.RenderControl(e.Output);
}
else if (n == 8)
{
Grid9.RenderControl(e.Output);
}
else if (n == 9)
{
Grid10.RenderControl(e.Output);
}
else if (n == 10)
{
Grid11.RenderControl(e.Output);
}
else if (n == 11)
{
Grid12.RenderControl(e.Output);
}
else if (n == 12)
{
Grid13.RenderControl(e.Output);
}
else if (n == 13)
{
Grid14.RenderControl(e.Output);
}
}
catch
{
BindGrid(n);
}
hfMessage.RenderControl(e.Output);
}
private void BindGrid(int n)
{
if (n == 0)
{
EducationLevelBLL objBLL = new EducationLevelBLL();
IList <EducationLevel> objList = objBLL.GetAllEducationLevel();
Grid1.DataSource = objList;
Grid1.DataBind();
Grid1.Visible = true;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 1)
{
PoliticalStatusBLL objBLL = new PoliticalStatusBLL();
IList <PoliticalStatus> objList = objBLL.GetAllPoliticalStatus();
Grid2.DataSource = objList;
Grid2.DataBind();
Grid1.Visible = false;
Grid2.Visible = true;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 2)
{
WorkGroupLeaderLevelBLL objBLL = new WorkGroupLeaderLevelBLL();
IList <WorkGroupLeaderLevel> objList = objBLL.GetAllWorkGroupLeaderLevel();
Grid3.DataSource = objList;
Grid3.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = true;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 3)
{
TechnicianTypeBLL objBLL = new TechnicianTypeBLL();
IList <TechnicianType> objList = objBLL.GetAllTechnicianType();
Grid4.DataSource = objList;
Grid4.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = true;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 4)
{
TechnicianTitleTypeBLL objBLL = new TechnicianTitleTypeBLL();
IList <TechnicianTitleType> objList = objBLL.GetAllTechnicianTitleType();
Grid5.DataSource = objList;
Grid5.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = true;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 5)
{
EducationEmployeeTypeBLL objBLL = new EducationEmployeeTypeBLL();
IList <EducationEmployeeType> objList = objBLL.GetAllEducationEmployeeType();
Grid6.DataSource = objList;
Grid6.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = true;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 6)
{
CommitteeHeadShipBLL objBLL = new CommitteeHeadShipBLL();
IList <CommitteeHeadShip> objList = objBLL.GetAllCommitteeHeadShip();
Grid7.DataSource = objList;
Grid7.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = true;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 7)
{
RandomExamModularTypeBLL objBLL = new RandomExamModularTypeBLL();
IList <RandomExamModularType> objList = objBLL.GetAllRandomExamModularType();
Grid8.DataSource = objList;
Grid8.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = true;
Grid9.Visible = false;
}
if (n == 8)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_trainplan_type order by trainplan_type_id").Tables[0];
Grid9.DataSource = dt;
Grid9.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = true;
}
if (n == 9)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_safe_level order by order_index").Tables[0];
Grid10.DataSource = dt;
Grid10.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = true;
}
if (n == 10)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_certificate order by order_index").Tables[0];
Grid11.DataSource = dt;
Grid11.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = true;
}
if (n == 11)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(@"select a.*,b.certificate_name from zj_certificate_level a
left join zj_certificate b on a.certificate_id=b.certificate_id order by a.order_index").Tables[0];
Grid12.DataSource = dt;
Grid12.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = true;
}
if (n == 12)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(" select * from zj_certificate_unit order by order_index").Tables[0];
Grid13.DataSource = dt;
Grid13.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = false;
Grid13.Visible = true;
}
if (n == 13)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(" select * from zj_train_unit order by order_index").Tables[0];
Grid14.DataSource = dt;
Grid14.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = false;
Grid13.Visible = false;
Grid14.Visible = true;
}
}
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Action1")
{
OffSession();
string username = Session["姓名"].ToString();
object[] keys = Grid1.DataKeys[e.RowIndex];
string 职务 = Session["职务"].ToString();
int ID = Convert.ToInt32(keys[0].ToString());//获取ID
FlowID.Text = ID.ToString();
School申报审批BLL sbspbll = new School申报审批BLL();
string xa = "";
string SID = keys[1].ToString(); //获取SID
资产ID.Text = SID;
string Mark = keys[5].ToString(); //获取FlowName
FlowName.Text = Mark;
Sort.Text = keys[2].ToString();
#region 报废判断
if (Mark == "资产处置-报废")
{
int sort = Convert.ToInt32(keys[2]);
Sort.Text = sort.ToString();
if (sort == 2)
{
//Button14.Hidden = true;
//Button6.Hidden = false;
}
else
{
Button2.Hidden = true;
}
if (keys[11] == null)
{
原因说明_bfckxq.Text = "";
}
else
{
原因说明_bfckxq.Text = keys[11].ToString();
}
分管领导_bfckxq.Text = keys[25].ToString();
分管领导处理意见_bfckxq.Text = keys[24].ToString();
分管领导操作时间_bfckxq.Text = keys[26].ToString();
电话_bfckxq.Text = keys[13].ToString();
职务_bfckxq.Text = keys[13].ToString();
事项名称_bfckxq.Text = keys[17].ToString();
主管部门_bfckxq.Text = keys[29].ToString();
主管部门处理意见_bfckxq.Text = keys[27].ToString();
主管部门操作时间_bfckxq.Text = keys[28].ToString();
财政部门意见_bfckxq.Text = keys[30].ToString();
财政部门_bfckxq.Text = keys[31].ToString();
财政部门操作时间_bfckxq.Text = keys[32].ToString();
if (职务 == "分管领导" && sort == 1)
{
Button15.Hidden = false;
}
else if (职务 == "主管部门" && sort == 2)
{
Button15.Hidden = false;
}
else if (职务 == "财务人员" && sort == 3)
{
Button15.Hidden = false;
}
else if (sort == 0)
{
Button15.Hidden = true;
}
else
{
Button15.Hidden = false;
}
流程状态_abfckxq.Text = keys[3].ToString();
单据编号_bfckxq.Text = keys[4].ToString();
float 总数 = 0.0f;
float 总价 = 0.0f;
总数 = float.Parse(keys[6].ToString());
总价 = float.Parse(keys[7].ToString());
申报日期_ckxq.Text = keys[8].ToString();
申报单位_bfckxq.Text = keys[9].ToString();
申请人_bfckxq.Text = keys[10].ToString();
List <School办公设备信息表> listdata = bll.处置申报查询(SID, keys[5].ToString());
Grid7.DataSource = listdata;
Grid7.DataBind();
Grid8.DataSource = listdata;
Grid8.DataBind();
JObject summary = new JObject();
summary.Add("major", "全部合计");
summary.Add("数量_bfckxq", 总数.ToString("F2"));
summary.Add("价格_bfckxq", 总价.ToString("F2"));
Grid7.SummaryData = summary;
Grid8.SummaryData = summary;
Window4.Hidden = false;
string zcid = keys[1].ToString();
资产ID.Text = zcid;
}
#endregion
#region 调拨
else if (Mark == "资产处置-调拨")
{
/*
* ID（0）,SID（1）,Sort（2）,流程状态（3）,单据编号（4）,FlowName（5）,总数（6）,总价（7）,申报日期（8）,申报单位（9）,申请人（10）
* ,原因说明（11）,职务（12）,电话（13）,验收日期（14）,调入单位（15）,调出单位（16）,事项名称（17）
* ,调出单位分管领导意见（18）,调出单位分管领导（19）,调出单位分管领导处理时间（20）,调入单位管理员意见（21）,调入单位管理员（22）
* ,调入单位管理员处理时间（23）,调入单位分管领导意见（24）,调入单位分管领导（25）,调入单位分管领导处理时间（26）,主管部门意见（27）
* ,主管部门处理时间（28）,主管部门（29）,财政部门意见（30）,财政部门（31）,财政部门处理时间（32）
*/
Window5.Hidden = false;
int sort = Convert.ToInt32(keys[2]);
btntanchuang.Text = "处理";
btntanchuang.Enabled = false;
if (sort == 1)
{
//分管领导处理
if (职务 == "分管领导")
{
btntanchuang.Text = "分管领导处理";
btntanchuang.Enabled = true;
}
}
else if (sort == 2)
{
//资产管理员处理
if (职务 == "资产管理员")
{
btntanchuang.Text = "资产管理员处理";
btntanchuang.Enabled = true;
}
}
//调入单位分管领导
else if (sort == 3)
{
if (职务 == "分管领导")
{
btntanchuang.Text = "分管领导处理";
btntanchuang.Enabled = true;
}
}
else if (sort == 4)
{
if (职务 == "主管部门")
{
btntanchuang.Text = "主管部门处理";
btntanchuang.Enabled = true;
}
}
else if (sort == 5)
{
if (职务 == "财务人员")
{
btntanchuang.Text = "财政部门处理";
btntanchuang.Enabled = true;
}
}
else if (sort == 6)
{
//string aID = Session["ID"].ToString();
//int zcczID = Convert.ToInt32(Session["UserID"].ToString());
//string fname = sbspbll.资产处置调出单位(zcczID);
if (职务 == "资产管理员" && keys[10].ToString() == username)
{
btntanchuang.Text = "资产管理员处理";
btntanchuang.Enabled = true;
}
}
else if (sort == 7)
{
//string aID = Session["ID"].ToString();
//int zcczID = Convert.ToInt32(Session["UserID"].ToString());
//string fname = sbspbll.资产处置调入单位(zcczID);
if (职务 == "资产管理员" && keys[22].ToString() == username)
{
btntanchuang.Text = "资产管理员处理";
btntanchuang.Enabled = true;
}
}
else if (sort == 0)
{
btntanchuang.Hidden = true;
}
else
{
Button2.Hidden = true;
}
/*
* ID（0）,SID（1）,Sort（2）,流程状态（3）,单据编号（4）,FlowName（5）,总数（6）,总价（7）,申报日期（8）,申报单位（9）,申请人（10）
* ,原因说明（11）,职务（12）,电话（13）,验收日期（14）,调入单位（15）,调出单位（16）,事项名称（17）
* ,调出单位分管领导意见（18）,调出单位分管领导（19）,调出单位分管领导处理时间（20）,调入单位管理员意见（21）,调入单位管理员（22）
* ,调入单位管理员处理时间（23）,调入单位分管领导意见（24）,调入单位分管领导（25）,调入单位分管领导处理时间（26）,主管部门意见（27）
* ,主管部门处理时间（28）,主管部门（29）,财政部门意见（30）,财政部门（31）,财政部门处理时间（32）
*/
流程状态_dbckxq.Text = keys[3].ToString();
单据编号_dbckxq.Text = keys[4].ToString();
int 总数 = 0;
int 总价 = 0;
总数 = Convert.ToInt32(keys[6].ToString());
总价 = Convert.ToInt32(keys[7].ToString());
申报日期_dbckxq.Text = keys[8].ToString();
申请人_dbckxq.Text = keys[10].ToString();
调拨原因说明.Text = keys[11].ToString();
职务_dbckxq.Text = keys[12].ToString();
电话_dbckxq.Text = keys[13].ToString();
验收日期_dbckxq.Text = keys[14].ToString();
调入单位_dbckxq.Text = keys[15].ToString();
调出单位_dbckxq.Text = keys[16].ToString();
事项名称_dbckxq.Text = keys[17].ToString();
调出单位分管领导意见.Text = keys[18].ToString();
调出单位分管领导.Text = keys[19].ToString();
调出单位分管领导处理时间.Text = keys[20].ToString();
调入单位管理员意见.Text = keys[21].ToString();
调入单位管理员.Text = keys[22].ToString();
调入单位管理员处理时间.Text = keys[23].ToString();
调入单位分管领导意见.Text = keys[24].ToString();
调入单位分管领导.Text = keys[25].ToString();
调入单位分管领导处理时间.Text = keys[26].ToString();
调拨主管部门意见.Text = keys[27].ToString();
主管部门处理时间.Text = keys[28].ToString();
主管部门.Text = keys[29].ToString();
调拨财政部门意见.Text = keys[30].ToString();
财政部门.Text = keys[31].ToString();
财政部门处理时间.Text = keys[32].ToString();
List <School办公设备信息表> listdata = bll.处置申报查询(SID, keys[5].ToString());
Grid9.DataSource = listdata;
Grid9.DataBind();
Grid10.DataSource = listdata;
Grid10.DataBind();
JObject summary = new JObject();
summary.Add("major", "全部合计");
summary.Add("数量_db", 总数.ToString("F2"));
summary.Add("价格_db", 总价.ToString("F2"));
Grid9.SummaryData = summary;
Grid10.SummaryData = summary;
}
#endregion
}
}
protected void 查看详情_Click(object sender, EventArgs e)
{
string FlowID = Request.QueryString["FlowID"];
if (FlowID != "" && FlowID != null)
{
ID = FlowID;
}
else
{
ID = Request.QueryString["ID"];
}
//string ID = Request.QueryString["ID"];
//string SID = Request.QueryString["SID"];
Window1.Hidden = false;
string SID = bll.资产处置SID(Convert.ToInt32(ID));
List <流程进度查看详情表> listdatas = bll.资产处置待报废查看详情(ID, SID);
流程状态_abfckxq.Text = listdatas[0].流程状态.ToString();
单据编号_bfckxq.Text = listdatas[0].单据编号.ToString();
float 总数 = 0.0f;
float 总价 = 0.0f;
总数 = float.Parse(listdatas[0].总数.ToString());
总价 = float.Parse(listdatas[0].总价.ToString());
分管领导_bfckxq.Text = listdatas[0].调入单位分管领导.ToString();
分管领导处理意见_bfckxq.Text = listdatas[0].调入单位分管领导意见.ToString();
分管领导操作时间_bfckxq.Text = listdatas[0].调入单位分管领导处理时间.ToString();
电话_bfckxq.Text = listdatas[0].电话.ToString();
职务_bfckxq.Text = listdatas[0].职务.ToString();
事项名称_bfckxq.Text = listdatas[0].事项名称.ToString();
主管部门_bfckxq.Text = listdatas[0].主管部门.ToString();
主管部门处理意见_bfckxq.Text = listdatas[0].主管部门意见.ToString();
主管部门操作时间_bfckxq.Text = listdatas[0].主管部门处理时间.ToString();
财政部门意见_bfckxq.Text = listdatas[0].财政部门意见.ToString();
财政部门_bfckxq.Text = listdatas[0].财政部门.ToString();
财政部门操作时间_bfckxq.Text = listdatas[0].财政部门处理时间.ToString();
原因说明_bfckxq.Text = listdatas[0].原因说明.ToString();
申请人_bfckxq.Text = listdatas[0].申请人.ToString();
申报单位_bfckxq.Text = listdatas[0].申报单位.ToString();
申报日期_ckxq.Text = listdatas[0].申报日期.ToString();
string FlowName = listdatas[0].FlowName.ToString();
School申报审批BLL sbspbll = new School申报审批BLL();
List <School办公设备信息表> listdata = sbspbll.处置申报查询(SID, FlowName);
Grid7.DataSource = listdata;
Grid7.DataBind();
Grid8.DataSource = listdata;
Grid8.DataBind();
JObject summary = new JObject();
summary.Add("major", "全部合计");
summary.Add("数量_bfckxq", 总数.ToString("F2"));
summary.Add("价格_bfckxq", 总价.ToString("F2"));
Grid7.SummaryData = summary;
Grid8.SummaryData = summary;
}