protected void Page_Load(object sender, EventArgs e) { roleCheck = new RoleCheck(CurrentUser); strProjGuid = Request["xmguid"] != null ? Request["xmguid"] : ""; userGuid = CurrentUser.UserGuid; depGuid = CurrentUser.UserGroup.Guid; strGuid = Request["Guid"] != null ? Request["Guid"] : ""; form.TableName = "tz_xmgz"; //表名 form.Key = "guid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); if (document["bglx"] == "建设方案") { filesign = "tz_Project_Fa"; } else if (document["bglx"] == "项目申报表") { filesign = "tz_Project_Sbb"; } else if (document["bglx"] == "云资源使用申请表") { filesign = "tz_Project_Yzy"; } System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { #region 接受参数 roleCheck = new RoleCheck(CurrentUser); strGuid = Request["xmguid"] != null ? Request["xmguid"] : ""; userGuid = CurrentUser.UserGuid; depGuid = CurrentUser.UserGroup.Guid; checkReturnHistory(); #endregion #region 初始化信息 form.TableName = "tz_zftz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); //管理员用户编辑权限一直开放 //其他部门用户在未提交或者被退回状态下可以编辑 if (roleCheck.isAdmin() || (document["ProState"] == "" || document["ProState"] == "退回")) { isEditable = true; } //可退回状态,生成唯一退回标识码 if (document["ProState"] == "提交" && (roleCheck.isAdmin() || roleCheck.isZfb() || roleCheck.isFgwAdmin())) { returnGuid = System.Guid.NewGuid().ToString(); successGuid = System.Guid.NewGuid().ToString(); holdGuid = System.Guid.NewGuid().ToString(); mergeGuid = System.Guid.NewGuid().ToString(); } //if (!UserCheck.checkIsAdmin(CurrentUser.user.UserLoginName)) //{ // isAdmin = false; // DataSet ds = db.ExecuteDataSet(" select * from tz_Project where ProGuid='" + strGuid + "'"); // prostate = ds.Tables[0].Rows[0]["ProState"].ToString(); // //未提交或者退回的项目申请提供编辑功能 // if (prostate == "" || prostate == "退回") // { // isEditable = true; // } //} //else //{ // isAdmin = true; // isEditable = true; //} #endregion System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); strGuid = this.Request.Params["xmguid"] ?? ""; xmguid = this.Request.Params["xmguid"] ?? ""; zjguid = this.Request.Params["zjguid"] ?? ""; form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); }
protected void Page_Load(object sender, EventArgs e) { db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); #region 接受参数 strGuid = Request["Guid"] != null ? Request["Guid"] : ""; xmguid = Request["xmguid"] != null ? Request["xmguid"] : ""; zjguid = Request["zjguid"] != null ? Request["zjguid"] : ""; #endregion if (strGuid == "" && xmguid.Length > 0 && zjguid.Length > 0) { System.Data.DataSet dsPs = db.ExecuteDataSet(" select top 1 * from tz_ProjectExpertPS where proguid='" + xmguid + "' and ExpertGuid='" + zjguid + "'"); if (dsPs.Tables[0].Rows.Count > 0) { strGuid = dsPs.Tables[0].Rows[0]["Guid"].ToString(); } else { //默认insert一条记录 var psguid = Guid.NewGuid().ToString(); db.ExecuteNonQuery(String.Format(@" insert into tz_ProjectExpertPS(Guid,ProGuid,ExpertGuid,psyj,pssj,sysstatus,status) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", psguid, xmguid, zjguid, "", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), 0, 0)); this.strGuid = psguid; } } //加载项目信息 db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); System.Data.DataSet dsProject = db.ExecuteDataSet(" select * from tz_project where proguid='" + xmguid + "' "); foreach (DataColumn col in dsProject.Tables[0].Columns) { if (dsProject.Tables[0].Rows.Count > 0) { documentProject.Add(col.ColumnName, dsProject.Tables[0].Rows[0][col].ToString()); } } #region 初始化信息 form.TableName = "tz_ProjectExpertPS"; //表名 form.Key = "Guid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); #endregion System.GC.Collect(); }
protected string strIssueRect = string.Empty;//问题整改动态行信息 protected void Page_Load(object sender, EventArgs e) { db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); strGuid = this.Request.Params["xmguid"] ?? ""; xmguid = this.Request.Params["xmguid"] ?? ""; form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); strIssueRect = form.GetRowDataXml("v_tz_ProjectExpert", "ProGuid", form.KeyValue, null, " order by pssj asc "); }
protected void Page_Load(object sender, EventArgs e) { // strProjGuid = Request["Guid"] != null ? Request["Guid"] : ""; strGuid = Request["xmguid"] != null ? Request["xmguid"] : ""; form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { // strProjGuid = Request["Guid"] != null ? Request["Guid"] : ""; strGuid = Request["Guid"] != null ? Request["Guid"] : ""; form.TableName = "tz_zjys"; //表名 form.Key = "guid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); datarow = form.GetRowDataXml("tz_zjys_mx", "refguid", form.KeyValue, null); System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { roleCheck = new RoleCheck(CurrentUser); // strProjGuid = Request["Guid"] != null ? Request["Guid"] : ""; strGuid = Request["guid"] != null ? Request["guid"] : ""; form.TableName = "tz_zlfb_new"; //表名 form.Key = "guid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); string guid = document["StartDeptGuid"]; System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { strProjGuid = Request["ProjGuid"] != null ? Request["ProjGuid"] : ""; strGuid = Request["Guid"] != null ? Request["Guid"] : ""; form.TableName = "tz_xmht"; //表名 form.Key = "guid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); dsHtfkfs = db.ExecuteDataSet(" select * from tz_xmht_zffs where htguid='" + strGuid + "' order by updatesj"); System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); strGuid = this.Request.Params["xmguid"] ?? ""; form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); //获取当前项目的上次抽取的评审专家 DataSet ds = db.ExecuteDataSet(" select * from tz_ProjectExpert where exists(select 1 from tz_ProjectAndExpert where tz_ProjectExpert.guid=tz_ProjectAndExpert.ExpertGuid and tz_ProjectAndExpert.proguid='" + strGuid + "') "); dtExperts = ds.Tables[0]; list_experts.DataSource = dtExperts; list_experts.DataBind(); }
protected string strIssueRect = string.Empty;//问题整改动态行信息 protected void Page_Load(object sender, EventArgs e) { db = Yawei.DataAccess.DatabaseFactory.CreateDatabase(); strGuid = this.Request.Params["xmguid"] ?? ""; xmguid = this.Request.Params["xmguid"] ?? ""; form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); strIssueRect = form.GetRowDataXml("tz_ProjectExpertPS", "ProGuid", form.KeyValue, null, " order by pssj asc "); DataSet ds = db.ExecuteDataSet(" select t2.* from tz_ProjectAndExpert t1 inner join tz_ProjectExpert t2 on t1.ExpertGuid=t2.guid and t1.proguid='" + xmguid + "' "); this.ProGuid.DataSource = ds.Tables[0]; this.ProGuid.DataTextField = "zjmc"; this.ProGuid.DataValueField = "Guid"; this.ProGuid.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { #region 接受参数 strGuid = Request["xmguid"] != null ? Request["xmguid"] : ""; checkReturnHistory(); #endregion #region 初始化信息 form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); string prostate = ""; if (!UserCheck.checkIsAdmin(CurrentUser.user.UserLoginName)) { isAdmin = false; DataSet ds = db.ExecuteDataSet(" select * from tz_Project where ProGuid='" + strGuid + "'"); prostate = ds.Tables[0].Rows[0]["ProState"].ToString(); //未提交或者退回的项目申请提供编辑功能 if (prostate == "" || prostate == "退回") { isEditable = true; } } else { isAdmin = true; isEditable = true; } #endregion System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { #region 接受参数 roleCheck = new RoleCheck(CurrentUser); strProGuid = Request["xmguid"] != null ? Request["xmguid"] : ""; userGuid = CurrentUser.UserGuid; depGuid = CurrentUser.UserGroup.Guid; #endregion #region 初始化信息 #endregion form.TableName = "tz_Project"; //表名 form.Key = "ProGuid"; //主键 form.KeyValue = strProGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); initYw(); System.GC.Collect(); }
protected void Page_Load(object sender, EventArgs e) { #region 接受参数 strGuid = Request["Guid"] != null ? Request["Guid"] : ""; xmguid = Request["xmguid"] != null ? Request["xmguid"] : ""; #endregion #region 初始化信息 form.TableName = "tz_ProjectExpertPS"; //表名 form.Key = "Guid"; //主键 form.KeyValue = strGuid; //主键的值 form.CurrentUser = CurrentUser; document = form.SetViewData(null); #endregion System.GC.Collect(); }