/// <summary>
/// Insert đối tượng vào database
/// </summary>
/// <param name="menu"></param>
/// <returns></returns>
public string Insert(GuarReturnDetailContract guarreturndetail, SqlTransaction tran = null)
{
DataTable dtResult = null;
string query = string.Format(@"INSERT INTO Guar_Return_Detail
VALUES ({0},{1},{2},{3},{4},convert(datetime,{5},103))",
(guarreturndetail.Guarreturnid != null? guarreturndetail.Guarreturnid.ToString() : "null").ToString(),
(guarreturndetail.Productid.Trim() != String.Empty ? guarreturndetail.Productid.ToString() : "null").ToString(),
(guarreturndetail.Quantity.Trim() != String.Empty ? guarreturndetail.Quantity.ToString() : "null").ToString(),
(guarreturndetail.Ordernum.Trim() != String.Empty ? guarreturndetail.Ordernum.ToString() : "null").ToString(),
(guarreturndetail.Deleted != null? "'" + SQLHelper.RejectInjection(guarreturndetail.Deleted.ToString()) + "'" : "null").ToString(),
(guarreturndetail.Deletedon != null? "'" + SQLHelper.RejectInjection(guarreturndetail.Deletedon.ToString()) + "'" : "null").ToString());
query += " ; select SCOPE_IDENTITY();";
if (tran == null)
{
dtResult = DataProvider.ExecuteQuery(query);
}
else
{
dtResult = DataProvider.ExecuteQueryWithTransaction(query, tran);
}
if (dtResult != null && dtResult.Rows.Count > 0)
{
return(dtResult.Rows[0][0].ToString());
}
return("");
}
/// <summary>
/// Cập nhật thông tin đối tượng
/// </summary>
/// <param name="menu"></param>
/// <param name="tran"></param>
/// <returns></returns>
public string Update(GuarReturnDetailContract guarreturndetail, SqlTransaction tran = null)
{
string query = String.Format("UPDATE " + TableName + @" SET GuarReturnID={0},ProductID={1},Quantity={2},OrderNum={3},Deleted={4},DeletedOn=convert(datetime,{5},103)
WHERE ID=" + guarreturndetail.Id.ToString(),
(guarreturndetail.Guarreturnid != null? guarreturndetail.Guarreturnid.ToString() : "null").ToString(),
(guarreturndetail.Productid.Trim() != String.Empty ? guarreturndetail.Productid.ToString() : "null").ToString(),
(guarreturndetail.Quantity.Trim() != String.Empty ? guarreturndetail.Quantity.ToString() : "null").ToString(),
(guarreturndetail.Ordernum.Trim() != String.Empty ? guarreturndetail.Ordernum.ToString() : "null").ToString(),
(guarreturndetail.Deleted != null? "'" + SQLHelper.RejectInjection(guarreturndetail.Deleted.ToString()) + "'" : "null").ToString(),
(guarreturndetail.Deletedon != null? "'" + SQLHelper.RejectInjection(guarreturndetail.Deletedon.ToString()) + "'" : "null").ToString());
if (tran == null)
{
DataProvider.ExecuteNonQuery(query);
}
else
{
DataProvider.ExecuteNonQueryWithTransaction(query, tran);
}
return(guarreturndetail.Id.ToString());
}
