1195 lines
98 KiB
C#
1195 lines
98 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Web;
|
|||
|
|
using System.Web.UI;
|
|||
|
|
using System.Web.UI.WebControls;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data;
|
|||
|
|
using Newtonsoft.Json;
|
|||
|
|
using Newtonsoft.Json.Linq;
|
|||
|
|
using System.IO;
|
|||
|
|
|
|||
|
|
|
|||
|
|
namespace FineUI.Examples
|
|||
|
|
{
|
|||
|
|
public class PageBase : System.Web.UI.Page
|
|||
|
|
{
|
|||
|
|
#region OnInit
|
|||
|
|
|
|||
|
|
protected override void OnInit(EventArgs e)
|
|||
|
|
{
|
|||
|
|
var pm = PageManager.Instance;
|
|||
|
|
|
|||
|
|
// 如果不是FineUI的AJAX回发（两种情况：1.页面第一个加载 2.页面非AJAX回发）
|
|||
|
|
if (pm != null && !pm.IsFineUIAjaxPostBack)
|
|||
|
|
{
|
|||
|
|
HttpCookie themeCookie = Request.Cookies["Theme_v6"];
|
|||
|
|
if (themeCookie != null)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
string themeValue = themeCookie.Value;
|
|||
|
|
pm.Theme = (Theme)Enum.Parse(typeof(Theme), themeValue, true);
|
|||
|
|
}
|
|||
|
|
catch (Exception)
|
|||
|
|
{
|
|||
|
|
pm.Theme = FineUI.Theme.Neptune;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
HttpCookie langCookie = Request.Cookies["Language_v6"];
|
|||
|
|
if (langCookie != null)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
string langValue = langCookie.Value;
|
|||
|
|
pm.Language = (Language)Enum.Parse(typeof(Language), langValue, true);
|
|||
|
|
}
|
|||
|
|
catch (Exception)
|
|||
|
|
{
|
|||
|
|
pm.Language = Language.ZH_CN;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
HttpCookie loadingCookie = Request.Cookies["Loading_v6"];
|
|||
|
|
if (loadingCookie != null)
|
|||
|
|
{
|
|||
|
|
int loadingNumber = Convert.ToInt32(loadingCookie.Value);
|
|||
|
|
pm.LoadingImageNumber = loadingNumber;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
// 为所有页面添加公共的：<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|||
|
|
System.Web.UI.HtmlControls.HtmlGenericControl metaCtrl = new System.Web.UI.HtmlControls.HtmlGenericControl("meta");
|
|||
|
|
metaCtrl.Attributes["http-equiv"] = "Content-Type";
|
|||
|
|
metaCtrl.Attributes["content"] = "text/html; charset=utf-8";
|
|||
|
|
Header.Controls.AddAt(0, metaCtrl);
|
|||
|
|
|
|||
|
|
|
|||
|
|
// 为所有页面添加公共的：<link rel="stylesheet" type="text/css" href="res/css/common.css"></link>
|
|||
|
|
System.Web.UI.HtmlControls.HtmlGenericControl linkCtrl = new System.Web.UI.HtmlControls.HtmlGenericControl("link");
|
|||
|
|
linkCtrl.Attributes["rel"] = "stylesheet";
|
|||
|
|
linkCtrl.Attributes["type"] = "text/css";
|
|||
|
|
linkCtrl.Attributes["href"] = ResolveClientUrl("~/res/css/common.css");
|
|||
|
|
Header.Controls.Add(linkCtrl);
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
base.OnInit(e);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private bool IsSystemTheme(string themeName)
|
|||
|
|
{
|
|||
|
|
themeName = themeName.ToLower();
|
|||
|
|
string[] themes = Enum.GetNames(typeof(Theme));
|
|||
|
|
foreach (string theme in themes)
|
|||
|
|
{
|
|||
|
|
if (theme.ToLower() == themeName)
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 上传文件类型判断
|
|||
|
|
|
|||
|
|
protected readonly static List<string> VALID_FILE_TYPES = new List<string> { "jpg", "bmp", "gif", "jpeg", "png" };
|
|||
|
|
|
|||
|
|
protected static bool ValidateFileType(string fileName)
|
|||
|
|
{
|
|||
|
|
string fileType = String.Empty;
|
|||
|
|
int lastDotIndex = fileName.LastIndexOf(".");
|
|||
|
|
if (lastDotIndex >= 0)
|
|||
|
|
{
|
|||
|
|
fileType = fileName.Substring(lastDotIndex + 1).ToLower();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (VALID_FILE_TYPES.Contains(fileType))
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 省市县
|
|||
|
|
|
|||
|
|
protected readonly static JArray SHENG_JSON = JArray.Parse("[\"北京\",\"天津\",\"上海\",\"重庆\",\"河北\",\"山西\",\"辽宁\",\"吉林\",\"黑龙江\",\"江苏\",\"浙江\",\"安徽\",\"福建\",\"江西\",\"山东\",\"河南\",\"湖北\",\"湖南\",\"广东\",\"海南\",\"四川\",\"贵州\",\"云南\",\"陕西\",\"甘肃\",\"青海\",\"内蒙古\",\"广西\",\"西藏\",\"宁夏\",\"新疆\",\"香港\",\"澳门\",\"台湾\"]");
|
|||
|
|
protected readonly static JObject SHI_JSON = JObject.Parse("{\"北京\":[\"北京市\"],\"天津\":[\"天津市\"],\"上海\":[\"上海市\"],\"重庆\":[\"重庆市\"],\"河北\":[\"石家庄市\",\"唐山市\",\"秦皇岛市\",\"邯郸市\",\"邢台市\",\"保定市\",\"张家口市\",\"承德市\",\"沧州市\",\"廊坊市\",\"衡水市\"],\"山西\":[\"太原市\",\"大同市\",\"阳泉市\",\"长治市\",\"晋城市\",\"朔州市\",\"晋中市运城市忻州市\",\"临汾市\",\"吕梁市\"],\"辽宁\":[\"沈阳市\",\"大连市\",\"鞍山市\",\"抚顺市\",\"本溪市\",\"丹东市\",\"锦州市\",\"营口市\",\"阜新市\",\"辽阳市\",\"盘锦市\",\"铁岭市\",\"朝阳市\",\"葫芦岛市\"],\"吉林\":[\"长春市\",\"吉林市\",\"四平市\",\"辽源市\",\"通化市\",\"白山市\",\"松原市\",\"白城市\",\"延边朝鲜族自治州\"],\"黑龙江\":[\"哈尔滨市\",\"齐齐哈尔市\",\"鹤岗市\",\"双鸭山市\",\"鸡西市\",\"大庆市\",\"伊春市\",\"牡丹江市\",\"佳木斯市\",\"七台河市\",\"黑河市\",\"绥化市\",\"大兴安岭地区\"],\"江苏\":[\"南京市\",\"苏州市\",\"无锡市\",\"常州市\",\"镇江市\",\"南通市\",\"泰州市\",\"扬州市\",\"盐城市\",\"连云港市\",\"徐州市\",\"淮安市\",\"宿迁市\"],\"浙江\":[\"杭州市\",\"宁波市\",\"温州市\",\"嘉兴市\",\"湖州市\",\"绍兴市\",\"金华市\",\"衢州市\",\"舟山市\",\"台州市\",\"丽水市\"],\"安徽\":[\"合肥市\",\"芜湖市\",\"蚌埠市\",\"淮南市\",\"马鞍山市\",\"淮北市\",\"铜陵市\",\"安庆市\",\"黄山市\",\"滁州市\",\"阜阳市\",\"宿州市\",\"巢湖市\",\"六安市\",\"亳州市\",\"池州市\",\"宣城市\"],\"福建\":[\"福州市\",\"厦门市\",\"莆田市\",\"三明市\",\"泉州市\",\"漳州市\",\"南平市\",\"龙岩市\",\"宁德市\"],\"江西\":[\"南昌市\",\"景德镇市\",\"萍乡市\",\"九江市\",\"新余市\",\"鹰潭市\",\"赣州市\",\"吉安市\",\"宜春市\",\"抚州市\",\"上饶市\"],\"山东\":[\"济南市\",\"青岛市\",\"淄博市\",\"枣庄市\",\"东营市\",\"烟台市\",\"潍坊市\",\"济宁市\",\"泰安市\",\"威海市\",\"日照市\",\"莱芜市\",\"临沂市\",\"德州市\",\"聊城市\",\"滨州市\",\"菏泽市\"],\"河南\":[\"郑州市\",\"开封市\",\"洛阳市\",\"平顶山市\",\"安阳市\",\"鹤壁市\",\"新乡市\",\"焦作市\",\"濮阳市\",\"许昌市\",\"漯河市\",\"三门峡市\",\"南阳市\",\"商丘市\",\"信阳市\",\"周口市\",\"驻马店市\",\"济源市\"],\"湖北\":[\"武汉市\",\"黄石市\",\"十堰市\",\"荆州市\",\"宜昌市\",\"襄樊市\",\"鄂州市\",\"荆门市\",\"孝感市\",\"黄冈市\",\"咸宁市\",\"随州市\",\"恩施土家族苗族自治州\",\"仙桃市\",\"天门市\",\"潜江市\",\"神农架林区\"],\"湖南\":[\"长沙市\",\"株洲市\",\"湘潭市\",\"衡阳市\",\"邵阳市\",\"岳阳市\",\"常德市\",\"张家界市\",\"益阳市\",\"郴州市\",\"永州市\",\"怀化市\",\"娄底市\",\"湘西土家族苗族自治州\"],\"广东\":[\"广州市\",\"深圳市\",\"珠海市\",\"汕头市\",\"韶关市\",\"佛山市\",\"江门市\",\"湛江市\",\"茂名市\",\"肇庆市\",\"惠州市\",\"梅州市\",\"汕尾市\",\"河源市\",\"阳江市\",\"清远市\",\"东莞市\",\"中山市\",\"潮州市\",\"揭阳市\",\"云浮市\"],\"海南\":[\"海口市\",\"三亚市\",\"五指山市\",\"琼海市\",\"儋州市\",\"文昌市\",\"万宁市\",\"东方市\",\"澄迈县\",\"定安县\",\"屯昌县\",\"临高县\",\"白沙黎族自治县\",\"昌江黎族自治县\",\"乐东黎族自治县\",\"陵水黎族自治县\",\"保亭黎族苗族自治县\",\"琼中黎族苗族自治县\"],\"四川\":[\"成都市\",\"自贡市\",\"攀枝花市\",\"泸州市\",\"德阳市\",\"绵阳市\",\"广元市\",\"遂宁市\",\"内江市\",\"乐山市\",\"南充市\",\"眉山市\",\"宜宾市\",\"广安市\",\"达州市\",\"雅安市\",\"巴中市\",\"资阳市\",\"阿坝藏族羌族自治州\",\"甘孜藏族自治州\",\"凉山彝族自治州\"],\"贵州\":[\"<22><>
|
|||
|
|
protected readonly static JObject XIAN_JSON = JObject.Parse("{\"北京市\":[\"东城区\",\"西城区\",\"崇文区\",\"宣武区\",\"朝阳区\",\"丰台区\",\"石景山区\",\"海淀区\",\"门头沟区\",\"房山区\",\"通州区\",\"顺义区\",\"昌平区\",\"大兴区\",\"怀柔区\",\"平谷区\",\"密云县\",\"延庆县\"],\"天津市\":[\"和平区\",\"河东区\",\"河西区\",\"南开区\",\"河北区\",\"红桥区\",\"塘沽区\",\"汉沽区\",\"大港区\",\"东丽区\",\"西青区\",\"北辰区\",\"津南区\",\"武清区\",\"宝坻区\",\"静海县\",\"宁河县\",\"蓟县\"],\"上海市\":[\"黄浦区\",\"卢湾区\",\"徐汇区\",\"长宁区\",\"静安区\",\"普陀区\",\"闸北区\",\"虹口区\",\"杨浦区\",\"宝山区\",\"闵行区\",\"嘉定区\",\"松江区\",\"金山区\",\"青浦区\",\"奉贤区\",\"浦东新区\",\"崇明县\"],\"重庆市\":[\"渝中区\",\"大渡口区\",\"江北区\",\"南岸区\",\"北碚区\",\"渝北区\",\"巴南区\",\"长寿区\",\"双桥区\",\"沙坪坝区\",\"万盛区\",\"万州区\",\"涪陵区\",\"黔江区\",\"永川区\",\"合川区\",\"江津区\",\"九龙坡区\",\"南川区\",\"綦江县\",\"潼南县\",\"荣昌县\",\"璧山县\",\"大足县\",\"铜梁县\",\"梁平县\",\"开县\",\"忠县\",\"城口县\",\"垫江县\",\"武隆县\",\"丰都县\",\"奉节县\",\"云阳县\",\"巫溪县\",\"巫山县\",\"石柱土家族自治县\",\"秀山土家族苗族自治县\",\"酉阳土家族苗族自治县\",\"彭水苗族土家族自治县\"],\"石家庄市\":[\"长安区\",\"桥东区\",\"桥西区\",\"新华区\",\"裕华区\",\"井陉矿区\",\"鹿泉市\",\"辛集市\",\"藁城市\",\"晋州市\",\"新乐市\",\"深泽县\",\"无极县\",\"赵县\",\"灵寿县\",\"高邑县\",\"元氏县\",\"赞皇县\",\"平山县\",\"井陉县\",\"栾城县\",\"正定县\",\"行唐县\"],\"唐山市\":[\"路北区\",\"路南区\",\"古冶区\",\"开平区\",\"丰南区\",\"丰润区\",\"遵化市\",\"迁安市\",\"迁西县\",\"滦南县\",\"玉田县\",\"唐海县\",\"乐亭县\",\"滦县\",\"汉沽管理区\"],\"秦皇岛市\":[\"海港区\",\"山海关区\",\"北戴河区\",\"昌黎县\",\"抚宁县\",\"卢龙县\",\"青龙满族自治县\"],\"邯郸市\":[\"邯山区\",\"丛台区\",\"复兴区\",\"峰峰矿区\",\"武安市\",\"邱县\",\"大名县\",\"魏县\",\"曲周县\",\"鸡泽县\",\"肥乡县\",\"广平县\",\"成安县\",\"临漳县\",\"磁县\",\"涉县\",\"永年县\",\"馆陶县\",\"邯郸县\"],\"邢台市\":[\"桥东区\",\"桥西区\",\"南宫市\",\"沙河市\",\"临城县\",\"内丘县\",\"柏乡县\",\"隆尧县\",\"任县\",\"南和县\",\"宁晋县\",\"巨鹿县\",\"新河县\",\"广宗县\",\"平乡县\",\"威县\",\"清河县\",\"临西县\",\"邢台县\"],\"保定市\":[\"新市区\",\"北市区\",\"南市区\",\"定州市\",\"涿州市\",\"安国市\",\"高碑店市\",\"易县\",\"徐水县\",\"涞源县\",\"顺平县\",\"唐县\",\"望都县\",\"涞水县\",\"高阳县\",\"安新县\",\"雄县\",\"容城县\",\"蠡县\",\"曲阳县\",\"阜平县\",\"博野县\",\"满城县\",\"清苑县\",\"定兴县\"],\"张家口市\":[\"桥东区\",\"桥西区\",\"宣化区\",\"下花园区\",\"张北县\",\"康保县\",\"沽源县\",\"尚义县\",\"蔚县\",\"阳原县\",\"怀安县\",\"万全县\",\"怀来县\",\"赤城县\",\"崇礼县\",\"宣化县\",\"涿鹿县\",\"塞北管理区\"],\"承德市\":[\"双桥区\",\"双滦区\",\"鹰手营子矿区\",\"兴隆县\",\"平泉县\",\"滦平县\",\"隆化县\",\"承德县\",\"丰宁满族自治县\",\"宽城满族自治县\",\"围场满族蒙古族自治县\"],\"沧州市\":[\"新华区\",\"运河区\",\"泊头市\",\"任丘市\",\"黄骅市\",\"河间市\",\"献县\",\"吴桥县\",\"沧县\",\"东光县\",\"肃宁县\",\"南皮县\",\"盐山县\",\"青县\",\"海兴县\",\"孟村回族自治县\"],\"廊坊市\":[\"安次区\",\"广阳区\",\"霸州市\",\"三河市\",\"香河县\",\"永清县\",\"固安县\",\"文安县\",\"大城县\",\"大厂回族自治县\"],\"衡水市\":[\"桃城区\",\"冀<>
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 表格相关
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 选中了哪些行
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="grid">表格对象</param>
|
|||
|
|
/// <returns>选中行的描述信息</returns>
|
|||
|
|
protected string HowManyRowsAreSelected(Grid grid)
|
|||
|
|
{
|
|||
|
|
return HowManyRowsAreSelected(grid, false);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 选中了哪些行
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="grid">表格对象</param>
|
|||
|
|
/// <param name="rowNumberInDataSource">在表格数据源中计算序号（而不是在当前分页内计算序号）</param>
|
|||
|
|
/// <returns>选中行的描述信息</returns>
|
|||
|
|
protected string HowManyRowsAreSelected(Grid grid, bool rowNumberInDataSource)
|
|||
|
|
{
|
|||
|
|
StringBuilder sb = new StringBuilder();
|
|||
|
|
int selectedCount = grid.SelectedRowIndexArray.Length;
|
|||
|
|
if (selectedCount > 0)
|
|||
|
|
{
|
|||
|
|
sb.AppendFormat("<p><strong>共选中了 {0} 行：</strong></p>", selectedCount);
|
|||
|
|
sb.Append("<table class=\"result\">");
|
|||
|
|
|
|||
|
|
sb.Append("<tr><th>序号</th>");
|
|||
|
|
foreach (string datakey in grid.DataKeyNames)
|
|||
|
|
{
|
|||
|
|
sb.AppendFormat("<th>{0}</th>", datakey);
|
|||
|
|
}
|
|||
|
|
sb.Append("</tr>");
|
|||
|
|
|
|||
|
|
|
|||
|
|
for (int i = 0; i < selectedCount; i++)
|
|||
|
|
{
|
|||
|
|
int rowIndex = grid.SelectedRowIndexArray[i];
|
|||
|
|
sb.Append("<tr>");
|
|||
|
|
|
|||
|
|
int rownumber = rowIndex + 1;
|
|||
|
|
if (rowNumberInDataSource && grid.AllowPaging)
|
|||
|
|
{
|
|||
|
|
rownumber += grid.PageIndex * grid.PageSize;
|
|||
|
|
}
|
|||
|
|
sb.AppendFormat("<td>{0}</td>", rownumber);
|
|||
|
|
|
|||
|
|
|
|||
|
|
// 如果是内存分页，所有分页的数据都存在，rowIndex 就是在全部数据中的顺序，而不是当前页的顺序
|
|||
|
|
if (grid.AllowPaging && !grid.IsDatabasePaging)
|
|||
|
|
{
|
|||
|
|
rowIndex = grid.PageIndex * grid.PageSize + rowIndex;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
object[] dataKeys = grid.DataKeys[rowIndex];
|
|||
|
|
for (int j = 0; j < dataKeys.Length; j++)
|
|||
|
|
{
|
|||
|
|
sb.AppendFormat("<td>{0}</td>", dataKeys[j]);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
sb.Append("</tr>");
|
|||
|
|
}
|
|||
|
|
sb.Append("</table>");
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
sb.Append("<strong>没有选中任何一行！</strong>");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
return sb.ToString();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取性别的字面值，在 ASPX 中调用
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="gender"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
protected string GetGender(object gender)
|
|||
|
|
{
|
|||
|
|
if (Convert.ToInt32(gender) == 1)
|
|||
|
|
{
|
|||
|
|
return "男";
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return "女";
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/*
|
|||
|
|
protected DataTable GetClassDataTable()
|
|||
|
|
{
|
|||
|
|
DataTable table = new DataTable();
|
|||
|
|
table.Columns.Add(new DataColumn("Id", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Name", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("EntranceYear", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("LogTime", typeof(DateTime)));
|
|||
|
|
table.Columns.Add(new DataColumn("Desc", typeof(string)));
|
|||
|
|
|
|||
|
|
DataRow row = table.NewRow();
|
|||
|
|
|
|||
|
|
row[0] = 101;
|
|||
|
|
row[1] = "班级一";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = DateTime.Parse("2000-09-01");
|
|||
|
|
row[4] = "班级一创建于2000年9月1号，班长胡飞，连续三年获得全校优秀班级称号。";
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 102;
|
|||
|
|
row[1] = "班级二";
|
|||
|
|
row[2] = 2005;
|
|||
|
|
row[3] = DateTime.Parse("2005-09-01");
|
|||
|
|
row[4] = "班级一创建于2005年9月1号，班长董婷婷，连续两年获得全校优秀班级称号。";
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
return table;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取模拟表格2
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
protected DataTable DataSourceUtil.GetDataTable2()
|
|||
|
|
{
|
|||
|
|
DataTable table = new DataTable();
|
|||
|
|
table.Columns.Add(new DataColumn("Id", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Name", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("EntranceYear", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("AtSchool", typeof(bool)));
|
|||
|
|
table.Columns.Add(new DataColumn("Major", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("Group", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Gender", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("LogTime", typeof(DateTime)));
|
|||
|
|
table.Columns.Add(new DataColumn("Desc", typeof(string)));
|
|||
|
|
table.Columns.Add(new DataColumn("Guid", typeof(Guid)));
|
|||
|
|
table.Columns.Add(new DataColumn("Hobby", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("EntranceDate", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("Donate", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Fee", typeof(int)));
|
|||
|
|
// Hobby：reading,basketball,travel,movie,music
|
|||
|
|
// 爱好：读书, 篮球, 旅游, 电影, 音乐
|
|||
|
|
|
|||
|
|
// 考试成绩
|
|||
|
|
table.Columns.Add(new DataColumn("ChineseScore", typeof(Int32)));
|
|||
|
|
table.Columns.Add(new DataColumn("MathScore", typeof(Int32)));
|
|||
|
|
table.Columns.Add(new DataColumn("TotalScore", typeof(Int32)));
|
|||
|
|
|
|||
|
|
|
|||
|
|
DataRow row = null;
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 101;
|
|||
|
|
row[1] = "陈萍萍";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "计算机应用技术";
|
|||
|
|
row[5] = 1;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-100);
|
|||
|
|
row[8] = "陈萍萍，女，20岁，出生于中国南方的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,travel";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 299;
|
|||
|
|
row[13] = 2990;
|
|||
|
|
row[14] = 80;
|
|||
|
|
row[15] = 80;
|
|||
|
|
row[16] = 160;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 102;
|
|||
|
|
row[1] = "胡飞";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "信息工程";
|
|||
|
|
row[5] = 1;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-90);
|
|||
|
|
row[8] = "胡飞，男，20岁，出生于中国北方的一个小山村，毕业于南方科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball";
|
|||
|
|
row[11] = "2008-09-01";
|
|||
|
|
row[12] = 199;
|
|||
|
|
row[13] = 1990;
|
|||
|
|
row[14] = 90;
|
|||
|
|
row[15] = 80;
|
|||
|
|
row[16] = 170;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 103;
|
|||
|
|
row[1] = "金婷婷";
|
|||
|
|
row[2] = 2001;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "会计学";
|
|||
|
|
row[5] = 2;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-80);
|
|||
|
|
row[8] = "金婷婷，女，28岁，出生于中国海南岛的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,music";
|
|||
|
|
row[11] = "2001-09-01";
|
|||
|
|
row[12] = 299;
|
|||
|
|
row[13] = 3990;
|
|||
|
|
row[14] = 85;
|
|||
|
|
row[15] = 85;
|
|||
|
|
row[16] = 170;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 104;
|
|||
|
|
row[1] = "潘国";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "国际经济与贸易";
|
|||
|
|
row[5] = 2;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-70);
|
|||
|
|
row[8] = "潘国，男，22岁，出生于中国澳门的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,music";
|
|||
|
|
row[11] = "2008-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3998;
|
|||
|
|
row[14] = 89;
|
|||
|
|
row[15] = 80;
|
|||
|
|
row[16] = 169;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 105;
|
|||
|
|
row[1] = "吴颖颖";
|
|||
|
|
row[2] = 2002;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "市场营销";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-60);
|
|||
|
|
row[8] = "吴颖颖，女，26岁，出生于中国福建的一个小山村，毕业于香港科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music";
|
|||
|
|
row[11] = "2002-09-01";
|
|||
|
|
row[12] = 499;
|
|||
|
|
row[13] = 4992;
|
|||
|
|
row[14] = 92;
|
|||
|
|
row[15] = 85;
|
|||
|
|
row[16] = 177;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 106;
|
|||
|
|
row[1] = "张博";
|
|||
|
|
row[2] = 2003;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "财务管理";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "张博，男，28岁，出生于中国浙江的一个小山村，毕业于电子科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "movie,music";
|
|||
|
|
row[11] = "2003-09-01";
|
|||
|
|
row[12] = 99;
|
|||
|
|
row[13] = 997;
|
|||
|
|
row[14] = 88;
|
|||
|
|
row[15] = 86;
|
|||
|
|
row[16] = 174;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 107;
|
|||
|
|
row[1] = "杨倩倩";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "材料物理与化学";
|
|||
|
|
row[5] = 4;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-40);
|
|||
|
|
row[8] = "杨倩倩，女，25岁，出生于中国北方的一个小山村，毕业于北京科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "travel,movie,music";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3995;
|
|||
|
|
row[14] = 95;
|
|||
|
|
row[15] = 82;
|
|||
|
|
row[16] = 177;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 108;
|
|||
|
|
row[1] = "董超";
|
|||
|
|
row[2] = 2004;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "生物医学工程";
|
|||
|
|
row[5] = 4;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-30);
|
|||
|
|
row[8] = "董超，男，26岁，出生于中国河南的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "basketball,movie,music";
|
|||
|
|
row[11] = "2004-09-01";
|
|||
|
|
row[12] = 299;
|
|||
|
|
row[13] = 2996;
|
|||
|
|
row[14] = 86;
|
|||
|
|
row[15] = 98;
|
|||
|
|
row[16] = 184;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 109;
|
|||
|
|
row[1] = "张娟娟";
|
|||
|
|
row[2] = 2003;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "土木工程";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-20);
|
|||
|
|
row[8] = "张娟娟，女，25岁，出生于中国广西的一个小山村，毕业于南方科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,travel,movie,music";
|
|||
|
|
row[11] = "2003-09-01";
|
|||
|
|
row[12] = 599;
|
|||
|
|
row[13] = 5990;
|
|||
|
|
row[14] = 92;
|
|||
|
|
row[15] = 96;
|
|||
|
|
row[16] = 198;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 110;
|
|||
|
|
row[1] = "叶鹏";
|
|||
|
|
row[2] = 2006;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "电子商务";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-10);
|
|||
|
|
row[8] = "叶鹏，男，23岁，出生于中国安徽的一个小山村，毕业于国防科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music";
|
|||
|
|
row[11] = "2006-09-01";
|
|||
|
|
row[12] = 699;
|
|||
|
|
row[13] = 6990;
|
|||
|
|
row[14] = 69;
|
|||
|
|
row[15] = 99;
|
|||
|
|
row[16] = 168;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 111;
|
|||
|
|
row[1] = "李玲玲";
|
|||
|
|
row[2] = 2002;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "管理学";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-5);
|
|||
|
|
row[8] = "李玲玲，女，22岁，出生于中国台湾的一个小山村，毕业于台湾科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,travel,music";
|
|||
|
|
row[11] = "2002-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3990;
|
|||
|
|
row[14] = 88;
|
|||
|
|
row[15] = 92;
|
|||
|
|
row[16] = 180;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 112;
|
|||
|
|
row[1] = "张萍萍";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "计算机应用技术";
|
|||
|
|
row[5] = 1;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-100);
|
|||
|
|
row[8] = "张萍萍，女，20岁，出生于中国南方的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,travel";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 299;
|
|||
|
|
row[13] = 2999;
|
|||
|
|
row[14] = 82;
|
|||
|
|
row[15] = 88;
|
|||
|
|
row[16] = 170;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 113;
|
|||
|
|
row[1] = "曹飞";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "信息工程";
|
|||
|
|
row[5] = 1;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-90);
|
|||
|
|
row[8] = "曹飞，男，20岁，出生于中国北方的一个小山村，毕业于南方科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball";
|
|||
|
|
row[11] = "2008-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3996;
|
|||
|
|
row[14] = 96;
|
|||
|
|
row[15] = 85;
|
|||
|
|
row[16] = 181;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 114;
|
|||
|
|
row[1] = "孙婷婷";
|
|||
|
|
row[2] = 2001;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "会计学";
|
|||
|
|
row[5] = 2;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-80);
|
|||
|
|
row[8] = "孙婷婷，女，28岁，出生于中国海南岛的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,music";
|
|||
|
|
row[11] = "2001-09-01";
|
|||
|
|
row[12] = 499;
|
|||
|
|
row[13] = 4990;
|
|||
|
|
row[14] = 80;
|
|||
|
|
row[15] = 90;
|
|||
|
|
row[16] = 170;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 115;
|
|||
|
|
row[1] = "董国";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "国际经济与贸易";
|
|||
|
|
row[5] = 2;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-70);
|
|||
|
|
row[8] = "董国，男，22岁，出生于中国澳门的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,music";
|
|||
|
|
row[11] = "2008-09-01";
|
|||
|
|
row[12] = 299;
|
|||
|
|
row[13] = 2992;
|
|||
|
|
row[14] = 90;
|
|||
|
|
row[15] = 95;
|
|||
|
|
row[16] = 185;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 116;
|
|||
|
|
row[1] = "习颖颖";
|
|||
|
|
row[2] = 2002;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "市场营销";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-60);
|
|||
|
|
row[8] = "习颖颖，女，26岁，出生于中国福建的一个小山村，毕业于香港科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music";
|
|||
|
|
row[11] = "2002-09-01";
|
|||
|
|
row[12] = 199;
|
|||
|
|
row[13] = 1990;
|
|||
|
|
row[14] = 86;
|
|||
|
|
row[15] = 90;
|
|||
|
|
row[16] = 176;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 117;
|
|||
|
|
row[1] = "李博";
|
|||
|
|
row[2] = 2003;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "财务管理";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "李博，男，28岁，出生于中国浙江的一个小山村，毕业于电子科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "movie,music";
|
|||
|
|
row[11] = "2003-09-01";
|
|||
|
|
row[12] = 99;
|
|||
|
|
row[13] = 990;
|
|||
|
|
row[14] = 80;
|
|||
|
|
row[15] = 95;
|
|||
|
|
row[16] = 175;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 118;
|
|||
|
|
row[1] = "黄婷婷";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "材料物理与化学";
|
|||
|
|
row[5] = 4;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-40);
|
|||
|
|
row[8] = "黄婷婷，女，25岁，出生于中国北方的一个小山村，毕业于北京科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "travel,movie,music";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3990;
|
|||
|
|
row[14] = 95;
|
|||
|
|
row[15] = 88;
|
|||
|
|
row[16] = 183;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 119;
|
|||
|
|
row[1] = "韩超";
|
|||
|
|
row[2] = 2004;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "生物医学工程";
|
|||
|
|
row[5] = 4;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-30);
|
|||
|
|
row[8] = "韩超，男，26岁，出生于中国河南的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "basketball,movie,music";
|
|||
|
|
row[11] = "2004-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3991;
|
|||
|
|
row[14] = 88;
|
|||
|
|
row[15] = 86;
|
|||
|
|
row[16] = 174;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 120;
|
|||
|
|
row[1] = "王娟娟";
|
|||
|
|
row[2] = 2003;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "土木工程";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-20);
|
|||
|
|
row[8] = "王娟娟，女，25岁，出生于中国广西的一个小山村，毕业于南方科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,travel,movie,music";
|
|||
|
|
row[11] = "2003-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3992;
|
|||
|
|
row[14] = 90;
|
|||
|
|
row[15] = 88;
|
|||
|
|
row[16] = 178;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 121;
|
|||
|
|
row[1] = "周鹏";
|
|||
|
|
row[2] = 2006;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "电子商务";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-10);
|
|||
|
|
row[8] = "周鹏，男，23岁，出生于中国安徽的一个小山村，毕业于国防科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music";
|
|||
|
|
row[11] = "2006-09-01";
|
|||
|
|
row[12] = 299;
|
|||
|
|
row[13] = 2992;
|
|||
|
|
row[14] = 92;
|
|||
|
|
row[15] = 96;
|
|||
|
|
row[16] = 186;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 122;
|
|||
|
|
row[1] = "吴玲玲";
|
|||
|
|
row[2] = 2002;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "管理学";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-5);
|
|||
|
|
row[8] = "吴玲玲，女，22岁，出生于中国台湾的一个小山村，毕业于台湾科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,travel,music";
|
|||
|
|
row[11] = "2002-09-01";
|
|||
|
|
row[12] = 399;
|
|||
|
|
row[13] = 3993;
|
|||
|
|
row[14] = 95;
|
|||
|
|
row[15] = 89;
|
|||
|
|
row[16] = 184;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
return table;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取模拟表格
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
protected DataTable DataSourceUtil.GetDataTable()
|
|||
|
|
{
|
|||
|
|
DataTable table = new DataTable();
|
|||
|
|
table.Columns.Add(new DataColumn("Id", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Name", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("EntranceYear", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("AtSchool", typeof(bool)));
|
|||
|
|
table.Columns.Add(new DataColumn("Major", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("Group", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Gender", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("LogTime", typeof(DateTime)));
|
|||
|
|
table.Columns.Add(new DataColumn("Desc", typeof(string)));
|
|||
|
|
table.Columns.Add(new DataColumn("Guid", typeof(Guid)));
|
|||
|
|
|
|||
|
|
// Hobby：reading,basketball,travel,movie,music
|
|||
|
|
// 爱好：读书, 篮球, 旅游, 电影, 音乐
|
|||
|
|
table.Columns.Add(new DataColumn("Hobby", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("EntranceDate", typeof(String)));
|
|||
|
|
|
|||
|
|
// 考试成绩
|
|||
|
|
table.Columns.Add(new DataColumn("ChineseScore", typeof(Int32)));
|
|||
|
|
table.Columns.Add(new DataColumn("MathScore", typeof(Int32)));
|
|||
|
|
table.Columns.Add(new DataColumn("TotalScore", typeof(Int32)));
|
|||
|
|
|
|||
|
|
// 体检结果
|
|||
|
|
table.Columns.Add(new DataColumn("ShenGao", typeof(Int32)));
|
|||
|
|
table.Columns.Add(new DataColumn("TiZhong", typeof(Int32)));
|
|||
|
|
table.Columns.Add(new DataColumn("XueYaDi", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("XueYaGao", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("ShiLiZuo", typeof(Single)));
|
|||
|
|
table.Columns.Add(new DataColumn("ShiLiYou", typeof(Single)));
|
|||
|
|
table.Columns.Add(new DataColumn("ShiLiZuoJiaoZhen", typeof(Single)));
|
|||
|
|
table.Columns.Add(new DataColumn("ShiLiYouJiaoZhen", typeof(Single)));
|
|||
|
|
|
|||
|
|
// 合并单元格需要的字段
|
|||
|
|
table.Columns.Add(new DataColumn("GroupB", typeof(int)));
|
|||
|
|
|
|||
|
|
|
|||
|
|
DataRow row = table.NewRow();
|
|||
|
|
row[0] = 101;
|
|||
|
|
row[1] = "张萍萍";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "材料科学与工程系";
|
|||
|
|
row[5] = 1;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-100); // DBNull.Value;
|
|||
|
|
row[8] = "张萍萍，女，20岁，出生于中国南方的一个小山村，毕业于中国科学技术大学。<br/>毕业后就职于某大型国有企业，任部门经理，连续三年获得企业优秀员工称号。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,travel,music";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 80;
|
|||
|
|
row[13] = 90;
|
|||
|
|
row[14] = 170;
|
|||
|
|
row[15] = 180;
|
|||
|
|
row[16] = 150;
|
|||
|
|
row[17] = 80;
|
|||
|
|
row[18] = 120;
|
|||
|
|
row[19] = 0.2;
|
|||
|
|
row[20] = 0.5;
|
|||
|
|
row[21] = 1.0;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 1;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 102;
|
|||
|
|
row[1] = "陈飞";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "化学系";
|
|||
|
|
row[5] = 1;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-100);
|
|||
|
|
row[8] = "陈飞，男，20岁，出生于中国北方的一个小山村，毕业于南方科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "basketball,travel,movie,reading,music";
|
|||
|
|
row[11] = "2001-09-01";
|
|||
|
|
row[12] = 85;
|
|||
|
|
row[13] = 90;
|
|||
|
|
row[14] = 175;
|
|||
|
|
row[15] = 160;
|
|||
|
|
row[16] = 120;
|
|||
|
|
row[17] = 70;
|
|||
|
|
row[18] = 110;
|
|||
|
|
row[19] = 0.3;
|
|||
|
|
row[20] = 0.3;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 1;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 103;
|
|||
|
|
row[1] = "董婷婷";
|
|||
|
|
row[2] = 2000;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "化学系";
|
|||
|
|
row[5] = 2;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-100);
|
|||
|
|
row[8] = "董婷婷，女，18岁，出生于中国海南岛的一个小山村，毕业于中国科学技术大学。<br/>董婷婷是在学校认识丈夫刘国的，有一天晚上下自习后，董婷婷发短信给刘国说“做我男朋友吧！”，然后他们就走到了一起。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "basketball,movie,music";
|
|||
|
|
row[11] = "2008-09-01";
|
|||
|
|
row[12] = 90;
|
|||
|
|
row[13] = 90;
|
|||
|
|
row[14] = 180;
|
|||
|
|
row[15] = 190;
|
|||
|
|
row[16] = 130;
|
|||
|
|
row[17] = 82;
|
|||
|
|
row[18] = 125;
|
|||
|
|
row[19] = 0.8;
|
|||
|
|
row[20] = 0.6;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.0;
|
|||
|
|
row[23] = 2;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 104;
|
|||
|
|
row[1] = "刘国";
|
|||
|
|
row[2] = 2002;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "化学系";
|
|||
|
|
row[5] = 2;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-100);
|
|||
|
|
row[8] = "刘国，男，22岁，出生于中国澳门的一个小山村，毕业于中国科学技术大学。<br/>刘国是作为交换生来中科大学习，在校期间认识了妻子董婷婷，虽然是被追到手了，不过在人前却总是说“老婆是我千辛万苦追来的！”。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,movie";
|
|||
|
|
row[11] = "2002-09-01";
|
|||
|
|
row[12] = 95;
|
|||
|
|
row[13] = 95;
|
|||
|
|
row[14] = 190;
|
|||
|
|
row[15] = 170;
|
|||
|
|
row[16] = 130;
|
|||
|
|
row[17] = 76;
|
|||
|
|
row[18] = 112;
|
|||
|
|
row[19] = 1.0;
|
|||
|
|
row[20] = 1.0;
|
|||
|
|
row[21] = 1.0;
|
|||
|
|
row[22] = 1.0;
|
|||
|
|
row[23] = 2;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 105;
|
|||
|
|
row[1] = "康颖颖";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "数学系";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-60);
|
|||
|
|
row[8] = "康颖颖，女，26岁，出生于中国福建的一个小山村，毕业于香港科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,travel,movie,music";
|
|||
|
|
row[11] = "2008-09-01";
|
|||
|
|
row[12] = 85;
|
|||
|
|
row[13] = 95;
|
|||
|
|
row[14] = 180;
|
|||
|
|
row[15] = 159;
|
|||
|
|
row[16] = 90;
|
|||
|
|
row[17] = 77;
|
|||
|
|
row[18] = 128;
|
|||
|
|
row[19] = 0.6;
|
|||
|
|
row[20] = 0.9;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 3;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 106;
|
|||
|
|
row[1] = "彭博";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "数学系";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "彭博，男，28岁，出生于中国浙江的一个小山村，毕业于电子科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "basketball,travel,music";
|
|||
|
|
row[11] = "2003-09-01";
|
|||
|
|
row[12] = 60;
|
|||
|
|
row[13] = 100;
|
|||
|
|
row[14] = 160;
|
|||
|
|
row[15] = 175;
|
|||
|
|
row[16] = 150;
|
|||
|
|
row[17] = 88;
|
|||
|
|
row[18] = 126;
|
|||
|
|
row[19] = 0.1;
|
|||
|
|
row[20] = 0.3;
|
|||
|
|
row[21] = 1.5;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 3;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 107;
|
|||
|
|
row[1] = "黄婷婷";
|
|||
|
|
row[2] = 2008;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "数学系";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "黄婷婷，女，25岁，出生于中国北方的一个小山村，毕业于北京科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "travel,movie,music,reading";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 100;
|
|||
|
|
row[13] = 80;
|
|||
|
|
row[14] = 180;
|
|||
|
|
row[15] = 160;
|
|||
|
|
row[16] = 80;
|
|||
|
|
row[17] = 70;
|
|||
|
|
row[18] = 110;
|
|||
|
|
row[19] = 0.8;
|
|||
|
|
row[20] = 0.8;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 3;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 108;
|
|||
|
|
row[1] = "唐超";
|
|||
|
|
row[2] = 2004;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "物理系";
|
|||
|
|
row[5] = 3;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "唐超，男，26岁，出生于中国河南的一个小山村，毕业于中国科学技术大学。<br/>作为刘国的同班同学，唐超是班里的尖子生，本科还没毕业就被哈佛大学录取了，现在好像还没毕业呢。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music,basketball";
|
|||
|
|
row[11] = "2004-09-01";
|
|||
|
|
row[12] = 80;
|
|||
|
|
row[13] = 80;
|
|||
|
|
row[14] = 160;
|
|||
|
|
row[15] = 188;
|
|||
|
|
row[16] = 130;
|
|||
|
|
row[17] = 82;
|
|||
|
|
row[18] = 130;
|
|||
|
|
row[19] = 0.5;
|
|||
|
|
row[20] = 0.8;
|
|||
|
|
row[21] = 1.3;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 3;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 109;
|
|||
|
|
row[1] = "杨婷婷";
|
|||
|
|
row[2] = 2004;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "物理系";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "杨婷婷，女，25岁，出生于中国广西的一个小山村，毕业于南方科学技术大学。<br/>杨婷婷的父母都是中科大的高材生，他们很高兴送女儿上一所前中科大校长创办的大学，而南科大自己颁发的学位文凭也颇受争议。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,movie";
|
|||
|
|
row[11] = "2003-09-01";
|
|||
|
|
row[12] = 90;
|
|||
|
|
row[13] = 60;
|
|||
|
|
row[14] = 150;
|
|||
|
|
row[15] = 166;
|
|||
|
|
row[16] = 110;
|
|||
|
|
row[17] = 70;
|
|||
|
|
row[18] = 116;
|
|||
|
|
row[19] = 0.8;
|
|||
|
|
row[20] = 1.0;
|
|||
|
|
row[21] = 0.8;
|
|||
|
|
row[22] = 1.0;
|
|||
|
|
row[23] = 5;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 110;
|
|||
|
|
row[1] = "徐鹏";
|
|||
|
|
row[2] = 2002;
|
|||
|
|
row[3] = false;
|
|||
|
|
row[4] = "物理系";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-50);
|
|||
|
|
row[8] = "徐鹏，男，23岁，出生于中国安徽的一个小山村，毕业于国防科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,basketball,travel";
|
|||
|
|
row[11] = "2002-09-01";
|
|||
|
|
row[12] = 60;
|
|||
|
|
row[13] = 90;
|
|||
|
|
row[14] = 150;
|
|||
|
|
row[15] = 198;
|
|||
|
|
row[16] = 145;
|
|||
|
|
row[17] = 83;
|
|||
|
|
row[18] = 128;
|
|||
|
|
row[19] = 1.2;
|
|||
|
|
row[20] = 1.5;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.5;
|
|||
|
|
row[23] = 5;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 111;
|
|||
|
|
row[1] = "纪婷婷";
|
|||
|
|
row[2] = 2012;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "自动化系";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 0;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-5);
|
|||
|
|
row[8] = "纪婷婷，女，22岁，出生于中国台湾的一个小山村，毕业于台湾科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music,basketball";
|
|||
|
|
row[11] = "2006-09-01";
|
|||
|
|
row[12] = 90;
|
|||
|
|
row[13] = 70;
|
|||
|
|
row[14] = 160;
|
|||
|
|
row[15] = 158;
|
|||
|
|
row[16] = 76;
|
|||
|
|
row[17] = 69;
|
|||
|
|
row[18] = 109;
|
|||
|
|
row[19] = 0.8;
|
|||
|
|
row[20] = 0.6;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 5;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
|
|||
|
|
row = table.NewRow();
|
|||
|
|
row[0] = 112;
|
|||
|
|
row[1] = "张一驰";
|
|||
|
|
row[2] = 2012;
|
|||
|
|
row[3] = true;
|
|||
|
|
row[4] = "材料科学与工程系";
|
|||
|
|
row[5] = 5;
|
|||
|
|
row[6] = 1;
|
|||
|
|
row[7] = DateTime.Now.AddDays(-5);
|
|||
|
|
row[8] = "张一驰，男，28岁，出生于中国河南的一个小山村，毕业于中国科学技术大学。";
|
|||
|
|
row[9] = Guid.NewGuid();
|
|||
|
|
row[10] = "reading,movie,music";
|
|||
|
|
row[11] = "2000-09-01";
|
|||
|
|
row[12] = 99;
|
|||
|
|
row[13] = 98;
|
|||
|
|
row[14] = 197;
|
|||
|
|
row[15] = 183;
|
|||
|
|
row[16] = 125;
|
|||
|
|
row[17] = 80;
|
|||
|
|
row[18] = 120;
|
|||
|
|
row[19] = 0.8;
|
|||
|
|
row[20] = 0.6;
|
|||
|
|
row[21] = 1.2;
|
|||
|
|
row[22] = 1.2;
|
|||
|
|
row[23] = 5;
|
|||
|
|
table.Rows.Add(row);
|
|||
|
|
|
|||
|
|
return table;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取空数据表
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
protected DataTable GetEmptyDataTable()
|
|||
|
|
{
|
|||
|
|
DataTable table = new DataTable();
|
|||
|
|
table.Columns.Add(new DataColumn("Id", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Name", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("EntranceYear", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("AtSchool", typeof(bool)));
|
|||
|
|
table.Columns.Add(new DataColumn("Major", typeof(String)));
|
|||
|
|
table.Columns.Add(new DataColumn("Group", typeof(int)));
|
|||
|
|
table.Columns.Add(new DataColumn("Gender", typeof(int)));
|
|||
|
|
|
|||
|
|
|
|||
|
|
return table;
|
|||
|
|
}
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 压缩ViewState
|
|||
|
|
|
|||
|
|
//protected override object LoadPageStateFromPersistenceMedium()
|
|||
|
|
//{
|
|||
|
|
// string gzippedState = Request.Form[StringUtil.GZIPPED_VIEWSTATE_ID];
|
|||
|
|
// return StringUtil.LoadGzippedViewState(gzippedState);
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
//protected override void SavePageStateToPersistenceMedium(object viewState)
|
|||
|
|
//{
|
|||
|
|
// ClientScript.RegisterHiddenField(StringUtil.GZIPPED_VIEWSTATE_ID, StringUtil.GenerateGzippedViewState(viewState));
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region 实用函数
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取回发的参数
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string GetRequestEventArgument()
|
|||
|
|
{
|
|||
|
|
return Request.Form["__EVENTARGUMENT"];
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 显示通知对话框
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="message"></param>
|
|||
|
|
public void ShowNotify(string message)
|
|||
|
|
{
|
|||
|
|
Alert.Show(message);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region GetDeleteSelectedRowsScript
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除表格选中行（FineUI v6.0更新：必须加上延迟，否则弹出框会阻止事件向上传播，导致不能选中单元格！！）
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="grid1"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
protected string GetDeleteScript(Grid grid1)
|
|||
|
|
{
|
|||
|
|
string confirmScript = Confirm.GetShowReference("删除选中行？", String.Empty, MessageBoxIcon.Question, grid1.GetDeleteSelectedRowsReference(), String.Empty);
|
|||
|
|
|
|||
|
|
return String.Format("F.defer(function(){{{0}}},100);", confirmScript);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|