/// <summary> /// 选择数据 /// </summary> protected void refresh() { DataView dv = new CawApprovalSetDB().Select(); GridView1.DataSource = dv; GridView1.DataBind(); //调用一个js函数,用于强制执行datagrid的颜色变换。如不用,因updatapanel中数据更新后将无法引起datagridcolor.js的执行 CallJsFun("ChangeColor();"); }
/// <summary> /// 获得通过的查询 /// </summary> /// <param name="dgList"></param> /// <param name="Table_Name"></param> /// <param name="CorGuid"></param> /// <param name="DateFrom"></param> /// <param name="DateTo"></param> /// <param name="PageSize"></param> /// <param name="CurrentPageIndex"></param> /// <param name="TotalNum"></param> /// <param name="Message"></param> public void GetApprovalList(System.Web.UI.WebControls.DataGrid dgList, string Table_Name, string CorGuid, string DateFrom, string DateTo, int PageSize, int CurrentPageIndex, out int TotalNum, out string Message) { DataView dvList = new CawApprovalSetDB().Select(Table_Name); if(dvList.Count<1) { Message="审批信息还没有配置,请先至审批配置页面进行审批信息配置"; TotalNum = 0; return; } //添加隐藏列GUID BoundColumn col =new BoundColumn(); col.DataField = "GUID"; col.Visible = false; dgList.Columns.Add(col); string col_En = "COMPANY_NAME," + dvList[0]["COLLIST"].ToString().Trim() + ",SUBMITDATE,DATASTATUS_NAME"; string col_Cn = "企业名称," + dvList[0]["COLLIST_CN"].ToString().Trim() + ",申请日期,审批状态"; string[] colList = col_En.Split(','); string[] colList_Cn = col_Cn.Split(','); //添加显示列 for (int i = 0; i < colList.Length; i++) { BoundColumn col1 = new BoundColumn(); col1.HeaderText = colList_Cn[i]; col1.DataField = colList[i]; col1.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; col1.ItemStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; dgList.Columns.Add(col1); } string Where = " AND B.DATASTATUS='2'"; Where += CorGuid == "" ? "" : " AND A." + dvList[0]["QUERYFIELD"].ToString().Trim() + "='" + CorGuid + "'"; Where += (DateFrom != "" && DateTo == "") ? " AND B.SUBMITDATE >=TO_DATE('" + DateFrom + "','yyyy-mm-dd')" : ""; Where += (DateFrom == "" && DateTo != "") ? " AND B.SUBMITDATE <=TO_DATE('" + DateTo + "','yyyy-mm-dd')" : ""; Where += (DateFrom != "" && DateTo != "") ? " AND B.SUBMITDATE >=TO_DATE('" + DateFrom + "','yyyy-mm-dd') AND B.SUBMITDATE <=TO_DATE('" + DateTo + "','yyyy-mm-dd')" : ""; string strSql = " SELECT '' AS TMP,A." + dvList[0]["COLLIST"].ToString().Trim().Replace(",",",A.") + ",A." + dvList[0]["KEYFIELD"].ToString().Trim() + " AS GUID,B.DATASTATUS_NAME,TO_CHAR(B.SUBMITDATE,'yyyy-mm-dd') SUBMITDATE,C.NAME AS COMPANY_NAME FROM " + Table_Name + " A INNER JOIN CAW_DATESTATUS B ON A." + dvList[0]["KEYFIELD"].ToString().Trim() + "=B.KEYGUID INNER JOIN CAW_COMPANY C ON A." + dvList[0]["QUERYFIELD"].ToString().Trim() + "=C.GUID" + Where; strSql = FrameCommon.GetPageSql(CawConnStr, out TotalNum, CurrentPageIndex, PageSize, strSql, "GUID", " ORDER BY SUBMITDATE DESC"); Database db = DatabaseFactory.CreateDatabase(CawConnStr); DbCommand cmd = db.GetSqlStringCommand(strSql); try { dgList.DataSource = db.ExecuteDataView(cmd); dgList.DataBind(); Message = ""; } catch(Exception err) { Message = "审批信息配置错误"; TotalNum = 0; return; } }
private void InitiData() { string Guid = Request.QueryString["guid"]; List<Detail_CAW_APPROVALSET> DataList = new CawApprovalSetDB().GetSet(Guid); string[] Name_Cn = DataList[0].COLLIST_CN.Split(','); int Flag = 0; foreach (DataGridItem item in this.GridView1.Items) { if (DataList[0].COLLIST.IndexOf(((Label)item.Cells[1].FindControl("lblName")).Text) > -1) { ((CheckBox)item.Cells[5].FindControl("chkShow")).Checked = true; ((TextBox)item.Cells[3].FindControl("txtName")).Text = Name_Cn[Flag]; Flag += 1; } if (DataList[0].QUERYFIELD.IndexOf(((Label)item.Cells[1].FindControl("lblName")).Text) > -1) { ((CheckBox)item.Cells[6].FindControl("chkQuery")).Checked = true; } if (DataList[0].KEYFIELD.IndexOf(((Label)item.Cells[1].FindControl("lblName")).Text) > -1) { ((CheckBox)item.Cells[4].FindControl("chkKey")).Checked = true; } } }