public List <ProductWarehouseDetail> LoadProductWarehouseDetailsByCreatedBy(string createdBy)
{
string sql = @"SELECT [DetailID]
, [InID]
, [PackageID]
, [LocationID]
, [Created]
, [CreatedBy]
FROM [BE_ProductWarehouseDetail] WHERE [CreatedBy]=@CreatedBy" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", createdBy);
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
List <ProductWarehouseDetail> ret = new List <ProductWarehouseDetail>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ProductWarehouseDetail iret = new ProductWarehouseDetail();
if (!Convert.IsDBNull(dr["DetailID"]))
{
iret.DetailID = (Guid)dr["DetailID"];
}
if (!Convert.IsDBNull(dr["InID"]))
{
iret.InID = (Guid)dr["InID"];
}
if (!Convert.IsDBNull(dr["PackageID"]))
{
iret.PackageID = (Guid)dr["PackageID"];
}
if (!Convert.IsDBNull(dr["LocationID"]))
{
iret.LocationID = (Guid)dr["LocationID"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
iret.Created = (DateTime)dr["Created"];
}
iret.CreatedBy = dr["CreatedBy"].ToString();
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int LoadProductWarehouseDetailByDetailID(ProductWarehouseDetail obj)
{
string sql = @"SELECT [DetailID]
, [InID]
, [PackageID]
, [LocationID]
, [Created]
, [CreatedBy]
FROM [BE_ProductWarehouseDetail] WITH(NOLOCK) WHERE [DetailID]=@DetailID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pDetailID = new SqlParameter("DetailID", Convert2DBnull(obj.DetailID));
pDetailID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pDetailID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["DetailID"]))
{
obj.DetailID = (Guid)dr["DetailID"];
}
if (!Convert.IsDBNull(dr["InID"]))
{
obj.InID = (Guid)dr["InID"];
}
if (!Convert.IsDBNull(dr["PackageID"]))
{
obj.PackageID = (Guid)dr["PackageID"];
}
if (!Convert.IsDBNull(dr["LocationID"]))
{
obj.LocationID = (Guid)dr["LocationID"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
obj.CreatedBy = dr["CreatedBy"].ToString();
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertProductWarehouseDetail(ProductWarehouseDetail obj)
{
string sql = @"INSERT INTO[BE_ProductWarehouseDetail]([DetailID]
, [InID]
, [PackageID]
, [LocationID]
, [Created]
, [CreatedBy]
) VALUES(@DetailID
, @InID
, @PackageID
, @LocationID
, @Created
, @CreatedBy
)" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pDetailID = new SqlParameter("DetailID", Convert2DBnull(obj.DetailID));
pDetailID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pDetailID);
SqlParameter pInID = new SqlParameter("InID", Convert2DBnull(obj.InID));
pInID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pInID);
SqlParameter pPackageID = new SqlParameter("PackageID", Convert2DBnull(obj.PackageID));
pPackageID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pPackageID);
SqlParameter pLocationID = new SqlParameter("LocationID", Convert2DBnull(obj.LocationID));
pLocationID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pLocationID);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}
public int UpdateProductWarehouseDetailByDetailID(ProductWarehouseDetail obj)
{
string sql = @"UPDATE [BE_ProductWarehouseDetail] SET [InID]=@InID
, [PackageID]=@PackageID
, [LocationID]=@LocationID
, [Created]=@Created
, [CreatedBy]=@CreatedBy
WHERE [DetailID]=@DetailID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pInID = new SqlParameter("InID", Convert2DBnull(obj.InID));
pInID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pInID);
SqlParameter pPackageID = new SqlParameter("PackageID", Convert2DBnull(obj.PackageID));
pPackageID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pPackageID);
SqlParameter pLocationID = new SqlParameter("LocationID", Convert2DBnull(obj.LocationID));
pLocationID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pLocationID);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
SqlParameter pDetailID = new SqlParameter("DetailID", Convert2DBnull(obj.DetailID));
pDetailID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pDetailID);
return(cmd.ExecuteNonQuery());
}