public IList <Sql_PackageDetail> GetPackageNumber(int packageId, int userId, out Sql_PackageCode code)
{
string sql = "update top(1) PackageCard set userid=@userId,intime=getdate() output deleted.Code where packageid=@packageId and userid=0";
SqlParameter[] pms =
{
new SqlParameter("@userId", SqlDbType.Int)
{
Value = userId
},
new SqlParameter("@packageId", SqlDbType.NVarChar)
{
Value = packageId
},
// new SqlParameter("@Code",SqlDbType.NVarChar,300)
};
code = db.Database.SqlQuery <Sql_PackageCode>(sql, pms).FirstOrDefault();
string str = "select p.msg,p.memo,p.gamename,c.systemname from Package p inner join company c on p.companyid=c.id where p.id=@packageId";
SqlParameter[] ps =
{
new SqlParameter("@packageId", SqlDbType.NVarChar)
{
Value = packageId
},
};
return(db.Database.SqlQuery <Sql_PackageDetail>(str, ps).ToList());
}
public IList <Sql_PackageDetail> GetPackageNumber(int packageId, int userId, out Sql_PackageCode code)
{
return(dbSession.PackageDal.GetPackageNumber(packageId, userId, out code));
}
