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);
}
