public int InsertSerial(MyBagSerial my)
{
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@SerialId", Guid.NewGuid()),
new SqlParameter("@UserId", my.UserId),
new SqlParameter("@BagAmount", my.BagAmount),
new SqlParameter("@CreateTime", my.CreateTime),
new SqlParameter("@RID", my.RID)
};
var result = @"INSERT INTO [dbo].[BagSerial]
([SerialId]
,[RID]
,[UserId]
,[BagAmount]
,[CreateTime])
VALUES
(@SerialId
,@RID
,@UserId
,@BagAmount
,@CreateTime)";
var r = Dapper.Helper.SQLHelper.Execute(result, sp, CommandType.Text);
return(r);
}
public List <MyBagSerial> GetUserSerialList(MyBagSerial my)
{
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@RID", my.RID)
};
var result = Dapper.Helper.SQLHelper.QueryDataSet(@"select * from [dbo].[BagSerial] b left join [dbo].[UserInfo] u
on b.UserId = u.UserId
where b.RID =@RID ", sp, CommandType.Text);
if (result == "")
{
return(null);
}
return(result.JsonDeserialize <List <MyBagSerial> >());
}
