//获取子类
protected void GetChildClass(int parentID)
{
jiantou += "---";
string cmdText = "select * from " + TableName + " where ParentID=" + parentID + " order by OrderBy asc";
DataTable list = new YK.Core.SqlHelper().GetDataSet(cmdText).Tables[0];
if (list.Rows.Count > 0)
{
foreach (DataRow dr in list.Rows)
{
ListItem li = new ListItem();
li.Value = dr["ID"].ToStr();
li.Text = jiantou + dr[NameField].ToStr();
DDLMenu.Items.Add(li);
//再次查询子类
GetChildClass(dr["ID"].ToInt());
}
}
//每推出一次循环jiantou减少两个>>符号
jiantou = jiantou.Substring(0, jiantou.Length - 3);
}
DataTable dt = new DataTable(); //记录类别信息，绑定到Repeater，采用递归方式记录
//加载
public void LoadDataBind()
{
string cmdText = "select * from " + TableName + " where ParentID=0 order by OrderBy asc";
DataTable list = new YK.Core.SqlHelper().GetDataSet(cmdText).Tables[0];
foreach (DataRow dr in list.Rows)
{
ListItem li = new ListItem();
li.Value = dr["ID"].ToStr();
li.Text = dr[NameField].ToStr();
DDLMenu.Items.Add(li);
jiantou = "";//记录级别
//获取子类
GetChildClass(dr["ID"].ToInt());
}
ListItem li2 = new ListItem();
li2.Text = "==请选择==";
li2.Value = "0";
DDLMenu.Items.Insert(0, li2);
}
protected void Page_Load(object sender, EventArgs e)
{
_logger.Info("hello");
Response.Write(545646.GetType().Name);
Response.Write("adfasdfaf".GetType().Name);
aaaa aa = new aaaa();
foreach (var prop in aa.GetType().GetProperties())
{
Type typex = Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType;
Response.Write(typex.Name + "<br/>");
}
DataSet ds = new YK.Core.SqlHelper().GetDataSet("select top 0 * from dbo.TB_Admin_Resources");
foreach (DataColumn cn in ds.Tables[0].Columns)
{
Response.Write(cn.DataType + "<br/>");
}
object[] paras = new object[1] {
1
};
Type type = Type.GetType("_Default");
object obj = Activator.CreateInstance(type, null);
Type[] types = new Type[1];
for (int i = 0; i < paras.Length; i++)
{
types[i] = paras[i].GetType();
}
MethodInfo methodInfo = type.GetMethod("GetCount", types);
Response.Write(methodInfo.Invoke(obj, paras));
//
//Response.Write(type.InvokeMember("GetCount", BindingFlags.InvokeMethod, null, obj, paras));
string name = "家用电器";
var list2 = YK.Service.ProductService.CategoryService.Search(w => w.CategoryName != name && w.ID > 8);
var list = YK.Service.ProductService.CategoryService.Search(w => w.CategoryName.Like(name));
List <object> arr = new List <object>()
{
"家用电器"
};
var list3 = YK.Service.ProductService.CategoryService.Search(w => w.CategoryName.In(arr) && w.ID < 8);
}