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