public void COA_Template_DetailsDAO_UPDATE(COA_Template_Details OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Details] SET" + "[COATemplateID] = " + OBJ.COATemplateID + ",[HMKTID] = " + OBJ.HMKTID + ",[Value] = N'" + OBJ.Value + "'" + ",[Tolerance] = N'" + OBJ.Tolerance + "'" + ",[ValueVN] = N'" + OBJ.ValueVN + "'" + ",[ToleranceVN] = N'" + OBJ.ToleranceVN + "'" + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + ",[Locked] = '" + OBJ.Locked + "' " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }
public void COA_Template_DetailsDAO_INSERT(COA_Template_Details OBJ) { DAO.COA_Template_DetailsDAO_INSERT(OBJ); }
public void COA_Template_DetailsDAO_DELETE(COA_Template_Details OBJ) { DAO.COA_Template_DetailsDAO_DELETE(OBJ); }