public CsSystemUsers GetModel(int primaryKey) { var strSql = "SELECT * FROM CrabShop.dbo.[CsSystemUsers] WHERE SysUserId = @primaryKey"; return(DbClient.Query <CsSystemUsers>(strSql, new { primaryKey }).FirstOrDefault()); }
public List <CsSystemUsers> GetModelList(string where) { var strSql = $"SELECT * FROM CrabShop.dbo.[CsSystemUsers] WHERE 1 = 1 {where}"; return(DbClient.Query <CsSystemUsers>(strSql).ToList()); }
public bool Delete(int primaryKey) { var strSql = "DELETE FROM CrabShop.dbo.[CsSystemUsers] WHERE SysUserId = @primaryKey"; return(DbClient.Excute(strSql, new { primaryKey }) > 0); }
public int DeleteByWhere(string where) => DbClient.Excute($"DELETE FROM CrabShop.dbo.[CsSystemUsers] WHERE 1 = 1 {where}");
public CsPrice GetModel(int primaryKey) { var strSql = "SELECT * FROM CrabShop.dbo.[CsPrice] WHERE PriceId = @primaryKey"; return(DbClient.Query <CsPrice>(strSql, new { primaryKey }).FirstOrDefault()); }
public bool ExistsByWhere(string where) => DbClient.ExecuteScalar <int>($"SELECT COUNT(1) FROM CrabShop.dbo.[CsSystemUsers] WHERE 1 = 1 {where};") > 0;
public CsUsers GetModelByTelPhone(string telPhone) { var strSql = $"select top 1 * from CsUsers where UserPhone='{telPhone}' "; return(DbClient.Query <CsUsers>(strSql).FirstOrDefault()); }
public bool Delete(int primaryKey) { var strSql = "DELETE FROM CrabShop.dbo.[CsPrice] WHERE PriceId = @primaryKey"; return(DbClient.Excute(strSql, new { primaryKey }) > 0); }
public CsUsers GetModel(string openId) { var strSql = "SELECT * FROM CrabShop.dbo.[CsUsers] WHERE OpenId = @openId"; return(DbClient.Query <CsUsers>(strSql, new { openId }).FirstOrDefault()); }
public List <CsOrderDetail> GetModelList(string where) { var strSql = $"SELECT * FROM CrabShop.dbo.[CsOrderDetail] WHERE 1 = 1 {where}"; return(DbClient.Query <CsOrderDetail>(strSql).ToList()); }
public CsOrderDetail GetModel(int primaryKey) { var strSql = "SELECT * FROM CrabShop.dbo.[CsOrderDetail] WHERE DetailId = @primaryKey"; return(DbClient.Query <CsOrderDetail>(strSql, new { primaryKey }).FirstOrDefault()); }
public int DeleteByWhere(string where) => DbClient.Excute($"DELETE FROM CrabShop.dbo.[CsOrderDetail] WHERE 1 = 1 {where}");
public int DeleteByWhere(string where) => DbClient.Excute($"DELETE FROM CrabShop.dbo.[CsCsDistrict] WHERE 1 = 1 {where}");