re: 浅谈项目经理的项目管理

火无极 — Tue, 22 Jul 2008 08:14:18 GMT

顶一个,顺便沙发起

火无极 2008-07-22 16:14 发表评论

re: Asp.net AJAX 返回从服务器端返回DataTable

Xuemin_Zhang — Mon, 16 Jun 2008 11:04:34 GMT

我反汇编了Prieview.dll，用其中的代码写了DataTableConverter.但调试时出现死循环，不知道什么情况？
以下是代码：
public class DataTableConverter1:JavaScriptConverter
{
protected virtual string GetClientTypeNameForType(Type type)
{
if (typeof(string).IsAssignableFrom(type) || typeof(char).IsAssignableFrom(type))
{
return "String";
}
if (typeof(bool).IsAssignableFrom(type))
{
return "Boolean";
}
if (typeof(DateTime).IsAssignableFrom(type))
{
return "Date";
}
if (((!typeof(int).IsAssignableFrom(type) && !typeof(double).IsAssignableFrom(type)) && (!typeof(float).IsAssignableFrom(type) && !typeof(long).IsAssignableFrom(type))) && (((!typeof(short).IsAssignableFrom(type) && !typeof(byte).IsAssignableFrom(type)) && (!typeof(uint).IsAssignableFrom(type) && !typeof(ulong).IsAssignableFrom(type))) && (!typeof(ushort).IsAssignableFrom(type) && !typeof(sbyte).IsAssignableFrom(type))))
{
return "Object";
}
return "Number";
}

protected virtual IDictionary SerializeDataColumn(DataColumn column, bool isPrimaryKeyColumn, JavaScriptSerializer serializer)
{
IDictionary dictionary = new Dictionary(5);
dictionary["name"] = column.ColumnName;
dictionary["dataType"] = this.GetClientTypeNameForType(column.DataType);
dictionary["defaultValue"] = (column.DefaultValue == DBNull.Value) ? null : column.DefaultValue;
dictionary["readOnly"] = column.ReadOnly;
dictionary["isKey"] = isPrimaryKeyColumn;
return dictionary;
}
public override object Deserialize(IDictionary dictionary, Type type, JavaScriptSerializer serializer)
{
throw new NotImplementedException();
}

public override IDictionary Serialize(object obj, JavaScriptSerializer serializer)
{
DataTable dt = obj as DataTable;
if (dt != null)
{
IDictionary dictionary = new Dictionary(2);
//行值列表
if (dt.Columns.Count > 0)
{
IDictionary[] dictionaryArray = new Dictionary[dt.Columns.Count];
DataColumn[] primaryKey = dt.PrimaryKey;
int index = 0;
//用这个Dictionary存列名和列值
foreach (DataColumn column in primaryKey)
{
dictionaryArray[index] = this.SerializeDataColumn(column, true, serializer);
index++;
}
for (int i = 0; index < dictionaryArray.Length; i++)
{
DataColumn column2 = dt.Columns[i];
if (Array.IndexOf(primaryKey, column2) == -1)
{
dictionaryArray[index] = this.SerializeDataColumn(column2, false, serializer);
index++;
}
}
dictionary["columns"] = dictionaryArray;
}
else
{
dictionary["columns"] = null;
}
if (dt.Rows.Count > 0)
{
DataRow[] rowArray = new DataRow[dt.Rows.Count];
for (int j = 0; j < rowArray.Length; j++)
{
rowArray[j] = dt.Rows[j];
}
dictionary["rows"] = rowArray;
return dictionary;
}
dictionary["rows"] = null;
return dictionary;
}
return new Dictionary();
}

///

/// 把DataTable定义成支持的类型
///

public override IEnumerable SupportedTypes
{
get
{
return new ReadOnlyCollection(new Type[] { typeof(DataTable) });
}
}
}
以下是使用的代码：
[WebMethod]
[ScriptMethod]
public string ReturnDataTable()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Sex", typeof(string)));
dt.Columns.Add(new DataColumn("Salary", typeof(string)));

DataRow drNew = dt.NewRow();
drNew["Name"] = "Rose Zhao";
drNew["Sex"] = "Female";
drNew["Salary"] = "2000";
dt.Rows.Add(drNew);

drNew = dt.NewRow();
drNew["Name"] = "King Zheng";
drNew["Sex"] = "male";
drNew["Salary"] = "3000";
dt.Rows.Add(drNew);

JavaScriptSerializer serializer = new JavaScriptSerializer();
serializer.RegisterConverters(new JavaScriptConverter[] { new Nimeux.DataConverter.DataTableConverter1() });

string temp = serializer.Serialize(dt);
return temp;
}

Xuemin_Zhang 2008-06-16 19:04 发表评论