protected void Page_Load(object sender, EventArgs e) { dic = FormatProjectFacade.GetProjDicByGuid(Request["Guid"]); if (dic["ProGuid"] != null) { projJson = "[{ProGuid:'" + dic["ProGuid"] + "',ProName:'" + dic["ProName"] + "'}]"; } XmlDocument xml = CurrentUser.GetMenuXml("b095e426-bbdf-449a-a6cb-0115cb5311f1"); menuJson = GetNodeJson(xml.FirstChild, Yawei.Common.AppSupport.AppPath); FinanceDBFacade safesup = new FinanceDBFacade(); DataSet doc; doc = safesup.GetDataSetBySql("select * from tz_Project where ProGuid='" + Request["Guid"] + "'"); //>=DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0) and Checktime<=DATEADD(SS,-1,DATEADD(MONTH,1+DATEDIFF(MONTH,0,GETDATE()),0)) if (doc != null && doc.Tables[0].Rows.Count > 0) { IsChecked = false; } else { IsChecked = true; } }
protected void Page_Load(object sender, EventArgs e) { string sqlstr = "select * from tz_Project where StartDeptGuid='" + CurrentUser.UserGroup.Guid + "'"; FinanceDBFacade sql = new FinanceDBFacade(); DataSet ds = sql.GetDataSetBySql(sqlstr); dt = ds.Tables[0]; string xmguid = ""; //if (dt != null & dt.Rows.Count > 0) //{ // foreach (DataRow dr in dt.Rows) // { // xmguid = dr["ProGuid"].ToString(); // } // for (int i = 0; i <= dt.Rows.Count - 1; i++) // { // xmguids[i] = dt.Rows[i]["ProGuid"].ToString(); // } //} }