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