/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Message model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_message(");
sql.Append("userid,type,name,mail,message,ip,time,status,admin,mobile,qq,msgtitle");
sql.Append(") values (");
sql.Append("@userid,@type,@name,@mail,@message,@ip,@time,@status,@admin,@mobile,@qq,@msgtitle");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.AdPositionCopy model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_ad_position_copy(");
sql.Append("name,type,width,height,description,status");
sql.Append(") values (");
sql.Append("@name,@type,@width,@height,@description,@status");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Coupons model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_coupons(");
sql.Append("coupon_type_id,coupon_sn,user_id,used_time,order_id,emailed");
sql.Append(") values (");
sql.Append("@coupon_type_id,@coupon_sn,@user_id,@used_time,@order_id,@emailed");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
public bool AddTTHCByPaging(List <ThuTucHanhChinhBo> items)
{
try
{
using (IDbConnection conn = Connection)
{
conn.Open();
var table = items.ToDataTable();
var parameters = new DynamicParameters();
parameters.AddDynamicParams(new { ThuTucTVP = table.AsTableValuedParameter() });
var readers = conn.Query("TTHC_ThuTucHanhChinh_Bo_ByPaging_Ins", parameters, commandType: CommandType.StoredProcedure);
return(true);
}
}
catch (Exception ex)
{
_logger.Error(ex.Message);
return(false);
}
}
/// <summary>
/// 查询列表(分页)
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="strSql">SQL语句</param>
/// <param name="dbParameter">参数</param>
/// <param name="pagination">分页数据</param>
/// <returns></returns>
public IEnumerable <T> FindList <T>(string strSql, object dbParameter, Pagination pagination) where T : class
{
int total = pagination.records;
pagination.sidx = SqlHelper2.SqlFilters(pagination.sidx);
if (string.IsNullOrEmpty(pagination.sidx))
{
pagination.sidx = "";
pagination.sord = "asc";
}
if (dbWhere != null)
{
int orderIndex = strSql.ToUpper().IndexOf("ORDER BY");
if (orderIndex > 0)
{
strSql = strSql.Substring(0, orderIndex);
string orderString = strSql.Substring(orderIndex);
strSql = string.Format(" select * From ({0})t Where {1} {2} ", strSql, dbWhere.sql, orderString);
}
else
{
strSql = string.Format(" select * From ({0})t Where {1} ", strSql, dbWhere.sql);
}
DynamicParameters dynamicParameters = SqlHelper.FieldValueParamToParameter(dbWhere.dbParameters);
dynamicParameters.AddDynamicParams(dbParameter);
var data = db.FindList <T>(strSql, dynamicParameters, pagination.sidx, pagination.sord.ToLower() == "asc" ? true : false, pagination.rows, pagination.page, out total);
pagination.records = total;
return(data);
}
else
{
var data = db.FindList <T>(strSql, dbParameter, pagination.sidx, pagination.sord.ToLower() == "asc" ? true : false, pagination.rows, pagination.page, out total);
pagination.records = total;
return(data);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.RoleUser model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_role_user(");
sql.Append("role_id,user_id");
sql.Append(") values (");
sql.Append("@role_id,@user_id");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
public IEnumerable <AuthorEM> GetAuthors(AuthorFilterEM filter, int pageSize, int pageNumber, out int total, string sortColumn = null, bool descendingSortOrder = false)
{
using (SqlConnection db = new SqlConnection(connectionString))
{
var spParams = new DynamicParameters();
spParams.Add("PageSize", pageSize);
spParams.Add("PageNumber", pageNumber);
if (sortColumn != null)
{
spParams.Add("SortColumn", sortColumn);
spParams.Add("DescendingOrder", descendingSortOrder);
}
spParams.Add("Total", dbType: DbType.Int32, direction: ParameterDirection.Output);
spParams.AddDynamicParams(filter);
var result = db.Query <AuthorEM>("USP_GetAuthors", spParams, commandType: CommandType.StoredProcedure).ToList();
total = spParams.Get <int>("Total");
return(result);
}
}
public async Task <Student> CreateStudent(Student newStudent)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
var values = new
{
firstName = newStudent.FirstName,
middleName = newStudent.MiddleName,
lastName = newStudent.LastName,
emailAddress = newStudent.EmailAddress
};
var parameters = new DynamicParameters();
parameters.AddDynamicParams(values);
parameters.Add("id", dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.Output);
await connection.QueryAsync("CreateStudent", parameters, commandType : System.Data.CommandType.StoredProcedure);
var newId = parameters.Get <int>("id");
var createdStudent = await connection.QueryFirstAsync <Student>($"SELECT Id, FirstName, MiddleName, LastName, EmailAddress FROM Student WHERE Id = {newId}");
return(createdStudent);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Order model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_order(");
sql.Append("sn,product_id,status,pay_statu,username,name,uid,seller_id,tel,mobile,email,add_time,rest_time,countdown,pay_time,pay_id,discount,coupon,price,num,total_fee,pay_fee,trade_no,txt,del,del_time,send_mail,fee,ensure,techfee,deposit");
sql.Append(") values (");
sql.Append("@sn,@product_id,@status,@pay_statu,@username,@name,@uid,@seller_id,@tel,@mobile,@email,@add_time,@rest_time,@countdown,@pay_time,@pay_id,@discount,@coupon,@price,@num,@total_fee,@pay_fee,@trade_no,@txt,@del,@del_time,@send_mail,@fee,@ensure,@techfee,@deposit");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.ProductAttr model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_product_attr(");
sql.Append("product_id,attr_pid,attr_id,attr_value,input");
sql.Append(") values (");
sql.Append("@product_id,@attr_pid,@attr_id,@attr_value,@input");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Complaint model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_complaint(");
sql.Append("uid,tszname,tszmobile,tszqq,ywname,body,tspic1,add_time,resp_time,click,anonmity,savepath,resp");
sql.Append(") values (");
sql.Append("@uid,@tszname,@tszmobile,@tszqq,@ywname,@body,@tspic1,@add_time,@resp_time,@click,@anonmity,@savepath,@resp");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.ProductImg model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_product_img(");
sql.Append("product_id,title,thumb,picture");
sql.Append(") values (");
sql.Append("@product_id,@title,@thumb,@picture");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// Gets the lookup data.
/// </summary>
/// <param name="Status">if set to <c>true</c> [status].</param>
/// <returns>IList<Lookup>.</returns>
public IList <Lookup> GetLookupData(bool Status, int StartRowIndex, int PageSize, ref int Total, string SortExpression, string SearchText)
{
List <Lookup> Course = new List <Lookup>();
using (var conn = new SqlConnection(DBHelper.ConnectionString))
{
conn.Open();
DynamicParameters dbParam = new DynamicParameters();
dbParam.AddDynamicParams(new { Status = Status, StartRowIndex = StartRowIndex, PageSize = PageSize, SortExpression = SortExpression, SearchText = SearchText });
using (var multi = conn.QueryMultiple("TMS_lookup_GetAll", dbParam, commandType: System.Data.CommandType.StoredProcedure))
{
Course = multi.Read <Lookup>().AsList <Lookup>();
if (!multi.IsConsumed)
{
Total = multi.Read <int>().FirstOrDefault <int>();
}
}
conn.Close();
}
return(Course.ToList());
// return ExecuteList<Lookup>("Select * from Lookup where IsActive=@IsActive", ParamBuilder.Par("@IsActive", Status));
}
/// <summary>
/// TMSs the groups get all dal.
/// </summary>
/// <param name="Culture">The culture.</param>
/// <returns>IList<SecurityGroups>.</returns>
public IList <SecurityGroups> TMS_Groups_GetAllDAL(int page, string Culture, int StartRowIndex, int PageSize, ref int Total, string SortExpression, string SearchText)
{
List <SecurityGroups> groups = new List <SecurityGroups>();
using (var conn = new SqlConnection(DBHelper.ConnectionString))
{
conn.Open();
DynamicParameters dbParam = new DynamicParameters();
dbParam.AddDynamicParams(new { Culture = Culture, StartRowIndex = StartRowIndex, PageSize = PageSize, SortExpression = SortExpression, SearchText = SearchText, page = page });
using (var multi = conn.QueryMultiple("TMS_Groups_GetAll", dbParam, commandType: System.Data.CommandType.StoredProcedure))
{
groups = multi.Read <SecurityGroups>().AsList <SecurityGroups>();
if (!multi.IsConsumed)
{
Total = multi.Read <int>().FirstOrDefault <int>();
}
}
conn.Close();
}
return(groups.ToList());
// return ExecuteListSp<SecurityGroups>("TMS_Groups_GetAll", ParamBuilder.Par("Culture", Culture));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Ask model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_ask(");
sql.Append("product_id,user_id,username,ip,time,update_time,content,status,replay,pid,is_user");
sql.Append(") values (");
sql.Append("@product_id,@user_id,@username,@ip,@time,@update_time,@content,@status,@replay,@pid,@is_user");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.AskReply model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_ask_reply(");
sql.Append("id,content,user_id,ask_id,reply_time,enable");
sql.Append(") values (");
sql.Append("@id,@content,@user_id,@ask_id,@reply_time,@enable");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Favorites model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_favorites(");
sql.Append("user_id,product_id,add_time,type");
sql.Append(") values (");
sql.Append("@user_id,@product_id,@add_time,@type");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 更新命令
/// </summary>
/// <param name="table"></param>
/// <param name="fields"></param>
/// <param name="filters"></param>
/// <returns></returns>
public SqlCommand UpdateCommand(string table, FieldsCollection fields, IEnumerable <Filter> filters)
{
if (fields == null || fields.Count == 0)
{
throw new ApplicationException("Invalid fields can be update.");
}
if (string.IsNullOrEmpty(table))
{
throw new ApplicationException("Invalid table's name.");
}
var param = new DynamicParameters();
var columnStrs = new List <string>();
var filterStrs = new List <string>();
foreach (var field in fields)
{
columnStrs.Add($"`{field.Name}`=@{field.Name}");
param.Add(field.Name, field.Value);
}
if (filters != null)
{
foreach (var filter in filters)
{
var filterCommand = filter.ToSqlCommand();
if (filterCommand != null)
{
filterStrs.Add(filterCommand.SqlString);
param.AddDynamicParams(filterCommand.Parameters);
}
}
}
string strSql = $@"UPDATE `{table}` SET {string.Join(",", columnStrs)}
{(filterStrs.Count > 0 ? $" WHERE {string.Join(" AND ", filterStrs)}" : "")};";
return(new SqlCommand(strSql, param));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Config model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_config(");
sql.Append("name,config,status,site_id");
sql.Append(") values (");
sql.Append("@name,@config,@status,@site_id");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 获取查询对象
/// </summary>
/// <param name="strSql">sql语句</param>
/// <param name="dbParameter">参数</param>
/// <returns></returns>
public object FindObject(string strSql, object dbParameter)
{
if (dbWhere != null)
{
int orderIndex = strSql.ToUpper().IndexOf("ORDER BY");
if (orderIndex > 0)
{
strSql = strSql.Substring(0, orderIndex);
string orderString = strSql.Substring(orderIndex);
strSql = string.Format(" select * From ({0})t Where {1} {2} ", strSql, dbWhere.sql, orderString);
}
else
{
strSql = string.Format(" select * From ({0})t Where {1} ", strSql, dbWhere.sql);
}
DynamicParameters dynamicParameters = SqlHelper.FieldValueParamToParameter(dbWhere.dbParameters);
dynamicParameters.AddDynamicParams(dbParameter);
return(db.FindObject(strSql, dynamicParameters));
}
else
{
return(db.FindObject(strSql, dbParameter));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Email model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_email(");
sql.Append("email,code,add_time,user_id,is_used");
sql.Append(") values (");
sql.Append("@email,@code,@add_time,@user_id,@is_used");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Wuyiju.Model.RoleUser model)
{
StringBuilder sql = new StringBuilder();
sql.Append("update RoleUser set ");
sql.Append(" role_id = @role_id , ");
sql.Append(" user_id = @user_id ");
sql.Append(" where ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("更新数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Buy model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_buy(");
sql.Append("title,sn,brief,cate_id,type,level,level_child,detail,start_price,end_price,validDay,stocks,status,v_status,p_status,remark,qq,user_name,mobile,good_rating,user_id,rating,add_time,created,credentials,click,role_id,admin_id");
sql.Append(") values (");
sql.Append("@title,@sn,@brief,@cate_id,@type,@level,@level_child,@detail,@start_price,@end_price,@validDay,@stocks,@status,@v_status,@p_status,@remark,@qq,@user_name,@mobile,@good_rating,@user_id,@rating,@add_time,@created,@credentials,@click,@role_id,@admin_id");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Payment model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_payment(");
sql.Append("pay_name,pay_code,pay_desc,pay_logo,enabled,pay_order,pay_content,pay_fee,partner_id,partner_key,is_online");
sql.Append(") values (");
sql.Append("@pay_name,@pay_code,@pay_desc,@pay_logo,@enabled,@pay_order,@pay_content,@pay_fee,@partner_id,@partner_key,@is_online");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.FinanceAccount model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_finance_account(");
sql.Append("user_id,username,money,frozen_money,rank_points,points,add_time,descm,type");
sql.Append(") values (");
sql.Append("@user_id,@username,@money,@frozen_money,@rank_points,@points,@add_time,@descm,@type");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.UserInfo model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_user_info(");
sql.Append("user_id,region_lv1,region_lv2,region_lv3,region_lv4,region_values,sex,brithday,blog,info,share_num,like_num,follow_num,fans_num,constellation,job,qq,realname,alipay,rank,money,frozen_money,points,rank_points,forum,salt,is_validated");
sql.Append(") values (");
sql.Append("@user_id,@region_lv1,@region_lv2,@region_lv3,@region_lv4,@region_values,@sex,@brithday,@blog,@info,@share_num,@like_num,@follow_num,@fans_num,@constellation,@job,@qq,@realname,@alipay,@rank,@money,@frozen_money,@points,@rank_points,@forum,@salt,@is_validated");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.Wantlearn model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_wantlearn(");
sql.Append("user_id,wl_content,add_time");
sql.Append(") values (");
sql.Append("@user_id,@wl_content,@add_time");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
internal static int Update <T>(this DbConnection conn, T obj, IQuery <T> where, int?commandTimeout = null) where T : BaseDBModel
{
if (obj.GetDBModel_ChangeList().Count == 0)
{
throw new Exception("没有修改列");
}
var elst = obj.GetDBModel_PKCols().AddRange(obj.GetDBModel_ExcludeColsForUpdate());
var updateList = obj.GetDBModel_ChangeList().Where(m => m != obj.GetDBModel_IncrementCol() && !elst.Contains(m)).ToList();
var sql = new StringBuilder($"UPDATE [{DBTool.GetTableName(obj)}] SET {GetSql(updateList, ",")} WHERE 1=1");
DynamicParameters dynamicParameters = SetWhereSql(where, sql);
dynamicParameters.AddDynamicParams(obj);
try
{
return(conn.Execute(sql: sql.ToString(), param: dynamicParameters, commandTimeout: commandTimeout));
}
catch (Exception e)
{
DBTool.DbError(e, sql.ToString() + JsonHelper.ToJSON(obj) + ToIQueryJSON(dynamicParameters, where) + ExceptionTool.ToString(e));
throw;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.DepositBankCard model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_deposit_bank_card(");
sql.Append("user_id,real_name,region_lv1,region_lv2,region_lv3,bank_name,bank_subname,card_number,add_time");
sql.Append(") values (");
sql.Append("@user_id,@real_name,@region_lv1,@region_lv2,@region_lv3,@bank_name,@bank_subname,@card_number,@add_time");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Insert(Wuyiju.Model.FinanceCash model)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into ec_finance_cash(");
sql.Append("user_id,uname,money,points,remark,add_time,ip,reply,status,realname,alipay,is_money");
sql.Append(") values (");
sql.Append("@user_id,@uname,@money,@points,@remark,@add_time,@ip,@reply,@status,@realname,@alipay,@is_money");
sql.Append(") ");
DynamicParameters param = new DynamicParameters();
if (model != null)
{
param.AddDynamicParams(model);
}
var rows = db.Execute(sql, param);
if (rows < 1)
{
throw new ApplicationException("插入数据无效");
}
}
public void QueryTyped_WithAnonymousParamsAndOutParam_Executes()
{
using (var c = _dataAndSchema.GetConnection())
{
c.Open();
var args = new DynamicParameters();
args.AddDynamicParams(new { Val = _dataAndSchema.Value.ToString() });
args.Add("@affected", null, DbType.Int32, ParameterDirection.InputOutput);
var result = c.Query<EntityBar>(
SqlDataAndSchema.SprocNameDapperSingleInSingleOutParam,
args,
commandType: CommandType.StoredProcedure).FirstOrDefault();
var outparam = args.Get<int>("@affected");
Assert.IsNotNull(result);
Assert.IsTrue(outparam == 1);
}
}
