/// <summary> /// 获取商家的关键字 /// </summary> /// <param name="userid">商家ID</param> /// <param name="pagesize">N条,默认10</param> /// <param name="pageindex">前N页,默认1,-1不分页</param> /// <returns></returns> public ActionResult GetKeywordOfSaleman(int userid, int pagesize = 10, int pageindex = 1) { var keys = new DataTable(); if (pageindex != -1) { keys = db.Select(pagesize, pageindex, "vw_key_user", "ukid", string.Format("uid={0}", userid), ""); } else { keys = db.Select("vw_key_user", string.Format("uid={0}", userid), ""); } return GetJson(keys.ToJson()); }
private void btn_test_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("col"); DataRow row = dt.NewRow(); row["col"] = "test"; dt.Rows.Add(row); string josn_test = dt.ToJson(); BsonDocument doc_test = dt.ToBsonDocument(); MongoHelper.insert_bson(doc_test); }
/// <summary> /// 加载数据库表字段 返回JSon /// </summary> /// <returns></returns> public ActionResult GetFieldTreeJson(string tableCode) { StringBuilder sb = new StringBuilder(); DataTable dt = new DataTable(); if (ConfigHelper.AppSettings("CodeMaticMode") == "PowerDesigner") { dt = codematicbll.GetColumns(tableCode); } else if (ConfigHelper.AppSettings("CodeMaticMode") == "DataBase") { dt = base_databasebll.GetColumnList(tableCode); dt.Columns["column"].ColumnName = "column_Name"; dt.Columns["datatype"].ColumnName = "data_type"; dt.Columns["length"].ColumnName = "char_col_decl_length"; dt.Columns["remark"].ColumnName = "comments"; } return Content(dt.ToJson()); }