Example #1
0
    private void BindData()
    {
        DataTable dt = new DAL.Tables.T_UnionLinkScale().Open("ID,UnionID,SiteLinkPID,BonusScale", "UnionID=" + _User.ID, "SiteLinkPID");

        DataTable dtLink = new DAL.Tables.T_Users().Open("distinct [Memo]", "Memo<>'' and CpsID=" + _User.cps.ID, "[Memo]");
       
        double scale = _Site.SiteOptions["BonusScale"].ToDouble(0.02);
       
        for (int i = 0; i < dtLink.Rows.Count; i++)
        {
            string pid = dtLink.Rows[i][0].ToString();
            DataRow[] drList = dt.Select("SiteLinkPID='" + pid + "'");
            if (drList.Length == 0)
            {
                DataRow dr = dt.NewRow();
                dr["ID"] = 0;
                dr["UnionID"] = _User.cps.ID;
                dr["SiteLinkPID"] = pid;
                dr["BonusScale"] = scale;
                dt.Rows.Add(dr);
            }
        }

        DataTable dtTemp = GetNewDataTable(dt, "SiteLinkPID like '%" + tbPID.Text.Trim() + "%'");

        PF.DataGridBindData(g, dtTemp, gPager);
    }