public void Test() { DbAccessor dba = DbAccessor.Get(); var result = dba.QueryDictionaries("select * from sys_user"); Console.WriteLine(result.Count); }
public void TestEntityExtenstions() { var proId = 112; DbAccessor dba = DbAccessor.Get(); var pro = dba.Select <SysProduct>(proId); dba.Delete <SysProduct>(proId); pro = dba.Select <SysProduct>(new { ProductId = proId }); var pors = dba.SelectList <SysProduct>(new { ProductName = "zwb" }); }
public IList <SecPermission> GetListByUserId(string userId) { DbAccessor dba = DbAccessor.Get(); string strSql = @"SELECT * FROM Sec_Permission a WHERE a.Status=1 and EXISTS ( SELECT NULL FROM Sec_RolePermission rp WHERE a.PermissionId = rp.PermissionId AND rp.RoleId IN ( SELECT RoleId FROM Sec_UserRole ur WHERE ur.UserId = #UserId# ) ) "; return(dba.QueryEntities <SecPermission>(strSql, new { UserId = userId })); }
public void Test() { string filePath = @"C:\Users\zwb\Desktop\cartype.xlsx"; using (var fs = new FileStream(filePath, FileMode.Open)) { var dt = new WorkbookDataAdapter(new XSSFWorkbook(fs)) //.SetColumnNameMapping(dic) .AddOnRowAdapt(c => { return(true); }).ToDataTable(); DbAccessor dba = DbAccessor.Get(); foreach (DataRow dr in dt.Rows) { foreach (DataColumn dc in dt.Columns) { //if (dc.ColumnName.ToUpper() == "STATUS" || dc.ColumnName.ToUpper()== "BELONGTTYPE") //{ // dr[dc.ColumnName] = Int16.Parse(dr[dc.ColumnName].ToString()); //} if (string.IsNullOrEmpty(dr[dc.ColumnName].ToString())) { dr[dc.ColumnName] = DBNull.Value; } } } dt.TableName = "Biz_Cartype"; dba.BulkWriteToServer(dt); Console.WriteLine(); } }
public static ContentResult GetDataGridPageData() { string strSql = HttpContext.Current.Request.QueryString["sql"]; if (strSql.Trim().Contains(" ")) { throw new Exception("参数“sql”格式错误!"); } string strOrderBy = HttpContext.Current.Request.QueryString["orderby"]; int page = Convert.ToInt32(HttpContext.Current.Request.Form["page"]); int rows = Convert.ToInt32(HttpContext.Current.Request.Form["rows"]); DbAccessor dba = DbAccessor.Get(); ContentResult cr = new ContentResult(); Dictionary <string, object> dicParam = new Dictionary <string, object>(); foreach (string key in HttpContext.Current.Request.Form.Keys) { if (key.StartsWith("Filter_")) { dicParam.Add(key.Replace("Filter_", ""), HttpContext.Current.Request.Form[key]); } } DataGridModel model = new DataGridModel(); int totalRowCount = 0; model.rows = dba.PageQueryDataTable(strSql, strOrderBy, page, rows, out totalRowCount, dicParam); model.total = totalRowCount; cr.Content = Newtonsoft.Json.JsonConvert.SerializeObject(model, new Newtonsoft.Json.Converters.DataTableConverter()); return(cr); }
public void AddLog(Sys_Log log) { DbAccessor dba = DbAccessor.Get(); dba.Insert <Sys_Log>(log); }