Exemplo n.º 1
0
        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;
            }
        }
Exemplo n.º 2
0
        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();
            //    }
            //}
        }